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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c57d-b3a7-7431-bf4b-91fd827ca2fd | DRAM | 2026-09-21 15:42 | call_diagonal_spread | 2 | 3 | 116 | 428272.00 | short | ask | 61.7500 | 1.3500 | ["45","55"] | ["0.6091","0.6080"] | [] | ["ARCO","EMLD","SPHR"] | 45.0000 | 55.0000 | 179 | 269 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:42:46Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c57d-b3a7-7431-bf4b-91e65c8606b0 | DRAM | 2026-09-21 15:42 | call_diagonal_spread | 2 | 3 | 99 | 365706.00 | short | ask | 61.7500 | 1.3500 | ["45","55"] | ["0.6101","0.6085"] | [] | ["BATO","C2OX","EDGO"] | 45.0000 | 55.0000 | 179 | 269 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:42:46Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c570-f9d7-7602-87ee-f709fffa9e8d | DRAM | 2026-09-21 15:28 | put_calendar | 2 | 1 | 528 | 216480.00 | short | bid | 61.6550 | 0.0300 | ["60"] | ["0.5934"] | [] | ["XISX"] | 60.0000 | 60.0000 | 11 | 18 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:28:50Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b615-a2df-7ee0-ac83-929949603702 | DRAM | 2026-09-18 15:54 | straddle | 2 | 6 | 59 | 132986.00 | short | bid | 59.3450 | 1.5000 | ["65"] | ["0.6063"] | ["42.46","87.54"] | ["AMXO","EMLD","XBOX","XCBO","XMIO","XPHO"] | 65.0000 | 65.0000 | 210 | 210 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:54:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b58d-aa47-7823-a6be-afeeb636e85d | DRAM | 2026-09-18 13:25 | call_vertical_spread | 2 | 4 | 45 | 100921.00 | short | bid | 58.6605 | 1.3500 | ["50","52"] | ["0.5817","0.5783"] | ["51.31"] | ["ARCO","EMLD","SPHR","XPHO"] | 50.0000 | 52.0000 | 91 | 91 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:26:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b52b-9cb7-7110-b428-5700107c3cac | DRAM | 2026-09-18 11:38 | call_vertical_spread | 2 | 3 | 300 | 105300.00 | short | bid | 58.3250 | 0.0867 | ["62","66"] | ["0.5654","0.5699"] | ["63.01"] | ["EMLD","XMIO","XPHO"] | 62.0000 | 66.0000 | 28 | 28 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:39:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b51c-c007-7f51-aa5d-d45dfb1ee34e | DRAM | 2026-09-18 11:22 | put_diagonal_spread | 2 | 1 | 262 | 122878.00 | short | bid | 58.2100 | 0.1300 | ["58.5","59"] | ["0.5618","0.5039"] | [] | ["BATO"] | 58.5000 | 59.0000 | 7 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:22:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ea-1b2f-7f73-a5f8-684a0aa295de | DRAM | 2026-09-18 10:27 | call_calendar | 2 | 1 | 40 | 107560.00 | short | ask | 58.2620 | 0.8500 | ["45"] | ["3.3155"] | [] | ["BATO"] | 45.0000 | 45.0000 | 0 | 28 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:27:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afea-6213-7c10-86d8-f279f3fb8f21 | DRAM | 2026-09-17 11:09 | call_diagonal_spread | 2 | 1 | 50 | 145550.00 | short | ask | 57.7350 | 0.9000 | ["40","50"] | ["3.7411","0.6077"] | [] | ["XCBO"] | 40.0000 | 50.0000 | 1 | 92 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:09:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a042-a1a8-72c1-96f0-982de32b21dd | DRAM | 2026-09-14 10:11 | call_vertical_spread | 2 | 1 | 150 | 218100.00 | short | bid | 55.2098 | 0.5500 | ["55","60"] | ["0.6169","0.6149"] | ["57"] | ["XISX"] | 55.0000 | 60.0000 | 123 | 123 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:11:55Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09183-d9e8-7d51-b5a0-5901746e5dd7 | DRAM | 2026-09-11 13:28 | call_diagonal_spread | 2 | 1 | 50 | 103300.00 | short | ask | 59.3400 | 0.7500 | ["50","60"] | ["0.6298","0.6206"] | [] | ["XISX"] | 50.0000 | 60.0000 | 70 | 126 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:29:15Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cbf-2db8-7f01-954f-b58534a4dbcf | DRAM | 2026-09-10 15:15 | call_vertical_spread | 2 | 5 | 170 | 201358.00 | short | bid | 58.5050 | 0.5500 | ["65","70"] | ["0.6384","0.6436"] | ["66.40"] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 65.0000 | 70.0000 | 127 | 127 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:15:59Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0870d-2fa0-7da1-b05b-10f882e61462 | DRAM | 2026-09-09 12:43 | put_calendar | 2 | 1 | 80 | 184560.00 | short | bid | 61.5500 | 0.6500 | ["70"] | ["0.6795"] | [] | ["XMIO"] | 70.0000 | 70.0000 | 37 | 72 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:43:08Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086ce-caf9-7663-8be9-160d2fd07cfd | DRAM | 2026-09-09 11:34 | straddle | 2 | 2 | 42 | 119616.00 | short | bid | 61.6800 | 0.7500 | ["65"] | ["0.6616"] | ["36.52","93.48"] | ["MCRY","SPHR"] | 65.0000 | 65.0000 | 281 | 281 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:35:05Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086cd-fbf0-70a0-a68e-190993bdd057 | DRAM | 2026-09-09 11:33 | straddle | 2 | 1 | 48 | 136704.00 | short | bid | 61.6900 | 0.6500 | ["65"] | ["0.6615"] | ["36.52","93.48"] | ["SPHR"] | 65.0000 | 65.0000 | 281 | 281 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:34:35Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086c0-6378-7672-bf2a-4ad3234cc5ca | DRAM | 2026-09-09 11:19 | call_diagonal_spread | 2 | 1 | 100 | 129700.00 | short | bid | 61.8200 | 0.7500 | ["60","68"] | ["0.6902","0.6730"] | [] | ["ARCO"] | 60.0000 | 68.0000 | 37 | 100 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:19:20Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08295-bcf8-7303-83fd-61883f9232f6 | DRAM | 2026-09-08 15:54 | call_vertical_spread | 2 | 3 | 32 | 140128.00 | short | bid | 61.0500 | 3.9000 | ["60","87"] | ["0.6673","0.6644"] | ["66.95"] | ["XISX"] | 60.0000 | 87.0000 | 829 | 829 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:54:20Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08211-17f0-7fb3-93d6-e1af9de50acc | DRAM | 2026-09-08 13:29 | call_vertical_spread | 2 | 2 | 166 | 331336.00 | short | bid | 61.7300 | 0.2000 | ["47","58"] | ["0.8797","0.7082"] | ["56.78"] | ["XMIO"] | 47.0000 | 58.0000 | 10 | 10 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:29:38Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0819d-8600-7751-9278-5dca00ae765a | DRAM | 2026-09-08 11:22 | call_calendar | 2 | 1 | 101 | 165236.00 | short | bid | 61.5975 | 1.1000 | ["55"] | ["0.7210"] | [] | ["XMIO"] | 55.0000 | 55.0000 | 17 | 24 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:23:04Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08144-cf10-7a30-89b8-a408a4e3b8f2 | DRAM | 2026-09-08 09:46 | put_calendar | 2 | 1 | 232 | 115304.00 | short | bid | 61.1400 | 0.3800 | ["60"] | ["0.6665"] | [] | ["XMIO"] | 60.0000 | 60.0000 | 10 | 17 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:46:19Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08144-55f8-7571-a38d-6e3655530a8b | DRAM | 2026-09-08 09:45 | put_calendar | 2 | 1 | 250 | 124250.00 | short | ask | 61.0825 | 0.2500 | ["60"] | ["0.6612"] | [] | ["XMIO"] | 60.0000 | 60.0000 | 10 | 17 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:45:38Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08142-1ba8-7b53-b095-c2140f890d97 | DRAM | 2026-09-08 09:43 | strangle | 2 | 4 | 1027 | 306723.00 | short | bid | 61.0900 | 0.0600 | ["55","62"] | ["0.7054","0.6700"] | ["52.01","64.99"] | ["AMXO","XCBO","XISX","XPHO"] | 55.0000 | 62.0000 | 10 | 10 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:43:12Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |