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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5fb-a29f-7190-8265-5f751e70486c | SPCX | 2026-09-18 15:25 | straddle | 2 | 1 | 40 | 47120.00 | long | ask | 152.7700 | 0.2000 | ["152.5"] | ["0.4942"] | ["140.72","164.28"] | ["XMIO"] | 152.5000 | 152.5000 | 14 | 14 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:26:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4cf-eff7-7222-8c49-4cef498b4553 | SPCX | 2026-09-18 09:58 | straddle | 2 | 1 | 100 | 83800.00 | short | bid | 152.5400 | 0.1000 | ["152.5"] | ["0.4975"] | ["144.12","160.88"] | ["XMIO"] | 152.5000 | 152.5000 | 7 | 7 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:58:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a5c6-dc1e-7b11-9e43-ad3e083afdca | SPCX | 2026-09-15 11:54 | straddle | 2 | 1 | 100 | 64800.00 | long | ask | 144.6950 | 0.1200 | ["144"] | ["0.6182"] | ["137.52","150.48"] | ["XBOX"] | 144.0000 | 144.0000 | 3 | 3 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:55:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0874c-0590-70a3-8f26-46f1d506796a | SPCX | 2026-09-09 13:51 | straddle | 2 | 1 | 49 | 241470.00 | long | ask | 147.2399 | 0.3000 | ["160"] | ["0.5557"] | ["110.72","209.28"] | ["EDGO"] | 160.0000 | 160.0000 | 191 | 191 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:52:06Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0874b-2300-7a13-81ea-c3b6f81cf898 | SPCX | 2026-09-09 13:50 | straddle | 2 | 1 | 13 | 63930.00 | long | ask | 147.1799 | 0.4000 | ["160"] | ["0.5546"] | ["110.82","209.18"] | ["EDGO"] | 160.0000 | 160.0000 | 191 | 191 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:51:00Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0874b-2300-7a13-81ea-c3af6bd5f6b0 | SPCX | 2026-09-09 13:50 | straddle | 2 | 1 | 24 | 118001.00 | long | ask | 147.1799 | 0.4000 | ["160"] | ["0.5544"] | ["110.83","209.17"] | ["EDGO"] | 160.0000 | 160.0000 | 191 | 191 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:51:00Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0874a-e098-7440-a6e2-89b461fbd6d2 | SPCX | 2026-09-09 13:50 | straddle | 2 | 1 | 38 | 186578.00 | long | ask | 147.1900 | 0.4000 | ["160"] | ["0.5536"] | ["110.90","209.10"] | ["EDGO"] | 160.0000 | 160.0000 | 191 | 191 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:51:00Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0874a-57e0-7b41-bf02-f265862597ec | SPCX | 2026-09-09 13:49 | straddle | 2 | 1 | 45 | 220897.00 | long | ask | 147.0950 | 0.3500 | ["160"] | ["0.5535"] | ["110.91","209.09"] | ["EDGO"] | 160.0000 | 160.0000 | 191 | 191 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:50:02Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08749-bf88-7f50-bc45-659c38d55650 | SPCX | 2026-09-09 13:49 | straddle | 2 | 1 | 100 | 490792.00 | long | ask | 147.1200 | 0.6000 | ["160"] | ["0.5534"] | ["110.92","209.08"] | ["EDGO"] | 160.0000 | 160.0000 | 191 | 191 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:50:02Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0820d-37c0-77a1-a891-903ef2847e27 | SPCX | 2026-09-08 13:24 | straddle | 2 | 1 | 50 | 268000.00 | long | ask | 152.9050 | 0.5500 | ["170"] | ["0.5729"] | ["116.40","223.60"] | ["EDGO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:25:27Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0820d-1c68-7221-b694-dc19f17283b2 | SPCX | 2026-09-08 13:24 | straddle | 2 | 1 | 38 | 203528.00 | long | ask | 152.9250 | 0.5000 | ["170"] | ["0.5724"] | ["116.44","223.56"] | ["EDGO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:25:27Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |