Simplify AnalyticsMulti-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b0ce-70e3-7130-8014-0783b6e227a4 | XHB | 2026-09-17 15:18 | put_diagonal_spread | 2 | 1 | 250 | 184000.00 | short | bid | 97.1250 | 0.9700 | ["96","100"] | ["0.2833","0.3700"] | [] | ["XPHO"] | 96.0000 | 100.0000 | 1 | 92 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:18:52Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0ce-5973-7dc1-aebd-13590639e773 | XHB | 2026-09-17 15:18 | put_diagonal_spread | 2 | 1 | 250 | 184000.00 | short | bid | 97.1250 | 1.0000 | ["96","100"] | ["0.2833","0.3700"] | [] | ["XPHO"] | 96.0000 | 100.0000 | 1 | 92 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:18:52Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a0ef-4cc8-7ea3-98d0-292be3dd5f16 | XHB | 2026-09-14 13:20 | call_vertical_spread | 2 | 1 | 15 | 127500.00 | long | ask | 97.9200 | 1.7000 | ["55","56"] | ["2.2892","2.3243"] | ["55.98"] | ["XMIO"] | 55.0000 | 56.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:20:44Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ed-d5c8-7e43-a30b-1753dede88f6 | XHB | 2026-09-14 13:18 | call_vertical_spread | 2 | 1 | 52 | 401648.00 | unknown | — | 97.9400 | 1.5000 | ["59","60"] | ["2.3788","2.3552"] | [] | ["XPHO"] | 59.0000 | 60.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:19:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ec-81f0-7c23-b650-03d69c5f9138 | XHB | 2026-09-14 13:17 | call_vertical_spread | 2 | 1 | 36 | 306000.00 | long | ask | 97.9850 | 1.7000 | ["55","56"] | ["3.1596","1.5543"] | ["55.98"] | ["XMIO"] | 55.0000 | 56.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:18:06Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0e5-07e0-70b1-b4e0-f652f717ffe8 | XHB | 2026-09-14 13:09 | call_vertical_spread | 2 | 1 | 26 | 206024.00 | long | ask | 98.0600 | 1.5000 | ["58","59"] | ["1.9562","2.0292"] | ["58.98"] | ["XMIO"] | 58.0000 | 59.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:09:43Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |