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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 01a0b021-f88a-7fe2-99f2-500694dfafc8 | V | 2026-09-17 12:10 | call_diagonal_spread | 2 | 1 | 47 | 430238.00 | short | bid | 371.3150 | 5.1000 | ["325","335"] | ["1.5549","0.2312"] | [] | ["XCBO"] | 325.0000 | 335.0000 | 1 | 120 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:10:40Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 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 |
| 01a0a091-1799-7412-b49e-64c13fdf31f0 | V | 2026-09-14 11:37 | call_diagonal_spread | 2 | 1 | 12 | 143568.00 | short | bid | 375.0400 | 4.7000 | ["380","390"] | ["0.2422","0.2415"] | [] | ["AMXO"] | 380.0000 | 390.0000 | 641 | 732 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:37:48Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08bd0-68b8-7332-ba74-f79066a89f06 | V | 2026-09-10 10:54 | call_diagonal_spread | 2 | 1 | 20 | 147840.00 | long | ask | 366.6450 | 4.0500 | ["345","365"] | ["0.2483","0.2522"] | [] | ["SPHR"] | 345.0000 | 365.0000 | 127 | 280 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:55:10Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0871c-9cd8-7062-ac98-cb3e841a1539 | V | 2026-09-09 12:59 | call_diagonal_spread | 2 | 1 | 32 | 154880.00 | long | bid | 368.3940 | 2.0000 | ["345","360"] | ["0.2851","0.2294"] | [] | ["XMIO"] | 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-09T17:00:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 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 |
| 01a0869b-ff11-7213-952d-0066de57f14a | V | 2026-09-09 10:39 | call_diagonal_spread | 2 | 1 | 20 | 109700.00 | long | ask | 367.7600 | 1.9000 | ["345","380"] | ["0.3285","0.2411"] | [] | ["XMIO"] | 345.0000 | 380.0000 | 9 | 281 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:39:24Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |