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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08682-c9f0-77e1-8531-d43998120f14 | SHOP | 2026-09-09 10:11 | call_calendar | 2 | 1 | 97 | 173824.00 | unknown | — | 131.1900 | 3.8500 | ["125"] | ["0.5569"] | [] | ["BATO"] | 125.0000 | 125.0000 | 9 | 16 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:12:08Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0820c-9798-78c1-bf40-50357a196060 | SHOP | 2026-09-08 13:24 | other | 2 | 1 | 26 | 136500.00 | unknown | — | 134.8200 | 2.3000 | ["155","160"] | ["0.5464","0.8844"] | [] | ["BATO"] | 155.0000 | 160.0000 | 3 | 101 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:24:40Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081dc-86e9-7a91-b9f8-a5f37eed4674 | SHOP | 2026-09-08 12:31 | call_frontspread | 2 | 1 | 45 | 167890.00 | long | bid | 134.5200 | 1.9000 | ["125","130"] | ["0.5581","0.5589"] | ["125.28","167.76"] | ["XMIO"] | 125.0000 | 130.0000 | 101 | 101 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:32:13Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0815d-f0a8-7733-8984-150584a5893f | SHOP | 2026-09-08 10:13 | call_vertical_spread | 2 | 2 | 500 | 881750.00 | unknown | — | 134.8600 | 1.7250 | ["160","230"] | ["0.5612","0.5685"] | [] | ["ARCO","XISX"] | 160.0000 | 230.0000 | 192 | 192 | true | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:13:51Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08145-b1a0-7c81-9187-a486b4c34511 | SHOP | 2026-09-08 09:47 | other | 2 | 1 | 52 | 185940.00 | unknown | — | 136.4100 | 4.3500 | ["125","135"] | ["0.6167","0.5755"] | [] | ["XISX"] | 125.0000 | 135.0000 | 73 | 101 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:47:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08136-778a-76c3-8e74-532e154bcf6a | SHOP | 2026-09-08 09:30 | call_calendar | 2 | 1 | 30 | 111960.00 | unknown | — | 141.5300 | 6.3500 | ["125"] | ["0.5779"] | [] | ["XMIO"] | 125.0000 | 125.0000 | 10 | 38 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:30:13Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dd2-ef85-7a73-bfcf-1d76d3419818 | SHOP | 2026-09-04 15:08 | other | 2 | 1 | 460 | 103730.00 | unknown | — | 145.2000 | 0.6300 | ["145","146"] | ["0.5337","0.4934"] | [] | ["EDGO"] | 145.0000 | 146.0000 | 0 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:09:09Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dd1-c6a5-7233-9cc2-964a3df16e06 | SHOP | 2026-09-04 15:07 | call_calendar | 2 | 1 | 45 | 144720.00 | short | bid | 145.3700 | 3.5000 | ["130"] | ["4.6948"] | [] | ["XMIO"] | 130.0000 | 130.0000 | 0 | 7 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:07:50Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dca-b60d-7461-81e0-3678ac42bcfb | SHOP | 2026-09-04 14:59 | call_calendar | 2 | 1 | 45 | 233550.00 | short | bid | 145.3300 | 5.7000 | ["120"] | ["6.7653"] | [] | ["SPHR"] | 120.0000 | 120.0000 | 0 | 7 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:00:17Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d8d-189d-7523-90a1-cf8ec1b7634f | SHOP | 2026-09-04 13:52 | call_vertical_spread | 2 | 1 | 32 | 117280.00 | short | bid | 145.9650 | 2.0000 | ["165","200"] | ["0.5494","0.5432"] | ["174.27"] | ["AMXO"] | 165.0000 | 200.0000 | 286 | 286 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:53:05Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d3b-a8f5-7232-81f7-a5ea9147c48c | SHOP | 2026-09-04 12:23 | other | 2 | 1 | 90 | 344582.00 | unknown | — | 147.6100 | 3.1000 | ["130","145"] | ["0.5699","0.5392"] | [] | ["XMIO"] | 130.0000 | 145.0000 | 77 | 105 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:23:43Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |