Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c549-d64f-7d93-a18a-f3ead376ad90 | V | 2026-09-21 14:45 | put_vertical_spread | 2 | 1 | 200 | 220000.00 | short | bid | 368.5400 | 0.9500 | ["310","315"] | ["0.2731","0.2682"] | ["314.36"] | ["BATO"] | 310.0000 | 315.0000 | 179 | 179 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:45:52Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b4bc-73af-70a1-b291-50b46b88b749 | V | 2026-09-18 09:37 | call_diagonal_spread | 2 | 2 | 48 | 190128.00 | short | bid | 367.1358 | 1.0500 | ["350","355"] | ["0.9985","0.2310"] | [] | ["ARCO","XMIO"] | 350.0000 | 355.0000 | 0 | 63 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:37:31Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aba8-8dfb-7d71-a77b-dadde24eda96 | V | 2026-09-16 15:19 | call_diagonal_spread | 2 | 1 | 20 | 168520.00 | short | bid | 368.7600 | 4.8500 | ["365","380"] | ["0.2474","0.2450"] | [] | ["XPHO"] | 365.0000 | 380.0000 | 274 | 457 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:19:03Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5a0-5ca6-7492-b7c7-1720a45c50a8 | V | 2026-09-15 11:12 | call_diagonal_spread | 2 | 1 | 45 | 132975.00 | short | bid | 373.9900 | 2.0000 | ["360","375"] | ["0.3244","0.2222"] | [] | ["BATO"] | 360.0000 | 375.0000 | 3 | 66 | false | false | true | true | false | mlet | market_whale | 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 |
| 01a09144-38d9-78c3-8e35-a028e5e2c798 | V | 2026-09-11 12:19 | call_calendar | 2 | 1 | 50 | 136200.00 | short | bid | 369.9150 | 0.8000 | ["360"] | ["0.2102"] | [] | ["BATO"] | 360.0000 | 360.0000 | 7 | 35 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:19:23Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a086fa-6321-7ac2-a504-66230843568a | V | 2026-09-09 12:22 | call_diagonal_spread | 2 | 1 | 93 | 435240.00 | short | bid | 367.6451 | 2.6500 | ["345","360"] | ["0.2280","0.2283"] | [] | ["XPHO"] | 345.0000 | 360.0000 | 9 | 100 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:22:43Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0865f-e070-7f42-a113-5b6fc61ab20a | V | 2026-09-09 09:33 | put_diagonal_spread | 2 | 1 | 100 | 229400.00 | short | ask | 366.9600 | 0.9500 | ["375","380"] | ["0.2149","0.3058"] | [] | ["XPHO"] | 375.0000 | 380.0000 | 2 | 9 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:33:58Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06d6a-468d-7801-a943-9d056ee53e2d | V | 2026-09-04 13:14 | call_calendar | 2 | 3 | 140 | 422800.00 | short | ask | 376.4500 | 2.6929 | ["365"] | ["0.1908"] | [] | ["BATO","EDGO","XISX"] | 365.0000 | 365.0000 | 21 | 28 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:15:04Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |