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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c44a-dcdf-7661-a87f-c5ee60cf7021 | CAT | 2026-09-21 10:07 | put_vertical_spread | 2 | 1 | 12 | 64224.00 | long | ask | 810.3500 | 3.3500 | ["740","760"] | ["0.4239","0.4208"] | ["753.54"] | ["XMIO"] | 740.0000 | 760.0000 | 60 | 60 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:07:20Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c42b-1427-7782-9b74-c81cafb0a3e9 | CAT | 2026-09-21 09:32 | put_vertical_spread | 2 | 1 | 10 | 30160.00 | long | ask | 814.2500 | 8.5500 | ["760","800"] | ["0.3492","0.3418"] | ["787.58"] | ["XCBO"] | 760.0000 | 800.0000 | 25 | 25 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:32:35Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b593-f3a7-73c2-b6e4-93362c7d0c80 | CAT | 2026-09-18 13:32 | put_vertical_spread | 2 | 1 | 10 | 26790.00 | short | bid | 800.7400 | 2.4000 | ["680","700"] | ["0.4242","0.4204"] | ["696.11"] | ["XCBO"] | 680.0000 | 700.0000 | 63 | 63 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:32:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4df-bed8-7a41-b542-a3a5d009131a | CAT | 2026-09-18 10:15 | put_vertical_spread | 2 | 1 | 9 | 200448.00 | long | ask | 806.9000 | 17.8000 | ["915","920"] | ["2.6925","2.7745"] | ["915.02"] | ["XCBO"] | 915.0000 | 920.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:16:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d8-8730-7d50-9903-45be645707ea | CAT | 2026-09-18 10:08 | put_vertical_spread | 2 | 1 | 2 | 44538.00 | long | ask | 804.6050 | 17.8000 | ["915","920"] | ["3.5758","3.6568"] | ["915.01"] | ["XMIO"] | 915.0000 | 920.0000 | 0 | 0 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:08:03Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d5-db97-7b40-b1a0-f0facf2b3fcd | CAT | 2026-09-18 10:05 | put_vertical_spread | 2 | 1 | 7 | 155897.00 | long | ask | 804.6850 | 17.8000 | ["915","920"] | ["3.5825","3.6640"] | ["915.01"] | ["XCBO"] | 915.0000 | 920.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:05:15Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b022-fe43-76d1-97f6-02317d1cf693 | CAT | 2026-09-17 12:11 | put_vertical_spread | 2 | 1 | 5 | 119280.00 | long | ask | 799.4550 | 21.1000 | ["915","920"] | ["1.5400","1.5844"] | ["915.02"] | ["XCBO"] | 915.0000 | 920.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:11:17Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b022-db1b-77a1-8c1d-95eb1a1121a7 | CAT | 2026-09-17 12:11 | put_vertical_spread | 2 | 1 | 10 | 238560.00 | long | ask | 799.4550 | 21.1000 | ["915","920"] | ["1.5400","1.5844"] | ["915.02"] | ["XCBO"] | 915.0000 | 920.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:11:17Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b015-ee83-7793-8c01-3b3b96055d14 | CAT | 2026-09-17 11:56 | put_vertical_spread | 2 | 1 | 2 | 48112.00 | long | ask | 798.5775 | 25.1000 | ["915","920"] | ["1.5776","1.6226"] | ["915.02"] | ["XCBO"] | 915.0000 | 920.0000 | 1 | 1 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:57:33Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b015-ee83-7793-8c01-3b2275023f43 | CAT | 2026-09-17 11:56 | put_vertical_spread | 2 | 1 | 2 | 48112.00 | long | ask | 798.5775 | 25.1000 | ["915","920"] | ["1.5776","1.6226"] | ["915.02"] | ["XCBO"] | 915.0000 | 920.0000 | 1 | 1 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:57:33Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab5d-5813-7d31-a86d-44d899d337a8 | CAT | 2026-09-16 13:56 | put_vertical_spread | 2 | 1 | 3 | 38490.00 | long | ask | 791.7000 | 17.4000 | ["600","700"] | ["0.4223","0.4189"] | ["664.66"] | ["XPHO"] | 600.0000 | 700.0000 | 492 | 492 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:57:20Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aabb-c4cb-7c52-9a13-3ffea59228ff | CAT | 2026-09-16 11:00 | put_vertical_spread | 2 | 1 | 3 | 75519.00 | long | ask | 788.3450 | 16.4500 | ["910","915"] | ["1.2309","1.2658"] | ["910.01"] | ["XCBO"] | 910.0000 | 915.0000 | 2 | 2 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:00:50Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aab5-257b-7113-961d-b88a520662d7 | CAT | 2026-09-16 10:53 | put_vertical_spread | 2 | 1 | 5 | 141460.00 | long | ask | 786.4800 | 21.6000 | ["925","930"] | ["1.1122","1.1374"] | ["925.02"] | ["XCBO"] | 925.0000 | 930.0000 | 2 | 2 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:53:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa69-50e3-7a63-98aa-971fc0bc4309 | CAT | 2026-09-16 09:30 | put_vertical_spread | 2 | 1 | 3 | 32412.00 | unknown | — | 797.7940 | 15.8750 | ["830","840"] | ["0.3631","0.3659"] | [] | ["XMIO"] | 830.0000 | 840.0000 | 30 | 30 | false | false | false | true | false | mlat | tracked | 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 |
| 01a0a165-3c30-79d2-b238-cd1312ebfdc0 | CAT | 2026-09-14 15:29 | put_vertical_spread | 2 | 1 | 2 | 55982.00 | long | ask | 786.8300 | 19.2000 | ["925","930"] | ["1.1658","1.1869"] | ["925.01"] | ["XCBO"] | 925.0000 | 930.0000 | 4 | 4 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:29:47Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a080-eaf8-7841-b7ba-f9ffe107c0af | CAT | 2026-09-14 11:19 | put_vertical_spread | 2 | 1 | 4 | 34268.00 | long | ask | 783.8950 | 5.2500 | ["760","770"] | ["0.4102","0.4093"] | ["765.51"] | ["XMIO"] | 760.0000 | 770.0000 | 67 | 67 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:20:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a06d-3800-74c0-978b-703e9bf94b6e | CAT | 2026-09-14 10:58 | put_vertical_spread | 2 | 1 | 20 | 55820.00 | short | bid | 783.4100 | 3.4000 | ["620","670"] | ["0.4209","0.4110"] | ["661.13"] | ["XMIO"] | 620.0000 | 670.0000 | 95 | 95 | false | true | false | 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 |
| 01a091ee-e440-77a2-a57d-24f3014fc723 | CAT | 2026-09-11 15:25 | put_vertical_spread | 2 | 1 | 17 | 125902.00 | long | ask | 819.3900 | 6.6000 | ["835","840"] | ["0.3552","0.3553"] | ["836.96"] | ["XCBO"] | 835.0000 | 840.0000 | 21 | 21 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:25:56Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091d0-1588-7eb2-ac14-73ba0343cebe | CAT | 2026-09-11 14:52 | put_vertical_spread | 2 | 1 | 10 | 38390.00 | long | ask | 819.3300 | 1.9000 | ["780","790"] | ["0.3508","0.3488"] | ["786.65"] | ["XMIO"] | 780.0000 | 790.0000 | 35 | 35 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:52:07Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c5c-c269-73f0-bd54-acd4f46879f1 | CAT | 2026-09-10 13:28 | put_vertical_spread | 2 | 1 | 4 | 33272.00 | long | ask | 801.7078 | 5.3500 | ["810","820"] | ["0.3591","0.3584"] | ["814.42"] | ["XCBO"] | 810.0000 | 820.0000 | 36 | 36 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:28:34Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b97-0d20-7050-a3d1-ee579410d4ba | CAT | 2026-09-10 09:52 | put_vertical_spread | 2 | 1 | 10 | 32790.00 | short | bid | 799.5500 | 8.4500 | ["795","800"] | ["0.3751","0.3755"] | ["797.55"] | ["EDGO"] | 795.0000 | 800.0000 | 8 | 8 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:52:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08214-0dc1-7431-b431-7711fb1a3480 | CAT | 2026-09-08 13:32 | put_vertical_spread | 2 | 1 | 50 | 294602.00 | short | bid | 826.9100 | 8.2000 | ["765","825"] | ["0.3873","0.3801"] | ["801.98"] | ["XCBO"] | 765.0000 | 825.0000 | 45 | 45 | true | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:32:44Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0818d-de31-7292-8c48-0883e760c7c2 | CAT | 2026-09-08 11:05 | put_vertical_spread | 2 | 1 | 12 | 43104.00 | unknown | — | 825.0400 | 2.2500 | ["770","780"] | ["0.3796","0.3772"] | [] | ["MCRY"] | 770.0000 | 780.0000 | 38 | 38 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:05:56Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dc0-4dfe-76d0-a1d7-e85bb3122bc9 | CAT | 2026-09-04 14:48 | put_vertical_spread | 2 | 1 | 3 | 27201.00 | long | ask | 810.9100 | 3.2500 | ["720","780"] | ["0.4039","0.4006"] | ["757.05"] | ["XMIO"] | 720.0000 | 780.0000 | 133 | 133 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:48:57Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |