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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b611-c698-7221-883d-d1180e2ce2f5 | AAPL | 2026-09-18 15:50 | call_backspread | 2 | 1 | 10 | 38920.00 | long | bid | 336.7900 | 2.9500 | ["330","380"] | ["0.2790","0.2639"] | ["333.40","426.60"] | ["XMIO"] | 330.0000 | 380.0000 | 272 | 272 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:50:15Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4be-cd40-7ff3-8af7-927303520ece | AAPL | 2026-09-18 09:39 | call_backspread | 2 | 1 | 14 | 42704.00 | long | bid | 336.6000 | 1.3000 | ["300","330"] | ["2.1747","0.5786"] | ["326.11","337.00"] | ["AMXO"] | 300.0000 | 330.0000 | 0 | 0 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:40:09Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b01a-a58b-73d3-9038-39e14dcb73ee | AAPL | 2026-09-17 12:02 | call_backspread | 2 | 1 | 40 | 33940.00 | long | bid | 335.3700 | 0.3000 | ["332.5","335"] | ["0.2470","0.2447"] | ["341.25"] | ["XISX"] | 332.5000 | 335.0000 | 8 | 8 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:02:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afc8-b113-73b1-b049-69e68853442b | AAPL | 2026-09-17 10:32 | call_backspread | 2 | 1 | 3 | 42926.00 | long | bid | 333.3000 | 2.6000 | ["240","310"] | ["0.3169","0.2892"] | ["256.21","417.58"] | ["C2OX"] | 240.0000 | 310.0000 | 491 | 491 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:33:00Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a68c-d7b6-7b72-b1e6-2849d2e43cdc | AAPL | 2026-09-15 15:30 | call_backspread | 2 | 1 | 24 | 36648.00 | long | bid | 329.9100 | 1.1500 | ["320","340"] | ["0.2599","0.2421"] | ["324.10","355.90"] | ["XMIO"] | 320.0000 | 340.0000 | 38 | 38 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:31:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5a0-9b25-7f21-8fa0-dc7dfc01dffa | AAPL | 2026-09-15 11:12 | call_backspread | 2 | 2 | 20 | 41020.00 | long | bid | 329.4200 | 0.5000 | ["320","325"] | ["0.2564","0.2522"] | ["339.38"] | ["BATO"] | 320.0000 | 325.0000 | 31 | 31 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:12:55Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a09202-f8e1-78b3-9d42-462a36368d2f | AAPL | 2026-09-11 15:47 | call_backspread | 2 | 1 | 20 | 32670.00 | long | bid | 332.6100 | 0.5000 | ["315","345"] | ["0.2563","0.2351"] | ["326.75","363.25"] | ["XPHO"] | 315.0000 | 345.0000 | 35 | 35 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:48:02Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091a3-96e8-7113-b39b-efdec5a8201b | AAPL | 2026-09-11 14:03 | call_backspread | 2 | 2 | 40 | 61400.00 | unknown | — | 333.6550 | 0.3500 | ["320","345"] | ["0.2544","0.2379"] | [] | ["XISX","XPHO"] | 320.0000 | 345.0000 | 35 | 35 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:03:48Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09148-1138-7273-8bab-7ae028c5123b | AAPL | 2026-09-11 12:23 | call_backspread | 2 | 1 | 12 | 210408.00 | long | bid | 334.1100 | 3.0000 | ["185","240"] | ["0.5679","0.3946"] | ["340.60"] | ["XCBO"] | 185.0000 | 240.0000 | 126 | 126 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:24:08Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090f6-1cc0-7d12-acf8-14c6746bfa29 | AAPL | 2026-09-11 10:54 | call_backspread | 2 | 2 | 40 | 76040.00 | long | bid | 335.1350 | 0.5000 | ["315","345"] | ["0.2717","0.2489"] | ["326.30","363.70"] | ["XISX","XPHO"] | 315.0000 | 345.0000 | 35 | 35 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:54:21Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08b8d-1e28-7a63-a67c-22533bacd0d4 | AAPL | 2026-09-10 09:41 | call_backspread | 2 | 1 | 200 | 115900.00 | long | bid | 319.3951 | 0.3200 | ["315","320"] | ["0.4585","0.4790"] | ["325.09"] | ["EDGO"] | 315.0000 | 320.0000 | 1 | 1 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:41:26Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08277-d0d1-7b43-b513-f22d01f4bbbe | AAPL | 2026-09-08 15:21 | call_backspread | 2 | 1 | 10 | 28390.00 | long | bid | 315.8900 | 1.5000 | ["280","320"] | ["0.2985","0.2588"] | ["299.90","340.10"] | ["EMLD"] | 280.0000 | 320.0000 | 38 | 38 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:22:02Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dd6-8d4d-7213-b4ec-d753da2460f9 | AAPL | 2026-09-04 15:12 | call_backspread | 2 | 1 | 280 | 151440.00 | long | bid | 322.0400 | 0.3000 | ["325","327.5"] | ["0.2508","0.2514"] | ["332.16"] | ["XMIO"] | 325.0000 | 327.5000 | 14 | 14 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:12:56Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |