Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06dba-e72d-7210-8d5d-8c4f987cca51 | DRAM | 2026-09-04 14:42 | other | 3 | 2 | 4000 | 741000.00 | unknown | — | 59.0850 | 0.0405 | ["59","60","61"] | ["0.5413","0.5358","0.5406"] | [] | ["AMXO"] | 59.0000 | 61.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:43:03Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dc5-5325-7010-80ab-0c57a759c62b | DRAM | 2026-09-04 14:54 | call_vertical_spread | 2 | 1 | 2500 | 1465000.00 | unknown | — | 59.1300 | 0.9100 | ["75","81"] | ["0.6427","0.6356"] | [] | ["SPHR"] | 75.0000 | 81.0000 | 105 | 105 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:54:05Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a0813e-79f8-7f31-8b55-3ab0dfe38de0 | DRAM | 2026-09-08 09:39 | call_vertical_spread | 2 | 1 | 1980 | 696960.00 | unknown | — | 61.6100 | 0.0600 | ["61","62"] | ["0.7474","0.7648"] | [] | ["AMXO"] | 61.0000 | 62.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:39:22Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08179-6019-7c82-a543-8dc2fe9dd17e | DRAM | 2026-09-08 10:43 | strangle | 2 | 1 | 2000 | 2550000.00 | long | ask | 61.4550 | 0.4500 | ["60","70"] | ["0.6513","0.6532"] | ["47.25","82.75"] | ["AMXO"] | 60.0000 | 70.0000 | 101 | 101 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:43:56Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0818c-fba0-7362-8b48-20b3e21827c4 | DRAM | 2026-09-08 11:04 | strangle | 2 | 2 | 500 | 637500.00 | long | ask | 61.3900 | 0.4000 | ["60","70"] | ["0.6493","0.6554"] | ["47.25","82.75"] | ["AMXO"] | 60.0000 | 70.0000 | 101 | 101 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:05:03Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08276-f9f9-7763-af5f-908881335399 | DRAM | 2026-09-08 15:20 | call_vertical_spread | 2 | 1 | 600 | 2539200.00 | unknown | — | 61.5399 | 2.2000 | ["55","62"] | ["0.6821","0.6719"] | [] | ["XBOX"] | 55.0000 | 62.0000 | 500 | 500 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:20:35Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0866f-1ae0-79b1-b336-52f0ca3bf3c8 | DRAM | 2026-09-09 09:50 | call_vertical_spread | 2 | 1 | 2240 | 1012480.00 | long | ask | 61.6450 | 0.3500 | ["67","80"] | ["0.7005","0.7102"] | ["69.50"] | ["SPHR"] | 67.0000 | 80.0000 | 37 | 37 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:50:32Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08bde-5338-7da0-b214-4d51e795af82 | DRAM | 2026-09-10 11:09 | other | 2 | 1 | 5610 | 5531160.00 | unknown | — | 59.1400 | 1.2000 | ["40","90"] | ["0.6201","0.6464"] | [] | ["XBOX"] | 40.0000 | 90.0000 | 280 | 280 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:09:58Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bee-4d11-7642-8acf-dd95f8842ee6 | DRAM | 2026-09-10 11:27 | strangle | 2 | 1 | 500 | 120000.00 | long | ask | 58.9750 | 0.0200 | ["58.5","65"] | ["0.6236","0.6483"] | ["56.1","67.40"] | ["XBOX"] | 58.5000 | 65.0000 | 8 | 8 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:27:34Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bfb-e970-7ae1-b441-2636a92ee83e | DRAM | 2026-09-10 11:42 | other | 4 | 2 | 2500 | 315000.00 | unknown | — | 58.9900 | 0.2100 | ["59.5","61","62","64"] | ["0.7355","0.7402","0.7564","0.6358"] | [] | ["AMXO"] | 59.5000 | 64.0000 | 1 | 15 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:42:22Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c96-b271-7050-b601-839a734b8ea6 | DRAM | 2026-09-10 14:31 | other | 3 | 1 | 81 | 127650.00 | unknown | — | 58.6200 | 2.1000 | ["65","67","68"] | ["1.7633","2.4322","1.8758"] | [] | ["XBOX"] | 65.0000 | 68.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:31:45Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a090d4-d150-7a51-8224-00a23267c319 | DRAM | 2026-09-11 10:17 | other | 3 | 2 | 400 | 272200.00 | unknown | — | 58.9400 | 1.0900 | ["65","85","90"] | ["0.6351","0.6412","0.6526"] | [] | ["AMXO"] | 65.0000 | 90.0000 | 126 | 126 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:17:53Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b1-7d80-7b42-af16-f6b73fd1a5d8 | DRAM | 2026-09-11 14:18 | risk_reversal | 2 | 1 | 400 | 148000.00 | unknown | — | 59.2301 | 0.1200 | ["62","65"] | ["0.5271","0.5444"] | [] | ["XBOX"] | 62.0000 | 65.0000 | 7 | 7 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:19:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a044-4788-7880-b77c-6b21a70842b8 | DRAM | 2026-09-14 10:13 | other | 2 | 1 | 250 | 185660.00 | unknown | — | 55.2800 | 1.4500 | ["60","61.5"] | ["0.5906","0.8089"] | [] | ["XBOX"] | 60.0000 | 61.5000 | 4 | 4 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:13:56Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a04e-6948-75a3-b941-9abe45832214 | DRAM | 2026-09-14 10:24 | call_ladder | 3 | 1 | 4000 | 2572000.00 | long | ask | 55.0000 | 0.3900 | ["70","80","100"] | ["0.6268","0.6335","0.6577"] | ["70.77","109.23"] | ["SPHR"] | 70.0000 | 100.0000 | 123 | 123 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:24:51Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a162-cb30-7801-9429-d3d31ccc62a7 | DRAM | 2026-09-14 15:26 | call_ratio_spread | 2 | 1 | 980 | 114170.00 | long | ask | 55.3950 | 0.1300 | ["57","64"] | ["0.6176","0.6412"] | ["58.09","69.91"] | ["AMXO"] | 57.0000 | 64.0000 | 11 | 11 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:26:54Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0b0b0-88a3-7e21-a45d-0711ffbda50d | DRAM | 2026-09-17 14:45 | put_ladder | 8 | 1 | 585 | 1239800.00 | unknown | — | 57.8250 | 4.9000 | ["62.5","63","63.5","64","65","66","67","69"] | ["1.1743","1.2023","1.3433","1.4250","2.2768","2.1051","2.5724","2.9792"] | [] | ["XBOX"] | 62.5000 | 69.0000 | 1 | 1 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:46:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b4db-e677-7302-b028-f1755e789734 | DRAM | 2026-09-18 10:11 | other | 3 | 1 | 7500 | 3100000.00 | unknown | — | 58.3700 | 1.1300 | ["35","70","105"] | ["0.6650","0.6031","0.6569"] | [] | ["SPHR"] | 35.0000 | 105.0000 | 119 | 119 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:11:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e5-ec08-7b00-be0c-e95421d420cd | DRAM | 2026-09-18 15:02 | synthetic | 2 | 1 | 2358 | 214578.00 | long | bid | 59.1200 | 0.3600 | ["60"] | ["0.9070"] | ["59.11"] | ["AMXO"] | 60.0000 | 60.0000 | 0 | 0 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:02:24Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |