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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b4e6-b02f-71d2-9932-d6a857df3c49 | CAT | 2026-09-18 10:23 | put_calendar | 2 | 1 | 10 | 52350.00 | short | bid | 807.3650 | 7.8000 | ["830"] | ["0.6105"] | [] | ["BATO"] | 830.0000 | 830.0000 | 0 | 7 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:23:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b05a-eaab-7080-a976-fdfb90fbfa7c | CAT | 2026-09-17 13:12 | put_calendar | 2 | 1 | 10 | 50710.00 | short | ask | 798.7050 | 7.9000 | ["775"] | ["0.3969"] | [] | ["XPHO"] | 775.0000 | 775.0000 | 22 | 43 | false | true | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:13:09Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b05a-def3-7623-8a39-db9e75aa0b1d | CAT | 2026-09-17 13:12 | put_calendar | 2 | 1 | 10 | 52010.00 | short | ask | 798.7050 | 7.8500 | ["775"] | ["0.4049"] | [] | ["XMIO"] | 775.0000 | 775.0000 | 22 | 43 | false | true | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:12:19Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aff0-325b-7b61-95ce-4815b4a11c41 | CAT | 2026-09-17 11:15 | put_calendar | 2 | 1 | 4 | 84640.00 | short | bid | 797.6400 | 9.3000 | ["740"] | ["0.4262"] | [] | ["XMIO"] | 740.0000 | 740.0000 | 491 | 638 | false | true | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:16:10Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb2-f60b-7550-bbdf-5414d6ff51e1 | CAT | 2026-09-16 15:30 | put_calendar | 2 | 1 | 2 | 27448.00 | short | ask | 777.3300 | 12.1000 | ["840"] | ["0.5784"] | [] | ["BATO"] | 840.0000 | 840.0000 | 2 | 30 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:30:31Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a56f-a016-7b53-8390-f1b3e22fce03 | CAT | 2026-09-15 10:19 | put_calendar | 2 | 2 | 2 | 44258.00 | unknown | — | 781.7900 | 16.3500 | ["850"] | ["0.3977"] | [] | ["SPHR","XBOX"] | 850.0000 | 850.0000 | 122 | 157 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:19:32Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a554-1936-72a2-bd2e-513beee45e8d | CAT | 2026-09-15 09:49 | put_calendar | 2 | 1 | 2 | 47962.00 | short | ask | 784.5700 | 19.5000 | ["900"] | ["0.5401"] | [] | ["ARCO"] | 900.0000 | 900.0000 | 3 | 45 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:49:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a554-154e-77e2-8ca2-30a6c9a90aab | CAT | 2026-09-15 09:49 | put_calendar | 2 | 2 | 8 | 191998.00 | unknown | — | 784.5800 | 20.5500 | ["900"] | ["0.6491"] | [] | ["ARCO","XISX"] | 900.0000 | 900.0000 | 3 | 45 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:49:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a554-154e-77e2-8ca2-30997154ecfc | CAT | 2026-09-15 09:49 | put_calendar | 2 | 1 | 3 | 71997.00 | unknown | — | 784.5800 | 20.5500 | ["900"] | ["0.6481"] | [] | ["XISX"] | 900.0000 | 900.0000 | 3 | 45 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:49:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0ae-a9e8-7760-a6b8-006c0a4ab730 | CAT | 2026-09-14 12:09 | put_calendar | 2 | 1 | 2 | 39950.00 | short | bid | 785.2550 | 17.2000 | ["880"] | ["0.6067"] | [] | ["XMIO"] | 880.0000 | 880.0000 | 4 | 46 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:10:13Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a028-d818-7de2-a489-be2ad2b39351 | CAT | 2026-09-14 09:43 | put_calendar | 2 | 1 | 2 | 63250.00 | short | bid | 786.7750 | 30.8000 | ["800"] | ["0.4290"] | [] | ["XISX"] | 800.0000 | 800.0000 | 641 | 858 | false | false | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:43:49Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c69-9790-7be3-ad98-8df021fceb9c | CAT | 2026-09-10 13:42 | put_calendar | 2 | 2 | 34 | 61444.00 | long | ask | 801.2650 | 2.1500 | ["750"] | ["0.3833"] | [] | ["BATO","SPHR"] | 750.0000 | 750.0000 | 8 | 36 | false | true | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:42:22Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08271-8f40-70a3-b6bc-fd37fbd206bd | CAT | 2026-09-08 15:14 | put_calendar | 2 | 2 | 38 | 230508.00 | long | ask | 826.2224 | 3.0000 | ["740"] | ["0.4173"] | [] | ["EDGO","XMIO"] | 740.0000 | 740.0000 | 73 | 129 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:15:09Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081cb-6818-7ca1-b29f-76f399011eda | CAT | 2026-09-08 12:13 | put_calendar | 2 | 2 | 32 | 488064.00 | short | ask | 825.5850 | 10.6000 | ["900"] | ["0.3721"] | [] | ["EDGO","XMIO"] | 900.0000 | 900.0000 | 3 | 17 | true | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:13:27Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dc4-553d-7901-9747-e1abba6ef919 | CAT | 2026-09-04 14:52 | put_calendar | 2 | 1 | 4 | 27528.00 | long | bid | 810.3800 | 2.1500 | ["740"] | ["0.4084"] | [] | ["BATO"] | 740.0000 | 740.0000 | 77 | 133 | false | true | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:53:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d4d-5c35-7402-b0ad-f4ff7f219ef9 | CAT | 2026-09-04 12:42 | put_calendar | 2 | 1 | 4 | 26976.00 | long | bid | 813.1600 | 3.3000 | ["740"] | ["0.4090"] | [] | ["XPHO"] | 740.0000 | 740.0000 | 77 | 133 | false | true | true | false | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:43:14Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |