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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b609-46cf-7872-83b0-9cf23ec5e35a | SPX | 2026-09-18 15:40 | strangle | 2 | 1 | 115 | 12992240.00 | unknown | ask | 7640.9200 | 2.6000 | ["7000","8000"] | ["0.1865","0.1273"] | ["7700.29"] | ["XCBO"] | 7000.0000 | 8000.0000 | 91 | 91 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:41:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4cc-36d7-7d50-bed5-4308a0615a9f | VIX | 2026-09-18 09:54 | strangle | 2 | 1 | 1200 | 165600.00 | long | ask | 15.3400 | 0.0900 | ["17","30"] | ["0.6383","1.7167"] | ["15.62","31.38"] | ["XCBO"] | 17.0000 | 30.0000 | 33 | 33 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:54:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4cc-36d7-7d50-bed5-42f6a74e8e09 | VIX | 2026-09-18 09:54 | strangle | 2 | 1 | 1800 | 248400.00 | long | ask | 15.3400 | 0.0900 | ["17","30"] | ["0.6383","1.7167"] | ["15.62","31.38"] | ["XCBO"] | 17.0000 | 30.0000 | 33 | 33 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:54:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0ab-a2bb-7bc1-a654-3f63579c2b47 | SPX | 2026-09-17 14:40 | strangle | 2 | 1 | 45 | 456300.00 | long | ask | 7633.2100 | 1.1000 | ["7000","8200"] | ["0.2029","0.1153"] | ["6898.60","8301.40"] | ["XCBO"] | 7000.0000 | 8200.0000 | 92 | 92 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:41:00Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a3-de73-70f2-ae46-931a3430cad7 | SPX | 2026-09-17 14:32 | strangle | 2 | 1 | 50 | 507000.00 | long | ask | 7637.8900 | 0.9000 | ["7000","8200"] | ["0.2029","0.1153"] | ["6898.60","8301.40"] | ["XCBO"] | 7000.0000 | 8200.0000 | 92 | 92 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:32:30Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a3-de73-70f2-ae46-930478d99cf1 | SPX | 2026-09-17 14:32 | strangle | 2 | 1 | 50 | 507000.00 | long | ask | 7637.8900 | 0.9000 | ["7000","8200"] | ["0.2029","0.1153"] | ["6898.60","8301.40"] | ["XCBO"] | 7000.0000 | 8200.0000 | 92 | 92 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:32:30Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a3-de73-70f2-ae46-92fd81ca740e | SPX | 2026-09-17 14:32 | strangle | 2 | 1 | 125 | 1267500.00 | long | ask | 7637.8900 | 0.9000 | ["7000","8200"] | ["0.2029","0.1153"] | ["6898.60","8301.40"] | ["XCBO"] | 7000.0000 | 8200.0000 | 92 | 92 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:32:30Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afef-01ab-7ce3-bd45-7c1c5b001bc8 | SPX | 2026-09-17 11:14 | strangle | 2 | 1 | 80 | 79090080.00 | long | ask | 7621.7600 | 33.6000 | ["2000","12000"] | ["0.8277","0.4032"] | [] | ["XCBO"] | 2000.0000 | 12000.0000 | 92 | 92 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:14:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afe8-27c3-7e73-bec8-54bc461acc3a | SPX | 2026-09-17 11:07 | strangle | 2 | 1 | 300 | 30511800.00 | long | ask | 7617.1800 | 3.6000 | ["7000","8000"] | ["0.2128","0.1057"] | ["6982.94","8017.06"] | ["XCBO"] | 7000.0000 | 8000.0000 | 29 | 29 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:07:01Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab5a-4ad3-7cf2-be09-c7eb3386182c | SPX | 2026-09-16 13:53 | strangle | 2 | 1 | 50 | 85000.00 | long | ask | 7608.0200 | 0.2000 | ["7560","7650"] | ["0.5532","0.4990"] | ["7543","7667.00"] | ["XCBO"] | 7560.0000 | 7650.0000 | 0 | 0 | false | true | false | true | true | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:54:13Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab09-311b-7bc0-81f3-2febf027fc00 | SPX | 2026-09-16 12:24 | strangle | 2 | 1 | 500 | 127700000.00 | long | ask | 7611.4000 | 571.0000 | ["7000","8000"] | ["0.2356","0.1894"] | ["4446","10554.00"] | ["XCBO"] | 7000.0000 | 8000.0000 | 1920 | 1920 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:25:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab04-f713-7e43-a641-a8cbb016ed2d | SPX | 2026-09-16 12:20 | strangle | 2 | 1 | 50 | 495650.00 | long | ask | 7613.3000 | 1.0000 | ["6900","8200"] | ["0.2155","0.1179"] | ["6800.87","8299.13"] | ["XCBO"] | 6900.0000 | 8200.0000 | 93 | 93 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:20:55Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab04-f713-7e43-a641-a8b10c94f86f | SPX | 2026-09-16 12:20 | strangle | 2 | 1 | 50 | 495650.00 | long | ask | 7613.3000 | 1.0000 | ["6900","8200"] | ["0.2155","0.1179"] | ["6800.87","8299.13"] | ["XCBO"] | 6900.0000 | 8200.0000 | 93 | 93 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:20:55Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5c3-6566-75b2-ae8e-d5921ec230c1 | SPX | 2026-09-15 11:50 | strangle | 2 | 1 | 50 | 75500.00 | long | ask | 7585.5000 | 0.5500 | ["7450","7750"] | ["0.2125","0.1395"] | ["7434.90","7765.10"] | ["XCBO"] | 7450.0000 | 7750.0000 | 3 | 3 | false | true | false | true | true | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:50:43Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a59c-de1e-74e0-b3ab-f02091073c04 | AZO | 2026-09-15 11:08 | strangle | 2 | 1 | 38 | 649800.00 | long | ask | 2906.4600 | 21.9000 | ["2810","3080"] | ["0.4277","0.4118"] | ["2639","3251.00"] | ["XCBO"] | 2810.0000 | 3080.0000 | 31 | 31 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:08:36Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a59c-da36-7012-824c-01af74c449c8 | AZO | 2026-09-15 11:08 | strangle | 2 | 1 | 12 | 205200.00 | long | ask | 2906.4600 | 21.9000 | ["2810","3080"] | ["0.4277","0.4118"] | ["2639","3251.00"] | ["XCBO"] | 2810.0000 | 3080.0000 | 31 | 31 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:08:36Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a183-2471-7df1-b1ac-b2e7514ca2aa | SPX | 2026-09-14 16:01 | strangle | 2 | 1 | 88 | 61688.00 | long | ask | 7619.9500 | 0.4500 | ["7375","7945"] | ["0.2285","0.1535"] | ["7367.99","7952.01"] | ["XCBO"] | 7375.0000 | 7945.0000 | 4 | 4 | false | true | false | true | true | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T20:03:17Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0c2-c658-7403-938f-ecad64eacefa | RUT | 2026-09-14 12:31 | strangle | 2 | 2 | 150 | 3165000.00 | long | ask | 2903.5230 | 9.8000 | ["2800","3300"] | ["0.2222","0.1790"] | ["2589","3511.00"] | ["XCBO"] | 2800.0000 | 3300.0000 | 276 | 276 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:32:11Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0c2-c270-79c2-a1ab-d16b7f340bf4 | RUT | 2026-09-14 12:31 | strangle | 2 | 1 | 100 | 2110000.00 | long | ask | 2903.5230 | 9.8000 | ["2800","3300"] | ["0.2222","0.1790"] | ["2589","3511.00"] | ["XCBO"] | 2800.0000 | 3300.0000 | 276 | 276 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:32:11Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091e7-1c10-7160-b2ed-950040ebedaf | SPX | 2026-09-11 15:17 | strangle | 2 | 1 | 28 | 2804060.00 | long | ask | 7664.0100 | 39.6000 | ["7000","8000"] | ["0.4006","0.1779"] | ["6998.55","8001.45"] | ["XCBO"] | 7000.0000 | 8000.0000 | 7 | 7 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:17:24Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c31-97a0-7c03-8608-4844d1fe4b6a | LOW | 2026-09-10 12:40 | strangle | 2 | 1 | 19 | 102600.00 | long | ask | 196.7150 | 1.5000 | ["210","220"] | ["0.3475","0.2848"] | ["156","274.00"] | ["XBOX"] | 210.0000 | 220.0000 | 498 | 498 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:41:22Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bef-1060-7ed1-a529-92666e03ddf2 | SPX | 2026-09-10 11:28 | strangle | 2 | 1 | 500 | 1802000.00 | long | ask | 7608.3300 | 0.9000 | ["7000","8000"] | ["0.2191","0.1109"] | ["6963.96","8036.04"] | ["XCBO"] | 7000.0000 | 8000.0000 | 36 | 36 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:28:15Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bd9-b788-7b93-98fd-069f810453fb | SPX | 2026-09-10 11:04 | strangle | 2 | 2 | 150 | 559500.00 | long | ask | 7601.5400 | 0.6000 | ["7300","7875"] | ["0.1875","0.1076"] | ["7262.70","7912.30"] | ["XCBO"] | 7300.0000 | 7875.0000 | 20 | 20 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:05:15Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086a9-2258-7f50-af92-8b30a9d7b559 | SPX | 2026-09-09 10:53 | strangle | 2 | 1 | 52 | 70200.00 | long | ask | 7651.3300 | 0.3000 | ["6925","8350"] | ["0.2317","0.1241"] | ["6911.50","8363.50"] | ["XCBO"] | 6925.0000 | 8350.0000 | 30 | 30 | false | true | false | true | true | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:53:52Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086a6-0578-7b90-9495-ebd5631778cd | SPX | 2026-09-09 10:50 | strangle | 2 | 1 | 40 | 3168000.00 | long | ask | 7651.7700 | 4.0000 | ["7800","8600"] | ["0.1818","0.1442"] | ["7008","9392.00"] | ["XCBO"] | 7800.0000 | 8600.0000 | 464 | 464 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:50:33Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0827b-3fb8-7811-9b3e-623392ebcff0 | SPX | 2026-09-08 15:25 | strangle | 2 | 1 | 75 | 217500.00 | long | ask | 7680.4800 | 0.5000 | ["7500","7900"] | ["0.1494","0.0960"] | ["7471","7929.00"] | ["XCBO"] | 7500.0000 | 7900.0000 | 14 | 14 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:25:40Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08143-f069-7f42-b795-a2f48f850a3d | SPX | 2026-09-08 09:45 | strangle | 2 | 1 | 120 | 549600.00 | long | ask | 7687.7500 | 0.4000 | ["7675","7700"] | ["0.1306","0.1224"] | ["7629.20","7745.80"] | ["XCBO"] | 7675.0000 | 7700.0000 | 2 | 2 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:45:19Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d6e-edf6-76d1-95f5-64c9cefce223 | SPX | 2026-09-04 13:19 | strangle | 2 | 1 | 420 | 73899000.00 | long | ask | 7718.4000 | 7.6000 | ["6000","7000"] | ["0.2559","0.2050"] | ["5240.50","7759.50"] | ["XCBO"] | 6000.0000 | 7000.0000 | 42 | 42 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:20:09Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d6e-edf5-7732-806d-821ffe1f4c2d | SPX | 2026-09-04 13:19 | strangle | 2 | 1 | 200 | 35190000.00 | long | ask | 7718.4000 | 7.6000 | ["6000","7000"] | ["0.2634","0.2050"] | ["5240.50","7759.50"] | ["XCBO"] | 6000.0000 | 7000.0000 | 42 | 42 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:20:09Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d6e-edf5-7732-806d-820b67b1221c | SPX | 2026-09-04 13:19 | strangle | 2 | 1 | 620 | 47380400.00 | long | ask | 7718.5000 | 2.0000 | ["6000","7000"] | ["0.3415","0.1872"] | ["5235.80","7764.20"] | ["XCBO"] | 6000.0000 | 7000.0000 | 42 | 42 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:20:09Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |