Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c569-f4f7-7200-b48e-3191ce3ffbff | APP | 2026-09-21 15:20 | put_ladder | 3 | 1 | 30 | 3808200.00 | unknown | ask | 333.3700 | 31.2000 | ["740","880","1110"] | ["1.1691","1.3588","1.6136"] | ["325.30"] | ["XBOX"] | 740.0000 | 1110.0000 | 116 | 116 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:21:13Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b0e1-cdeb-7212-84ed-669e85843d07 | APP | 2026-09-17 15:39 | call_diagonal_spread | 2 | 1 | 300 | 260400.00 | short | bid | 318.4850 | 0.7500 | ["335","350"] | ["0.6506","0.5331"] | [] | ["SPHR"] | 335.0000 | 350.0000 | 1 | 29 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:40:02Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a1-1b6b-7610-8cb7-6c528501f2f8 | APP | 2026-09-17 14:29 | ratio_risk_reversal | 2 | 2 | 120 | 1624000.00 | unknown | — | 316.6300 | 13.8000 | ["280","410"] | ["0.6905","0.6791"] | [] | ["ARCO"] | 280.0000 | 410.0000 | 638 | 638 | true | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:29:07Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abcb-489b-7f10-8ab3-c26ded60fbcc | APP | 2026-09-16 15:56 | risk_reversal | 2 | 1 | 350 | 1289750.00 | long | bid | 326.9800 | 13.2000 | ["290","390"] | ["0.6812","0.6891"] | ["288.95"] | ["AMXO"] | 290.0000 | 390.0000 | 65 | 65 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:57:13Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abb5-ebdb-7c42-922c-dfc4f1ce6712 | APP | 2026-09-16 15:33 | other | 8 | 1 | 302 | 19274940.00 | unknown | — | 323.2000 | 75.7000 | ["400","410","460","470","500","640","700","1110"] | ["1.9995","2.2499","2.9885","3.1577","3.7938","4.6323","5.4240","1.2906"] | [] | ["XBOX"] | 400.0000 | 1110.0000 | 2 | 121 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:33:51Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba8-574b-7521-adf4-0bafe2bdd55c | APP | 2026-09-16 15:18 | put_ladder | 6 | 1 | 157 | 4601832.00 | unknown | — | 323.4025 | 56.6000 | ["400","410","460","470","500","700"] | ["1.7513","1.9809","2.6981","2.7832","3.1448","5.5109"] | [] | ["XBOX"] | 400.0000 | 700.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:19:03Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a091e5-04e9-7b93-b29b-5adb32d386cc | APP | 2026-09-11 15:14 | other | 7 | 1 | 100 | 3347040.00 | unknown | — | 324.9850 | 48.2000 | ["410","450","460","470","500","610","700"] | ["0.6939","1.7581","1.9864","2.0705","2.3068","3.0225","3.4890"] | [] | ["XBOX"] | 410.0000 | 700.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:15:20Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c8f-ec10-7060-95bc-917cdf19dd82 | APP | 2026-09-10 14:23 | strangle | 2 | 2 | 50 | 304000.00 | unknown | — | 314.7700 | 3.4000 | ["260","590"] | ["0.6795","0.6931"] | [] | ["AMXO"] | 260.0000 | 590.0000 | 280 | 280 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:24:16Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0826e-a528-78e3-b1bf-e8931072f5bd | APP | 2026-09-08 15:11 | other | 8 | 1 | 110 | 4169680.00 | unknown | — | 311.9800 | 73.3000 | ["420","440","450","460","470","500","640","700"] | ["1.3748","1.4934","1.5638","1.7378","1.7091","1.8714","2.6143","2.8592"] | [] | ["XBOX"] | 420.0000 | 700.0000 | 10 | 10 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:11:45Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |