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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5fd-9e70-7d32-ae19-5b49db390ca9 | SPX | 2026-09-18 15:28 | straddle | 2 | 1 | 50 | 1655000.00 | short | bid | 7640.4400 | 1.6000 | ["7700"] | ["0.1307"] | ["7369","8031.00"] | ["XCBO"] | 7700.0000 | 7700.0000 | 63 | 63 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:28:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a7-7f8f-7361-a5bf-f0144a8b9df6 | VIX | 2026-09-18 13:54 | straddle | 2 | 1 | 3000 | 882000.00 | short | bid | 15.2500 | 0.1000 | ["17.5"] | ["1.0481"] | ["14.56","20.44"] | ["XCBO"] | 17.5000 | 17.5000 | 33 | 33 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:54:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b50e-f0e0-7772-a9aa-6176e2458aec | SPX | 2026-09-18 11:07 | straddle | 2 | 1 | 400 | 8043200.00 | short | bid | 7630.1100 | 1.0000 | ["7650"] | ["0.1193"] | ["7448.92","7851.08"] | ["XCBO"] | 7650.0000 | 7650.0000 | 28 | 28 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:07:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4fa-9dbf-7a82-b1b8-3daf9ffd5239 | SPX | 2026-09-18 10:45 | straddle | 2 | 2 | 25 | 517750.00 | short | bid | 7619.8800 | 1.9000 | ["7625"] | ["0.1228"] | ["7417.90","7832.10"] | ["XCBO"] | 7625.0000 | 7625.0000 | 28 | 28 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:45:26Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afb7-a1e3-7523-9d9f-706397fa81b6 | VIX | 2026-09-17 10:13 | straddle | 2 | 2 | 3400 | 1200200.00 | short | bid | 15.9100 | 0.1000 | ["18.5"] | ["1.0180"] | ["14.97","22.03"] | ["XCBO"] | 18.5000 | 18.5000 | 34 | 34 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:14:01Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa8-8a9b-7f03-8047-1e00865b59f5 | VIX | 2026-09-17 09:57 | straddle | 2 | 1 | 500 | 177500.00 | short | bid | 15.7700 | 0.1300 | ["18.5"] | ["1.0370"] | ["14.95","22.05"] | ["XCBO"] | 18.5000 | 18.5000 | 34 | 34 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:57:40Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af96-d373-7681-86c6-ce4a82e4b840 | SPX | 2026-09-17 09:38 | straddle | 2 | 1 | 200 | 1062400.00 | short | bid | 7622.9200 | 0.3500 | ["7675"] | ["0.1508"] | ["7621.88","7728.12"] | ["XCBO"] | 7675.0000 | 7675.0000 | 0 | 0 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:38:25Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abd3-d803-7221-940f-46bdc0afe90a | SPX | 2026-09-16 16:06 | straddle | 2 | 2 | 350 | 6062000.00 | short | bid | 7551.8100 | 1.1000 | ["7525"] | ["0.1448"] | ["7351.80","7698.20"] | ["XCBO"] | 7525.0000 | 7525.0000 | 14 | 14 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T20:08:02Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab28-2eb3-7ed2-b8d7-5561abdf1c74 | SPX | 2026-09-16 12:58 | straddle | 2 | 1 | 29 | 1466240.00 | short | bid | 7610.1600 | 2.1000 | ["7700"] | ["0.1448"] | ["7194.40","8205.60"] | ["XCBO"] | 7700.0000 | 7700.0000 | 121 | 121 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:59:37Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa8f-78f3-7fe0-b106-9a7faa819f4c | SPX | 2026-09-16 10:12 | straddle | 2 | 1 | 32 | 2039680.00 | short | bid | 7607.3400 | 2.4000 | ["7800"] | ["0.1477"] | ["7162.60","8437.40"] | ["XCBO"] | 7800.0000 | 7800.0000 | 184 | 184 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:12:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a6a9-3956-71a1-980e-10c135b39600 | RUT | 2026-09-15 16:01 | straddle | 2 | 2 | 8 | 179200.00 | short | bid | 2870.3080 | 1.1000 | ["2890"] | ["0.1930"] | ["2666","3114.00"] | ["XCBO"] | 2890.0000 | 2890.0000 | 94 | 94 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T20:02:47Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0a5-0cf9-7860-b2b5-22bae1ca934a | SHOP | 2026-09-14 11:59 | straddle | 2 | 1 | 425 | 767125.00 | short | bid | 133.1700 | 2.0000 | ["145"] | ["0.4726"] | ["126.95","163.05"] | ["XCBO"] | 145.0000 | 145.0000 | 32 | 32 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:00:00Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0a5-0cf9-7860-b2b5-22a525698d46 | SHOP | 2026-09-14 11:59 | straddle | 2 | 2 | 75 | 135375.00 | short | bid | 133.1700 | 2.0000 | ["145"] | ["0.4726"] | ["126.95","163.05"] | ["XCBO"] | 145.0000 | 145.0000 | 32 | 32 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:00:00Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a06d-6eb0-7a22-b4cb-eeffbf717b8e | SPX | 2026-09-14 10:58 | straddle | 2 | 1 | 75 | 2892750.00 | short | bid | 7596.4300 | 1.8000 | ["7595"] | ["0.1480"] | ["7209.30","7980.70"] | ["XCBO"] | 7595.0000 | 7595.0000 | 67 | 67 | false | false | false | false | true | mfsl | market_whale | 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 |
| 01a0a02c-9138-71b3-a055-e7c6011d37d0 | SPX | 2026-09-14 09:47 | straddle | 2 | 1 | 50 | 1211000.00 | short | bid | 7611.2900 | 2.3000 | ["7640"] | ["0.1347"] | ["7397.80","7882.20"] | ["XCBO"] | 7640.0000 | 7640.0000 | 32 | 32 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:47:56Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09134-8550-7bf0-9a1a-3ae26300dbbd | SPX | 2026-09-11 12:02 | straddle | 2 | 1 | 17 | 1897200.00 | short | bid | 7673.0100 | 5.0000 | ["8200"] | ["0.1614"] | ["7084","9316.00"] | ["XCBO"] | 8200.0000 | 8200.0000 | 462 | 462 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:02:24Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09134-8550-7bf0-9a1a-3ad841bb6555 | SPX | 2026-09-11 12:02 | straddle | 2 | 1 | 17 | 1897200.00 | short | bid | 7673.0100 | 5.0000 | ["8200"] | ["0.1614"] | ["7084","9316.00"] | ["XCBO"] | 8200.0000 | 8200.0000 | 462 | 462 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:02:24Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09134-8550-7bf0-9a1a-3ac71debb5bc | SPX | 2026-09-11 12:02 | straddle | 2 | 1 | 46 | 5133600.00 | short | bid | 7673.0100 | 5.0000 | ["8200"] | ["0.1614"] | ["7084","9316.00"] | ["XCBO"] | 8200.0000 | 8200.0000 | 462 | 462 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:02:24Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c02-4270-75f2-b1a5-102c740d7809 | WBD | 2026-09-10 11:49 | straddle | 2 | 1 | 500 | 102500.00 | short | bid | 28.2250 | 0.5700 | ["28"] | ["0.2892"] | ["25.95","30.05"] | ["XCBO"] | 28.0000 | 28.0000 | 36 | 36 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:49:13Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bcb-57d8-7443-ba3b-4fa7bcf39d44 | SU | 2026-09-10 10:49 | straddle | 2 | 2 | 500 | 398000.00 | short | bid | 68.8100 | 0.4000 | ["70"] | ["0.3266"] | ["62.04","77.96"] | ["XCBO"] | 70.0000 | 70.0000 | 71 | 71 | true | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:49:50Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0877e-8740-72a1-8414-3b3726b8e0e8 | SPX | 2026-09-09 14:46 | straddle | 2 | 2 | 50 | 1293500.00 | short | bid | 7645.6900 | 1.1000 | ["7645"] | ["0.1329"] | ["7386.30","7903.70"] | ["XCBO"] | 7645.0000 | 7645.0000 | 37 | 37 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:47:08Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0877d-5690-79b3-a689-9a22efe081c4 | SPX | 2026-09-09 14:45 | straddle | 2 | 1 | 75 | 926250.00 | short | bid | 7646.1100 | 1.0000 | ["7645"] | ["0.1288"] | ["7521.50","7768.50"] | ["XCBO"] | 7645.0000 | 7645.0000 | 9 | 9 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:45:36Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086a2-34e8-7eb3-9a18-acddb433b903 | SPX | 2026-09-09 10:46 | straddle | 2 | 1 | 75 | 920250.00 | short | bid | 7650.7800 | 1.0000 | ["7650"] | ["0.1279"] | ["7527.30","7772.70"] | ["XCBO"] | 7650.0000 | 7650.0000 | 9 | 9 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:46:22Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0868e-1c61-75e3-9316-73f9c5b9a2fe | VIX | 2026-09-09 10:24 | straddle | 2 | 2 | 200 | 108000.00 | short | bid | 16.2600 | 0.1600 | ["19"] | ["0.6483"] | ["13.60","24.40"] | ["XCBO"] | 19.0000 | 19.0000 | 98 | 98 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:24:29Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08253-be70-7e92-a3d2-5d3994bb0ee7 | SPX | 2026-09-08 14:41 | straddle | 2 | 2 | 25 | 298750.00 | short | bid | 7686.5100 | 1.0000 | ["7690"] | ["0.1177"] | ["7570.50","7809.50"] | ["XCBO"] | 7690.0000 | 7690.0000 | 10 | 10 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:42:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081f9-1768-7531-8585-f7d1178507c8 | SPX | 2026-09-08 13:02 | straddle | 2 | 1 | 75 | 5805000.00 | short | bid | 7692.9700 | 2.7000 | ["8000"] | ["0.1497"] | ["7226","8774.00"] | ["XCBO"] | 8000.0000 | 8000.0000 | 255 | 255 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:03:30Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |