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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c456-a867-74d0-8acb-c962031017c9 | VOO | 2026-09-21 10:20 | call_diagonal_spread | 2 | 2 | 24 | 195336.00 | short | bid | 708.1350 | 4.4000 | ["670","675"] | ["0.1419","0.1480"] | [] | ["EDGO","XPHO"] | 670.0000 | 675.0000 | 25 | 60 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:20:07Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b0d1-9593-71c2-aceb-dd37450bc517 | VOO | 2026-09-17 15:21 | call_diagonal_spread | 2 | 1 | 149 | 1199450.00 | short | ask | 701.1800 | 1.0000 | ["660","665"] | ["0.5646","0.1360"] | [] | ["XISX"] | 660.0000 | 665.0000 | 1 | 29 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:22:33Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0c9-c1ab-7d73-bc35-1429892c7e44 | VOO | 2026-09-17 15:13 | call_diagonal_spread | 2 | 4 | 122 | 903267.00 | short | bid | 701.1700 | 1.3000 | ["665","675"] | ["0.5696","0.1556"] | [] | ["AMXO","C2OX","EDGO","XPHO"] | 665.0000 | 675.0000 | 1 | 64 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:14:03Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0affc-82b3-7de3-9061-3008fe9dcde0 | VOO | 2026-09-17 11:29 | call_diagonal_spread | 2 | 1 | 32 | 716288.00 | short | bid | 700.1650 | 5.9000 | ["590","595"] | ["1.4290","0.2246"] | [] | ["XCBO"] | 590.0000 | 595.0000 | 1 | 92 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:29:37Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0affc-7ecb-7881-a526-bcfaa0c7e927 | VOO | 2026-09-17 11:29 | call_diagonal_spread | 2 | 1 | 8 | 179068.00 | short | bid | 700.1650 | 5.9000 | ["590","595"] | ["1.4099","0.2249"] | [] | ["XCBO"] | 590.0000 | 595.0000 | 1 | 92 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:29:37Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af8f-9fb8-7a83-9c8a-ef329083b649 | VOO | 2026-09-17 09:30 | call_calendar | 2 | 5 | 5 | 112876.00 | short | ask | 701.4890 | 7.3000 | ["700"] | ["0.1750"] | [] | ["EMLD","MCRY","XCBO","XISX","XPHO"] | 700.0000 | 700.0000 | 820 | 855 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:30:12Z"} | 2026-09-17 | 2026-09-17 17:27 | 2026-09-17 17:27 |
| 01a0aa69-43b6-7622-9921-12c8735c0f20 | VOO | 2026-09-16 09:30 | call_calendar | 2 | 1 | 8 | 158448.00 | short | bid | 698.1900 | 8.5000 | ["720"] | ["0.1736"] | [] | ["XMIO"] | 720.0000 | 720.0000 | 821 | 856 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:30:23Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa69-43b6-7622-9921-129cc1bf4de8 | VOO | 2026-09-16 09:30 | call_calendar | 2 | 1 | 8 | 158112.00 | short | ask | 698.3199 | 7.7000 | ["720"] | ["0.1728"] | [] | ["EMLD"] | 720.0000 | 720.0000 | 821 | 856 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:30:12Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa69-34a9-77e1-abfc-f60541280a37 | VOO | 2026-09-16 09:30 | call_calendar | 2 | 1 | 8 | 157760.00 | short | ask | 698.1500 | 7.1000 | ["720"] | ["0.1726"] | [] | ["ARCO"] | 720.0000 | 720.0000 | 821 | 856 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:30:07Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa69-09d3-7252-b3a9-d27b70a3ad31 | VOO | 2026-09-16 09:30 | call_calendar | 2 | 1 | 8 | 157328.00 | short | ask | 698.1900 | 6.7000 | ["720"] | ["0.1718"] | [] | ["XCBO"] | 720.0000 | 720.0000 | 821 | 856 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:30:03Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a13e-0909-7533-89c3-57ca27313ce2 | VOO | 2026-09-14 14:46 | call_calendar | 2 | 1 | 8 | 180000.00 | short | bid | 700.7000 | 9.4000 | ["700"] | ["0.2004"] | [] | ["XMIO"] | 700.0000 | 700.0000 | 823 | 858 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:46:47Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a13e-0909-7533-89c3-57b991c27321 | VOO | 2026-09-14 14:46 | call_calendar | 2 | 1 | 7 | 157500.00 | short | bid | 700.7000 | 9.4000 | ["700"] | ["0.2004"] | [] | ["EMLD"] | 700.0000 | 700.0000 | 823 | 858 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:46:47Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0d4-eec8-7171-b66c-bc8cc4fcdf2b | VOO | 2026-09-14 12:51 | call_diagonal_spread | 2 | 1 | 27 | 125604.00 | short | bid | 701.6800 | 5.3000 | ["680","730"] | ["0.1743","0.1346"] | [] | ["XCBO"] | 680.0000 | 730.0000 | 4 | 214 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:51:56Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09163-1f00-7c41-ab8f-a21c15c11653 | VOO | 2026-09-11 12:53 | call_diagonal_spread | 2 | 1 | 35 | 278250.00 | short | bid | 703.5371 | 2.8000 | ["665","675"] | ["0.2149","0.1567"] | [] | ["MCRY"] | 665.0000 | 675.0000 | 7 | 70 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:53:25Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a081a0-f4e8-70b2-833f-6f1eae654ee1 | VOO | 2026-09-08 11:26 | call_diagonal_spread | 2 | 1 | 8 | 107512.00 | short | ask | 706.0500 | 6.6000 | ["655","670"] | ["0.1755","0.1654"] | [] | ["BATO"] | 655.0000 | 670.0000 | 129 | 220 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:26:55Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |