core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 01a0d400-687f-71c1-9f8b-fadf62029fda | SNOW | 2026-09-24 11:19 | call_diagonal_spread | 2 | 1 | 20 | 360100.00 | long | ask | 334.9600 | 9.6000 | ["260","340"] | ["0.5876","0.5826"] | [] | ["XISX"] | 260.0000 | 340.0000 | 113 | 449 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T15:20:02Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0cf31-c19f-7a63-84de-556002a0d490 | SNOW | 2026-09-23 12:55 | call_diagonal_spread | 2 | 1 | 15 | 102375.00 | long | ask | 335.6279 | 3.8500 | ["300","350"] | ["0.5751","0.4803"] | [] | ["XCBO"] | 300.0000 | 350.0000 | 23 | 86 | false | false | true | ||||||||||
| 01a0cefc-de8e-7c01-b1be-96797bbd75e8 | SNOW | 2026-09-23 11:57 | call_diagonal_spread | 2 | 6 | 30 | 137330.00 | long | ask | 340.1900 | 1.7000 | ["330","350"] | ["0.4841","0.4957"] | [] | ["AMXO","EMLD","MCRY","XBOX","XMIO","XPHO"] | 330.0000 | 350.0000 | 23 | 58 | false | false | true | ||||||||||
| 01a0c4ef-0c1e-7d43-a071-678f60c309cd | SNOW | 2026-09-21 13:06 | call_diagonal_spread | 2 | 1 | 4 | 158996.00 | long | ask | 332.1150 | 9.1000 | ["140","155"] | ["0.6236","3.2837"] | [] | ["AMXO"] | 140.0000 | 155.0000 | 4 | 816 | false | false | true | ||||||||||
| 01a0b509-18c7-7f13-b45b-8b56b54efeda | SNOW | 2026-09-18 11:01 | call_diagonal_spread | 2 | 1 | 5 | 123195.00 | long | ask | 333.2600 | 8.9000 | ["330","350"] | ["0.5807","0.5839"] | [] | ["XMIO"] | 330.0000 | 350.0000 | 819 | 854 | false | false | true | ||||||||||
| 01a0b4c3-d650-7340-8a38-0229efe7bc5e | SNOW | 2026-09-18 09:45 | call_diagonal_spread | 2 | 1 | 40 | 204678.00 | long | ask | 333.7100 | 7.2000 | ["310","320"] | ["1.9960","0.4559"] | [] | ["XCBO"] | 310.0000 | 320.0000 | 0 | 35 | false | false | true | ||||||||||
| 01a0b0bb-8cf3-74a1-beb4-05e292f4d967 | SNOW | 2026-09-17 14:57 | call_diagonal_spread | 2 | 1 | 8 | 208112.00 | long | ask | 338.2600 | 5.9000 | ["210","220"] | ["4.0910","0.6044"] | [] | ["XISX"] | 210.0000 | 220.0000 | 1 | 183 | false | false | true | ||||||||||
| 01a0b006-cb83-7113-b335-d84f5a5ba7c6 | SNOW | 2026-09-17 11:40 | call_diagonal_spread | 2 | 1 | 7 | 110026.00 | long | bid | 342.2050 | 7.7000 | ["250","300"] | ["3.5453","0.5794"] | [] | ["ARCO"] | 250.0000 | 300.0000 | 1 | 92 | false | false | true | ||||||||||
| 01a0a6a3-edde-78e0-9005-d8b1d22ba6ef | SNOW | 2026-09-15 15:55 | call_diagonal_spread | 2 | 1 | 31 | 847912.00 | long | bid | 323.5100 | 9.0500 | ["175","220"] | ["4.2328","0.5781"] | [] | ["ARCO"] | 175.0000 | 220.0000 | 3 | 275 | false | false | true | ||||||||||
| 01a0a562-1b26-7613-a874-feb0366d55d6 | SNOW | 2026-09-15 10:04 | call_diagonal_spread | 2 | 2 | 2 | 102608.00 | long | ask | 319.9600 | 13.0000 | ["65","75"] | ["2.7991","0.7043"] | [] | ["ARCO","XPHO"] | 65.0000 | 75.0000 | 31 | 822 | false | false | true | ||||||||||
| 01a090d7-6191-72c1-bda0-c82a53aa015f | SNOW | 2026-09-11 10:20 | call_diagonal_spread | 2 | 1 | 44 | 682572.00 | long | ask | 326.5900 | 7.4500 | ["330","360"] | ["0.5789","0.5277"] | [] | ["AMXO"] | 330.0000 | 360.0000 | 161 | 826 | false | true | true | ||||||||||
| 01a087a7-f0d0-7ed0-be34-a7eab5bf9af2 | SNOW | 2026-09-09 15:32 | call_diagonal_spread | 2 | 1 | 15 | 154710.00 | long | ask | 332.8600 | 3.7000 | ["340","450"] | ["0.5725","0.5197"] | [] | ["XMIO"] | 340.0000 | 450.0000 | 128 | 499 | false | true | true | ||||||||||
| 01a0876a-3808-7bd3-92a0-7a286af52706 | SNOW | 2026-09-09 14:24 | call_diagonal_spread | 2 | 1 | 3 | 120480.00 | long | ask | 332.4900 | 12.0000 | ["90","190"] | ["0.6853","1.1286"] | [] | ["ARCO"] | 90.0000 | 190.0000 | 30 | 828 | false | false | true | ||||||||||
| 01a08761-d398-7f30-928d-b12d4dc0b00c | SNOW | 2026-09-09 14:15 | call_diagonal_spread | 2 | 1 | 5 | 258330.00 | long | bid | 332.3700 | 5.5000 | ["65","100"] | ["4.7711","0.6538"] | [] | ["XPHO"] | 65.0000 | 100.0000 | 9 | 828 | false | false | true | ||||||||||
| 01a08761-9ce8-79a2-ae87-bf65622db899 | SNOW | 2026-09-09 14:15 | call_diagonal_spread | 2 | 1 | 2 | 105660.00 | long | bid | 332.3200 | 4.6000 | ["65","85"] | ["4.9114","0.6715"] | [] | ["XISX"] | 65.0000 | 85.0000 | 9 | 828 | false | false | true | ||||||||||
| 01a08290-b000-7303-8ce4-25b8664e2fb5 | SNOW | 2026-09-08 15:48 | call_diagonal_spread | 2 | 1 | 5 | 261035.00 | long | ask | 337.3050 | 8.5500 | ["80","85"] | ["3.3547","0.6896"] | [] | ["XMIO"] | 80.0000 | 85.0000 | 10 | 829 | false | false | true | ||||||||||
| 01a0828f-2d48-7b43-9589-8eb2224dcc4a | SNOW | 2026-09-08 15:46 | call_diagonal_spread | 2 | 1 | 10 | 525920.00 | long | ask | 337.0000 | 5.0000 | ["75","80"] | ["0.7955","4.0398"] | [] | ["XPHO"] | 75.0000 | 80.0000 | 10 | 500 | false | false | true | ||||||||||
| 01a0827d-2030-7613-b604-ae9bd5202b45 | SNOW | 2026-09-08 15:27 | call_diagonal_spread | 2 | 1 | 2 | 100126.00 | long | bid | 336.1600 | 6.3000 | ["85","95"] | ["3.5072","0.7126"] | [] | ["ARCO"] | 85.0000 | 95.0000 | 10 | 500 | false | false | true | ||||||||||
| 01a0827a-f968-7b82-8519-6e00ebed964f | SNOW | 2026-09-08 15:24 | call_diagonal_spread | 2 | 1 | 5 | 260315.00 | long | bid | 336.0650 | 7.1000 | ["65","95"] | ["2.3275","0.7412"] | [] | ["ARCO"] | 65.0000 | 95.0000 | 38 | 465 | false | false | true | ||||||||||
| 01a0827a-e5e1-7e52-bc63-bc8e95347cfd | SNOW | 2026-09-08 15:24 | call_diagonal_spread | 2 | 1 | 5 | 260665.00 | long | bid | 336.0750 | 6.2500 | ["65","95"] | ["2.5336","0.7541"] | [] | ["XMIO"] | 65.0000 | 95.0000 | 38 | 465 | false | false | true | ||||||||||
| 01a08279-0950-72c3-a010-44f2376000cd | SNOW | 2026-09-08 15:22 | call_diagonal_spread | 2 | 1 | 10 | 500580.00 | long | bid | 335.9300 | 9.0500 | ["85","95"] | ["1.8131","0.7188"] | [] | ["XPHO"] | 85.0000 | 95.0000 | 38 | 500 | false | false | true | ||||||||||
| 01a08270-52d9-74d3-ba3f-492ced2fde46 | SNOW | 2026-09-08 15:13 | call_diagonal_spread | 2 | 1 | 10 | 562750.00 | long | ask | 338.6200 | 14.1500 | ["60","65"] | ["1.5415","0.7604"] | [] | ["XPHO"] | 60.0000 | 65.0000 | 101 | 829 | false | false | true | ||||||||||
| 01a08270-4720-7250-a213-f18669ce3014 | SNOW | 2026-09-08 15:13 | call_diagonal_spread | 2 | 1 | 10 | 555100.00 | long | bid | 338.6200 | 11.8500 | ["55","80"] | ["1.5439","0.7179"] | [] | ["XPHO"] | 55.0000 | 80.0000 | 101 | 829 | false | false | true | ||||||||||
| 01a08266-40b8-70b3-ae39-5ec18579d09c | SNOW | 2026-09-08 15:02 | call_diagonal_spread | 2 | 1 | 3 | 145116.00 | long | ask | 338.3200 | 9.5500 | ["95","100"] | ["0.6872","1.5701"] | [] | ["ARCO"] | 95.0000 | 100.0000 | 73 | 192 | false | false | true | ||||||||||
| 01a08264-cda1-7933-acf5-3e5f49e9d30a | SNOW | 2026-09-08 15:00 | call_diagonal_spread | 2 | 1 | 4 | 191404.00 | long | bid | 338.1850 | 11.2000 | ["90","110"] | ["1.7608","0.6297"] | [] | ["ARCO"] | 90.0000 | 110.0000 | 73 | 192 | false | false | true | ||||||||||
| 01a08263-27c0-7712-aa09-e8560be8d342 | SNOW | 2026-09-08 14:58 | call_diagonal_spread | 2 | 1 | 3 | 116010.00 | long | bid | 337.8450 | 11.2000 | ["145","150"] | ["0.6992","0.6807"] | [] | ["ARCO"] | 145.0000 | 150.0000 | 73 | 192 | false | false | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:55:41Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:57:53Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:07:00Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:01:21Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:45:39Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:58:33Z"} |
| 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:40:36Z"} |
| 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-15T19:56:10Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:04:42Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:20:35Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:32:37Z"} |
| 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-09T18:25:12Z"} |
| 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-09T18:15:45Z"} |
| 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-09T18:15:45Z"} |
| 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-08T19:48:51Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:47:02Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:27:43Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:25:01Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:25:01Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:22:43Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:13:36Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:13:36Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:02:33Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:01:06Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:58:59Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |