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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b559-3880-7051-94a6-6ef84ccb2250 | IWM | 2026-09-18 12:28 | put_ratio_spread | 2 | 1 | 116 | 34974.00 | unknown | bid | 282.6950 | 0.2200 | ["282","287"] | ["0.1178","0.1186"] | ["279.63","284.37"] | ["XMIO"] | 282.0000 | 287.0000 | 3 | 3 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:28:40Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4be-6f80-7b20-bdca-375ed94fac68 | IWM | 2026-09-18 09:39 | put_ratio_spread | 2 | 1 | 2825 | 1489234.00 | unknown | bid | 283.9150 | 0.1000 | ["281","285"] | ["0.1698","0.1533"] | ["253.47","283.76"] | ["XISX"] | 281.0000 | 285.0000 | 12 | 12 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:39:39Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0abbe-7b43-72e2-a369-c58d7866513a | IWM | 2026-09-16 15:42 | put_ratio_spread | 2 | 1 | 900 | 403500.00 | unknown | — | 282.4900 | 0.1000 | ["278","283"] | ["0.2265","0.2003"] | [] | ["XISX"] | 278.0000 | 283.0000 | 9 | 9 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:43:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abb6-16d3-7720-ab15-6da80c53f4df | IWM | 2026-09-16 15:33 | put_ratio_spread | 2 | 1 | 1456 | 315224.00 | unknown | — | 282.1950 | 0.0700 | ["270","280"] | ["0.2659","0.2157"] | [] | ["AMXO"] | 270.0000 | 280.0000 | 9 | 9 | false | true | false | true | false | mlat | 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 |
| 01a0ab28-ee1b-7a70-87eb-b80f93452338 | IWM | 2026-09-16 12:59 | put_ratio_spread | 2 | 1 | 2500 | 1130000.00 | unknown | — | 286.5550 | 0.0500 | ["270","280"] | ["0.2319","0.2035"] | [] | ["XPHO"] | 270.0000 | 280.0000 | 30 | 30 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:00:24Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a588-7775-7122-aa94-7512e39bbda1 | IWM | 2026-09-15 10:46 | put_ratio_spread | 2 | 1 | 550 | 593550.00 | unknown | — | 284.6600 | 0.1300 | ["284","287"] | ["0.1966","0.1881"] | [] | ["EDGO"] | 284.0000 | 287.0000 | 24 | 24 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:46:33Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a55a-fed6-7981-a208-2e4ac658bf5a | IWM | 2026-09-15 09:56 | put_ratio_spread | 2 | 1 | 550 | 525200.00 | unknown | — | 285.7500 | 0.1200 | ["284","287"] | ["0.1919","0.1837"] | [] | ["EDGO"] | 284.0000 | 287.0000 | 24 | 24 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:56:50Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |