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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b4f2-02a0-79a1-926f-4d07fd250003 | QQQ | 2026-09-18 10:35 | put_diagonal_spread | 2 | 1 | 11 | 34958.00 | long | ask | 716.6800 | 0.3200 | ["655","692"] | ["0.2508","0.2035"] | [] | ["C2OX"] | 655.0000 | 692.0000 | 28 | 272 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:36:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f1-9157-7813-b46d-213f425c606e | QQQ | 2026-09-18 10:35 | put_diagonal_spread | 2 | 2 | 18 | 57254.00 | long | ask | 716.6400 | 0.3300 | ["655","692"] | ["0.2508","0.2037"] | [] | ["C2OX","XISX"] | 655.0000 | 692.0000 | 28 | 272 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:35:40Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f1-5e90-7162-af53-124c3dc4ac8c | QQQ | 2026-09-18 10:35 | put_diagonal_spread | 2 | 2 | 16 | 50879.00 | long | ask | 716.6550 | 0.3688 | ["655","692"] | ["0.2508","0.2038"] | [] | ["C2OX","XISX"] | 655.0000 | 692.0000 | 28 | 272 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:35:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b02c-8f7a-7430-964e-02ba8ebf195e | QQQ | 2026-09-17 12:21 | put_diagonal_spread | 2 | 1 | 8 | 25000.00 | short | bid | 716.5500 | 0.1300 | ["655","660"] | ["0.2480","0.2452"] | [] | ["XCBO"] | 655.0000 | 660.0000 | 105 | 183 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:21:52Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abc0-ffcb-72b3-9624-d1f694b64b01 | QQQ | 2026-09-16 15:45 | put_diagonal_spread | 2 | 1 | 10 | 31790.00 | short | bid | 703.6300 | 0.7200 | ["717","719"] | ["0.1887","0.2021"] | [] | ["XISX"] | 717.0000 | 719.0000 | 2 | 9 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:45:51Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abb4-2aa3-7bd0-907c-66ddea84942c | QQQ | 2026-09-16 15:31 | put_diagonal_spread | 2 | 1 | 20 | 71140.00 | short | bid | 702.3950 | 0.6500 | ["718","720"] | ["0.1913","1.2425"] | [] | ["XISX"] | 718.0000 | 720.0000 | 0 | 9 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:31:46Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab6b-1b83-76e3-a2f4-433153aa86e6 | QQQ | 2026-09-16 14:11 | put_diagonal_spread | 2 | 1 | 57 | 107673.00 | short | bid | 710.2600 | 0.1700 | ["715","717"] | ["0.1819","0.2164"] | [] | ["C2OX"] | 715.0000 | 717.0000 | 2 | 9 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:12:31Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a619-c2c5-77d3-8ae5-0f9406bbcd3c | QQQ | 2026-09-15 13:24 | put_diagonal_spread | 2 | 1 | 21 | 33768.00 | unknown | — | 704.6500 | 0.0800 | ["704","710"] | ["0.1715","0.1898"] | [] | ["XPHO"] | 704.0000 | 710.0000 | 0 | 24 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:25:16Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a619-bede-7993-875b-8ddfbab642be | QQQ | 2026-09-15 13:24 | put_diagonal_spread | 2 | 1 | 20 | 32120.00 | unknown | — | 704.6600 | 0.0900 | ["704","710"] | ["0.1701","0.1897"] | [] | ["XPHO"] | 704.0000 | 710.0000 | 0 | 24 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:25:16Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5cc-3b1e-72f3-a609-cc74017a1507 | QQQ | 2026-09-15 12:00 | put_diagonal_spread | 2 | 1 | 15 | 33735.00 | unknown | — | 705.4200 | 0.2400 | ["705","710"] | ["0.2003","0.1955"] | [] | ["XISX"] | 705.0000 | 710.0000 | 10 | 17 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:00:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a594-b82e-7dc3-9e49-73e3094d54e1 | QQQ | 2026-09-15 10:59 | put_diagonal_spread | 2 | 2 | 28 | 25312.00 | long | bid | 704.5450 | 0.0357 | ["695","702"] | ["0.2238","0.2493"] | [] | ["C2OX","XISX"] | 695.0000 | 702.0000 | 3 | 6 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:00:05Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0c4-3588-78d1-98d0-bd4af582a1cc | QQQ | 2026-09-14 12:33 | put_diagonal_spread | 2 | 1 | 3 | 76275.00 | long | ask | 710.4450 | 3.4400 | ["800","850"] | ["0.2459","0.2795"] | [] | ["C2OX"] | 800.0000 | 850.0000 | 368 | 823 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:33:52Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a083-1990-7651-998d-40a04a32e0f6 | QQQ | 2026-09-14 11:22 | put_diagonal_spread | 2 | 1 | 200 | 40200.00 | short | ask | 707.1200 | 0.0200 | ["700","707"] | ["0.2209","0.1906"] | [] | ["XISX"] | 700.0000 | 707.0000 | 0 | 1 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:22:50Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a07c-2450-7c30-9824-8a6edf6fd837 | QQQ | 2026-09-14 11:14 | put_diagonal_spread | 2 | 1 | 190 | 36100.00 | short | ask | 706.3200 | 0.0200 | ["699","706"] | ["0.2239","0.1874"] | [] | ["EMLD"] | 699.0000 | 706.0000 | 0 | 1 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:15:04Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091fe-7888-7cf1-b77e-9fa23dbcb5d4 | QQQ | 2026-09-11 15:42 | put_diagonal_spread | 2 | 1 | 10 | 30620.00 | long | ask | 715.7600 | 0.2800 | ["720","725"] | ["0.1720","0.1710"] | [] | ["XISX"] | 720.0000 | 725.0000 | 21 | 28 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:42:57Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b6-ec20-70e3-aa7a-cc64d362a720 | QQQ | 2026-09-11 14:24 | put_diagonal_spread | 2 | 2 | 260 | 105300.00 | long | ask | 715.9800 | 0.0400 | ["670","680"] | ["0.2363","0.2492"] | [] | ["ARCO","C2OX"] | 670.0000 | 680.0000 | 7 | 28 | false | true | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:24:58Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09185-1e20-7881-bf37-9ef0f15703b8 | QQQ | 2026-09-11 13:30 | put_diagonal_spread | 2 | 1 | 25 | 130625.00 | short | bid | 716.7900 | 0.5700 | ["671","765"] | ["0.2860","0.1944"] | [] | ["XISX"] | 671.0000 | 765.0000 | 7 | 70 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:30:32Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cad-5750-78c1-ae4c-acb020ee75f1 | QQQ | 2026-09-10 14:56 | put_diagonal_spread | 2 | 1 | 203 | 128499.00 | short | bid | 709.9050 | 0.0400 | ["700","701"] | ["0.2264","0.2936"] | [] | ["ARCO"] | 700.0000 | 701.0000 | 1 | 8 | false | true | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:56:25Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ba1-6978-7131-b1bb-83c1deb4a7a5 | QQQ | 2026-09-10 10:03 | put_diagonal_spread | 2 | 1 | 53 | 42400.00 | long | ask | 709.4100 | 0.0200 | ["687","697"] | ["0.2405","0.3183"] | [] | ["EMLD"] | 687.0000 | 697.0000 | 1 | 22 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:03:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ba1-61a8-7830-a38b-0afe1f7bfc6a | QQQ | 2026-09-10 10:03 | put_diagonal_spread | 2 | 2 | 53 | 42400.00 | long | ask | 709.2400 | 0.0200 | ["687","697"] | ["0.2397","0.3154"] | [] | ["XBOX"] | 687.0000 | 697.0000 | 1 | 22 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:03:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087ca-fd79-7362-95d4-bb3918401fde | QQQ | 2026-09-09 16:10 | put_diagonal_spread | 2 | 2 | 498 | 82170.00 | short | bid | 716.1600 | 0.0219 | ["575","709"] | ["0.3737","0.2107"] | [] | ["XBOX"] | 575.0000 | 709.0000 | 1 | 37 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T20:11:19Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08246-58c1-7300-80ae-f42d8cb9f081 | QQQ | 2026-09-08 14:27 | put_diagonal_spread | 2 | 1 | 53 | 276130.00 | long | ask | 719.8100 | 0.0600 | ["700","725"] | ["0.2055","0.2257"] | [] | ["XISX"] | 700.0000 | 725.0000 | 38 | 204 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:28:02Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |