Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c57e-e457-7023-9673-92b488db12ee | SPX | 2026-09-21 15:43 | ratio_risk_reversal | 2 | 1 | 28 | 32060.00 | unknown | ask | 7774.5900 | 0.2500 | ["7735","7785"] | ["0.1178","0.1025"] | ["7723.55","7807.90"] | ["XCBO"] | 7735.0000 | 7785.0000 | 1 | 1 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:44:08Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c57e-e457-7023-9673-9291dc14f207 | SPX | 2026-09-21 15:43 | ratio_risk_reversal | 2 | 1 | 26 | 29770.00 | unknown | ask | 7774.5900 | 0.2538 | ["7735","7785"] | ["0.1178","0.1025"] | ["7723.55","7807.90"] | ["XCBO"] | 7735.0000 | 7785.0000 | 1 | 1 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:44:08Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c57e-82ae-7aa1-a53b-ae7ea8959a09 | SPX | 2026-09-21 15:43 | ratio_risk_reversal | 2 | 1 | 24 | 27480.00 | unknown | ask | 7775.0600 | 0.3000 | ["7735","7785"] | ["0.1186","0.1013"] | ["7723.55","7807.90"] | ["XCBO"] | 7735.0000 | 7785.0000 | 1 | 1 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:43:40Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c56b-c5ce-7f00-bdaf-4caab1c47752 | PANW | 2026-09-21 15:22 | ratio_risk_reversal | 2 | 1 | 9 | 112770.00 | unknown | ask | 369.9750 | 2.5500 | ["460","470"] | ["0.5793","0.5636"] | ["272.05","595.30"] | ["XISX"] | 460.0000 | 470.0000 | 269 | 269 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:22:58Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c56b-c5ce-7f00-bdaf-4c97b5d1b394 | PANW | 2026-09-21 15:22 | ratio_risk_reversal | 2 | 1 | 6 | 75180.00 | unknown | ask | 369.9750 | 2.6000 | ["460","470"] | ["0.5793","0.5636"] | ["272.05","595.30"] | ["XISX"] | 460.0000 | 470.0000 | 269 | 269 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:22:58Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c56b-c5ce-7f00-bdaf-4c8372730363 | PANW | 2026-09-21 15:22 | ratio_risk_reversal | 2 | 1 | 3 | 37590.00 | unknown | ask | 369.9750 | 2.6000 | ["460","470"] | ["0.5793","0.5636"] | ["272.05","595.30"] | ["XISX"] | 460.0000 | 470.0000 | 269 | 269 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:22:58Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c56b-c5ce-7f00-bdaf-4c6849b0f4fe | PANW | 2026-09-21 15:22 | ratio_risk_reversal | 2 | 1 | 3 | 37490.00 | unknown | ask | 369.9750 | 2.0000 | ["460","470"] | ["0.5742","0.5644"] | ["272.55","594.97"] | ["XCBO"] | 460.0000 | 470.0000 | 269 | 269 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:22:58Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c565-d647-7702-9d59-5a5782508dcc | SPX | 2026-09-21 15:16 | ratio_risk_reversal | 2 | 3 | 68 | 80920.00 | unknown | ask | 7773.9800 | 0.2647 | ["7735","7785"] | ["0.1202","0.1047"] | ["7723.10","7808.80"] | ["XCBO"] | 7735.0000 | 7785.0000 | 1 | 1 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:16:32Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c543-e2de-7a03-86b3-7cb1521679d8 | AAPL | 2026-09-21 14:39 | ratio_risk_reversal | 2 | 3 | 24 | 29220.00 | unknown | ask | 338.8680 | 0.2500 | ["340","365"] | ["0.2636","0.2474"] | ["315.65","377.18"] | ["ARCO","C2OX","XISX"] | 340.0000 | 365.0000 | 60 | 60 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:39:33Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c42e-3107-70a2-88a4-4b2278be9eb9 | SPX | 2026-09-21 09:35 | ratio_risk_reversal | 2 | 1 | 128 | 76160.00 | unknown | bid | 7696.3200 | 0.1500 | ["7690","7710"] | ["0.1122","0.0924"] | ["7678.10","7715.95"] | ["XCBO"] | 7690.0000 | 7710.0000 | 0 | 0 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:35:59Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c42d-fe3f-7d93-b7c1-c703da9d34ef | SPX | 2026-09-21 09:35 | ratio_risk_reversal | 2 | 3 | 50 | 30250.00 | unknown | bid | 7695.8500 | 0.1500 | ["7690","7710"] | ["0.1123","0.0941"] | ["7677.90","7716.05"] | ["XCBO"] | 7690.0000 | 7710.0000 | 0 | 0 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:35:45Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b59a-e8e7-7962-9fc0-cc0fe6bdb582 | IWM | 2026-09-18 13:40 | ratio_risk_reversal | 2 | 5 | 44 | 37840.00 | unknown | ask | 283.4050 | 0.1000 | ["265","290"] | ["0.2254","0.1757"] | ["256.40","307.20"] | ["EDGO","XCBO","XPHO"] | 265.0000 | 290.0000 | 91 | 91 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:40:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4fe-7a07-7163-b1dc-faf15bbd8990 | SPX | 2026-09-18 10:49 | ratio_risk_reversal | 2 | 3 | 34 | 28390.00 | unknown | bid | 7624.4200 | 0.2353 | ["7620","7640"] | ["0.1440","0.1346"] | ["7603.30","7648.35"] | ["XCBO"] | 7620.0000 | 7640.0000 | 0 | 0 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:49:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4fe-761f-7dd2-8265-b32d36895a16 | SPX | 2026-09-18 10:49 | ratio_risk_reversal | 2 | 3 | 30 | 25050.00 | unknown | bid | 7624.3400 | 0.2000 | ["7620","7640"] | ["0.1435","0.1350"] | ["7603.30","7648.35"] | ["XCBO"] | 7620.0000 | 7640.0000 | 0 | 0 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:49:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4fe-761f-7dd2-8265-b2e5b337075c | SPX | 2026-09-18 10:49 | ratio_risk_reversal | 2 | 1 | 42 | 35070.00 | unknown | bid | 7624.3400 | 0.2000 | ["7620","7640"] | ["0.1435","0.1350"] | ["7603.30","7648.35"] | ["XCBO"] | 7620.0000 | 7640.0000 | 0 | 0 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:49:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afd5-4f8b-7ab1-a6ff-cadd49ef64b8 | SPX | 2026-09-17 10:46 | ratio_risk_reversal | 2 | 1 | 12 | 68640.00 | unknown | — | 7627.8000 | 0.6000 | ["7550","7700"] | ["0.1327","0.1058"] | [] | ["XCBO"] | 7550.0000 | 7700.0000 | 13 | 13 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:46:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afd5-4f8b-7ab1-a6ff-ca8816ff95f7 | SPX | 2026-09-17 10:46 | ratio_risk_reversal | 2 | 1 | 6 | 34320.00 | unknown | — | 7627.8000 | 0.6000 | ["7550","7700"] | ["0.1327","0.1058"] | [] | ["XCBO"] | 7550.0000 | 7700.0000 | 13 | 13 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:46:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afd5-4f8b-7ab1-a6ff-ca6294dfbac7 | SPX | 2026-09-17 10:46 | ratio_risk_reversal | 2 | 1 | 16 | 91520.00 | unknown | — | 7627.8000 | 0.6000 | ["7550","7700"] | ["0.1327","0.1058"] | [] | ["XCBO"] | 7550.0000 | 7700.0000 | 13 | 13 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:46:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afd5-4f8b-7ab1-a6ff-ca0926add5c4 | SPX | 2026-09-17 10:46 | ratio_risk_reversal | 2 | 1 | 14 | 80080.00 | unknown | — | 7627.8000 | 0.7000 | ["7550","7700"] | ["0.1327","0.1058"] | [] | ["XCBO"] | 7550.0000 | 7700.0000 | 13 | 13 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:46:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abc5-ce43-7630-9b11-85ea95c37e4b | SPX | 2026-09-16 15:50 | ratio_risk_reversal | 2 | 1 | 24 | 78070.00 | unknown | — | 7549.1900 | 0.8000 | ["7525","7600"] | ["0.1818","0.1685"] | [] | ["XCBO"] | 7525.0000 | 7600.0000 | 2 | 2 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:51:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab42-7d13-7e23-bf35-7ffcd0709a1a | QQQ | 2026-09-16 13:27 | ratio_risk_reversal | 2 | 2 | 251 | 61645.00 | unknown | — | 709.6200 | 0.0200 | ["705","713"] | ["0.6200","0.5417"] | [] | ["C2OX"] | 705.0000 | 713.0000 | 0 | 0 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:27:46Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab3a-245b-7180-8cd2-061f5ec14003 | SPY | 2026-09-16 13:18 | ratio_risk_reversal | 2 | 3 | 344 | 49694.00 | unknown | — | 759.8200 | 0.0200 | ["750","770"] | ["0.2449","0.1520"] | [] | ["ARCO","C2OX","EMLD"] | 750.0000 | 770.0000 | 2 | 2 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:19:01Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab3a-245b-7180-8cd2-05fe796694f5 | SPY | 2026-09-16 13:18 | ratio_risk_reversal | 2 | 4 | 220 | 31714.00 | unknown | — | 759.8200 | 0.0200 | ["750","770"] | ["0.2449","0.1520"] | [] | ["C2OX","EMLD","XCBO","XMIO"] | 750.0000 | 770.0000 | 2 | 2 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:19:01Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a669-1375-7b22-8a37-dd9730b7404c | NVDA | 2026-09-15 14:51 | ratio_risk_reversal | 2 | 3 | 27 | 30720.00 | unknown | — | 212.0300 | 0.1000 | ["210","220"] | ["0.3371","0.3318"] | [] | ["AMXO","EDGO","XMIO"] | 210.0000 | 220.0000 | 31 | 31 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:52:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a60a-4dbe-77e3-bce5-1f659c7bcc75 | XOM | 2026-09-15 13:08 | ratio_risk_reversal | 2 | 1 | 99 | 206415.00 | unknown | — | 169.1100 | 0.1000 | ["160","180"] | ["0.3241","0.2682"] | [] | ["ARCO"] | 160.0000 | 180.0000 | 275 | 275 | false | true | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:08:37Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a60a-4dbe-77e3-bce5-1f457f836baa | XOM | 2026-09-15 13:08 | ratio_risk_reversal | 2 | 3 | 21 | 43700.00 | unknown | — | 169.1100 | 0.1071 | ["160","180"] | ["0.3237","0.2677"] | [] | ["XCBO"] | 160.0000 | 180.0000 | 275 | 275 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:08:37Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5bc-58b6-77c2-a4d4-2f0935ae93e8 | XOM | 2026-09-15 11:42 | ratio_risk_reversal | 2 | 1 | 300 | 624000.00 | long | ask | 169.1300 | 2.3500 | ["160","180"] | ["0.3214","0.2706"] | ["157.40"] | ["XCBO"] | 160.0000 | 180.0000 | 275 | 275 | false | true | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:43:20Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a57c-a806-7752-9163-31ab2efa3d27 | QQQ | 2026-09-15 10:33 | ratio_risk_reversal | 2 | 1 | 54 | 35235.00 | unknown | — | 706.5800 | 0.0900 | ["700","703"] | ["0.2660","0.2587"] | [] | ["ARCO"] | 700.0000 | 703.0000 | 2 | 2 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:33:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a543-e8ae-78a1-b017-a9b1a790109e | SPX | 2026-09-15 09:31 | ratio_risk_reversal | 2 | 4 | 51 | 27030.00 | unknown | — | 7607.4200 | 0.3853 | ["7400","7800"] | ["0.2334","0.1331"] | [] | ["XCBO"] | 7400.0000 | 7800.0000 | 3 | 3 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:31:32Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0914f-c1f9-72b1-bffa-c9c7844bdead | NVDA | 2026-09-11 12:31 | ratio_risk_reversal | 2 | 1 | 50 | 26100.00 | long | ask | 219.1200 | 0.0700 | ["180","220"] | ["0.4246","0.3333"] | ["227.56"] | ["ARCO"] | 180.0000 | 220.0000 | 35 | 35 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:31:59Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0914b-12c0-7a60-b0bf-7a1704522fcc | NVDA | 2026-09-11 12:26 | ratio_risk_reversal | 2 | 3 | 48 | 25056.00 | long | ask | 219.1600 | 0.0600 | ["180","220"] | ["0.4249","0.3325"] | ["227.56"] | ["ARCO","C2OX"] | 180.0000 | 220.0000 | 35 | 35 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:27:08Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08bdc-3058-7f61-b971-319f7cc02a18 | SMH | 2026-09-10 11:07 | ratio_risk_reversal | 2 | 1 | 6 | 36585.00 | long | ask | 564.5400 | 1.1000 | ["485","630"] | ["0.3967","0.3696"] | ["478.88"] | ["ARCO"] | 485.0000 | 630.0000 | 280 | 280 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:07:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a081a4-15b0-78f0-922f-ed4740e4768a | FLEX | 2026-09-08 11:30 | ratio_risk_reversal | 2 | 1 | 216 | 104220.00 | long | bid | 113.2200 | 1.5500 | ["115","135"] | ["0.5886","0.6054"] | ["135.18"] | ["XCBO"] | 115.0000 | 135.0000 | 38 | 38 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:30:32Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |