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
active:ticker = RSP×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c437-cdf7-74e0-bbb8-8ef7ae203fd4 | RSP | 2026-09-21 09:46 | put_vertical_spread | 2 | 3 | 275 | 153317.00 | short | bid | 211.7100 | 2.2000 | ["200","210"] | ["0.1597","0.1341"] | ["207.94"] | ["BATO","C2OX","EDGO"] | 200.0000 | 210.0000 | 88 | 88 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:46:36Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c437-cdf7-74e0-bbb8-8ee0a58a83f2 | RSP | 2026-09-21 09:46 | put_vertical_spread | 2 | 4 | 325 | 182000.00 | short | bid | 211.7100 | 2.2000 | ["200","210"] | ["0.1602","0.1344"] | ["207.94"] | ["ARCO","EMLD","SPHR","XPHO"] | 200.0000 | 210.0000 | 88 | 88 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:46:36Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b55e-9f4f-7ae1-847c-32763c051d94 | RSP | 2026-09-18 12:34 | call_diagonal_spread | 2 | 1 | 35 | 353115.00 | short | bid | 212.2250 | 8.2000 | ["160","165"] | ["0.4465","0.6974"] | [] | ["XPHO"] | 160.0000 | 165.0000 | 28 | 91 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:34:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b530-3867-79b1-b0ce-3fb172b7bb91 | RSP | 2026-09-18 11:43 | put_vertical_spread | 2 | 2 | 3750 | 4338750.00 | unknown | ask | 212.2700 | 4.1000 | ["205","215"] | ["0.1753","0.1550"] | ["204.22"] | ["ARCO"] | 205.0000 | 215.0000 | 119 | 119 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:43:55Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0d4-50cb-7f30-8c11-44c3834197cc | RSP | 2026-09-17 15:24 | straddle | 2 | 1 | 1000 | 153000.00 | unknown | — | 213.5450 | 0.4000 | ["215"] | ["0.0966"] | [] | ["AMXO"] | 215.0000 | 215.0000 | 1 | 1 | false | false | false | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:25:16Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a08cb1-9928-7142-9345-70c0515426c1 | RSP | 2026-09-10 15:00 | other | 3 | 1 | 1508 | 1725364.00 | unknown | — | 213.0900 | 3.8000 | ["217.5","220"] | ["0.2714","0.1624"] | [] | ["XBOX"] | 217.5000 | 220.0000 | 1 | 8 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:00:58Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c83-7c78-7722-9d84-23e30be9ce7c | RSP | 2026-09-10 14:10 | other | 4 | 3 | 471 | 231469.00 | unknown | — | 213.1543 | 1.2000 | ["200","210","215"] | ["0.2237","0.1591","0.1240"] | [] | ["EDGO","XCBO","XISX"] | 200.0000 | 215.0000 | 8 | 22 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:10:23Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c83-7891-7132-97d8-57aba2a2e77d | RSP | 2026-09-10 14:10 | other | 4 | 7 | 287 | 140867.00 | unknown | — | 213.1543 | 1.2000 | ["200","210","215"] | ["0.2289","0.1572","0.1258"] | [] | ["AMXO","ARCO","EMLD","MCRY","XBOX","XMIO","XPHO"] | 200.0000 | 215.0000 | 8 | 22 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:10:23Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b94-4a19-7590-9921-a6709be81768 | RSP | 2026-09-10 09:49 | put_vertical_spread | 2 | 1 | 1100 | 690800.00 | short | bid | 213.8800 | 0.7500 | ["215","217.5"] | ["0.1422","0.1363"] | ["215.84"] | ["XMIO"] | 215.0000 | 217.5000 | 8 | 8 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:49:15Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0825a-ee48-72f3-bbe7-1117630b1d78 | RSP | 2026-09-08 14:49 | call_diagonal_spread | 2 | 1 | 20 | 159580.00 | long | bid | 217.1900 | 5.7000 | ["175","185"] | ["0.7258","0.1784"] | [] | ["XCBO"] | 175.0000 | 185.0000 | 10 | 192 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:50:24Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08259-7361-7431-b980-55e17432014c | RSP | 2026-09-08 14:48 | call_diagonal_spread | 2 | 1 | 18 | 126414.00 | long | bid | 217.3300 | 6.7000 | ["180","190"] | ["0.5956","0.1655"] | [] | ["XCBO"] | 180.0000 | 190.0000 | 10 | 192 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:48:26Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081c8-d3f0-7511-ba1b-8fbb48edf4d2 | RSP | 2026-09-08 12:10 | other | 2 | 1 | 22 | 186890.00 | unknown | — | 217.3600 | 6.5000 | ["175","200"] | ["0.2605","0.1403"] | [] | ["XISX"] | 175.0000 | 200.0000 | 129 | 829 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:10:48Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081c7-5908-7230-9adb-77ada417dc92 | RSP | 2026-09-08 12:08 | other | 2 | 1 | 80 | 619600.00 | unknown | — | 217.4050 | 9.1000 | ["180","205"] | ["0.1359","0.1419"] | [] | ["XMIO"] | 180.0000 | 205.0000 | 129 | 829 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:08:40Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |