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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c57b-0fdf-7d23-8ea2-e5dd01d01844 | AMZN | 2026-09-21 15:39 | call_vertical_spread | 2 | 1 | 100 | 110100.00 | unknown | ask | 259.0905 | 0.5000 | ["280","285"] | ["0.3938","0.3921"] | ["288.00"] | ["SPHR"] | 280.0000 | 285.0000 | 39 | 39 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:39:33Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b0ac-46cb-7450-af2c-edd7ef4a1b56 | AMZN | 2026-09-17 14:41 | other | 4 | 1 | 21 | 231360.00 | unknown | — | 251.5900 | 5.1500 | ["262.5","275","300"] | ["0.6382","1.3873","0.5058"] | [] | ["XBOX"] | 262.5000 | 300.0000 | 1 | 29 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:41:47Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a9-d9b3-7231-bf28-ba1373da2051 | AMZN | 2026-09-17 14:38 | other | 5 | 1 | 2000 | 18173600.00 | unknown | — | 251.2900 | 4.7000 | ["265","270","275","280","290"] | ["0.5721","0.9931","0.7963","1.1013","0.3571"] | [] | ["XPHO"] | 265.0000 | 290.0000 | 1 | 29 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:38:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a5-d65b-77c1-9691-be6b01234472 | AMZN | 2026-09-17 14:34 | put_ladder | 3 | 1 | 1800 | 8060800.00 | unknown | — | 251.2874 | 3.5500 | ["270","275","280"] | ["0.7073","0.7708","1.0796"] | [] | ["XPHO"] | 270.0000 | 280.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:34:23Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b09f-a853-7c90-84bf-449a3513a23a | AMZN | 2026-09-17 14:27 | put_vertical_spread | 2 | 1 | 1290 | 6940200.00 | unknown | — | 251.2750 | 2.5500 | ["275","280"] | ["1.2696","1.4534"] | [] | ["XBOX"] | 275.0000 | 280.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:27:53Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b04e-30db-7273-8852-69ff45f8e3aa | AMZN | 2026-09-17 12:58 | put_diagonal_spread | 2 | 1 | 950 | 1376075.00 | unknown | — | 251.2874 | 0.9200 | ["135","240"] | ["0.4666","0.3700"] | [] | ["XPHO"] | 135.0000 | 240.0000 | 183 | 456 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:59:04Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b044-8833-71c3-b221-5361c06d68fb | AMZN | 2026-09-17 12:47 | put_diagonal_spread | 2 | 2 | 400 | 1520000.00 | unknown | — | 251.3200 | 0.8500 | ["210","250"] | ["0.3675","0.3694"] | [] | ["AMXO"] | 210.0000 | 250.0000 | 120 | 491 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:48:17Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afd1-c933-7b63-a5d4-4ffd7735c242 | AMZN | 2026-09-17 10:42 | put_diagonal_spread | 2 | 1 | 250 | 611600.00 | unknown | — | 252.6940 | 3.6500 | ["170","260"] | ["0.3831","0.3671"] | [] | ["XBOX"] | 170.0000 | 260.0000 | 273 | 855 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:42:50Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aba9-bac3-7851-80ca-cd31b183f771 | AMZN | 2026-09-16 15:20 | put_ladder | 3 | 1 | 31 | 235170.00 | unknown | — | 244.9600 | 4.1500 | ["280","285","290"] | ["1.0577","1.1868","1.5547"] | [] | ["XBOX"] | 280.0000 | 290.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:20:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a68a-2066-7d62-8dc5-6c4cd1083996 | AMZN | 2026-09-15 15:27 | other | 4 | 1 | 392 | 1561590.00 | unknown | — | 247.8200 | 3.0500 | ["265","267.5","270","272.5"] | ["0.9600","0.8467","1.1265","1.1887"] | [] | ["XBOX"] | 265.0000 | 272.5000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:27:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a684-ec5e-7b02-b173-cf6b76423cef | AMZN | 2026-09-15 15:22 | put_ratio_spread | 2 | 2 | 400 | 1983500.00 | unknown | — | 247.9600 | 2.3000 | ["220","230"] | ["0.3638","0.3581"] | [] | ["AMXO"] | 220.0000 | 230.0000 | 822 | 822 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:22:46Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a67c-2e16-7163-955e-0a8699295769 | AMZN | 2026-09-15 15:12 | call_ratio_spread | 2 | 1 | 1100 | 626000.00 | unknown | — | 248.0850 | 0.1900 | ["285","320"] | ["0.3751","0.3849"] | [] | ["XBOX"] | 285.0000 | 320.0000 | 66 | 66 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:13:03Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a66f-8f9e-7c52-85a3-68e4adad3946 | AMZN | 2026-09-15 14:58 | call_calendar | 2 | 2 | 900 | 346200.00 | unknown | — | 247.8700 | 0.4500 | ["252.5"] | ["0.3300"] | [] | ["ARCO"] | 252.5000 | 252.5000 | 3 | 13 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:59:15Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0ca-a9e0-72d2-8ad9-938503e9509c | AMZN | 2026-09-14 12:40 | other | 2 | 2 | 1200 | 454800.00 | unknown | — | 253.6000 | 0.2700 | ["250"] | ["0.3256"] | [] | ["ARCO"] | 250.0000 | 250.0000 | 4 | 11 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:40:54Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a05c-9a18-7fb3-86fb-2e0a66b7ec33 | AMZN | 2026-09-14 10:40 | other | 2 | 1 | 225 | 55500.00 | unknown | — | 251.7650 | 0.7500 | ["285","310"] | ["0.3885","0.3851"] | [] | ["XBOX"] | 285.0000 | 310.0000 | 46 | 46 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:40:31Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a040-e841-70f3-a899-c7ca4dacf686 | AMZN | 2026-09-14 10:10 | other | 4 | 1 | 25000 | 24875000.00 | unknown | — | 252.7000 | 1.8100 | ["280","295","320","350"] | ["0.3761","0.3752","0.3527","0.3815"] | [] | ["XPHO"] | 280.0000 | 350.0000 | 46 | 67 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:10:01Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09206-63e0-7651-88f7-75e7096478f6 | AMZN | 2026-09-11 15:51 | call_vertical_spread | 2 | 1 | 984 | 91512.00 | unknown | — | 257.0100 | 0.0700 | ["300","310"] | ["0.3068","0.3120"] | [] | ["XBOX"] | 300.0000 | 310.0000 | 35 | 35 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:51:44Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090d8-e060-7262-9b92-234ac0eac653 | AMZN | 2026-09-11 10:22 | call_vertical_spread | 2 | 2 | 200 | 499200.00 | unknown | — | 256.6100 | 0.6000 | ["280","320"] | ["0.3664","0.3644"] | [] | ["SPHR"] | 280.0000 | 320.0000 | 161 | 161 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:22:26Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ca2-0cb0-75c0-b6f7-beca439c3064 | AMZN | 2026-09-10 14:43 | other | 6 | 1 | 1400 | 7335660.00 | unknown | — | 252.0000 | 4.9500 | ["267.5","270","280","285","290","300"] | ["0.7448","0.8337","0.4589","0.5188","0.5765","0.2806"] | [] | ["XBOX"] | 267.5000 | 300.0000 | 1 | 22 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:43:48Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca1-f159-78a2-ad0d-6b42bdd9865b | AMZN | 2026-09-10 14:43 | other | 2 | 1 | 2018 | 8354520.00 | unknown | — | 252.0100 | 1.0000 | ["265","280"] | ["0.6298","0.4502"] | [] | ["XBOX"] | 265.0000 | 280.0000 | 1 | 8 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:43:48Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca1-d600-7953-a9e1-775e742f0f69 | AMZN | 2026-09-10 14:43 | put_vertical_spread | 2 | 1 | 21 | 123900.00 | unknown | — | 251.9750 | 1.5000 | ["280","282.5"] | ["0.4540","0.4840"] | [] | ["XBOX"] | 280.0000 | 282.5000 | 8 | 8 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:43:48Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca0-c490-78b1-af21-1985f5a751bf | AMZN | 2026-09-10 14:42 | other | 2 | 1 | 5 | 37500.00 | unknown | — | 252.0150 | 2.6000 | ["290"] | ["1.2595"] | [] | ["XBOX"] | 290.0000 | 290.0000 | 1 | 8 | false | false | true | false | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:43:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08711-7d30-7243-9e4a-beb71dcb889f | AMZN | 2026-09-09 12:47 | other | 3 | 1 | 1500 | 1261500.00 | unknown | — | 251.5404 | 0.4200 | ["240","260","280"] | ["0.3211","0.3140","0.3185"] | [] | ["XPHO"] | 240.0000 | 280.0000 | 37 | 37 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:48:04Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08265-3718-73c1-8509-1ad3ee90b538 | AMZN | 2026-09-08 15:01 | other | 2 | 1 | 540 | 163800.00 | unknown | — | 257.3100 | 0.1700 | ["265","295"] | ["0.3152","0.3217"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:01:06Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08261-d3e8-78b3-a067-1f88d83fe92d | AMZN | 2026-09-08 14:57 | other | 2 | 1 | 330 | 96800.00 | unknown | — | 256.9700 | 0.1600 | ["265","295"] | ["0.3159","0.3215"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:57:35Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0825c-3280-7052-856a-d72292e77da3 | AMZN | 2026-09-08 14:51 | other | 2 | 1 | 330 | 95260.00 | unknown | — | 256.7400 | 0.2000 | ["265","295"] | ["0.3178","0.3218"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:51:45Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08257-e8d8-7790-a082-7c5ea104dc29 | AMZN | 2026-09-08 14:46 | other | 2 | 1 | 330 | 99220.00 | unknown | — | 257.1650 | 0.1600 | ["265","295"] | ["0.3154","0.3227"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:46:42Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08250-cc88-7e60-9857-6dd579caee0a | AMZN | 2026-09-08 14:38 | other | 2 | 1 | 330 | 97460.00 | unknown | — | 257.0700 | 0.1100 | ["265","295"] | ["0.3132","0.3225"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:38:50Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0824c-e870-7cb0-a37b-4d30c8246645 | AMZN | 2026-09-08 14:34 | other | 2 | 1 | 330 | 97680.00 | unknown | — | 257.1067 | 0.1600 | ["265","295"] | ["0.3139","0.3218"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:35:01Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08242-2e58-7320-bdd5-5bdf80dd1dd2 | AMZN | 2026-09-08 14:22 | other | 2 | 1 | 330 | 96800.00 | unknown | — | 256.8250 | 0.1200 | ["265","295"] | ["0.3175","0.3233"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:23:04Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0822d-f2a8-7d12-92e9-75f4a2c6f57f | AMZN | 2026-09-08 14:00 | other | 2 | 1 | 330 | 97900.00 | unknown | — | 257.0200 | 0.1100 | ["265","295"] | ["0.3163","0.3224"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:01:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08220-8528-7853-8d0f-758c7bb36b5d | AMZN | 2026-09-08 13:46 | other | 2 | 1 | 330 | 95480.00 | unknown | — | 256.7550 | 0.1400 | ["265","295"] | ["0.3161","0.3230"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:46:42Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08212-8720-7d62-a38d-eb883838cc36 | AMZN | 2026-09-08 13:30 | other | 2 | 1 | 330 | 96140.00 | unknown | — | 256.9700 | 0.1600 | ["265","295"] | ["0.3139","0.3215"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:30:59Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08205-0619-7113-a55e-f0bd0958ac3c | AMZN | 2026-09-08 13:16 | other | 2 | 1 | 330 | 97680.00 | unknown | — | 257.2250 | 0.1800 | ["265","295"] | ["0.3135","0.3197"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:16:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081f8-5be8-7b52-9543-c2d362e9e610 | AMZN | 2026-09-08 13:02 | other | 2 | 1 | 330 | 101860.00 | unknown | — | 257.6500 | 0.1500 | ["265","295"] | ["0.3129","0.3197"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:02:47Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081f0-d239-70c3-a2a6-e21538b80902 | AMZN | 2026-09-08 12:53 | other | 2 | 1 | 330 | 101200.00 | unknown | — | 257.4800 | 0.1100 | ["265","295"] | ["0.3130","0.3217"] | [] | ["XPHO"] | 265.0000 | 295.0000 | 10 | 38 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:54:31Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08199-24e9-7f90-8df6-a72309da5021 | AMZN | 2026-09-08 11:18 | other | 3 | 1 | 279 | 88449.00 | unknown | — | 256.8450 | 0.2400 | ["295","300","310"] | ["0.3811","0.3987","0.3736"] | [] | ["SPHR"] | 295.0000 | 310.0000 | 10 | 73 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:18:36Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |