core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 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 |
|---|
| 01a0da24-1bf7-74f3-938a-fddf2a4ef552 | SOXL | 2026-09-25 15:56 | call_frontspread | 2 | 1 | 80 | 148840.00 | long | bid | 151.3701 | 0.8000 | ["144","145"] | ["1.0212","1.0267"] | ["156.15"] | ["XISX"] | 144.0000 | 145.0000 | 7 | 7 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T19:56:50Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d9ff-80de-7732-b9cc-2ceed241479c | SOXL | 2026-09-25 15:16 | call_diagonal_spread | 2 | 1 | 15 | 107550.00 | long | bid | 152.3750 | 4.8500 | ["114","120"] | ["14.5013","1.2091"] | [] | ["XPHO"] | 114.0000 | 120.0000 | 0 | 7 | false | false | true | true | |||||||||
| 01a0d95e-33e7-71c3-90e6-efee25e553d6 | SOXL | 2026-09-25 12:20 | call_diagonal_spread | 2 | 1 | 24 | 152400.00 | long | bid | 152.4300 | 5.9500 | ["120","132"] | ["7.0355","1.1811"] | [] | ["XPHO"] | 120.0000 | 132.0000 | 0 | 28 | false | false | true | true | |||||||||
| 01a0d8ca-9abf-7140-be8d-3732c0a22284 | SOXL | 2026-09-25 09:39 | put_calendar | 2 | 1 | 25 | 105750.00 | long | bid | 150.9800 | 2.2000 | ["150"] | ["1.1526"] | [] | ["XMIO"] | 150.0000 | 150.0000 | 21 | 56 | false | true | true | false | |||||||||
| 01a0d8c7-f6f7-7f21-9d5a-260742c89582 | SOXL | 2026-09-25 09:36 | call_diagonal_spread | 2 | 1 | 90 | 478260.00 | long | bid | 150.9900 | 4.5000 | ["116","135"] | ["7.5693","1.0370"] | [] | ["XMIO"] | 116.0000 | 135.0000 | 0 | 7 | false | false | true | true | |||||||||
| 01a0d4b5-686f-7e71-b41f-1d0fed2f11fc | SOXL | 2026-09-24 14:37 | call_diagonal_spread | 2 | 1 | 5 | 115805.00 | long | bid | 144.2023 | 4.9500 | ["22","55"] | ["1.0694","0.9378"] | [] | ["XCBO"] | 22.0000 | 55.0000 | 484 | 848 | false | false | true | true | |||||||||
| 01a0d425-da6f-79d3-8031-b4a8383ebd3c | SOXL | 2026-09-24 12:00 | call_diagonal_spread | 2 | 2 | 102 | 278192.00 | long | bid | 139.0100 | 2.3500 | ["125","145"] | ["1.6219","1.1080"] | [] | ["XISX","XMIO"] | 125.0000 | 145.0000 | 1 | 22 | false | false | true | true | |||||||||
| 01a0cef4-436f-7331-ac36-07ac69e7fa32 | SOXL | 2026-09-23 11:48 | call_diagonal_spread | 2 | 1 | 93 | 591108.00 | long | bid | 143.7885 | 3.2000 | ["110","130"] | ["1.3475","1.1849"] | [] | ["BATO"] | 110.0000 | 130.0000 | 9 | 37 | false | false | true | true | |||||||||
| 01a0ced9-58cf-7a11-bebb-055a89543825 | SOXL | 2026-09-23 11:19 | call_calendar | 2 | 1 | 10 | 156730.00 | long | bid | 145.0818 | 6.6000 | ["71"] | ["1.1734"] | [] | ["XISX"] | 71.0000 | 71.0000 | 86 | 114 | false | false | true | false | |||||||||
| 01a0ced7-c677-77d2-9f5e-85c9928ae2da | SOXL | 2026-09-23 11:17 | call_calendar | 2 | 1 | 110 | 218350.00 | long | bid | 144.6520 | 1.2000 | ["150"] | ["1.0363"] | [] | ["XISX"] | 150.0000 | 150.0000 | 14 | 16 | false | true | true | false | |||||||||
| 01a0ca91-b857-7710-b705-e6d6c1fd7139 | SOXL | 2026-09-22 15:22 | put_diagonal_spread | 2 | 1 | 9 | 129564.00 | long | bid | 150.2322 | 3.2500 | ["150","205"] | ["1.2403","1.1997"] | [] | ["EMLD"] | 150.0000 | 205.0000 | 87 | 486 | false | false | true | true | |||||||||
| 01a0ca42-82ff-7903-a57c-50a317bd3787 | SOXL | 2026-09-22 13:55 | call_diagonal_spread | 2 | 1 | 25 | 130500.00 | long | bid | 149.0600 | 2.8000 | ["150","175"] | ["1.1619","1.1461"] | [] | ["XISX"] | 150.0000 | 175.0000 | 59 | 87 | false | true | true | true | |||||||||
| 01a0c9dd-4cd6-76f2-a4d8-f540ec26b58d | SOXL | 2026-09-22 12:05 | call_diagonal_spread | 2 | 1 | 9 | 192681.00 | long | bid | 147.7300 | 6.0000 | ["23","89"] | ["2.8682","1.0433"] | [] | ["ARCO"] | 23.0000 | 89.0000 | 59 | 486 | false | false | true | true | |||||||||
| 01a0c587-e8ee-7703-9ee3-7be83e42ec03 | SOXL | 2026-09-21 15:53 | call_diagonal_spread | 2 | 1 | 10 | 229100.00 | long | bid | 142.8350 | 7.2000 | ["22","55"] | ["1.1154","0.9355"] | [] | ["XMIO"] | 22.0000 | 55.0000 | 487 | 851 | false | false | true | true | |||||||||
| 01a0c571-5f66-7470-9fbc-0284dc233fae | SOXL | 2026-09-21 15:28 | put_diagonal_spread | 2 | 1 | 44 | 205040.00 | long | bid | 142.1900 | 3.8000 | ["145","149"] | ["1.1955","1.1714"] | [] | ["XISX"] | 145.0000 | 149.0000 | 32 | 39 | false | false | true | true | |||||||||
| 01a0c56c-2b5f-7482-bdf7-da53c55ded4a | SOXL | 2026-09-21 15:23 | call_diagonal_spread | 2 | 1 | 90 | 1017360.00 | long | bid | 142.5400 | 3.0000 | ["100","129"] | ["1.1569","1.1087"] | [] | ["XPHO"] | 100.0000 | 129.0000 | 116 | 242 | false | false | true | true | |||||||||
| 01a0c539-8687-79d0-8408-5e1bacb8eaa2 | SOXL | 2026-09-21 14:27 | call_diagonal_spread | 2 | 1 | 74 | 808746.00 | long | bid | 140.8100 | 6.1500 | ["100","129"] | ["1.1242","1.0985"] | [] | ["XISX"] | 100.0000 | 129.0000 | 116 | 242 | false | false | true | true | |||||||||
| 01a0c4e8-edb7-7db3-af99-974aa086548c | SOXL | 2026-09-21 12:59 | iron_butterfly | 4 | 1 | 30 | 163410.00 | long | bid | 140.2001 | 0.3800 | ["100","120","140"] | ["1.2511","1.1484","1.0997"] | ["104.05","135.95"] | ["XCBO"] | 100.0000 | 140.0000 | 25 | 25 | false | false | false | true | |||||||||
| 01a0c439-48df-7420-abea-48e785817719 | SOXL | 2026-09-21 09:48 | call_diagonal_spread | 2 | 1 | 27 | 115965.00 | long | bid | 134.2600 | 3.1000 | ["125","130"] | ["1.0718","1.1005"] | [] | ["XISX"] | 125.0000 | 130.0000 | 32 | 39 | false | false | true | true | |||||||||
| 01a0b557-9e57-7882-84ff-7e8499faaf9e | SOXL | 2026-09-18 12:26 | call_diagonal_spread | 2 | 1 | 10 | 140070.00 | long | bid | 116.8500 | 6.3500 | ["60","135"] | ["1.0308","1.0178"] | [] | ["XPHO"] | 60.0000 | 135.0000 | 490 | 854 | false | false | true | true | |||||||||
| 01a0a6a4-99be-7541-8ab7-e2c79a1bd621 | SOXL | 2026-09-15 15:56 | put_calendar | 2 | 1 | 5 | 100695.00 | long | bid | 102.0600 | 7.7000 | ["200"] | ["2.1100"] | [] | ["AMXO"] | 200.0000 | 200.0000 | 3 | 122 | false | false | true | false | |||||||||
| 01a0a6a0-add7-7692-93e7-61ab18b8cb16 | SOXL | 2026-09-15 15:52 | put_calendar | 2 | 1 | 5 | 100745.00 | long | bid | 102.0290 | 7.9000 | ["200"] | ["2.1453"] | [] | ["AMXO"] | 200.0000 | 200.0000 | 3 | 122 | false | false | true | false | |||||||||
| 01a0a69f-dae6-72f0-80de-bfe210bebb9c | SOXL | 2026-09-15 15:51 | put_calendar | 2 | 1 | 5 | 100745.00 | long | bid | 102.0382 | 7.9000 | ["200"] | ["2.1602"] | [] | ["AMXO"] | 200.0000 | 200.0000 | 3 | 122 | false | false | true | false | |||||||||
| 01a0a59c-1eb6-7941-aeb9-741be8d0096c | SOXL | 2026-09-15 11:07 | call_calendar | 2 | 1 | 118 | 238360.00 | long | bid | 102.7999 | 2.4000 | ["125"] | ["1.0851"] | [] | ["XPHO"] | 125.0000 | 125.0000 | 45 | 66 | false | true | true | false | |||||||||
| 01a0a0d8-d6c8-7132-aefe-23475176520e | SOXL | 2026-09-14 12:55 | put_diagonal_spread | 2 | 6 | 49 | 435924.00 | long | bid | 104.0950 | 3.0929 | ["135","140"] | ["1.1374","1.1388"] | [] | ["AMXO","XBOX","XMIO","XPHO"] | 135.0000 | 140.0000 | 67 | 95 | false | false | true | true | |||||||||
| 01a0a044-c0a0-7210-b04c-df8091c29c71 | SOXL | 2026-09-14 10:14 | put_calendar | 2 | 2 | 210 | 703500.00 | long | bid | 104.7146 | 3.1000 | ["115"] | ["1.1523"] | [] | ["EDGO","XPHO"] | 115.0000 | 115.0000 | 7 | 32 | false | false | true | false | |||||||||
| 01a0a039-9928-7560-939b-67048bc3f337 | SOXL | 2026-09-14 10:02 | call_frontspread | 2 | 1 | 121 | 1746610.00 | long | bid | 103.4635 | 8.2000 | ["38","40"] | ["0.9501","0.9728"] | ["38.25","250.00"] | ["XISX"] | 38.0000 | 40.0000 | 494 | 494 | false | false | false | true | |||||||||
| 01a0a024-3c69-7590-b213-fd3f26dedcf9 | SOXL | 2026-09-14 09:38 | call_diagonal_spread | 2 | 1 | 27 | 348435.00 | long | bid | 100.3550 | 8.6000 | ["27","50"] | ["1.7719","1.1121"] | [] | ["XPHO"] | 27.0000 | 50.0000 | 123 | 158 | false | false | true | true | |||||||||
| 01a091ad-5ed0-7a70-9822-1512bb2f4735 | SOXL | 2026-09-11 14:14 | call_calendar | 2 | 1 | 11 | 196460.00 | long | bid | 123.5900 | 5.9000 | ["35"] | ["1.2573"] | [] | ["XISX"] | 35.0000 | 35.0000 | 70 | 126 | false | false | true | false | |||||||||
| 01a087b8-6f78-7d20-b991-390ede91412c | SOXL | 2026-09-09 15:50 | call_diagonal_spread | 2 | 1 | 10 | 113550.00 | long | bid | 125.1200 | 5.2000 | ["60","110"] | ["1.1747","1.1303"] | [] | ["XMIO"] | 60.0000 | 110.0000 | 128 | 163 | false | false | true | true | |||||||||
| 01a0877a-1688-7030-9fdf-5313fa74f545 | SOXL | 2026-09-09 14:41 | call_ladder | 3 | 1 | 20 | 120980.00 | long | bid | 125.5928 | 7.7000 | ["130","140","300"] | ["1.1997","1.1846","1.1967"] | ["310.79"] | ["XCBO"] | 130.0000 | 300.0000 | 100 | 100 | false | true | false | true | |||||||||
| 01a08139-3a38-7de3-b795-8f0a7284051e | SOXL | 2026-09-08 09:33 | call_diagonal_spread | 2 | 1 | 57 | 429210.00 | long | bid | 124.4301 | 5.5000 | ["85","90"] | ["4.4014","1.5581"] | [] | ["XPHO"] | 85.0000 | 90.0000 | 1 | 8 | false | false | true | true | |||||||||
| 01a06df1-a2e5-77d0-9d34-e05c690a4cae | SOXL | 2026-09-04 15:42 | put_calendar | 2 | 1 | 23 | 203849.00 | long | bid | 116.5800 | 2.6500 | ["160"] | ["1.3568"] | [] | ["SPHR"] | 160.0000 | 160.0000 | 7 | 14 | false | false | true | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:17:08Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:20:33Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:39:22Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:36:21Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:37:58Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:01:15Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:48:28Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:19:31Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:17:28Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:23:03Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:55:56Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:05:28Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:53:47Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:29:24Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:23:23Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:28:12Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:00:19Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:48:10Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:27:11Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:57:00Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:52:21Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:51:56Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:07:59Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:56:32Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:14:22Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:02:10Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:38:53Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:14:35Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:50:04Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:42:22Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:33:29Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:42:41Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |