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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b593-bcf7-7463-99a8-4d8e82186b9d | TSM | 2026-09-18 13:32 | put_calendar | 2 | 1 | 270 | 645975.00 | unknown | ask | 430.3650 | 0.9500 | ["430"] | ["0.3088"] | [] | ["XBOX"] | 430.0000 | 430.0000 | 14 | 28 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:32:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b577-efc7-78e3-9def-d1c967be5614 | TSM | 2026-09-18 13:02 | put_calendar | 2 | 2 | 450 | 2189250.00 | long | ask | 429.7450 | 1.7500 | ["430"] | ["0.3335"] | [] | ["ARCO"] | 430.0000 | 430.0000 | 63 | 91 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:02:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b04a-d963-77e1-bff3-7eed4d55053e | TSM | 2026-09-17 12:54 | synthetic | 2 | 1 | 750 | 2733750.00 | short | ask | 427.0985 | 0.5500 | ["450"] | ["0.3247"] | ["428.25"] | ["AMXO"] | 450.0000 | 450.0000 | 29 | 29 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:55:13Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a03f-9080-7450-9b5e-a328386c2b3c | TSM | 2026-09-14 10:08 | call_diagonal_spread | 2 | 1 | 86 | 233060.00 | long | ask | 421.9700 | 0.5000 | ["410","415"] | ["0.3055","0.3265"] | [] | ["XBOX"] | 410.0000 | 415.0000 | 4 | 11 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:08:34Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a03e-4c49-7b81-ac59-9b4705b7e595 | TSM | 2026-09-14 10:07 | call_diagonal_spread | 2 | 1 | 86 | 236930.00 | long | ask | 421.9593 | 0.6000 | ["410","415"] | ["0.3275","0.3340"] | [] | ["XBOX"] | 410.0000 | 415.0000 | 4 | 11 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:07:12Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c84-a558-7c02-9867-457ebb39f903 | TSM | 2026-09-10 14:11 | ratio_risk_reversal | 2 | 2 | 1350 | 623250.00 | long | ask | 429.8700 | 0.4800 | ["380","450"] | ["0.3481","0.3233"] | ["452.75"] | ["ARCO"] | 380.0000 | 450.0000 | 29 | 29 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:11:48Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0818e-e000-7281-9452-15719dadae59 | TSM | 2026-09-08 11:06 | call_vertical_spread | 2 | 1 | 1500 | 10650000.00 | long | ask | 437.9200 | 2.3500 | ["420","500"] | ["0.3762","0.3809"] | ["451"] | ["ARCO"] | 420.0000 | 500.0000 | 129 | 129 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:07:08Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |