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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5ed-f6a0-7bc3-9daa-c6d4c5291baa | SPX | 2026-09-18 15:11 | straddle | 2 | 1 | 80 | 3346400.00 | long | ask | 7641.7100 | 1.4000 | ["7700"] | ["0.1375"] | ["7281.70","8118.30"] | ["XCBO"] | 7700.0000 | 7700.0000 | 91 | 91 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:11:33Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ed-f6a0-7bc3-9daa-c6c8bdf1fb17 | SPX | 2026-09-18 15:11 | straddle | 2 | 2 | 120 | 5019600.00 | long | ask | 7641.7100 | 1.4000 | ["7700"] | ["0.1375"] | ["7281.70","8118.30"] | ["XCBO"] | 7700.0000 | 7700.0000 | 91 | 91 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:11:33Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e6-3257-7e93-96da-60d1d19b8015 | SPX | 2026-09-18 15:02 | straddle | 2 | 1 | 60 | 3767100.00 | long | ask | 7641.5100 | 1.8000 | ["7800"] | ["0.1460"] | ["7172.15","8427.85"] | ["XCBO"] | 7800.0000 | 7800.0000 | 182 | 182 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:02:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e6-3257-7e93-96da-60c90a0a2266 | SPX | 2026-09-18 15:02 | straddle | 2 | 1 | 90 | 5650650.00 | long | ask | 7641.5100 | 1.8000 | ["7800"] | ["0.1460"] | ["7172.15","8427.85"] | ["XCBO"] | 7800.0000 | 7800.0000 | 182 | 182 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:02:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4df-68e7-7c32-8262-0e712c5e1b42 | SPX | 2026-09-18 10:15 | straddle | 2 | 1 | 20 | 843800.00 | long | ask | 7622.7600 | 1.4000 | ["7700"] | ["0.1390"] | ["7278.10","8121.90"] | ["XCBO"] | 7700.0000 | 7700.0000 | 91 | 91 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:15:53Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4df-68e7-7c32-8262-0e647417bf16 | SPX | 2026-09-18 10:15 | straddle | 2 | 2 | 40 | 1687600.00 | long | ask | 7622.7600 | 1.4000 | ["7700"] | ["0.1390"] | ["7278.10","8121.90"] | ["XCBO"] | 7700.0000 | 7700.0000 | 91 | 91 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:15:53Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0f0-48f3-7fe3-8241-b68a41391402 | SPX | 2026-09-17 15:55 | straddle | 2 | 1 | 40 | 858000.00 | long | ask | 7642.6200 | 0.8000 | ["7650"] | ["0.1247"] | ["7435.50","7864.50"] | ["XCBO"] | 7650.0000 | 7650.0000 | 29 | 29 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:55:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0f0-48f3-7fe3-8241-b6776bc83ed9 | SPX | 2026-09-17 15:55 | straddle | 2 | 3 | 60 | 1287000.00 | long | ask | 7642.6200 | 0.8000 | ["7650"] | ["0.1247"] | ["7435.50","7864.50"] | ["XCBO"] | 7650.0000 | 7650.0000 | 29 | 29 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:55:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0d7-ac2b-7810-bda9-26a6eb534a85 | SPX | 2026-09-17 15:28 | straddle | 2 | 1 | 80 | 10688960.00 | long | ask | 7637.3100 | 7.9000 | ["8250"] | ["0.1666"] | ["6913.88","9586.12"] | ["XCBO"] | 8250.0000 | 8250.0000 | 638 | 638 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:28:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa3-e333-79e2-b083-dd7a233b8dc2 | SPX | 2026-09-17 09:52 | straddle | 2 | 1 | 50 | 1838000.00 | long | ask | 7624.8900 | 1.8000 | ["7590"] | ["0.1424"] | ["7222.40","7957.60"] | ["XCBO"] | 7590.0000 | 7590.0000 | 64 | 64 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:52:47Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a575-b2c6-76a0-b774-ca9c5704239c | SPX | 2026-09-15 10:25 | straddle | 2 | 2 | 500 | 8490000.00 | long | ask | 7588.1000 | 5.1000 | ["7700"] | ["0.1208"] | ["7530.20","7869.80"] | ["XCBO"] | 7700.0000 | 7700.0000 | 15 | 15 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:25:54Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a575-b2c6-76a0-b774-c9b57c915372 | SPX | 2026-09-15 10:25 | straddle | 2 | 2 | 500 | 6125000.00 | long | ask | 7588.1000 | 2.0000 | ["7700"] | ["0.1416"] | ["7577.50","7822.50"] | ["XCBO"] | 7700.0000 | 7700.0000 | 3 | 3 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:25:54Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a54d-1456-7650-99f3-f1525dccc3ff | SPX | 2026-09-15 09:41 | straddle | 2 | 1 | 200 | 3351400.00 | long | ask | 7609.4500 | 0.7000 | ["7600"] | ["0.1356"] | ["7432.43","7767.57"] | ["XCBO"] | 7600.0000 | 7600.0000 | 15 | 15 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:41:39Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a54d-1456-7650-99f3-f14a3b3a190b | SPX | 2026-09-15 09:41 | straddle | 2 | 3 | 600 | 10054200.00 | long | ask | 7609.4500 | 0.7000 | ["7600"] | ["0.1356"] | ["7432.43","7767.57"] | ["XCBO"] | 7600.0000 | 7600.0000 | 15 | 15 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:41:39Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a54a-8be6-7ff1-84c0-8e0392981b04 | SPX | 2026-09-15 09:38 | straddle | 2 | 1 | 21 | 93660.00 | long | ask | 7608.1600 | 0.3500 | ["7650"] | ["0.1560"] | ["7605.40","7694.60"] | ["XCBO"] | 7650.0000 | 7650.0000 | 0 | 0 | false | false | false | false | true | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:38:46Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a54a-8be5-7371-b3f2-c916f262374c | SPX | 2026-09-15 09:38 | straddle | 2 | 1 | 21 | 188580.00 | long | ask | 7608.1600 | 1.0000 | ["7650"] | ["0.1522"] | ["7560.20","7739.80"] | ["XCBO"] | 7650.0000 | 7650.0000 | 3 | 3 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:38:46Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a186-1e28-7912-990a-c00fb4a4891e | SPX | 2026-09-14 16:05 | straddle | 2 | 2 | 60 | 2194200.00 | long | ask | 7619.9800 | 1.8000 | ["7675"] | ["0.1404"] | ["7309.30","8040.70"] | ["XCBO"] | 7675.0000 | 7675.0000 | 67 | 67 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T20:05:44Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a056-be18-7b83-a388-1e9a9754b6fc | SPX | 2026-09-14 10:33 | straddle | 2 | 1 | 150 | 14670000.00 | long | ask | 7602.1200 | 3.7000 | ["8000"] | ["0.1603"] | ["7022","8978.00"] | ["XCBO"] | 8000.0000 | 8000.0000 | 368 | 368 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:34:15Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c8d-dcb8-7570-a55b-b04ccc8d18ec | SPX | 2026-09-10 14:21 | straddle | 2 | 1 | 100 | 2726000.00 | long | ask | 7591.7100 | 1.4000 | ["7600"] | ["0.1432"] | ["7327.40","7872.60"] | ["XCBO"] | 7600.0000 | 7600.0000 | 36 | 36 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:21:45Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c8d-dcb8-7570-a55b-b0335f529622 | SPX | 2026-09-10 14:21 | straddle | 2 | 2 | 150 | 4089000.00 | long | ask | 7591.7100 | 1.4000 | ["7600"] | ["0.1432"] | ["7327.40","7872.60"] | ["XCBO"] | 7600.0000 | 7600.0000 | 36 | 36 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:21:45Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c0b-9910-7ad0-b34b-9376a7b74b91 | SPX | 2026-09-10 11:59 | straddle | 2 | 1 | 50 | 2317500.00 | long | ask | 7598.8500 | 1.9000 | ["7700"] | ["0.1466"] | ["7236.50","8163.50"] | ["XCBO"] | 7700.0000 | 7700.0000 | 99 | 99 | false | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:59:33Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a06e0a-9985-79f1-a6db-89ad697ad112 | SPX | 2026-09-04 16:09 | straddle | 2 | 1 | 100 | 4510000.00 | long | ask | 7718.6000 | 2.1000 | ["7785"] | ["0.1367"] | ["7334","8236.00"] | ["XCBO"] | 7785.0000 | 7785.0000 | 105 | 105 | true | false | false | false | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T20:11:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |