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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b621-d00f-7cf1-9b58-58281587f2ad | SPY | 2026-09-18 16:07 | straddle | 2 | 1 | 1997 | 728905.00 | long | ask | 762.6500 | 0.0300 | ["763"] | ["0.0661"] | ["759.35","766.65"] | ["EDGO"] | 763.0000 | 763.0000 | 3 | 3 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T20:08:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0abc0-9e23-7cc2-89e3-b330c51f30e0 | SPY | 2026-09-16 15:45 | straddle | 2 | 1 | 46 | 28842.00 | short | bid | 752.3700 | 0.0300 | ["752"] | ["0.1993"] | ["745.73","758.27"] | ["EDGO"] | 752.0000 | 752.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:45:32Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abbc-e11b-7382-a3cc-0595cc3ff037 | SPY | 2026-09-16 15:41 | straddle | 2 | 1 | 61 | 38614.00 | short | bid | 752.5500 | 0.0400 | ["752"] | ["0.2009"] | ["745.67","758.33"] | ["EDGO"] | 752.0000 | 752.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:41:34Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abbc-0273-7421-b87e-90a2b95fbcf8 | SPY | 2026-09-16 15:40 | straddle | 2 | 1 | 68 | 43384.00 | short | bid | 752.1700 | 0.0200 | ["752"] | ["0.2030"] | ["745.62","758.38"] | ["EDGO"] | 752.0000 | 752.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:40:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abbb-ac83-78e2-ac05-85e905cecd2e | SPY | 2026-09-16 15:39 | straddle | 2 | 1 | 42 | 26880.00 | short | bid | 752.4400 | 0.0300 | ["752"] | ["0.2033"] | ["745.60","758.40"] | ["EDGO"] | 752.0000 | 752.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:40:02Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abbb-98fb-7252-939a-57613ede0a4e | SPY | 2026-09-16 15:39 | straddle | 2 | 1 | 41 | 26199.00 | short | bid | 752.5215 | 0.0300 | ["752"] | ["0.2028"] | ["745.61","758.39"] | ["EDGO"] | 752.0000 | 752.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:40:02Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abba-c223-7dc2-9bc7-adc45d0ec594 | SPY | 2026-09-16 15:38 | straddle | 2 | 1 | 68 | 43588.00 | unknown | — | 751.9900 | 0.0400 | ["752"] | ["0.2046"] | [] | ["EDGO"] | 752.0000 | 752.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:39:17Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abb8-4953-7502-8c49-1389ea54d79c | SPY | 2026-09-16 15:36 | straddle | 2 | 1 | 255 | 163710.00 | short | bid | 752.0600 | 0.0200 | ["752"] | ["0.2044"] | ["745.58","758.42"] | ["EDGO"] | 752.0000 | 752.0000 | 1 | 1 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:36:20Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abb8-456b-7502-9715-58ffb0edce1f | SPY | 2026-09-16 15:36 | straddle | 2 | 2 | 86 | 55298.00 | short | bid | 752.0700 | 0.0200 | ["752"] | ["0.2047"] | ["745.57","758.43"] | ["EDGO"] | 752.0000 | 752.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:36:20Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abb7-a543-7211-8b7a-e01dc923543d | SPY | 2026-09-16 15:35 | straddle | 2 | 1 | 50 | 32300.00 | short | bid | 752.3300 | 0.0300 | ["752"] | ["0.2054"] | ["745.54","758.46"] | ["EDGO"] | 752.0000 | 752.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:35:38Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abb6-6cc3-71e1-94e8-77405af27f10 | SPY | 2026-09-16 15:34 | straddle | 2 | 1 | 57 | 37335.00 | short | bid | 752.0450 | 0.0300 | ["752"] | ["0.2085"] | ["745.45","758.55"] | ["EDGO"] | 752.0000 | 752.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:34:16Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abb6-4d83-7122-923f-1cce8467727b | SPY | 2026-09-16 15:34 | straddle | 2 | 1 | 65 | 42575.00 | short | bid | 752.0601 | 0.0200 | ["752"] | ["0.2085"] | ["745.45","758.55"] | ["EDGO"] | 752.0000 | 752.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:34:16Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab8e-fb1b-78b2-b202-3583e9fc3a9c | SPY | 2026-09-16 14:51 | straddle | 2 | 1 | 80 | 53442.00 | short | bid | 757.0400 | 0.0300 | ["760"] | ["0.1977"] | ["753.32","766.68"] | ["XMIO"] | 760.0000 | 760.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:51:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab86-d143-7842-ae4c-f91b9071c447 | SPY | 2026-09-16 14:42 | straddle | 2 | 1 | 128 | 44544.00 | short | bid | 759.1850 | 0.0300 | ["760"] | ["0.4637"] | ["756.52","763.48"] | ["XMIO"] | 760.0000 | 760.0000 | 0 | 0 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:42:23Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab86-d143-7842-ae4c-f8f8363a3c52 | SPY | 2026-09-16 14:42 | straddle | 2 | 1 | 78 | 27222.00 | short | bid | 759.1850 | 0.0300 | ["760"] | ["0.4651"] | ["756.51","763.49"] | ["XMIO"] | 760.0000 | 760.0000 | 0 | 0 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:42:23Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab73-ed53-7341-8b6d-f151ee9d5c29 | SPY | 2026-09-16 14:21 | straddle | 2 | 1 | 100 | 63400.00 | unknown | — | 760.1200 | 0.0400 | ["760"] | ["0.1997"] | [] | ["XCBO"] | 760.0000 | 760.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:21:54Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab5a-9cdb-7333-ab65-eed959ea4960 | SPY | 2026-09-16 13:53 | straddle | 2 | 1 | 61 | 42700.00 | long | ask | 759.7950 | 0.0200 | ["760"] | ["0.2206"] | ["753","767.00"] | ["EDGO"] | 760.0000 | 760.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:54:13Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab5a-9123-7bc0-ae24-a53458a1df5e | SPY | 2026-09-16 13:53 | straddle | 2 | 1 | 96 | 67104.00 | long | ask | 759.7800 | 0.0200 | ["760"] | ["0.2202"] | ["753.01","766.99"] | ["EDGO"] | 760.0000 | 760.0000 | 1 | 1 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:54:13Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a033-1530-71c2-a5ee-4bceb7a69fdc | SPY | 2026-09-14 09:54 | straddle | 2 | 1 | 100 | 679200.00 | short | bid | 760.2100 | 0.3700 | ["730"] | ["0.1734"] | ["662.08","797.92"] | ["XCBO"] | 730.0000 | 730.0000 | 123 | 123 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:55:07Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0920f-54f0-7db2-8ffa-56774cdfd60a | SPY | 2026-09-11 16:01 | straddle | 2 | 1 | 128 | 137600.00 | long | ask | 764.3400 | 0.0800 | ["764"] | ["0.1271"] | ["753.25","774.75"] | ["XISX"] | 764.0000 | 764.0000 | 7 | 7 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T20:01:50Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ce5-9d91-7593-b6c6-8d08e03b413c | SPY | 2026-09-10 15:57 | straddle | 2 | 1 | 5 | 27925.00 | short | bid | 757.9450 | 0.2700 | ["760"] | ["0.1563"] | ["704.15","815.85"] | ["XCBO"] | 760.0000 | 760.0000 | 127 | 127 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:57:49Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08234-b520-7af1-8025-a03a4eb10781 | SPY | 2026-09-08 14:08 | straddle | 2 | 1 | 10 | 38270.00 | long | ask | 767.7000 | 0.0700 | ["770"] | ["0.1396"] | ["731.73","808.27"] | ["XCBO"] | 770.0000 | 770.0000 | 73 | 73 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:08:14Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08230-f048-75b1-94d7-a1891706a8dc | SPY | 2026-09-08 14:03 | straddle | 2 | 1 | 19 | 33916.00 | short | bid | 767.5000 | 0.1800 | ["775"] | ["0.1142"] | ["757.15","792.85"] | ["XCBO"] | 775.0000 | 775.0000 | 22 | 22 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:04:31Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |