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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b618-4e77-7051-b976-893fe1c23d32 | MSFT | 2026-09-18 15:57 | put_ratio_spread | 2 | 1 | 60 | 28640.00 | unknown | ask | 493.6300 | 1.5900 | ["185","210"] | ["0.4033","0.3884"] | ["202.84"] | ["XISX"] | 185.0000 | 210.0000 | 819 | 819 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:57:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b613-511f-7402-8179-062dce790c79 | MSFT | 2026-09-18 15:51 | put_ratio_spread | 2 | 3 | 180 | 103020.00 | unknown | ask | 493.1400 | 3.4267 | ["185","210"] | ["0.4166","0.4029"] | ["201.42"] | ["AMXO","XBOX","XCBO"] | 185.0000 | 210.0000 | 819 | 819 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:55Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4b9-b0a7-76e1-b766-b863eb3568e6 | MSFT | 2026-09-18 09:34 | put_ratio_spread | 2 | 1 | 60 | 28460.00 | unknown | bid | 495.2900 | 4.0400 | ["185","210"] | ["0.4041","0.3884"] | ["134.85"] | ["AMXO"] | 185.0000 | 210.0000 | 819 | 819 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:34:34Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4b9-7ddf-74f3-9e75-4e81e115a7c8 | MSFT | 2026-09-18 09:34 | put_ratio_spread | 2 | 1 | 60 | 28720.00 | unknown | ask | 495.3800 | 4.0400 | ["185","210"] | ["0.4042","0.3898"] | ["202.82"] | ["XPHO"] | 185.0000 | 210.0000 | 819 | 819 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:34:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4b9-3f5f-7e12-bfc6-01b11aebaadb | MSFT | 2026-09-18 09:33 | put_ratio_spread | 2 | 1 | 60 | 28860.00 | unknown | bid | 495.0100 | 4.0400 | ["185","210"] | ["0.4050","0.3894"] | ["134.85"] | ["XISX"] | 185.0000 | 210.0000 | 819 | 819 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:34:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a5be-8366-7523-9487-201295782821 | MSFT | 2026-09-15 11:45 | put_ratio_spread | 2 | 1 | 22 | 29733.00 | unknown | — | 499.6100 | 0.4500 | ["480","500"] | ["0.2612","0.2508"] | [] | ["XISX"] | 480.0000 | 500.0000 | 31 | 31 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:45:21Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |