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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06dfb-9d95-7a71-8566-2e23fef94588 | MU | 2026-09-04 15:53 | put_diagonal_spread_bearish | 2 | 1 | 10 | 40842.00 | long | ask | 1010.7101 | 0.6500 | ["990","1010"] | ["0.4495","0.5289"] | [] | ["XCBO"] | 990.0000 | 1010.0000 | 5 | 7 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:53:21Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06df7-ec45-7c30-87e9-bb2fba1790cc | QQQ | 2026-09-04 15:49 | put_diagonal_spread_bearish | 2 | 1 | 17 | 66912.00 | short | bid | 718.4800 | 0.6600 | ["735","740"] | ["0.1389","0.1534"] | [] | ["XCBO"] | 735.0000 | 740.0000 | 7 | 14 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:49:31Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06df0-33b5-7530-8ceb-db583b6c9ff3 | SPX | 2026-09-04 15:40 | put_diagonal_spread_bearish | 2 | 1 | 2 | 35096.00 | long | ask | 7713.6800 | 0.7000 | ["7640","7740"] | ["0.1220","0.1229"] | [] | ["XCBO"] | 7640.0000 | 7740.0000 | 21 | 42 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:41:10Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06ded-0f05-7720-9068-6aa2958ed614 | PANW | 2026-09-04 15:37 | put_diagonal_spread_bearish | 2 | 2 | 22 | 58114.00 | long | ask | 331.3200 | 4.4700 | ["335","352.5"] | ["1.2347","0.4391"] | [] | ["XMIO"] | 335.0000 | 352.5000 | 0 | 7 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:37:46Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dda-7d1d-7352-bd4a-ad5734ea8efa | META | 2026-09-04 15:17 | put_diagonal_spread_bearish | 2 | 1 | 100 | 152700.00 | short | bid | 616.3602 | 0.1100 | ["560","615"] | ["3.6448","0.3405"] | [] | ["XCBO"] | 560.0000 | 615.0000 | 0 | 14 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:17:40Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dcb-989d-7de3-a9cf-2a440d56f887 | SPX | 2026-09-04 15:00 | put_diagonal_spread_bearish | 2 | 1 | 2 | 29748.00 | long | ask | 7716.8700 | 0.8000 | ["7720","7730"] | ["0.1040","0.1158"] | [] | ["XCBO"] | 7720.0000 | 7730.0000 | 12 | 28 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:01:26Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d87-2145-7533-9ce6-cadc8d4f6c17 | IWM | 2026-09-04 13:46 | put_diagonal_spread_bearish | 2 | 1 | 343 | 215404.00 | long | ask | 295.2401 | 0.0800 | ["289","292"] | ["0.1835","0.1809"] | [] | ["XMIO"] | 289.0000 | 292.0000 | 14 | 35 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:46:38Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d79-6d76-76c3-9f41-914365160015 | SNDK | 2026-09-04 13:31 | put_diagonal_spread_bearish | 2 | 1 | 10 | 210060.00 | long | ask | 1715.7500 | 15.8000 | ["1550","1575"] | ["0.7570","0.7562"] | [] | ["XCBO"] | 1550.0000 | 1575.0000 | 42 | 49 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:31:38Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d57-0cae-70b1-9f8d-85110a7a69c3 | DELL | 2026-09-04 12:53 | put_diagonal_spread_bearish | 2 | 1 | 10 | 46290.00 | long | ask | 525.4001 | 1.2400 | ["440","530"] | ["0.6204","0.6095"] | [] | ["XMIO"] | 440.0000 | 530.0000 | 14 | 42 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:53:35Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d56-495d-7af2-b585-7e5d335c7515 | MDB | 2026-09-04 12:52 | put_diagonal_spread_bearish | 2 | 1 | 75 | 138675.00 | short | bid | 376.5400 | 3.7900 | ["375","380"] | ["0.9985","0.5037"] | [] | ["XISX"] | 375.0000 | 380.0000 | 0 | 14 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:52:59Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d4d-390d-7b82-80ec-827e1d31a3ae | QQQ | 2026-09-04 12:42 | put_diagonal_spread_bearish | 2 | 1 | 1000 | 1569000.00 | short | bid | 718.7550 | 0.1200 | ["710","718"] | ["0.1685","0.1678"] | [] | ["XISX"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:43:14Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d4c-2f6d-7852-b00c-ca998a81a481 | QQQ | 2026-09-04 12:41 | put_diagonal_spread_bearish | 2 | 1 | 1000 | 1568000.00 | short | bid | 718.7800 | 0.1300 | ["710","718"] | ["0.1687","0.1678"] | [] | ["XISX"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:41:49Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d48-dbdd-7202-9aaf-30046a60bacf | TSM | 2026-09-04 12:38 | put_diagonal_spread_bearish | 2 | 1 | 15 | 100980.00 | long | ask | 427.3800 | 2.6500 | ["410","420"] | ["0.3660","0.3711"] | [] | ["XCBO"] | 410.0000 | 420.0000 | 168 | 196 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:38:21Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d41-07f5-7902-bb55-795a53d3ce67 | SPCX | 2026-09-04 12:29 | put_diagonal_spread_bearish | 2 | 1 | 15 | 30015.00 | short | bid | 148.3822 | 0.3000 | ["135","140"] | ["0.5461","0.5406"] | [] | ["XMIO"] | 135.0000 | 140.0000 | 77 | 105 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:29:55Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d29-2a95-77d3-ba39-d225c221d5ca | SPX | 2026-09-04 12:03 | put_diagonal_spread_bearish | 2 | 1 | 7 | 48202.00 | long | ask | 7715.3100 | 0.7000 | ["7620","7625"] | ["0.1224","0.1183"] | [] | ["XCBO"] | 7620.0000 | 7625.0000 | 14 | 17 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:03:48Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |