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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0afc9-d223-7c43-8f9a-6ac0a4b81a25 | SPCX | 2026-09-17 10:33 | call_backspread | 2 | 1 | 40 | 67600.00 | long | bid | 154.7960 | 0.5500 | ["160","165"] | ["0.5538","0.5537"] | ["178.72"] | ["XCBO"] | 160.0000 | 165.0000 | 64 | 64 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:33:56Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a091e7-9140-74f1-ac89-598ef139d706 | SPCX | 2026-09-11 15:17 | call_backspread | 2 | 1 | 388 | 93314.00 | long | bid | 150.1600 | 0.0600 | ["150","170"] | ["0.4987","0.5500"] | ["153.73","186.27"] | ["XPHO"] | 150.0000 | 170.0000 | 7 | 7 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:18:02Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091e7-0888-74a2-bd3f-b8d1a8f1771a | SPCX | 2026-09-11 15:17 | call_backspread | 2 | 1 | 230 | 54625.00 | unknown | — | 150.1050 | 0.0600 | ["150","170"] | ["0.4961","0.5492"] | [] | ["XMIO"] | 150.0000 | 170.0000 | 7 | 7 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:17:24Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091e5-a128-78d3-a05d-4825e9d827c2 | SPCX | 2026-09-11 15:15 | call_backspread | 2 | 1 | 162 | 39123.00 | long | bid | 150.1550 | 0.0600 | ["150","170"] | ["0.4990","0.5543"] | ["153.71","186.29"] | ["XPHO"] | 150.0000 | 170.0000 | 7 | 7 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:15:51Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091e5-2fe0-7002-83b8-5537f44b2625 | SPCX | 2026-09-11 15:15 | call_backspread | 2 | 1 | 400 | 95200.00 | long | bid | 150.1200 | 0.1100 | ["150","170"] | ["0.4952","0.5510"] | ["153.68","186.32"] | ["XPHO"] | 150.0000 | 170.0000 | 7 | 7 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:15:20Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08b9e-0a30-7ad0-98ea-30cf8386c449 | SPCX | 2026-09-10 09:59 | call_backspread | 2 | 2 | 100 | 41200.00 | long | bid | 153.9999 | 0.2400 | ["155","185"] | ["0.5668","0.6344"] | ["160.16","209.84"] | ["MCRY","XMIO"] | 155.0000 | 185.0000 | 15 | 15 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:59:43Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a081b5-1d10-7f73-ac35-af4cb40c2348 | SPCX | 2026-09-08 11:48 | call_backspread | 2 | 1 | 22 | 33334.00 | long | bid | 153.0219 | 0.1000 | ["143","150"] | ["0.5749","0.5724"] | ["143.40","161.56"] | ["XISX"] | 143.0000 | 150.0000 | 10 | 10 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:49:21Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dd1-0b25-7fc0-b462-7695134787e7 | SPCX | 2026-09-04 15:06 | call_backspread | 2 | 1 | 6 | 55386.00 | long | bid | 148.7600 | 2.4500 | ["100","150"] | ["0.5809","0.5760"] | ["233.70"] | ["XMIO"] | 100.0000 | 150.0000 | 833 | 833 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:07:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |