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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0a038-e961-79b0-988e-07400f9ea5bb | XSP | 2026-09-14 10:01 | call_condor | 4 | 1 | 320 | 29824.00 | long | ask | 761.5600 | 0.8200 | ["757","758","763","764"] | ["0.2131","0.1201","0.1352","0.1368"] | ["758","763"] | ["XCBO"] | 757.0000 | 764.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:01:29Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a581-0536-7763-9b93-1de7ac19a821 | XSP | 2026-09-15 10:38 | call_condor | 4 | 1 | 650 | 32240.00 | unknown | — | 758.3000 | 0.7900 | ["756","757","763","764"] | ["0.1799","0.1674","0.1609","0.1708"] | [] | ["XCBO"] | 756.0000 | 764.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:38:17Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0aad0-a48b-7092-b3aa-04fa2302e6d2 | XSP | 2026-09-16 11:23 | call_condor | 4 | 1 | 1200 | 152760.00 | unknown | — | 761.6000 | 0.4800 | ["757","758","764","765"] | ["0.3880","0.3775","0.3322","0.3269"] | [] | ["XCBO"] | 757.0000 | 765.0000 | 0 | 0 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:23:31Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0afd4-4dbb-75f1-8a79-11da791f9f09 | XSP | 2026-09-17 10:45 | call_condor | 4 | 1 | 575 | 32189.80 | unknown | — | 763.0100 | 0.6300 | ["760","762","764","766"] | ["0.1598","0.1392","0.1301","0.1327"] | [] | ["XCBO"] | 760.0000 | 766.0000 | 0 | 0 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:45:41Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b61a-5600-7f42-b50e-a575b2c08b46 | XSP | 2026-09-18 15:59 | call_condor | 4 | 1 | 330 | 30030.00 | short | bid | 764.7800 | 1.7700 | ["760","761","764","765"] | ["6.6599","3.5079","1.0919","0.4068"] | ["760.20","764.80"] | ["XCBO"] | 760.0000 | 765.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b61a-59e8-7db2-be17-5f9581a2618e | XSP | 2026-09-18 15:59 | call_condor | 4 | 1 | 330 | 30129.00 | short | bid | 764.7900 | 1.7800 | ["760","761","764","765"] | ["6.7302","3.7725","1.0628","0.4034"] | ["760.17","764.83"] | ["XCBO"] | 760.0000 | 765.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b61a-5600-7f42-b50e-a5a1833f406d | XSP | 2026-09-18 15:59 | call_condor | 4 | 1 | 330 | 30129.00 | short | ask | 764.7800 | 1.7800 | ["760","761","764","765"] | ["6.7778","4.5444","1.1112","0.3667"] | [] | ["XCBO"] | 760.0000 | 765.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b61a-5600-7f42-b50e-a5998454fd88 | XSP | 2026-09-18 15:59 | call_condor | 4 | 1 | 330 | 30096.00 | short | bid | 764.7800 | 1.7800 | ["760","761","764","765"] | ["6.7778","3.7650","1.1112","0.4140"] | ["760.18","764.82"] | ["XCBO"] | 760.0000 | 765.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b61a-5600-7f42-b50e-a5878b9f4e69 | XSP | 2026-09-18 15:59 | call_condor | 4 | 1 | 330 | 30049.70 | short | bid | 764.7800 | 1.7800 | ["760","761","764","765"] | ["6.7778","3.7823","1.1112","0.4140"] | ["760.14","764.86"] | ["XCBO"] | 760.0000 | 765.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c4d4-ec9f-7931-af4a-228b6055f9e1 | XSP | 2026-09-21 12:38 | call_condor | 4 | 1 | 1055 | 67625.50 | unknown | — | 775.3300 | 0.1500 | ["772","773","776","777"] | ["0.1312","0.1132","0.1208","0.1271"] | [] | ["XCBO"] | 772.0000 | 777.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:38:17Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c512-2c4f-75d2-9ed9-b0113443081e | XSP | 2026-09-21 13:44 | call_condor | 4 | 1 | 1000 | 52600.00 | unknown | — | 775.9400 | 0.1200 | ["773","774","777","778"] | ["0.1479","0.1224","0.1116","0.1258"] | [] | ["XCBO"] | 773.0000 | 778.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:45:12Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c567-2a1e-7322-a952-1df097dc413e | XSP | 2026-09-21 15:17 | call_condor | 4 | 1 | 464 | 40321.60 | unknown | — | 777.4800 | 0.1500 | ["773","774","777","778"] | ["0.2741","0.2315","0.1330","0.1382"] | [] | ["XCBO"] | 773.0000 | 778.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:18:05Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |