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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5e6-49c7-7ed1-ad87-2f5221ecbc8e | SPX | 2026-09-18 15:02 | call_ratio_spread | 2 | 2 | 100 | 66900.00 | unknown | bid | 7641.5100 | 0.1500 | ["7640","7645"] | ["0.1346","0.1304"] | ["7646.06"] | ["XCBO"] | 7640.0000 | 7645.0000 | 0 | 0 | false | false | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:02:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b57c-413f-7032-a6d8-5d42648e611d | SPX | 2026-09-18 13:06 | call_ratio_spread | 2 | 1 | 146 | 77580.00 | unknown | bid | 7624.6200 | 0.1500 | ["7630","7635"] | ["0.1120","0.1129"] | ["7635.20"] | ["XCBO"] | 7630.0000 | 7635.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:07:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55a-da78-7570-ab2a-7890df5cf82f | SPX | 2026-09-18 12:30 | call_ratio_spread | 2 | 1 | 1500 | 7554800.00 | unknown | bid | 7617.1100 | 1.2000 | ["7850","8125"] | ["0.1243","0.1152"] | ["8155.03"] | ["XCBO"] | 7850.0000 | 8125.0000 | 91 | 91 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:30:34Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b557-a627-7762-910d-a57d5e860d91 | SPX | 2026-09-18 12:26 | call_ratio_spread | 2 | 2 | 195 | 179650.00 | unknown | bid | 7612.8300 | 0.2000 | ["7615","7620"] | ["0.1223","0.1244"] | ["7622.65"] | ["XCBO"] | 7615.0000 | 7620.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:27:11Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b507-d48f-7a82-8b46-27383017b3e2 | SPX | 2026-09-18 10:59 | call_ratio_spread | 2 | 2 | 100 | 28200.00 | unknown | bid | 7629.0500 | 0.1000 | ["7655","7660"] | ["0.1366","0.1407"] | ["7657.82"] | ["XCBO"] | 7655.0000 | 7660.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:59:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f3-cf8f-7a83-b3df-1fa455b271e9 | SPX | 2026-09-18 10:37 | call_ratio_spread | 2 | 1 | 590 | 121658.00 | unknown | bid | 7623.4000 | 0.1000 | ["7655","7660"] | ["0.1371","0.1415"] | ["7657.06"] | ["XCBO"] | 7655.0000 | 7660.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:38:08Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4db-1388-7321-a814-f4d0e1d29ee4 | SPX | 2026-09-18 10:10 | call_ratio_spread | 2 | 2 | 199 | 39360.00 | unknown | bid | 7627.7400 | 0.1000 | ["7660","7665"] | ["0.1316","0.1369"] | ["7661.98"] | ["XCBO"] | 7660.0000 | 7665.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:11:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4bc-3917-7ae0-9c70-83e6bd713d28 | SPX | 2026-09-18 09:37 | call_ratio_spread | 2 | 2 | 300 | 169200.00 | unknown | bid | 7639.6400 | 0.1500 | ["7660","7665"] | ["0.1361","0.1370"] | ["7665.40"] | ["XCBO"] | 7660.0000 | 7665.0000 | 0 | 0 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:37:16Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |