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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0afa6-63d3-7043-8eb6-2ba4d52a068a | QQQ | 2026-09-17 09:55 | call_backspread | 2 | 1 | 1500 | 2798676.00 | long | bid | 715.1900 | 0.2900 | ["730","765"] | ["0.1942","0.1796"] | ["786.15"] | ["EDGO"] | 730.0000 | 765.0000 | 92 | 92 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:55:13Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aba9-64d4-7750-ac89-09e9c55f0d40 | QQQ | 2026-09-16 15:19 | call_backspread | 2 | 1 | 132 | 27720.00 | long | bid | 701.3100 | 0.0300 | ["705","720"] | ["0.2454","0.2316"] | ["707.84","732.16"] | ["XPHO"] | 705.0000 | 720.0000 | 2 | 2 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:20:02Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a14b-10f8-73e3-be1f-0dd526fcc86c | QQQ | 2026-09-14 15:00 | call_backspread | 2 | 1 | 100 | 53800.00 | long | bid | 711.5800 | 0.0400 | ["710","714"] | ["0.1971","0.1843"] | ["718.64"] | ["MCRY"] | 710.0000 | 714.0000 | 2 | 2 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:01:06Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a116-ed51-71f2-b96f-ffa5e60cd6ca | QQQ | 2026-09-14 14:03 | call_backspread | 2 | 1 | 200 | 50500.00 | long | bid | 712.2527 | 0.0300 | ["712","715"] | ["0.1643","0.1554"] | ["712.17","717.83"] | ["MCRY"] | 712.0000 | 715.0000 | 1 | 1 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:04:24Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a090f4-2ca9-7442-b871-758728280cb0 | QQQ | 2026-09-11 10:51 | call_backspread | 2 | 1 | 20 | 36420.00 | long | bid | 714.8500 | 0.2100 | ["715","730"] | ["0.1807","0.1679"] | ["746.90"] | ["XCBO"] | 715.0000 | 730.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:52:12Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090e9-0531-7563-8ca3-6d95d957a45b | QQQ | 2026-09-11 10:39 | call_backspread | 2 | 1 | 20 | 36770.00 | unknown | — | 714.8050 | 0.2100 | ["715","730"] | ["0.1823","0.1695"] | [] | ["MCRY"] | 715.0000 | 730.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:40:10Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090e8-d651-7f51-a989-a270b6197e8d | QQQ | 2026-09-11 10:39 | call_backspread | 2 | 1 | 20 | 36900.00 | long | bid | 714.9200 | 0.1900 | ["715","730"] | ["0.1821","0.1694"] | ["747.06"] | ["XCBO"] | 715.0000 | 730.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:39:40Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |