core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| net_sidetext |
|---|
| underlying_pricenumeric |
|---|
| bid_ask_spreadnumeric |
|---|
| strikesjsonb |
|---|
| ivsjsonb |
|---|
| breakevensjsonb |
|---|
| uniq_exchangesjsonb |
|---|
| min_strikenumeric |
|---|
| max_strikenumeric |
|---|
| min_dteinteger |
|---|
| max_dteinteger |
|---|
| all_opening_legsboolean |
|---|
| all_otmboolean |
|---|
| diff_expirationsboolean |
|---|
| diff_strikesboolean |
|---|
| diff_typesboolean |
|---|
| codetext |
|---|
| kept_bytext |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| as_ofdate |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| 01a0ca6b-09ff-71b1-abbe-c2f19eb6cfa8 | STX | 2026-09-22 14:40 | put_diagonal_spread | 2 | 1 | 2 | 29592.00 | long | ask | 910.4100 | 5.2000 | ["880","900"] | ["0.7443","0.7054"] | [] | ["XISX"] | 880.0000 | 900.0000 | 24 | 59 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:40:11Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c468-193f-7150-83ea-786d6413204b | STX | 2026-09-21 10:39 | put_diagonal_spread | 2 | 1 | 2 | 38162.00 | short | ask | 881.3300 | 19.1000 | ["740","820"] | ["0.7119","0.7011"] | [] | ["XISX"] | 740.0000 | 820.0000 | 116 | 179 | false | true | true | ||||||||||
| 01a0c439-9ae7-7420-9b08-6b3fa47bfe62 | STX | 2026-09-21 09:48 | put_diagonal_spread | 2 | 1 | 3 | 63780.00 | long | ask | 883.9100 | 12.1000 | ["900","950"] | ["0.7344","0.6886"] | [] | ["XISX"] | 900.0000 | 950.0000 | 25 | 60 | false | false | true | ||||||||||
| 01a0b608-7baf-7752-b903-9c48701817ef | STX | 2026-09-18 15:40 | put_diagonal_spread | 2 | 1 | 5 | 65330.00 | short | ask | 856.9050 | 14.9000 | ["790","825"] | ["0.7124","0.7312"] | [] | ["XMIO"] | 790.0000 | 825.0000 | 42 | 63 | false | true | true | ||||||||||
| 01a0b4e0-f36f-7401-bf95-c538b92e2b80 | STX | 2026-09-18 10:17 | put_diagonal_spread | 2 | 2 | 14 | 97538.00 | long | ask | 827.0500 | 6.3000 | ["800","850"] | ["0.6542","1.0245"] | [] | ["ARCO","XPHO"] | 800.0000 | 850.0000 | 0 | 28 | false | false | true | ||||||||||
| 01a0b00d-c0c3-7af3-9960-60f5651e723b | STX | 2026-09-17 11:48 | put_diagonal_spread | 2 | 3 | 3 | 80905.00 | long | ask | 803.2600 | 24.1000 | ["925","945"] | ["1.7401","0.8432"] | [] | ["ARCO","XISX"] | 925.0000 | 945.0000 | 1 | 8 | false | false | true | ||||||||||
| 01a0b00d-c0c3-7af3-9960-60e73544fe34 | STX | 2026-09-17 11:48 | put_diagonal_spread | 2 | 1 | 12 | 324588.00 | long | ask | 803.2600 | 23.1500 | ["925","945"] | ["1.8159","0.8628"] | [] | ["XISX"] | 925.0000 | 945.0000 | 1 | 8 | true | false | true | ||||||||||
| 01a0aa7a-1463-7fd0-91e9-8123ab352692 | STX | 2026-09-16 09:48 | put_diagonal_spread | 2 | 1 | 4 | 82496.00 | long | ask | 787.1600 | 21.3000 | ["840","860"] | ["0.7566","0.7508"] | [] | ["XMIO"] | 840.0000 | 860.0000 | 16 | 44 | false | false | true | ||||||||||
| 01a0a683-0be5-7303-a0b0-60ec9d339865 | STX | 2026-09-15 15:19 | put_diagonal_spread | 2 | 1 | 5 | 86850.00 | long | ask | 770.4500 | 13.3000 | ["740","850"] | ["0.7172","0.9259"] | [] | ["XISX"] | 740.0000 | 850.0000 | 3 | 94 | false | false | true | ||||||||||
| 01a0a59f-e776-7f53-9430-a925bbcc5497 | STX | 2026-09-15 11:11 | put_diagonal_spread | 2 | 2 | 4 | 32462.00 | short | ask | 769.2600 | 6.7000 | ["730","750"] | ["0.6643","0.6692"] | [] | ["ARCO","XPHO"] | 730.0000 | 750.0000 | 24 | 31 | false | true | true | ||||||||||
| 01a0a58e-381e-7af3-8310-4e84c0f91e60 | STX | 2026-09-15 10:52 | put_diagonal_spread | 2 | 1 | 3 | 35850.00 | long | ask | 771.3600 | 12.2000 | ["800","825"] | ["0.6721","0.8161"] | [] | ["EMLD"] | 800.0000 | 825.0000 | 3 | 17 | false | false | true | ||||||||||
| 01a0a588-4896-7ff2-95db-4f1a3eeba0de | STX | 2026-09-15 10:46 | put_diagonal_spread | 2 | 2 | 2 | 65246.00 | long | ask | 772.6300 | 24.6000 | ["915","925"] | ["0.6916","0.6986"] | [] | ["EDGO","XISX"] | 915.0000 | 925.0000 | 24 | 38 | false | false | true | ||||||||||
| 01a0a543-e8ae-78a1-b017-ac954f1653c6 | STX | 2026-09-15 09:31 | put_diagonal_spread | 2 | 1 | 10 | 52590.00 | long | ask | 794.2200 | 4.8000 | ["740","780"] | ["0.6713","0.8298"] | [] | ["XMIO"] | 740.0000 | 780.0000 | 3 | 31 | false | true | true | ||||||||||
| 01a0a17c-5258-7771-9c4d-309aa279fba0 | STX | 2026-09-14 15:54 | put_diagonal_spread | 2 | 1 | 4 | 28976.00 | long | ask | 806.7700 | 16.7000 | ["800","815"] | ["0.6688","0.7336"] | [] | ["XMIO"] | 800.0000 | 815.0000 | 4 | 18 | false | false | true | ||||||||||
| 01a0a0d1-54e8-74b3-957c-3aea14858b25 | STX | 2026-09-14 12:47 | put_diagonal_spread | 2 | 1 | 3 | 32313.00 | long | ask | 812.1700 | 13.7000 | ["840","850"] | ["0.7272","0.8312"] | [] | ["XPHO"] | 840.0000 | 850.0000 | 4 | 11 | false | false | true | ||||||||||
| 01a0a093-d2d1-7310-a1f3-b9c132bd8096 | STX | 2026-09-14 11:40 | put_diagonal_spread | 2 | 2 | 18 | 120600.00 | long | ask | 819.5850 | 13.5000 | ["810","825"] | ["0.7284","0.8271"] | [] | ["C2OX"] | 810.0000 | 825.0000 | 4 | 11 | false | false | true | ||||||||||
| 01a0a093-d2d1-7310-a1f3-b9bedcddc430 | STX | 2026-09-14 11:40 | put_diagonal_spread | 2 | 2 | 18 | 120870.00 | long | ask | 819.5850 | 13.5000 | ["810","825"] | ["0.7278","0.8323"] | [] | ["XPHO"] | 810.0000 | 825.0000 | 4 | 11 | false | false | true | ||||||||||
| 01a0a06b-3078-7e40-9bf4-016632a378c0 | STX | 2026-09-14 10:56 | put_diagonal_spread | 2 | 1 | 2 | 48004.00 | long | ask | 791.1200 | 25.6000 | ["750","900"] | ["0.7165","0.8976"] | [] | ["EDGO"] | 750.0000 | 900.0000 | 4 | 186 | false | false | true | ||||||||||
| 01a0a041-cad0-77e3-bd8f-d72eaad08a4c | STX | 2026-09-14 10:10 | put_diagonal_spread | 2 | 1 | 2 | 42740.00 | long | ask | 804.2950 | 19.9000 | ["880","900"] | ["0.7188","0.9271"] | [] | ["XISX"] | 880.0000 | 900.0000 | 4 | 32 | false | false | true | ||||||||||
| 01a0a038-e191-7f83-ac48-8214393ffc6a | STX | 2026-09-14 10:01 | put_diagonal_spread | 2 | 1 | 4 | 76728.00 | long | ask | 794.3400 | 21.4000 | ["790","850"] | ["0.7665","0.7438"] | [] | ["XCBO"] | 790.0000 | 850.0000 | 25 | 67 | false | false | true | ||||||||||
| 01a0917e-bd50-79a3-ae0a-0d9ab4f8ac54 | STX | 2026-09-11 13:23 | put_diagonal_spread | 2 | 1 | 2 | 26024.00 | long | ask | 830.2900 | 14.2000 | ["880","900"] | ["2.8184","0.6816"] | [] | ["BATO"] | 880.0000 | 900.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a09176-e198-76a3-8e75-4920e3db86b6 | STX | 2026-09-11 13:14 | put_diagonal_spread | 2 | 1 | 5 | 61495.00 | long | ask | 827.1625 | 17.0000 | ["870","900"] | ["1.3994","0.6645"] | [] | ["XMIO"] | 870.0000 | 900.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a09173-5f28-7d72-b14f-71ed8e020940 | STX | 2026-09-11 13:10 | put_diagonal_spread | 2 | 1 | 10 | 160000.00 | long | ask | 830.0750 | 22.0000 | ["865","905"] | ["0.7002","3.5749"] | [] | ["XCBO"] | 865.0000 | 905.0000 | 0 | 28 | false | false | true | ||||||||||
| 01a09110-6b20-7ed0-b4e1-456052c7eaee | STX | 2026-09-11 11:22 | put_diagonal_spread | 2 | 1 | 2 | 41808.00 | long | ask | 827.1500 | 21.1000 | ["780","800"] | ["0.7141","0.7252"] | [] | ["XMIO"] | 780.0000 | 800.0000 | 98 | 126 | false | true | true | ||||||||||
| 01a090f8-fb20-7260-972f-7e3e18b4d591 | STX | 2026-09-11 10:57 | put_diagonal_spread | 2 | 1 | 6 | 71280.00 | long | ask | 821.0300 | 12.6000 | ["820","860"] | ["0.6693","0.6541"] | [] | ["SPHR"] | 820.0000 | 860.0000 | 7 | 35 | false | false | true | ||||||||||
| 01a08b96-d288-7353-871c-3b49091e58a8 | STX | 2026-09-10 09:51 | put_diagonal_spread | 2 | 2 | 2 | 33212.00 | short | ask | 858.7750 | 15.2000 | ["780","900"] | ["0.7410","0.6980"] | [] | ["ARCO","C2OX"] | 780.0000 | 900.0000 | 36 | 71 | false | false | true | ||||||||||
| 01a087a4-9188-7693-bb67-65466819e881 | STX | 2026-09-09 15:28 | put_diagonal_spread | 2 | 1 | 50 | 91250.00 | short | ask | 898.8200 | 1.3000 | ["790","885"] | ["0.6917","0.7325"] | [] | ["XPHO"] | 790.0000 | 885.0000 | 2 | 9 | false | true | true | ||||||||||
| 01a081e7-ece0-7301-b8a0-51ee9fcbc4e6 | STX | 2026-09-08 12:44 | put_diagonal_spread | 2 | 1 | 4 | 110152.00 | long | ask | 893.8150 | 12.6000 | ["910","1000"] | ["0.7301","0.7742"] | [] | ["BATO"] | 910.0000 | 1000.0000 | 38 | 73 | false | false | true | ||||||||||
| 01a081c0-1d78-7ae3-a348-19b67484a688 | STX | 2026-09-08 12:00 | put_diagonal_spread | 2 | 1 | 2 | 96470.00 | long | ask | 891.2500 | 27.5000 | ["1025","1150"] | ["0.7733","0.8045"] | [] | ["AMXO"] | 1025.0000 | 1150.0000 | 45 | 73 | false | false | true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:39:17Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:48:26Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:40:20Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:17:17Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:48:38Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:48:38Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:48:52Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:20:10Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:12:14Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:52:39Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:46:33Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:31:32Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:54:34Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:48:06Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:40:52Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:40:52Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:56:27Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:11:04Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:01:29Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:23:35Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:14:48Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:11:14Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:23:19Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:57:18Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:51:59Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:28:32Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:44:55Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:01:08Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |