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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06dcd-0bb5-7a50-93f1-c0f2f12d59d1 | GDX | 2026-09-04 15:02 | put_vertical_spread | 2 | 1 | 42 | 135702.00 | long | ask | 99.1950 | 0.8000 | ["102","104"] | ["0.4534","0.4568"] | ["102.75"] | ["AMXO"] | 102.0000 | 104.0000 | 286 | 286 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:02:41Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a086d6-ae80-7300-90d5-d100aa3fb205 | GDX | 2026-09-09 11:43 | put_vertical_spread | 2 | 1 | 1500 | 180000.00 | unknown | — | 99.4700 | 0.2000 | ["75","85"] | ["0.5018","0.4724"] | [] | ["XISX"] | 75.0000 | 85.0000 | 37 | 37 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:43:55Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0876a-2868-74f2-80e4-a3fba1026c29 | GDX | 2026-09-09 14:24 | put_vertical_spread | 2 | 1 | 1500 | 714000.00 | unknown | — | 100.0900 | 0.3500 | ["98","100"] | ["0.4629","0.4696"] | [] | ["SPHR"] | 98.0000 | 100.0000 | 9 | 9 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:25:12Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08c98-cd80-7ba0-bc65-fe95183eea5c | GDX | 2026-09-10 14:33 | put_vertical_spread | 2 | 1 | 146 | 321200.00 | unknown | — | 96.2800 | 0.7000 | ["105","110"] | ["1.0580","1.3704"] | [] | ["XBOX"] | 105.0000 | 110.0000 | 1 | 1 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:33:41Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a091f5-b658-7100-b1f0-6f9149bb22e2 | GDX | 2026-09-11 15:33 | put_vertical_spread | 2 | 1 | 300 | 169500.00 | short | bid | 96.6250 | 0.2000 | ["96","99"] | ["0.4364","0.4313"] | ["97.33"] | ["XCBO"] | 96.0000 | 99.0000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:33:27Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a137-dee8-7760-b6b1-382d3acfdfd9 | GDX | 2026-09-14 14:39 | put_vertical_spread | 2 | 1 | 500 | 128500.00 | long | ask | 94.6100 | 0.2800 | ["40","80"] | ["0.6792","0.4543"] | ["77.51"] | ["XMIO"] | 40.0000 | 80.0000 | 95 | 95 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:40:33Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a16a-5cb0-7d11-b57e-834c2583180a | GDX | 2026-09-14 15:34 | put_vertical_spread | 2 | 1 | 1672 | 844360.00 | short | bid | 94.2300 | 0.4300 | ["93","97"] | ["0.5147","0.4885"] | ["94.83"] | ["SPHR"] | 93.0000 | 97.0000 | 4 | 4 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:35:26Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a552-967e-7b93-8545-044f3aeb484f | GDX | 2026-09-15 09:47 | put_vertical_spread | 2 | 1 | 397 | 167186.00 | unknown | — | 94.0100 | 0.3300 | ["60","85"] | ["0.4997","0.4421"] | [] | ["XISX"] | 60.0000 | 85.0000 | 94 | 94 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:47:26Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a616-09a6-7f31-93ec-8c4cf00dfe95 | GDX | 2026-09-15 13:20 | put_vertical_spread | 2 | 5 | 49 | 121479.00 | long | ask | 93.4700 | 0.5000 | ["100","105"] | ["0.4502","0.4568"] | ["101.41"] | ["ARCO","MCRY","XBOX","XPHO"] | 100.0000 | 105.0000 | 66 | 66 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:21:45Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a616-155e-7cf2-81d1-6baa89678cbb | GDX | 2026-09-15 13:20 | put_vertical_spread | 2 | 2 | 42 | 104038.00 | long | ask | 93.4700 | 0.5000 | ["100","105"] | ["0.4495","0.4561"] | ["101.41"] | ["EDGO","MCRY"] | 100.0000 | 105.0000 | 66 | 66 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:21:45Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0abaf-b9eb-7531-b9ff-71dc83b0fe5e | GDX | 2026-09-16 15:26 | put_vertical_spread | 2 | 1 | 1320 | 546480.00 | short | bid | 91.4200 | 0.3600 | ["91","93"] | ["0.6465","0.6312"] | ["91.92"] | ["AMXO"] | 91.0000 | 93.0000 | 2 | 2 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:26:54Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0af90-f773-7f11-8b8f-611f58c15ba1 | GDX | 2026-09-17 09:31 | put_vertical_spread | 2 | 1 | 394 | 243492.00 | short | bid | 95.2100 | 0.3300 | ["89","94"] | ["0.4538","0.4479"] | ["92.10"] | ["XPHO"] | 89.0000 | 94.0000 | 29 | 29 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:31:48Z"} | 2026-09-17 | 2026-09-17 17:27 | 2026-09-17 17:27 |
| 01a0af9f-d03b-7e81-98cd-f158fedd0581 | GDX | 2026-09-17 09:47 | put_vertical_spread | 2 | 2 | 80 | 851120.00 | unknown | — | 95.1968 | 3.4125 | ["124","170"] | ["0.5268","0.7747"] | [] | ["XBOX","XMIO"] | 124.0000 | 170.0000 | 120 | 120 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:48:13Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0bc-5bfb-79c3-b8cb-6e25be978011 | GDX | 2026-09-17 14:58 | put_vertical_spread | 2 | 1 | 220 | 391600.00 | unknown | — | 95.6650 | 0.9500 | ["104","105"] | ["0.9095","0.9930"] | [] | ["XBOX"] | 104.0000 | 105.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:59:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b504-61c0-7542-a176-ff4c2a649d8f | GDX | 2026-09-18 10:55 | put_vertical_spread | 2 | 1 | 175 | 115500.00 | short | bid | 94.7200 | 0.1700 | ["90","95"] | ["0.4183","0.4192"] | ["92.84"] | ["AMXO"] | 90.0000 | 95.0000 | 28 | 28 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:56:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b615-b280-7d10-b837-ffa0fe508744 | GDX | 2026-09-18 15:54 | put_vertical_spread | 2 | 1 | 20 | 116200.00 | short | bid | 95.3650 | 0.7000 | ["115","130"] | ["0.4777","0.5176"] | ["117"] | ["C2OX"] | 115.0000 | 130.0000 | 119 | 119 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:54:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b615-b280-7d10-b837-ff9bf04a1db1 | GDX | 2026-09-18 15:54 | put_vertical_spread | 2 | 3 | 60 | 350000.00 | unknown | ask | 95.3650 | 0.7333 | ["115","130"] | ["0.4838","0.5252"] | ["93.33"] | ["ARCO","XCBO"] | 115.0000 | 130.0000 | 119 | 119 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:54:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b615-b280-7d10-b837-ff835304cb3c | GDX | 2026-09-18 15:54 | put_vertical_spread | 2 | 1 | 20 | 116200.00 | short | bid | 95.3650 | 0.6000 | ["115","130"] | ["0.4777","0.5176"] | ["117"] | ["XISX"] | 115.0000 | 130.0000 | 119 | 119 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:54:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b61a-7157-7bb0-adf8-e7ab0fe7f3e6 | GDX | 2026-09-18 15:59 | put_vertical_spread | 2 | 3 | 60 | 348880.00 | short | bid | 95.5000 | 1.1500 | ["115","130"] | ["0.4838","0.5262"] | ["117"] | ["C2OX","XPHO"] | 115.0000 | 130.0000 | 119 | 119 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b61a-7157-7bb0-adf8-e79f2697f558 | GDX | 2026-09-18 15:59 | put_vertical_spread | 2 | 1 | 20 | 115800.00 | unknown | bid | 95.5000 | 1.2000 | ["115","130"] | ["0.4774","0.5182"] | ["93.55"] | ["XISX"] | 115.0000 | 130.0000 | 119 | 119 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b61a-7157-7bb0-adf8-e78e70d87b1c | GDX | 2026-09-18 15:59 | put_vertical_spread | 2 | 1 | 20 | 116000.00 | unknown | — | 95.5000 | 1.2000 | ["115","130"] | ["0.4800","0.5214"] | [] | ["XPHO"] | 115.0000 | 130.0000 | 119 | 119 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |