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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b607-d3b8-7753-846b-5d6809fd2968 | SPX | 2026-09-18 15:39 | strangle | 2 | 1 | 75 | 122175.00 | short | bid | 7641.5000 | 0.6000 | ["7000","8000"] | ["0.2117","0.0974"] | ["6983.71","8016.29"] | ["XCBO"] | 7000.0000 | 8000.0000 | 28 | 28 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:39:36Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ae-cea7-7b91-be53-69e5711f9204 | SPX | 2026-09-18 14:02 | strangle | 2 | 1 | 100 | 10530600.00 | short | bid | 7629.0800 | 18.2000 | ["7500","8500"] | ["0.1337","0.1961"] | ["7446.94","8553.06"] | ["XCBO"] | 7500.0000 | 8500.0000 | 28 | 28 | false | false | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:02:12Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a3-8fbf-70f1-87da-19955108113b | SPX | 2026-09-18 13:49 | strangle | 2 | 1 | 1163 | 1952677.00 | short | bid | 7627.0100 | 0.6000 | ["7000","8000"] | ["0.2127","0.0981"] | ["6983.21","8016.79"] | ["XCBO"] | 7000.0000 | 8000.0000 | 28 | 28 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:50:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a2-f37f-7091-8b49-bb40d33b32f3 | SPX | 2026-09-18 13:49 | strangle | 2 | 1 | 1000 | 1699000.00 | short | bid | 7627.3700 | 0.5000 | ["7000","8000"] | ["0.2128","0.0989"] | ["6983.01","8016.99"] | ["XCBO"] | 7000.0000 | 8000.0000 | 28 | 28 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:49:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b536-df87-7c92-b348-e1c24f96dc72 | SPX | 2026-09-18 11:51 | strangle | 2 | 1 | 250 | 1030000.00 | short | bid | 7623.2700 | 0.5000 | ["7000","8000"] | ["0.2093","0.1072"] | ["6958.80","8041.20"] | ["XCBO"] | 7000.0000 | 8000.0000 | 42 | 42 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:51:26Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b52f-84b8-7020-a938-0efe18626d31 | SPX | 2026-09-18 11:43 | strangle | 2 | 1 | 125 | 8188250.00 | short | bid | 7622.9600 | 2.7000 | ["6000","7000"] | ["0.3796","0.1942"] | ["5344.94","7655.06"] | ["XCBO"] | 6000.0000 | 7000.0000 | 28 | 28 | false | false | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:43:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e0-f370-7870-bc45-08c35ccc4cd9 | SPX | 2026-09-18 10:17 | strangle | 2 | 1 | 4000 | 655608000.00 | short | bid | 7618.9400 | 4.0000 | ["7000","8000"] | ["0.1918","0.1632"] | ["6360.98","8639.02"] | ["XCBO"] | 7000.0000 | 8000.0000 | 364 | 364 | false | false | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:17:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a698-06fe-7610-b651-3ae650fa5464 | SPX | 2026-09-15 15:42 | strangle | 2 | 1 | 2000 | 204826000.00 | short | bid | 7578.1000 | 3.8000 | ["7000","8000"] | ["0.2220","0.1068"] | ["6975.87","8024.13"] | ["XCBO"] | 7000.0000 | 8000.0000 | 31 | 31 | false | false | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:42:57Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a698-06fe-7610-b651-3acc70f8e0b5 | SPX | 2026-09-15 15:42 | strangle | 2 | 1 | 1000 | 102413000.00 | short | bid | 7578.1000 | 3.8000 | ["7000","8000"] | ["0.2220","0.1068"] | ["6975.87","8024.13"] | ["XCBO"] | 7000.0000 | 8000.0000 | 31 | 31 | false | false | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:42:57Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a572-1cce-73d1-80d3-47f8ce5858f5 | SPX | 2026-09-15 10:21 | strangle | 2 | 1 | 3500 | 556500.00 | short | bid | 7588.8900 | 0.2000 | ["7000","8000"] | ["0.4131","0.2081"] | ["6998.41","8001.59"] | ["XCBO"] | 7000.0000 | 8000.0000 | 3 | 3 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:21:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a110-2ad8-74c2-b71b-5cc6f8a1480f | SPX | 2026-09-14 13:56 | strangle | 2 | 1 | 300 | 21085800.00 | short | bid | 7640.9900 | 2.9000 | ["7000","8000"] | ["0.2088","0.1519"] | ["6297.14","8702.86"] | ["XCBO"] | 7000.0000 | 8000.0000 | 368 | 368 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:56:30Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a110-2ad8-74c2-b71b-5cb433629bb2 | SPX | 2026-09-14 13:56 | strangle | 2 | 1 | 300 | 21085800.00 | short | bid | 7640.9900 | 2.9000 | ["7000","8000"] | ["0.2088","0.1519"] | ["6297.14","8702.86"] | ["XCBO"] | 7000.0000 | 8000.0000 | 368 | 368 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:56:30Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a110-2ad8-74c2-b71b-5ca7977a01f4 | SPX | 2026-09-14 13:56 | strangle | 2 | 1 | 600 | 99273600.00 | short | bid | 7640.9900 | 4.2000 | ["7000","8000"] | ["0.1862","0.1678"] | ["6345.44","8654.56"] | ["XCBO"] | 7000.0000 | 8000.0000 | 368 | 368 | false | false | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:56:30Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08ce6-1a90-7b41-8ea7-11c439af884f | SPX | 2026-09-10 15:58 | strangle | 2 | 1 | 268 | 101840.00 | short | bid | 7591.1300 | 0.4500 | ["7000","8000"] | ["0.2920","0.1367"] | ["6996.20","8003.80"] | ["XCBO"] | 7000.0000 | 8000.0000 | 8 | 8 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:58:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c38-fe29-7ea0-8522-9d378c0f9c8b | SPX | 2026-09-10 12:48 | strangle | 2 | 1 | 350 | 5946150.00 | short | bid | 7604.1700 | 1.3000 | ["7000","8000"] | ["0.2071","0.1274"] | ["6830.11","8169.89"] | ["XCBO"] | 7000.0000 | 8000.0000 | 99 | 99 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:49:24Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c38-a450-7eb3-af78-b36645f50395 | SPX | 2026-09-10 12:48 | strangle | 2 | 1 | 100 | 32700.00 | short | bid | 7604.5300 | 0.4000 | ["7000","8000"] | ["0.2893","0.1326"] | ["6996.73","8003.27"] | ["XCBO"] | 7000.0000 | 8000.0000 | 8 | 8 | false | true | false | true | true | cbmo | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:48:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c38-a450-7eb3-af78-b3564be30a77 | SPX | 2026-09-10 12:48 | strangle | 2 | 1 | 350 | 114450.00 | short | bid | 7604.5300 | 0.4000 | ["7000","8000"] | ["0.2893","0.1326"] | ["6996.73","8003.27"] | ["XCBO"] | 7000.0000 | 8000.0000 | 8 | 8 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:48:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bf2-7390-7ac0-a137-1d73527b3921 | SPX | 2026-09-10 11:31 | strangle | 2 | 1 | 1000 | 337000.00 | short | bid | 7605.4500 | 0.2000 | ["7000","8000"] | ["0.2896","0.1371"] | ["6996.63","8003.37"] | ["XCBO"] | 7000.0000 | 8000.0000 | 8 | 8 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:32:13Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08743-5ad0-7c12-9d79-cb0c99231974 | SPX | 2026-09-09 13:42 | strangle | 2 | 1 | 1750 | 113435000.00 | short | bid | 7641.0300 | 2.7500 | ["6000","7000"] | ["0.5488","0.2015"] | ["5351.80","7648.20"] | ["XCBO"] | 6000.0000 | 7000.0000 | 9 | 9 | false | false | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:42:19Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08743-5ad0-7c12-9d79-cafd093a47db | SPX | 2026-09-09 13:42 | strangle | 2 | 1 | 1750 | 288235500.00 | short | bid | 7641.0300 | 4.4500 | ["6000","7000"] | ["0.5207","0.2765"] | ["5352.94","7647.06"] | ["XCBO"] | 6000.0000 | 7000.0000 | 9 | 9 | false | false | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:42:19Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086f8-ec20-73a3-80be-c3043dff76a3 | SPX | 2026-09-09 12:20 | strangle | 2 | 1 | 350 | 46828950.00 | short | bid | 7628.1900 | 2.7000 | ["7000","8000"] | ["0.1892","0.1472"] | ["6662.03","8337.97"] | ["XCBO"] | 7000.0000 | 8000.0000 | 191 | 191 | false | false | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:21:11Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08197-aa00-7831-8bb6-97c68d025825 | SPX | 2026-09-08 11:16 | strangle | 2 | 1 | 300 | 1171200.00 | short | bid | 7697.3300 | 0.8000 | ["7000","8000"] | ["0.2130","0.1064"] | ["6960.96","8039.04"] | ["XCBO"] | 7000.0000 | 8000.0000 | 38 | 38 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:16:53Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06e02-fc4d-7b72-9386-47b44cfe5386 | SPX | 2026-09-04 16:01 | strangle | 2 | 1 | 20 | 153020.00 | short | bid | 7718.3600 | 0.9000 | ["7300","7825"] | ["0.1695","0.1000"] | ["7223.49","7901.51"] | ["XCBO"] | 7300.0000 | 7825.0000 | 31 | 31 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T20:02:41Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dd4-cffd-7670-b902-4179a8e78540 | SPX | 2026-09-04 15:10 | strangle | 2 | 1 | 282 | 50103504.00 | short | bid | 7713.2000 | 18.0000 | ["6000","7000"] | ["0.2372","0.2037"] | ["5223.28","7776.72"] | ["XCBO"] | 6000.0000 | 7000.0000 | 56 | 56 | false | false | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:11:00Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dad-3745-71a2-be32-31e305bbafc8 | SPX | 2026-09-04 14:27 | strangle | 2 | 1 | 440 | 146960.00 | short | bid | 7713.8000 | 0.3000 | ["7000","8000"] | ["0.2363","0.0911"] | ["6996.66","8003.34"] | ["XCBO"] | 7000.0000 | 8000.0000 | 14 | 14 | false | true | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:28:25Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06daa-06dd-7b60-9764-4c33c33ad3a6 | SPX | 2026-09-04 14:24 | strangle | 2 | 1 | 3000 | 333408000.00 | short | bid | 7714.1900 | 3.4000 | ["7000","8000"] | ["0.1848","0.1230"] | ["6888.64","8111.36"] | ["XCBO"] | 7000.0000 | 8000.0000 | 77 | 77 | false | false | false | true | true | cbmo | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:25:02Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |