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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c58c-4236-77a0-afa2-71b5fe31561b | DRAM | 2026-09-21 15:58 | call_diagonal_spread | 2 | 2 | 142 | 207391.00 | long | ask | 61.6700 | 0.3500 | ["70","100"] | ["0.5986","0.6192"] | [] | ["ARCO","C2OX"] | 70.0000 | 100.0000 | 116 | 487 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:58:18Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 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 |
| 01a0c4a8-b44f-7c70-a29f-ce5e2173592d | DRAM | 2026-09-21 11:49 | call_diagonal_spread | 2 | 1 | 300 | 479400.00 | long | ask | 61.3451 | 1.8000 | ["56","66"] | ["0.6120","0.6000"] | [] | ["XCBO"] | 56.0000 | 66.0000 | 39 | 151 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:49:47Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c441-a197-7d51-a5e8-735df1604b1c | DRAM | 2026-09-21 09:57 | call_diagonal_spread | 2 | 8 | 73 | 113466.00 | long | ask | 61.3700 | 0.9500 | ["65","73"] | ["0.6015","0.6142"] | [] | ["AMXO","ARCO","EMLD","XBOX","XCBO","XISX","XMIO","XPHO"] | 65.0000 | 73.0000 | 88 | 269 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:57:18Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c43f-e05e-70b2-8747-ce8d968b7c4f | DRAM | 2026-09-21 09:55 | call_diagonal_spread | 2 | 7 | 70 | 108916.00 | long | ask | 61.4550 | 0.8500 | ["65","73"] | ["0.5999","0.6119"] | [] | ["AMXO","ARCO","XBOX","XCBO","XISX","XMIO","XPHO"] | 65.0000 | 73.0000 | 88 | 269 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:55:15Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c43f-e05e-70b2-8747-ce737ac0025d | DRAM | 2026-09-21 09:55 | call_diagonal_spread | 2 | 7 | 70 | 108916.00 | long | ask | 61.4500 | 0.8500 | ["65","73"] | ["0.6001","0.6120"] | [] | ["AMXO","ARCO","XBOX","XCBO","XISX","XMIO","XPHO"] | 65.0000 | 73.0000 | 88 | 269 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:55:15Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c43f-e05e-70b2-8747-ce6fc4557055 | DRAM | 2026-09-21 09:55 | call_diagonal_spread | 2 | 8 | 73 | 113595.00 | long | ask | 61.4500 | 0.8500 | ["65","73"] | ["0.6001","0.6121"] | [] | ["AMXO","ARCO","EMLD","XBOX","XCBO","XISX","XMIO","XPHO"] | 65.0000 | 73.0000 | 88 | 269 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:55:15Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c435-ed7e-7271-a1ef-126a5f9efbaa | DRAM | 2026-09-21 09:44 | call_diagonal_spread | 2 | 7 | 70 | 111472.00 | long | ask | 61.9200 | 1.2500 | ["65","73"] | ["0.5978","0.6083"] | [] | ["AMXO","ARCO","XBOX","XCBO","XISX","XMIO","XPHO"] | 65.0000 | 73.0000 | 88 | 269 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:44:30Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c435-e997-7502-b9df-3cc233410542 | DRAM | 2026-09-21 09:44 | call_diagonal_spread | 2 | 8 | 73 | 116230.00 | long | ask | 61.9200 | 1.2500 | ["65","73"] | ["0.5976","0.6083"] | [] | ["AMXO","ARCO","EMLD","XBOX","XCBO","XISX","XMIO","XPHO"] | 65.0000 | 73.0000 | 88 | 269 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:44:30Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c435-e997-7502-b9df-3cb34655f678 | DRAM | 2026-09-21 09:44 | call_diagonal_spread | 2 | 7 | 70 | 111472.00 | long | ask | 61.9200 | 1.2500 | ["65","73"] | ["0.5978","0.6083"] | [] | ["AMXO","ARCO","XBOX","XCBO","XISX","XMIO","XPHO"] | 65.0000 | 73.0000 | 88 | 269 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:44:30Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c435-e997-7502-b9df-3ca1c181dd55 | DRAM | 2026-09-21 09:44 | call_diagonal_spread | 2 | 7 | 70 | 111472.00 | long | ask | 61.9200 | 1.2500 | ["65","73"] | ["0.5978","0.6083"] | [] | ["AMXO","ARCO","XBOX","XCBO","XISX","XMIO","XPHO"] | 65.0000 | 73.0000 | 88 | 269 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:44:30Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c435-e5af-7140-aec3-994fccc59c16 | DRAM | 2026-09-21 09:44 | call_diagonal_spread | 2 | 6 | 64 | 102052.00 | long | ask | 61.9200 | 1.2500 | ["65","73"] | ["0.5986","0.6088"] | [] | ["AMXO","ARCO","XCBO","XISX","XMIO","XPHO"] | 65.0000 | 73.0000 | 88 | 269 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:44:30Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c435-e5af-7140-aec3-99291991bb28 | DRAM | 2026-09-21 09:44 | call_diagonal_spread | 2 | 7 | 70 | 111592.00 | unknown | ask | 61.9207 | 1.2500 | ["65","73"] | ["0.5984","0.6087"] | [] | ["AMXO","ARCO","XBOX","XCBO","XISX","XMIO","XPHO"] | 65.0000 | 73.0000 | 88 | 269 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:44:30Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b4d0-b347-7a13-96f4-04f1ecb51644 | DRAM | 2026-09-18 09:59 | call_diagonal_spread | 2 | 1 | 1000 | 187000.00 | long | bid | 58.3600 | 0.1900 | ["57.5","63.5"] | ["0.6367","0.5724"] | [] | ["XPHO"] | 57.5000 | 63.5000 | 0 | 14 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:59:35Z"} | 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 |
| 01a0afde-2543-7e83-b493-bc936e8a430e | DRAM | 2026-09-17 10:56 | call_diagonal_spread | 2 | 6 | 259 | 101542.00 | long | ask | 57.5650 | 0.0699 | ["58","59"] | ["0.6855","0.5942"] | [] | ["C2OX","MCRY","XCBO","XPHO"] | 58.0000 | 59.0000 | 1 | 29 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:56:05Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a02e-3331-7991-9616-c3c0a27d7cac | DRAM | 2026-09-14 09:49 | call_diagonal_spread | 2 | 1 | 300 | 270600.00 | unknown | — | 55.2178 | 1.0500 | ["56","62"] | ["0.6077","0.6054"] | [] | ["XMIO"] | 56.0000 | 62.0000 | 46 | 95 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:49:50Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a028-91c8-7070-a39b-37e4b95b454a | DRAM | 2026-09-14 09:43 | call_diagonal_spread | 2 | 1 | 526 | 348738.00 | short | ask | 54.4400 | 0.7700 | ["50","122"] | ["0.7915","0.6597"] | [] | ["XCBO"] | 50.0000 | 122.0000 | 4 | 276 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:43:31Z"} | 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 |
| 01a090fb-c5f8-7ab0-ad7c-71c89af923d7 | DRAM | 2026-09-11 11:00 | call_diagonal_spread | 2 | 1 | 37 | 121286.00 | long | bid | 58.7900 | 2.3000 | ["45","50"] | ["0.6535","0.6681"] | [] | ["BATO"] | 45.0000 | 50.0000 | 126 | 189 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:00:17Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090fb-c210-7381-813d-0c691bcfab96 | DRAM | 2026-09-11 11:00 | call_diagonal_spread | 2 | 1 | 83 | 272157.00 | short | ask | 58.8000 | 2.3000 | ["45","50"] | ["0.6713","0.6561"] | [] | ["XCBO"] | 45.0000 | 50.0000 | 126 | 189 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:00:17Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 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 |
| 01a08163-dc49-7fb3-be9b-3c3385865d3c | DRAM | 2026-09-08 10:19 | call_diagonal_spread | 2 | 1 | 190 | 118180.00 | long | ask | 61.0382 | 0.3500 | ["67","75"] | ["0.6670","0.6773"] | [] | ["XISX"] | 67.0000 | 75.0000 | 38 | 73 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:20:14Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0814c-f500-7cf0-9c87-f471c2cf85c4 | DRAM | 2026-09-08 09:54 | call_diagonal_spread | 2 | 1 | 158 | 198290.00 | short | bid | 61.2099 | 0.9500 | ["60","66"] | ["0.6629","0.6451"] | [] | ["XCBO"] | 60.0000 | 66.0000 | 38 | 101 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:55:15Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |