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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0afb7-403b-7081-ab35-26e5bf20d910 | SPX | 2026-09-17 10:13 | call_ratio_spread | 2 | 1 | 60 | 36300.00 | long | ask | 7614.8500 | 0.1500 | ["7625","7650"] | ["0.1608","0.1566"] | ["7629.30","7670.70"] | ["XCBO"] | 7625.0000 | 7650.0000 | 0 | 0 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:13:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb7-403b-7081-ab35-26af42cd851f | SPX | 2026-09-17 10:13 | call_ratio_spread | 2 | 1 | 236 | 142780.00 | long | ask | 7614.8500 | 0.1500 | ["7625","7650"] | ["0.1608","0.1566"] | ["7629.30","7670.70"] | ["XCBO"] | 7625.0000 | 7650.0000 | 0 | 0 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:13:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a59a-942e-7540-91ac-303eb3e62582 | SPX | 2026-09-15 11:06 | call_ratio_spread | 2 | 1 | 111 | 54945.00 | long | ask | 7581.5400 | 0.1797 | ["7580","7620"] | ["0.1472","0.1575"] | ["7587.95","7636.02"] | ["XCBO"] | 7580.0000 | 7620.0000 | 0 | 0 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:06:22Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a034-ce98-7103-9ca0-f6c14c1e0e62 | SPX | 2026-09-14 09:56 | call_ratio_spread | 2 | 1 | 6 | 45000.00 | long | ask | 7612.3500 | 1.1000 | ["7700","7850"] | ["0.1275","0.1145"] | ["7724.80","7975.20"] | ["XCBO"] | 7700.0000 | 7850.0000 | 32 | 32 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:56:59Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08bc2-5340-7d11-8973-af7bba40e58f | SPX | 2026-09-10 10:39 | call_ratio_spread | 2 | 2 | 50 | 36000.00 | long | ask | 7607.8400 | 0.2020 | ["7610","7640"] | ["0.1556","0.1508"] | ["7617","7663.00"] | ["XCBO"] | 7610.0000 | 7640.0000 | 0 | 0 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:39:40Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bc2-4b71-7032-91fa-95a9fcc4b260 | SPX | 2026-09-10 10:39 | call_ratio_spread | 2 | 2 | 40 | 28800.00 | long | ask | 7607.7900 | 0.1750 | ["7610","7640"] | ["0.1559","0.1510"] | ["7617","7663.00"] | ["XCBO"] | 7610.0000 | 7640.0000 | 0 | 0 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:39:40Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |