Simplify AnalyticsMulti-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c589-216f-7251-bc36-41a17ccee627 | SPX | 2026-09-21 15:54 | call_condor | 4 | 1 | 300 | 49500.00 | unknown | ask | 7768.2100 | 0.2500 | ["7770","7775","7785","7790"] | ["0.2045","0.2348","0.3433","0.3813"] | ["7771.65"] | ["XCBO"] | 7770.0000 | 7790.0000 | 0 | 0 | false | true | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:55:03Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c521-f747-72b3-a5d6-7e36f49209e9 | SPX | 2026-09-21 14:02 | call_condor | 4 | 1 | 100 | 307600.00 | unknown | bid | 7761.0700 | 0.7000 | ["7750","7755","7760","7765"] | ["0.1231","0.1123","0.1089","0.1091"] | ["7765.19"] | ["XCBO"] | 7750.0000 | 7765.0000 | 0 | 0 | false | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:02:34Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b581-88d0-7b43-80ac-ef16ed444425 | SPX | 2026-09-18 13:12 | call_condor | 4 | 2 | 129 | 1242528.00 | unknown | ask | 7621.5700 | 0.8000 | ["7630","7635","7650","7655"] | ["0.0905","0.0896","0.0870","0.0863"] | ["7666.58"] | ["XCBO"] | 7630.0000 | 7655.0000 | 5 | 5 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:12:48Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0abbb-db62-7c73-8439-3679bfc79626 | SPX | 2026-09-16 15:40 | call_condor | 4 | 1 | 100 | 347300.00 | unknown | — | 7534.8400 | 1.3000 | ["7825","7875","7925","7975"] | ["0.1120","0.1101","0.1092","0.1097"] | [] | ["XCBO"] | 7825.0000 | 7975.0000 | 28 | 28 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:40:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5b2-b3f6-7f22-a44a-1b304e11a1e5 | SPX | 2026-09-15 11:32 | call_condor | 4 | 2 | 200 | 627800.00 | unknown | — | 7582.6600 | 1.2000 | ["7875","7900","7925","7950"] | ["0.1108","0.1099","0.1089","0.1083"] | [] | ["XCBO"] | 7875.0000 | 7950.0000 | 24 | 24 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:32:32Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0822b-0891-79b2-82b5-7eef9e348ba4 | SPX | 2026-09-08 13:57 | call_condor | 4 | 1 | 50 | 3478500.00 | unknown | — | 7691.2700 | 6.3000 | ["8500","9000","9500","10000"] | ["0.1466","0.1373","0.1321","0.1301"] | [] | ["XCBO"] | 8500.0000 | 10000.0000 | 465 | 465 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:57:36Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |