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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b619-4877-7073-9cac-d109b33419b5 | BE | 2026-09-18 15:58 | call_calendar | 2 | 1 | 10 | 133350.00 | short | bid | 266.0700 | 6.3000 | ["200"] | ["44.9076"] | [] | ["XMIO"] | 200.0000 | 200.0000 | 0 | 7 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:58:36Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b615-b667-7c70-b601-83a16bba1747 | BE | 2026-09-18 15:54 | call_calendar | 2 | 1 | 27 | 106920.00 | short | ask | 267.4400 | 3.8000 | ["250"] | ["6.6335"] | [] | ["XISX"] | 250.0000 | 250.0000 | 0 | 7 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:54:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0cf-9dab-7261-a3b3-5a086fd03288 | BE | 2026-09-17 15:19 | call_calendar | 2 | 1 | 10 | 450770.00 | long | ask | 279.6600 | 5.5500 | ["55"] | ["1.3534"] | [] | ["XPHO"] | 55.0000 | 55.0000 | 64 | 120 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:20:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a692-03ee-7780-ba63-59a0773019f1 | BE | 2026-09-15 15:36 | call_calendar | 2 | 1 | 15 | 197115.00 | long | ask | 259.1850 | 3.8500 | ["200"] | ["1.0442"] | [] | ["BATO"] | 200.0000 | 200.0000 | 3 | 66 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:36:21Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a57f-47e6-7552-8c09-3a94e9c64ede | BE | 2026-09-15 10:36 | call_calendar | 2 | 1 | 5 | 121375.00 | unknown | — | 265.3250 | 6.5000 | ["350"] | ["0.9013"] | [] | ["XISX"] | 350.0000 | 350.0000 | 822 | 857 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:36:43Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a15e-f2d0-7ac2-8de0-2856b520b84f | BE | 2026-09-14 15:22 | call_calendar | 2 | 1 | 30 | 619320.00 | short | ask | 258.8550 | 3.9000 | ["160"] | ["1.5679"] | [] | ["XISX"] | 160.0000 | 160.0000 | 4 | 95 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:23:13Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091bf-e8e8-7b03-8d87-0d22bc485f83 | BE | 2026-09-11 14:34 | call_calendar | 2 | 4 | 52 | 314020.00 | short | ask | 275.7300 | 1.6500 | ["250"] | ["0.7553"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 250.0000 | 250.0000 | 7 | 14 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:34:47Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cd5-51b0-74f0-9829-c6e0e076514c | BE | 2026-09-10 15:39 | call_calendar | 2 | 4 | 202 | 1115352.00 | short | bid | 259.5000 | 3.2500 | ["270"] | ["0.8530"] | [] | ["ARCO","C2OX","EDGO","XCBO"] | 270.0000 | 270.0000 | 43 | 50 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:39:53Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0865c-9c86-7283-9b53-ab9ece57995f | BE | 2026-09-09 09:30 | call_calendar | 2 | 2 | 3 | 112795.00 | long | bid | 273.2800 | 8.6500 | ["100"] | ["0.9410"] | [] | ["XCBO","XISX"] | 100.0000 | 100.0000 | 281 | 499 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:30:07Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08288-5748-7f41-a187-fc9cae891c8b | BE | 2026-09-08 15:39 | call_calendar | 2 | 2 | 34 | 449888.00 | long | bid | 279.2250 | 3.2500 | ["230"] | ["0.9008"] | [] | ["EDGO","XISX"] | 230.0000 | 230.0000 | 38 | 73 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:40:07Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08168-dd88-7f73-8d20-31d14f5c2c88 | BE | 2026-09-08 10:25 | call_calendar | 2 | 1 | 25 | 219050.00 | long | bid | 272.5900 | 2.3000 | ["290"] | ["0.9442"] | [] | ["XPHO"] | 290.0000 | 290.0000 | 73 | 101 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:25:29Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d6e-8c4e-7560-9d10-ad6e31115634 | BE | 2026-09-04 13:19 | call_calendar | 2 | 1 | 40 | 126480.00 | short | bid | 245.9650 | 1.3500 | ["250"] | ["0.9607"] | [] | ["BATO"] | 250.0000 | 250.0000 | 7 | 21 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:19:31Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |