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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c48f-199e-7ba0-8d30-e6bdfdb9f258 | CAT | 2026-09-21 11:21 | other | 4 | 1 | 10 | 90740.00 | unknown | ask | 819.3300 | 6.1500 | ["770","780"] | ["0.3926","0.3899"] | [] | ["XPHO"] | 770.0000 | 780.0000 | 25 | 60 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:21:55Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b608-1a07-7f73-85e2-e3ce98cea1cf | CAT | 2026-09-18 15:39 | other | 4 | 1 | 2 | 27068.00 | unknown | — | 805.6600 | 29.4000 | ["730","740","850","855"] | ["0.3808","0.3877","0.3645","0.3531"] | [] | ["AMXO"] | 730.0000 | 855.0000 | 21 | 35 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:39:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b582-1187-7591-93f8-d444007736d7 | CAT | 2026-09-18 13:13 | other | 7 | 1 | 544 | 1033025.00 | unknown | ask | 800.4750 | 13.1300 | ["740","760","775","785","790","800","815"] | ["1.5043","0.3503","0.9885","0.3512","0.9136","0.4407","0.3469"] | [] | ["XCBO"] | 740.0000 | 815.0000 | 0 | 7 | false | false | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:13:28Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b516-249f-7231-87e1-30086f4fe3f4 | CAT | 2026-09-18 11:15 | other | 4 | 1 | 3 | 73089.00 | unknown | ask | 801.3400 | 15.1500 | ["790","810","860","870"] | ["0.4131","0.4163","0.3273","0.3385"] | [] | ["XCBO"] | 790.0000 | 870.0000 | 28 | 63 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:15:51Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f6-86e0-76d1-8b72-12a1e0bc5751 | CAT | 2026-09-18 10:40 | other | 4 | 1 | 9 | 39577.00 | unknown | bid | 805.2050 | 8.9000 | ["795","805","840","870"] | ["0.6622","0.4755","0.3510","0.3452"] | [] | ["XPHO"] | 795.0000 | 870.0000 | 0 | 28 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:41:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0dc-dc4b-7e63-b20f-3062427ff7c4 | CAT | 2026-09-17 15:34 | other | 4 | 1 | 4 | 34988.00 | unknown | — | 797.2350 | 8.8000 | ["750","760","800","805"] | ["0.4243","0.4240","0.3870","0.4014"] | [] | ["MCRY"] | 750.0000 | 805.0000 | 1 | 64 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:34:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b08b-87fb-79f0-ae8b-7a8123835e7d | CAT | 2026-09-17 14:05 | other | 4 | 1 | 20 | 228200.00 | unknown | — | 795.5600 | 10.3500 | ["740","760","770","780"] | ["0.4211","0.4201","0.3570","0.3587"] | [] | ["XMIO"] | 740.0000 | 780.0000 | 36 | 64 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:05:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b026-c703-7c50-ac5e-8d184d40f2b3 | CAT | 2026-09-17 12:15 | other | 5 | 2 | 2 | 53054.00 | unknown | — | 799.2850 | 38.8000 | ["735","775","800","905","910"] | ["0.3734","0.3615","0.3554","1.4223","1.4650"] | [] | ["XCBO"] | 735.0000 | 910.0000 | 1 | 36 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:15:54Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a679-8a4e-7353-8e9a-babbb174b462 | CAT | 2026-09-15 15:09 | other | 3 | 1 | 6 | 193974.00 | unknown | — | 781.7550 | 26.4000 | ["960","1100"] | ["0.4033","0.5392"] | [] | ["XPHO"] | 960.0000 | 1100.0000 | 94 | 275 | false | false | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:09:39Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a589-4296-72a2-94c4-6000b78595eb | CAT | 2026-09-15 10:47 | other | 4 | 1 | 12 | 86328.00 | unknown | — | 780.6850 | 14.4000 | ["735","740","745","750"] | ["0.4229","0.4225","0.3685","0.3680"] | [] | ["XMIO"] | 735.0000 | 750.0000 | 17 | 45 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:47:29Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a57e-3e46-7491-bbbc-4597c4ad2b7c | CAT | 2026-09-15 10:35 | other | 4 | 1 | 10 | 188227.00 | unknown | — | 782.2150 | 27.8000 | ["800","900"] | ["0.3619","0.4716"] | [] | ["XCBO"] | 800.0000 | 900.0000 | 10 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:35:29Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a565-535e-7c73-81bf-2b4617e0c0a7 | CAT | 2026-09-15 10:07 | other | 4 | 1 | 10 | 223530.00 | unknown | — | 784.7700 | 20.9000 | ["810","820","840","850"] | ["0.4021","0.4049","0.6476","0.6479"] | [] | ["XCBO"] | 810.0000 | 850.0000 | 3 | 94 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:08:12Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a079-9fc8-71d3-89f2-fe9d902032df | CAT | 2026-09-14 11:11 | other | 4 | 1 | 2 | 48038.00 | unknown | — | 782.7050 | 18.1500 | ["800","850","1000","1080"] | ["0.4096","0.3988","0.3964","0.3998"] | [] | ["MCRY"] | 800.0000 | 1080.0000 | 95 | 186 | false | false | true | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:12:17Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a06c-fd68-79c1-9ea6-aef9ecdbe6de | CAT | 2026-09-14 10:58 | other | 4 | 1 | 10 | 65380.00 | unknown | — | 783.0700 | 15.6100 | ["690","740","780","800"] | ["0.3879","0.4453","0.3596","0.3875"] | [] | ["XMIO"] | 690.0000 | 800.0000 | 4 | 39 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:58:39Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a066-a080-7ba3-9d63-c2cba22208cc | CAT | 2026-09-14 10:51 | other | 4 | 1 | 3 | 109426.00 | unknown | — | 784.3300 | 37.4000 | ["880","900"] | ["0.3820","0.3504"] | [] | ["XCBO"] | 880.0000 | 900.0000 | 32 | 46 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:51:42Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091d5-7870-7760-8966-593a421e4566 | CAT | 2026-09-11 14:57 | other | 4 | 1 | 3 | 108852.00 | unknown | — | 819.3800 | 27.3500 | ["900","910","920"] | ["0.3285","0.2789","0.4604"] | [] | ["XMIO"] | 900.0000 | 920.0000 | 14 | 21 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:58:24Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09102-c308-7882-851c-8c6016d40006 | CAT | 2026-09-11 11:07 | other | 7 | 1 | 544 | 1079560.00 | unknown | — | 819.3100 | 14.9300 | ["745","775","780","800","805","835"] | ["2.3318","0.3931","0.9204","0.4822","0.8458","0.3478"] | [] | ["XISX"] | 745.0000 | 835.0000 | 0 | 7 | false | false | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:08:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c91-d458-7931-8591-56d25ebb8685 | CAT | 2026-09-10 14:25 | other | 4 | 1 | 3 | 130125.00 | unknown | — | 804.4000 | 25.7500 | ["620","640","940","1000"] | ["0.4132","0.4026","0.3968","0.4052"] | [] | ["XCBO"] | 620.0000 | 1000.0000 | 99 | 127 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:26:01Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bcc-c320-7af2-baa2-55db2b145b47 | CAT | 2026-09-10 10:50 | other | 3 | 1 | 4 | 36308.00 | unknown | — | 806.4900 | 16.5500 | ["750","790","865"] | ["0.4162","0.5321","0.3841"] | [] | ["XCBO"] | 750.0000 | 865.0000 | 1 | 15 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:51:09Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bac-7599-7941-86d9-9b17f10e3d2c | CAT | 2026-09-10 10:15 | other | 4 | 1 | 9 | 29862.00 | unknown | — | 801.7700 | 10.7200 | ["740","800","810"] | ["0.5148","0.3939","0.5327"] | [] | ["XCBO"] | 740.0000 | 810.0000 | 1 | 8 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:15:59Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a06e01-94ee-7b43-848f-a40543105b0d | CAT | 2026-09-04 15:59 | other | 4 | 1 | 2 | 26498.00 | unknown | — | 813.7800 | 27.8500 | ["740","750","855","860"] | ["0.3649","0.3397","0.3827","0.3724"] | [] | ["XCBO"] | 740.0000 | 860.0000 | 21 | 35 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T20:00:34Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d4d-1db5-7fa1-a12a-bc9fa5a76829 | CAT | 2026-09-04 12:42 | other | 4 | 2 | 390 | 542714.00 | unknown | — | 813.1600 | 2.6800 | ["780","800"] | ["0.6696","0.4309"] | [] | ["XCBO"] | 780.0000 | 800.0000 | 0 | 7 | false | true | true | true | false | mlat | market_whale | 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 |
| 01a06d4b-5895-7b53-870f-35f2fb187676 | CAT | 2026-09-04 12:40 | other | 2 | 1 | 4 | 26960.00 | unknown | — | 813.1850 | 3.3500 | ["740"] | ["0.4089"] | [] | ["XPHO"] | 740.0000 | 740.0000 | 77 | 133 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:41:06Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d3a-a725-7410-9964-8fc0709e8d62 | CAT | 2026-09-04 12:22 | other | 3 | 1 | 8 | 48608.00 | unknown | — | 813.5650 | 6.1000 | ["790","840"] | ["0.6474","0.3367"] | [] | ["XCBO"] | 790.0000 | 840.0000 | 0 | 7 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:23:08Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |