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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5f8-d7c7-70e2-91c2-1463d94ae5fa | MU | 2026-09-18 15:22 | call_calendar | 2 | 1 | 500 | 1360000.00 | short | bid | 1008.1550 | 2.4500 | ["1050"] | ["0.4773"] | [] | ["SPHR"] | 1050.0000 | 1050.0000 | 7 | 10 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:23:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5c3-a2af-7b32-b888-64089d3c531a | MU | 2026-09-18 14:24 | synthetic | 2 | 2 | 24 | 60720.00 | short | bid | 1004.3593 | 0.3000 | ["1000"] | ["0.3452"] | ["1004.00"] | ["AMXO"] | 1000.0000 | 1000.0000 | 3 | 3 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:24:53Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b58a-991f-7ba1-b4a7-b3fa0e990c70 | MU | 2026-09-18 13:22 | put_diagonal_spread | 2 | 1 | 1000 | 9348000.00 | short | bid | 997.6500 | 1.0700 | ["920","970"] | ["1.7313","0.5731"] | [] | ["SPHR"] | 920.0000 | 970.0000 | 0 | 91 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:22:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b06b-7cdb-76d1-a50e-8b3cf234866d | MU | 2026-09-17 13:30 | put_vertical_spread | 2 | 1 | 200 | 49400.00 | short | bid | 975.5098 | 0.0900 | ["930","935"] | ["0.6392","0.6200"] | ["934.71"] | ["XBOX"] | 930.0000 | 935.0000 | 1 | 1 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:30:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afc8-8deb-75a1-b5cb-77c4e0b55f4c | MU | 2026-09-17 10:32 | synthetic | 2 | 1 | 100 | 3945000.00 | short | ask | 975.2950 | 11.0000 | ["1200"] | ["0.5949"] | ["998.32"] | ["XPHO"] | 1200.0000 | 1200.0000 | 183 | 183 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:32:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a60b-016e-7511-9e6b-d28d992b72ee | MU | 2026-09-15 13:08 | synthetic | 2 | 2 | 400 | 1712000.00 | short | bid | 924.9900 | 1.7000 | ["900"] | ["0.5684"] | ["925.20"] | ["AMXO"] | 900.0000 | 900.0000 | 3 | 3 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:09:31Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5b7-6afe-7761-a177-5ad5d333f1a5 | MU | 2026-09-15 11:37 | strangle | 2 | 1 | 150 | 3423000.00 | short | bid | 928.1450 | 6.6000 | ["950","1000"] | ["0.5707","0.5882"] | ["721.80","1228.20"] | ["SPHR"] | 950.0000 | 1000.0000 | 122 | 122 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:37:41Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a57c-947e-7c00-9983-aa8472ef4ef2 | MU | 2026-09-15 10:33 | call_calendar | 2 | 1 | 100 | 277000.00 | short | ask | 942.1950 | 1.2000 | ["960"] | ["0.5247"] | [] | ["SPHR"] | 960.0000 | 960.0000 | 3 | 6 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:33:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a127-4cb9-7a82-835f-bd0d9d4207ca | MU | 2026-09-14 14:21 | put_diagonal_spread | 2 | 1 | 220 | 1801800.00 | short | bid | 930.9810 | 1.8000 | ["925","950"] | ["0.6372","0.5833"] | [] | ["SPHR"] | 925.0000 | 950.0000 | 4 | 18 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:21:51Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09114-6e78-7860-b82c-7c9ab81d2c8b | MU | 2026-09-11 11:27 | synthetic | 2 | 1 | 100 | 6060000.00 | short | ask | 978.5765 | 6.9000 | ["1400"] | ["0.6557"] | ["1014.16"] | ["SPHR"] | 1400.0000 | 1400.0000 | 279 | 279 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:27:20Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cca-ce48-7d00-931c-89db65879578 | MU | 2026-09-10 15:28 | risk_reversal | 2 | 1 | 90 | 2605500.00 | short | bid | 982.6100 | 5.7000 | ["800","1100"] | ["0.6296","0.6412"] | ["1181.70"] | ["SPHR"] | 800.0000 | 1100.0000 | 280 | 280 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:28:35Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bae-dec8-7990-9d81-e9100aaa575d | MU | 2026-09-10 10:18 | risk_reversal | 2 | 1 | 50 | 474550.00 | short | ask | 984.2200 | 7.1000 | ["820","1300"] | ["0.6147","0.6550"] | ["819.25"] | ["XPHO"] | 820.0000 | 1300.0000 | 99 | 99 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:18:13Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b87-f5d8-7b63-aae0-cf348a660c84 | MU | 2026-09-10 09:35 | put_vertical_spread | 2 | 1 | 50 | 69050.00 | short | bid | 990.0000 | 0.3500 | ["960","965"] | ["0.8544","0.8425"] | ["963.85"] | ["AMXO"] | 960.0000 | 965.0000 | 1 | 1 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:35:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0877b-00e9-73d3-b1bb-bd9104b412d8 | MU | 2026-09-09 14:42 | put_vertical_spread | 2 | 1 | 400 | 467200.00 | short | bid | 1024.9901 | 0.2200 | ["850","950"] | ["0.6782","0.5839"] | ["941.40"] | ["SPHR"] | 850.0000 | 950.0000 | 9 | 9 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:43:49Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08678-4689-79f0-a5fc-d21356dab67f | MU | 2026-09-09 10:00 | call_vertical_spread | 2 | 1 | 320 | 102720.00 | short | bid | 1034.4026 | 0.2400 | ["1135","1160"] | ["0.8389","0.8889"] | ["1135.81"] | ["XBOX"] | 1135.0000 | 1160.0000 | 2 | 2 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:00:39Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08673-e958-71c1-b97e-eac237eb8f99 | MU | 2026-09-09 09:55 | risk_reversal | 2 | 1 | 200 | 2067200.00 | short | ask | 1026.8500 | 11.1000 | ["700","2500"] | ["0.6619","0.7140"] | ["671.50"] | ["XPHO"] | 700.0000 | 2500.0000 | 281 | 281 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:55:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06d51-f015-7d30-9c3a-005e8a958ea7 | MU | 2026-09-04 12:47 | call_diagonal_spread_bearish | 2 | 1 | 60 | 5145600.00 | short | bid | 1003.5400 | 10.2000 | ["600","610"] | ["0.6650","0.6500"] | [] | ["SPHR"] | 600.0000 | 610.0000 | 133 | 196 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:48:17Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |