Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 rowsexportable
| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b614-df8f-7650-a840-6f8e4a16972b | LITE | 2026-09-18 15:53 | iron_butterfly | 4 | 1 | 11 | 102861.00 | long | bid | 929.7900 | 8.6000 | ["850","920","990"] | ["0.6978","0.6888","0.6981"] | ["871.83","968.17"] | ["XCBO"] | 850.0000 | 990.0000 | 7 | 7 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:53:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5b5-623f-7cb3-93ad-07140244423e | LITE | 2026-09-18 14:09 | call_diagonal_spread | 2 | 1 | 3 | 463980.00 | long | bid | 914.4400 | 28.4000 | ["105","200"] | ["63.7617","0.8743"] | [] | ["XMIO"] | 105.0000 | 200.0000 | 0 | 490 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:09:21Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0d3-33a3-7773-8813-252fc678bd48 | LITE | 2026-09-17 15:23 | call_butterfly_spread | 3 | 1 | 20 | 484640.00 | long | ask | 892.2350 | 29.6000 | ["900","1000","1100"] | ["0.7624","0.7615","0.7648"] | ["909","1091"] | ["XMIO"] | 900.0000 | 1100.0000 | 120 | 120 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:23:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afe7-f113-7a50-bb0e-d84da9ee4687 | LITE | 2026-09-17 11:06 | call_vertical_spread | 2 | 1 | 3 | 187056.00 | long | ask | 911.9650 | 29.0000 | ["1300","1400"] | ["0.7563","0.7557"] | ["1318.78"] | ["XCBO"] | 1300.0000 | 1400.0000 | 820 | 820 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:07:01Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab65-dbc3-7003-a57e-dc145a7c7cd9 | LITE | 2026-09-16 14:06 | call_vertical_spread | 2 | 1 | 5 | 432010.00 | long | ask | 931.1150 | 36.0000 | ["900","920"] | ["0.7524","0.7518"] | ["906.10"] | ["XCBO"] | 900.0000 | 920.0000 | 821 | 821 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:06:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab35-0f93-7a62-b94c-6ca6c4d6891a | LITE | 2026-09-16 13:12 | call_vertical_spread | 2 | 1 | 10 | 971640.00 | long | ask | 910.0000 | 31.3000 | ["700","710"] | ["0.7619","0.7608"] | ["704"] | ["XMIO"] | 700.0000 | 710.0000 | 821 | 821 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:13:26Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab34-38bb-7541-a909-57e6164675f4 | LITE | 2026-09-16 13:11 | call_vertical_spread | 2 | 1 | 2 | 151288.00 | long | ask | 910.1700 | 28.9000 | ["1000","1100"] | ["0.7507","0.7489"] | ["1025.68"] | ["XMIO"] | 1000.0000 | 1100.0000 | 821 | 821 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:12:21Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab07-c9bb-7322-8aee-af3d300c8dd8 | LITE | 2026-09-16 12:23 | call_vertical_spread | 2 | 1 | 33 | 394020.00 | long | ask | 906.7250 | 4.6000 | ["850","855"] | ["0.8860","0.8786"] | ["854.22"] | ["XMIO"] | 850.0000 | 855.0000 | 2 | 2 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:23:35Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaf1-6f13-7b82-a076-a8b3dcbfe064 | LITE | 2026-09-16 11:59 | call_vertical_spread | 2 | 1 | 221 | 1395394.00 | long | ask | 910.7250 | 6.1000 | ["900","1000"] | ["0.7576","0.7577"] | ["934.80"] | ["XPHO"] | 900.0000 | 1000.0000 | 9 | 9 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:59:40Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aace-a8bb-7383-910f-1d2c43906deb | LITE | 2026-09-16 11:21 | call_vertical_spread | 2 | 1 | 45 | 256230.00 | long | ask | 903.3450 | 3.1000 | ["900","1000"] | ["0.7527","0.7536"] | ["932.28"] | ["XMIO"] | 900.0000 | 1000.0000 | 9 | 9 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:21:48Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaa0-16db-7ed2-9994-f8398cf99d9e | LITE | 2026-09-16 10:30 | call_butterfly_spread | 3 | 1 | 2 | 126849.00 | long | ask | 895.1400 | 51.0000 | ["1200","1280","1360"] | ["0.7481","0.7487","0.7494"] | ["1201.25","1358.75"] | ["XMIO"] | 1200.0000 | 1360.0000 | 821 | 821 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:30:39Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa98-c3da-7be2-82af-9021dfaa4e2a | LITE | 2026-09-16 10:22 | call_butterfly_spread | 3 | 1 | 4 | 250604.00 | long | ask | 888.0000 | 41.9000 | ["1200","1280","1360"] | ["0.7493","0.7499","0.7510"] | ["1201.50","1358.50"] | ["XMIO"] | 1200.0000 | 1360.0000 | 821 | 821 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:22:39Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa97-7fa3-7bf1-928b-d1927ee75a42 | LITE | 2026-09-16 10:20 | call_butterfly_spread | 3 | 1 | 2 | 125706.00 | long | ask | 891.1700 | 47.9000 | ["1200","1280","1360"] | ["0.7472","0.7479","0.7492"] | ["1201.50","1358.50"] | ["EDGO"] | 1200.0000 | 1360.0000 | 821 | 821 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:21:27Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a02a-acd8-7f71-8cb5-77a97484b93c | LITE | 2026-09-14 09:45 | put_vertical_spread | 2 | 1 | 56 | 254240.00 | long | ask | 859.1950 | 5.4000 | ["815","855"] | ["0.9391","0.9057"] | ["840.06"] | ["AMXO"] | 815.0000 | 855.0000 | 4 | 4 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:45:44Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091f6-a889-7ca0-afa7-f72a9e57897d | LITE | 2026-09-11 15:34 | call_vertical_spread | 2 | 1 | 10 | 201710.00 | long | ask | 934.2940 | 9.6000 | ["1100","1200"] | ["0.7608","0.7652"] | ["1124.35"] | ["XCBO"] | 1100.0000 | 1200.0000 | 126 | 126 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:34:15Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09113-7c48-7262-920d-09c8278e5922 | LITE | 2026-09-11 11:26 | iron_condor | 4 | 1 | 2 | 254190.00 | long | ask | 937.1000 | 57.7000 | ["850","900","1550","1600"] | ["0.8042","0.8057","0.7888","0.7879"] | ["860.45","1589.55"] | ["XMIO"] | 850.0000 | 1600.0000 | 826 | 826 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:26:14Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090ce-0ed8-7193-8c41-c10cbf82c7b0 | LITE | 2026-09-11 10:10 | call_vertical_spread | 2 | 1 | 2 | 104168.00 | long | ask | 921.4900 | 19.7000 | ["640","700"] | ["0.7184","0.7259"] | ["693.96"] | ["XMIO"] | 640.0000 | 700.0000 | 35 | 35 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:10:31Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08771-8338-7800-b956-6db317b4f147 | LITE | 2026-09-09 14:32 | put_vertical_spread | 2 | 1 | 6 | 200838.00 | long | ask | 1006.0900 | 25.4000 | ["700","750"] | ["0.8049","0.8034"] | ["725.83"] | ["XCBO"] | 700.0000 | 750.0000 | 499 | 499 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:32:48Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08737-1249-7711-99be-6d1a3f2248a9 | LITE | 2026-09-09 13:28 | call_diagonal_spread | 2 | 1 | 21 | 1040046.00 | long | ask | 1008.3000 | 19.5000 | ["770","820"] | ["1.0360","0.8394"] | [] | ["XCBO"] | 770.0000 | 820.0000 | 9 | 72 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:28:54Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08730-f7c9-7823-84b9-e0b86ea3835a | LITE | 2026-09-09 13:22 | call_vertical_spread | 2 | 1 | 13 | 515476.00 | long | ask | 1011.2900 | 16.4000 | ["1000","1020"] | ["0.8113","0.8106"] | ["1008.40"] | ["XCBO"] | 1000.0000 | 1020.0000 | 128 | 128 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:22:18Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08730-f3e1-7890-9547-b103be651c35 | LITE | 2026-09-09 13:22 | call_vertical_spread | 2 | 1 | 66 | 2617032.00 | long | ask | 1011.2900 | 16.4000 | ["1000","1020"] | ["0.8113","0.8106"] | ["1008.40"] | ["XCBO"] | 1000.0000 | 1020.0000 | 128 | 128 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:22:18Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08667-b070-72b1-a31f-51c87a9e32fb | LITE | 2026-09-09 09:42 | call_vertical_spread | 2 | 1 | 3 | 172473.00 | long | ask | 994.6850 | 27.1000 | ["720","800"] | ["0.8784","0.8626"] | ["777.35"] | ["XCBO"] | 720.0000 | 800.0000 | 72 | 72 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:42:32Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08260-9780-7cd3-836f-ffb9a7aaa0ac | LITE | 2026-09-08 14:56 | call_vertical_spread | 2 | 2 | 37 | 280608.00 | long | ask | 996.4450 | 3.1000 | ["975","1000"] | ["0.9075","0.9163"] | ["987.90"] | ["XMIO"] | 975.0000 | 1000.0000 | 3 | 3 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:56:47Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0820b-a569-7351-9209-24bd0672fcb4 | LITE | 2026-09-08 13:23 | put_vertical_spread | 2 | 1 | 10 | 103190.00 | long | ask | 993.2601 | 2.4000 | ["980","1000"] | ["0.8175","0.8205"] | ["989.53"] | ["XMIO"] | 980.0000 | 1000.0000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:23:47Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0820a-5960-7db1-9005-136c9a7c1acb | LITE | 2026-09-08 13:21 | call_diagonal_spread | 2 | 1 | 3 | 103614.00 | long | bid | 993.9450 | 22.6000 | ["1000","1140"] | ["0.8268","0.8254"] | [] | ["XCBO"] | 1000.0000 | 1140.0000 | 101 | 164 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:22:04Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081b6-6918-7b43-9fc5-7014979f2fe6 | LITE | 2026-09-08 11:50 | straddle | 2 | 1 | 100 | 5279000.00 | long | ask | 990.0750 | 16.0000 | ["1200"] | ["0.8232"] | ["672.10","1727.90"] | ["EDGO"] | 1200.0000 | 1200.0000 | 192 | 192 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:50:48Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08196-36e8-7dc2-9f47-ad173dafe171 | LITE | 2026-09-08 11:14 | call_vertical_spread | 2 | 1 | 10 | 158450.00 | long | ask | 980.8100 | 17.7000 | ["1100","1300"] | ["0.8252","0.8348"] | ["1146.49"] | ["XMIO"] | 1100.0000 | 1300.0000 | 73 | 73 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:15:13Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08177-8770-7882-b262-5d90933b75e0 | LITE | 2026-09-08 10:41 | call_vertical_spread | 2 | 1 | 11 | 199544.00 | long | ask | 966.2800 | 19.8000 | ["1250","1350"] | ["0.8043","0.8086"] | ["1269.17"] | ["XMIO"] | 1250.0000 | 1350.0000 | 129 | 129 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:41:42Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08170-5798-7763-a70e-fbedf90d51de | LITE | 2026-09-08 10:33 | call_vertical_spread | 2 | 1 | 20 | 588680.00 | long | ask | 966.3050 | 20.7000 | ["1060","1080"] | ["0.7932","0.7925"] | ["1066.80"] | ["XMIO"] | 1060.0000 | 1080.0000 | 129 | 129 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:34:05Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |