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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c9aa-b79e-7d31-ba86-f22740bd1fb9 | PANW | 2026-09-22 11:10 | straddle | 2 | 1 | 300 | 8182500.00 | short | bid | 368.2200 | 12.5000 | ["480"] | ["0.5810"] | ["207.25","752.75"] | ["SPHR"] | 480.0000 | 480.0000 | 815 | 815 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T15:10:27Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0b602-6ce8-78b2-942e-3b8d3923e50e | PANW | 2026-09-18 15:33 | straddle | 2 | 1 | 33 | 396990.00 | long | ask | 361.8050 | 1.1000 | ["400"] | ["0.5599"] | ["279.70","520.30"] | ["ARCO"] | 400.0000 | 400.0000 | 182 | 182 | false | false | false | false | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:33:26Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5eb-e747-7e63-8827-2e3b4787a283 | PANW | 2026-09-18 15:08 | straddle | 2 | 1 | 4 | 48084.00 | short | bid | 362.6300 | 3.6000 | ["400"] | ["0.5594"] | ["279.79","520.21"] | ["MCRY"] | 400.0000 | 400.0000 | 182 | 182 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:08:54Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5eb-00cf-7931-a311-22f7536d10af | PANW | 2026-09-18 15:07 | straddle | 2 | 1 | 3 | 36060.00 | short | bid | 362.5800 | 4.9000 | ["400"] | ["0.5594"] | ["279.80","520.20"] | ["EMLD"] | 400.0000 | 400.0000 | 182 | 182 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:08:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0e4-100b-7a43-a716-a73c8e367ea0 | PANW | 2026-09-17 15:42 | straddle | 2 | 4 | 25 | 369225.00 | long | ask | 376.2700 | 3.3500 | ["500"] | ["0.5618"] | ["352.31","647.69"] | ["EMLD","XISX"] | 500.0000 | 500.0000 | 120 | 120 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:42:22Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0e4-100b-7a43-a716-a72e90ed07ee | PANW | 2026-09-17 15:42 | straddle | 2 | 4 | 28 | 413343.00 | short | bid | 376.2700 | 1.3643 | ["500"] | ["0.5613"] | ["352.38","647.62"] | ["ARCO","MCRY","XISX"] | 500.0000 | 500.0000 | 120 | 120 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:42:22Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b01c-d423-7212-adcf-bfca47a75b49 | PANW | 2026-09-17 12:04 | straddle | 2 | 1 | 16 | 139360.00 | unknown | — | 374.8650 | 2.2000 | ["400"] | ["0.5558"] | [] | ["MCRY"] | 400.0000 | 400.0000 | 92 | 92 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:04:56Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa5-1f9b-76e1-8442-d3dc4435fce2 | PANW | 2026-09-17 09:53 | straddle | 2 | 1 | 13 | 89102.00 | short | bid | 371.5400 | 7.7000 | ["360"] | ["0.5565"] | ["291.46","428.54"] | ["ARCO"] | 360.0000 | 360.0000 | 64 | 64 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:54:03Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa5-1f9b-76e1-8442-d3ce6164881a | PANW | 2026-09-17 09:53 | straddle | 2 | 2 | 24 | 164448.00 | unknown | — | 371.5400 | 7.7000 | ["360"] | ["0.5563"] | [] | ["EDGO","XISX"] | 360.0000 | 360.0000 | 64 | 64 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:54:03Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aa75-940b-7e40-af1d-ed13f88e64f4 | PANW | 2026-09-16 09:43 | straddle | 2 | 3 | 8 | 35548.00 | short | bid | 378.4650 | 4.3000 | ["410"] | ["0.5543"] | ["365.56","454.44"] | ["ARCO","EMLD"] | 410.0000 | 410.0000 | 16 | 16 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:43:56Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a15b-0300-7601-9663-d2d7e49c4f86 | PANW | 2026-09-14 15:18 | straddle | 2 | 2 | 40 | 92800.00 | short | bid | 375.2400 | 1.6500 | ["360"] | ["0.6336"] | ["336.80","383.20"] | ["XMIO"] | 360.0000 | 360.0000 | 4 | 4 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:18:09Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ce-72a0-70e3-b7bb-7ab36d91da27 | PANW | 2026-09-14 12:44 | straddle | 2 | 1 | 30 | 72690.00 | long | ask | 375.8100 | 1.3500 | ["360"] | ["0.6633"] | ["335.77","384.23"] | ["AMXO"] | 360.0000 | 360.0000 | 4 | 4 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:44:49Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a031-f421-7cb2-9fca-1feb939e9310 | PANW | 2026-09-14 09:53 | straddle | 2 | 4 | 14 | 71932.00 | long | ask | 350.8750 | 4.4393 | ["320"] | ["0.5063"] | ["268.62","371.38"] | ["MCRY","XISX","XPHO"] | 320.0000 | 320.0000 | 39 | 39 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:53:42Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |