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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b60f-51af-7b72-aefc-c7c2273fcc85 | SPX | 2026-09-18 15:47 | risk_reversal | 2 | 1 | 44 | 80080.00 | short | ask | 7645.4200 | 0.4000 | ["7350","7825"] | ["0.1622","0.0897"] | ["7346"] | ["XCBO"] | 7350.0000 | 7825.0000 | 14 | 14 | false | true | false | true | true | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:47:39Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b607-fac7-7b33-9f94-6f6da0340416 | GFL | 2026-09-18 15:39 | risk_reversal | 3 | 2 | 650 | 245050.00 | long | ask | 42.5300 | 3.3000 | ["37.5","45","50"] | ["0.4751","0.4321","0.3379"] | ["45.55"] | ["XCBO"] | 37.5000 | 50.0000 | 63 | 63 | false | true | false | true | true | mfsl | 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 |
| 01a0b525-014f-7203-9507-34e5ba286ea0 | SPX | 2026-09-18 11:31 | risk_reversal | 2 | 1 | 40 | 1014800.00 | long | ask | 7626.3200 | 1.3000 | ["7400","7850"] | ["0.1655","0.1257"] | ["7856.60"] | ["XCBO"] | 7400.0000 | 7850.0000 | 91 | 91 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:31:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b51b-5c8f-74f2-a3d7-e8a4a031220f | SPX | 2026-09-18 11:21 | risk_reversal | 2 | 1 | 20 | 34640.00 | short | ask | 7628.9100 | 0.6000 | ["7000","8000"] | ["0.2139","0.0991"] | ["6992.18"] | ["XCBO"] | 7000.0000 | 8000.0000 | 28 | 28 | false | true | false | true | true | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:21:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b51b-5c8f-74f2-a3d7-e87bf61d95fc | SPX | 2026-09-18 11:21 | risk_reversal | 2 | 1 | 101 | 174932.00 | short | ask | 7628.9100 | 0.6000 | ["7000","8000"] | ["0.2139","0.0991"] | ["6992.18"] | ["XCBO"] | 7000.0000 | 8000.0000 | 28 | 28 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:21:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4b9-81c7-7721-829e-089222362850 | SPX | 2026-09-18 09:34 | risk_reversal | 2 | 2 | 650 | 1430000.00 | long | ask | 7644.6500 | 0.3000 | ["7635","7645"] | ["0.1574","0.1623"] | ["7649.70"] | ["XCBO"] | 7635.0000 | 7645.0000 | 0 | 0 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:34:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afe8-27c3-7e73-bec8-54c102dab5e0 | SPX | 2026-09-17 11:07 | risk_reversal | 2 | 1 | 300 | 622800.00 | short | ask | 7617.2500 | 0.7000 | ["7000","8000"] | ["0.2159","0.1045"] | ["6991"] | ["XCBO"] | 7000.0000 | 8000.0000 | 29 | 29 | false | true | 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 |
| 01a0afb9-5f33-7fa3-b32b-02a6265f65c2 | VIAV | 2026-09-17 10:15 | risk_reversal | 2 | 3 | 215 | 297560.00 | short | ask | 35.0950 | 2.2500 | ["49","60"] | ["4.9532","4.1063"] | ["35.20"] | ["XCBO"] | 49.0000 | 60.0000 | 1 | 1 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:15:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb6-1b43-7960-8549-4599affc8316 | VIAV | 2026-09-17 10:12 | risk_reversal | 2 | 2 | 215 | 238650.00 | short | ask | 34.9250 | 2.2000 | ["46","65"] | ["3.5614","5.2042"] | ["35"] | ["XCBO"] | 46.0000 | 65.0000 | 1 | 1 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:12:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb5-6af3-7eb1-a77c-7205bd481601 | SPX | 2026-09-16 15:33 | risk_reversal | 2 | 2 | 250 | 5527500.00 | short | ask | 7531.9900 | 2.8000 | ["7525","7575"] | ["0.1471","0.1376"] | ["7523.16"] | ["XCBO"] | 7525.0000 | 7575.0000 | 30 | 30 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:33:17Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab5a-ac7b-7ba1-92d2-2ce8a201ff75 | SPX | 2026-09-16 13:53 | risk_reversal | 2 | 1 | 60 | 32400.00 | short | ask | 7608.8500 | 0.1500 | ["7535","7720"] | ["0.5766","0.4993"] | ["7531"] | ["XCBO"] | 7535.0000 | 7720.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 |
| 01a0aa95-aecb-7d72-b009-fc9116d9ea63 | SPX | 2026-09-16 10:18 | risk_reversal | 2 | 1 | 5 | 34650.00 | long | ask | 7605.9500 | 0.8000 | ["7540","7590"] | ["0.1926","0.1893"] | ["7624.40"] | ["XCBO"] | 7540.0000 | 7590.0000 | 2 | 2 | false | false | false | true | true | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:19:06Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5c3-6566-75b2-ae8e-d5a42f23b8ab | SPX | 2026-09-15 11:50 | risk_reversal | 2 | 1 | 50 | 135500.00 | short | ask | 7585.5000 | 0.9000 | ["7500","7700"] | ["0.1960","0.1437"] | ["7485.90"] | ["XCBO"] | 7500.0000 | 7700.0000 | 3 | 3 | false | true | false | true | true | mfsl | market_whale | 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 |
| 01a091f6-8178-75a0-b6c7-734ff22db53f | SPX | 2026-09-11 15:34 | risk_reversal | 2 | 1 | 70 | 1922200.00 | long | ask | 7662.6300 | 2.1000 | ["6400","7400"] | ["0.4931","0.1757"] | ["7673.40"] | ["XCBO"] | 6400.0000 | 7400.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:34:15Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091f6-8178-75a0-b6c7-726c5a3bf291 | SPX | 2026-09-11 15:34 | risk_reversal | 2 | 1 | 70 | 1930250.00 | long | ask | 7662.6300 | 21.1000 | ["6400","7400"] | ["0.5050","0.1825"] | ["7674.25"] | ["XCBO"] | 6400.0000 | 7400.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:34:15Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091f0-d070-7a03-b1ec-9fc11c81e0cd | SPX | 2026-09-11 15:27 | risk_reversal | 2 | 1 | 15 | 2113950.00 | long | ask | 7664.8300 | 8.0000 | ["6000","7000"] | ["0.2515","0.1893"] | ["8139.28"] | ["XCBO"] | 6000.0000 | 7000.0000 | 462 | 462 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:28:07Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c76-0ef8-70a0-8663-6fcaf3ad32fb | SPX | 2026-09-10 13:55 | risk_reversal | 2 | 1 | 150 | 7995000.00 | long | ask | 7595.8700 | 1.5000 | ["7000","8000"] | ["0.2043","0.1495"] | ["8125.00"] | ["XCBO"] | 7000.0000 | 8000.0000 | 280 | 280 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:56:19Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bbb-13c8-73a1-a42d-ca0a926a9423 | SPX | 2026-09-10 10:31 | risk_reversal | 2 | 2 | 39 | 2126280.00 | short | ask | 7601.5500 | 3.2000 | ["7350","8550"] | ["0.1947","0.1398"] | ["7235.50"] | ["XCBO"] | 7350.0000 | 8550.0000 | 372 | 372 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:31:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0879c-6b98-7981-8eb7-78edada02a08 | SPX | 2026-09-09 15:19 | risk_reversal | 2 | 1 | 25 | 89250.00 | short | ask | 7647.5200 | 0.7000 | ["7000","8000"] | ["0.2152","0.1080"] | ["6994.70"] | ["XCBO"] | 7000.0000 | 8000.0000 | 37 | 37 | false | true | false | true | true | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:19:48Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0879c-67b0-7c20-96fc-85feee585ab3 | SPX | 2026-09-09 15:19 | risk_reversal | 2 | 1 | 23 | 82110.00 | short | ask | 7647.5200 | 0.7000 | ["7000","8000"] | ["0.2152","0.1080"] | ["6994.70"] | ["XCBO"] | 7000.0000 | 8000.0000 | 37 | 37 | false | true | false | true | true | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:19:48Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08154-b178-77f3-9833-7277d8fb7788 | SPX | 2026-09-08 10:03 | risk_reversal | 2 | 2 | 70 | 469000.00 | short | ask | 7684.0600 | 1.1000 | ["7600","7750"] | ["0.1401","0.1126"] | ["7599"] | ["XCBO"] | 7600.0000 | 7750.0000 | 10 | 10 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:03:24Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08154-b178-77f3-9833-71e13a961287 | SPX | 2026-09-08 10:03 | risk_reversal | 2 | 1 | 40 | 499000.00 | short | ask | 7684.0600 | 0.9000 | ["7600","7775"] | ["0.1401","0.1147"] | ["7593.75"] | ["XCBO"] | 7600.0000 | 7775.0000 | 24 | 24 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:03:24Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08154-b178-77f3-9833-71d84d083169 | SPX | 2026-09-08 10:03 | risk_reversal | 2 | 1 | 40 | 499000.00 | short | ask | 7684.0600 | 1.0000 | ["7600","7775"] | ["0.1401","0.1147"] | ["7593.75"] | ["XCBO"] | 7600.0000 | 7775.0000 | 24 | 24 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:03:24Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06e04-a9fd-7ba1-b046-41b963d0794f | SPX | 2026-09-04 16:03 | risk_reversal | 2 | 1 | 1500 | 69142500.00 | long | ask | 7718.4200 | 0.8000 | ["7700","7720"] | ["0.1479","0.1352"] | ["7794.75"] | ["XCBO"] | 7700.0000 | 7720.0000 | 105 | 105 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T20:05:00Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |