Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
403,968 rowsCSV — whole table, not this view
Sources in this table
uw_multileg403,968 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0ca6a-2b57-7ac3-983b-1ce9375df79f | DE | 2026-09-22 14:39 | call_vertical_spread | 2 | 1 | 10 | 67660.00 | long | ask | 699.1000 | 12.1000 | ["665","667.5"] | ["0.3742","0.3659"] | ["667.38"] | ["XCBO"] | 665.0000 | 667.5000 | 3 | 3 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:39:23Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9e8-a716-7071-babd-c46734b3ffb2 | DE | 2026-09-22 12:17 | call_vertical_spread | 2 | 1 | 5 | 29670.00 | short | bid | 694.1125 | 6.1000 | ["665","667.5"] | ["0.4067","0.3965"] | ["667.3"] | ["XCBO"] | 665.0000 | 667.5000 | 3 | 3 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T16:18:10Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9be-f34e-70f3-8914-243fcbfa7328 | DE | 2026-09-22 11:32 | call_vertical_spread | 2 | 1 | 20 | 118540.00 | long | ask | 693.1850 | 9.5000 | ["665","667.5"] | ["0.4637","0.4467"] | ["667.33"] | ["XCBO"] | 665.0000 | 667.5000 | 3 | 3 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T15:32:24Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9bd-a746-7982-8013-6773ea05ed25 | DE | 2026-09-22 11:30 | call_vertical_spread | 2 | 1 | 5 | 29625.00 | unknown | — | 693.1850 | 9.5000 | ["665","667.5"] | ["0.4603","0.4486"] | [] | ["AMXO"] | 665.0000 | 667.5000 | 3 | 3 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T15:31:04Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c469-ab97-7062-8eec-18c43c10573b | DE | 2026-09-21 10:40 | call_vertical_spread | 2 | 1 | 5 | 66645.00 | long | ask | 689.6900 | 6.4000 | ["690","700"] | ["0.3252","0.3241"] | ["694.89"] | ["XMIO"] | 690.0000 | 700.0000 | 179 | 179 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:41:09Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0a613-004e-7043-966f-70353f51f6d8 | DE | 2026-09-15 13:17 | call_vertical_spread | 2 | 1 | 9 | 45675.00 | unknown | — | 686.8450 | 12.5000 | ["662.5","665"] | ["0.3910","0.3863"] | [] | ["XCBO"] | 662.5000 | 665.0000 | 3 | 3 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:18:02Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a58c-24de-77a3-98bb-c20245e37881 | DE | 2026-09-15 10:50 | call_vertical_spread | 2 | 1 | 10 | 48740.00 | short | bid | 684.7300 | 8.3000 | ["662.5","665"] | ["0.4367","0.4286"] | ["664.6"] | ["XCBO"] | 662.5000 | 665.0000 | 3 | 3 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:50:35Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a085-f408-7e81-9233-92ae17ad1dbe | DE | 2026-09-14 11:25 | call_vertical_spread | 2 | 1 | 4 | 58400.00 | unknown | — | 687.5500 | 11.8000 | ["612.5","615"] | ["0.7832","0.7619"] | [] | ["XCBO"] | 612.5000 | 615.0000 | 4 | 4 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:25:35Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091f7-e108-7293-aae9-810e4393ec39 | DE | 2026-09-11 15:35 | call_vertical_spread | 2 | 1 | 2 | 50572.00 | short | bid | 676.4350 | 12.9000 | ["660","700"] | ["0.3648","0.3617"] | ["678.32"] | ["XMIO"] | 660.0000 | 700.0000 | 497 | 497 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:35:36Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08686-6ba0-71b3-b93e-e6293d3e7c0f | DE | 2026-09-09 10:15 | call_vertical_spread | 2 | 1 | 2 | 46946.00 | short | bid | 681.2900 | 15.3000 | ["562.5","567.5"] | ["1.4428","1.3894"] | ["567.49"] | ["XCBO"] | 562.5000 | 567.5000 | 2 | 2 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:16:05Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08681-fed0-7863-b953-28878877bc45 | DE | 2026-09-09 10:10 | call_vertical_spread | 2 | 1 | 2 | 44082.00 | long | ask | 680.6950 | 9.2000 | ["570","572.5"] | ["1.2576","1.2409"] | ["572.47"] | ["XCBO"] | 570.0000 | 572.5000 | 2 | 2 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:11:15Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06db3-a3cd-7110-a4b4-9150a77c6edf | DE | 2026-09-04 14:34 | call_vertical_spread | 2 | 1 | 15 | 41640.00 | unknown | — | 695.4250 | 10.9000 | ["680","682.5"] | ["2.2219","2.0425"] | [] | ["XCBO"] | 680.0000 | 682.5000 | 0 | 0 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:35:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d23-2f55-71f0-979b-046bc5fe9e81 | DE | 2026-09-04 11:56 | call_vertical_spread | 2 | 1 | 7 | 55188.00 | long | ask | 698.5000 | 6.5000 | ["650","680"] | ["0.3039","0.2908"] | ["674.26"] | ["XMIO"] | 650.0000 | 680.0000 | 14 | 14 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T15:57:07Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |