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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b613-c64f-7520-b4c2-908a6000feb2 | SPX | 2026-09-18 15:52 | straddle_swap | 4 | 1 | 2 | 81122.00 | unknown | ask | 7642.1900 | 2.6000 | ["7700","7710"] | ["0.1116","0.1120"] | [] | ["XCBO"] | 7700.0000 | 7710.0000 | 31 | 32 | false | false | true | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:52:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b60b-5628-77e3-b9e5-5f173918f58c | SPY | 2026-09-18 15:43 | straddle_swap | 4 | 1 | 7 | 39550.00 | unknown | ask | 761.2000 | 0.2700 | ["760"] | ["0.1317"] | [] | ["XCBO"] | 760.0000 | 760.0000 | 28 | 63 | false | false | true | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:43:21Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5c6-9c67-7693-aeb2-fb0ef8bf8c0d | SPX | 2026-09-18 14:28 | straddle_swap | 4 | 1 | 2 | 32484.00 | unknown | ask | 7633.5700 | 1.0000 | ["7640"] | ["0.0999"] | [] | ["XCBO"] | 7640.0000 | 7640.0000 | 6 | 7 | false | false | true | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:28:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b594-f95f-79e3-b76e-8996b4ea90bf | SPX | 2026-09-18 13:33 | straddle_swap | 4 | 1 | 2 | 33482.00 | unknown | ask | 7623.3700 | 1.0000 | ["7630"] | ["0.1031"] | [] | ["XCBO"] | 7630.0000 | 7630.0000 | 6 | 7 | false | false | true | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:34:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b51f-11c8-7c01-8bb6-8625d6ac4bb9 | SPX | 2026-09-18 11:25 | straddle_swap | 4 | 1 | 2 | 31294.00 | unknown | ask | 7628.9900 | 0.9000 | ["7635"] | ["0.1001"] | [] | ["XCBO"] | 7635.0000 | 7635.0000 | 5 | 7 | false | false | true | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:25:31Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b51f-09f7-7483-9d45-d72a8db397cc | SPX | 2026-09-18 11:25 | straddle_swap | 4 | 1 | 2 | 31314.00 | unknown | ask | 7628.9200 | 0.9000 | ["7635"] | ["0.1002"] | [] | ["XCBO"] | 7635.0000 | 7635.0000 | 5 | 7 | false | false | true | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:25:31Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |