core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg541,738 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0e94f-8837-7382-8811-c498db23821b | VOO | 2026-09-28 14:38 | call_vertical_spread | 2 | 1 | 36 | 102780.00 | short | bid | 704.7650 | 1.3000 | ["705","715"] | ["0.1407","0.1316"] | ["710.73"] | ["AMXO"] | 705.0000 | 715.0000 | 53 | 53 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-28T18:38:34Z"} | 2026-09-28 | 2026-09-28 17:15 | 2026-09-28 17:15 |
| 01a0e877-3d1e-7542-9892-397f671141b3 | VOO | 2026-09-28 10:42 | put_calendar | 2 | 1 | 50 | 105000.00 | short | ask | 704.4800 | 9.8000 | ["455"] | ["0.2821"] | [] | ["XPHO"] | 455.0000 | 455.0000 | 809 | 844 | false | true | |||||||||||
| 01a0e875-7be7-7f83-8f1a-af12025c84d7 | VOO | 2026-09-28 10:40 | put_calendar | 2 | 1 | 50 | 119950.00 | short | bid | 704.3800 | 5.8000 | ["475"] | ["0.2740"] | [] | ["XPHO"] | 475.0000 | 475.0000 | 809 | 844 | false | true | |||||||||||
| 01a0e874-eb5e-7b63-9b80-a90596eb8278 | VOO | 2026-09-28 10:39 | put_calendar | 2 | 1 | 50 | 105000.00 | short | ask | 704.6200 | 9.8000 | ["455"] | ["0.2822"] | [] | ["XPHO"] | 455.0000 | 455.0000 | 809 | 844 | false | true | |||||||||||
| 01a0da1b-e27f-7402-a85e-a67bea60e882 | VOO | 2026-09-25 15:47 | call_calendar | 2 | 1 | 20 | 362080.00 | short | bid | 711.2100 | 5.3000 | ["620"] | ["8.1295"] | [] | ["XMIO"] | 620.0000 | 620.0000 | 0 | 7 | false | false | |||||||||||
| 01a0d4dc-5d17-7361-847e-25c41a95c162 | VOO | 2026-09-24 15:20 | call_diagonal_spread | 2 | 1 | 15 | 162300.00 | short | bid | 707.3632 | 5.1000 | ["655","660"] | ["0.2008","0.1709"] | [] | ["XISX"] | 655.0000 | 660.0000 | 22 | 57 | false | false | |||||||||||
| 01a0ced8-8dae-7900-87cc-b8b1fde6308e | VOO | 2026-09-23 11:18 | put_calendar | 2 | 1 | 30 | 126960.00 | short | ask | 709.1000 | 6.8000 | ["555"] | ["0.2510"] | [] | ["XCBO"] | 555.0000 | 555.0000 | 814 | 849 | true | true | |||||||||||
| 01a0ca58-b697-72f2-b95d-ec972ea3f5c1 | VOO | 2026-09-22 14:20 | call_diagonal_spread | 2 | 1 | 10 | 107300.00 | short | ask | 713.3250 | 3.6000 | ["660","695"] | ["0.1591","0.1535"] | [] | ["XPHO"] | 660.0000 | 695.0000 | 24 | 206 | false | false | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:42:13Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:40:19Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:39:44Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:47:55Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:20:43Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:18:43Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:20:39Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |