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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5d0-c20f-7a81-958b-675b54095faf | JNJ | 2026-09-18 14:39 | put_frontspread | 2 | 1 | 6783 | 542220.00 | long | ask | 271.3800 | 0.4500 | ["260","265"] | ["0.2413","0.2460"] | ["257.68"] | ["SPHR"] | 260.0000 | 265.0000 | 7 | 7 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:39:24Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f7-32bf-76c0-8346-2a9575117e93 | QQQ | 2026-09-18 10:41 | put_frontspread | 2 | 2 | 1000 | 1932500.00 | long | ask | 716.6400 | 0.2400 | ["599.78","725"] | ["0.2949","0.2043"] | ["495.01","704.55"] | ["AMXO"] | 599.7800 | 725.0000 | 91 | 91 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:41:48Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b079-6b43-73e3-a60a-580d143ddbf3 | NDX | 2026-09-17 13:45 | put_frontspread | 2 | 1 | 14 | 2088952.00 | long | ask | 0.0000 | 59.3000 | ["26400","30000"] | ["0.2504","0.2082"] | ["23182.86","29617.14"] | ["XPHO"] | 26400.0000 | 30000.0000 | 183 | 183 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:45:59Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0affa-4093-7e80-806d-ec02795438ce | WBD | 2026-09-17 11:26 | put_frontspread | 2 | 1 | 7500 | 875000.00 | long | ask | 28.1750 | 1.3200 | ["26","28"] | ["0.3040","0.2523"] | ["22.50","27.75"] | ["AMXO"] | 26.0000 | 28.0000 | 64 | 64 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:27:10Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afed-1d4b-7c10-8520-ceb3488dc140 | JNJ | 2026-09-17 11:12 | put_frontspread | 2 | 1 | 6300 | 441000.00 | long | ask | 269.2150 | 0.3800 | ["255","260"] | ["0.2610","0.2652"] | ["252.41","260"] | ["SPHR"] | 255.0000 | 260.0000 | 8 | 8 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:12:31Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afe7-83b3-7a20-b5e6-506f8abd0d8c | BMY | 2026-09-17 11:06 | put_frontspread | 2 | 1 | 4000 | 884000.00 | long | ask | 63.4000 | 0.1900 | ["55","60"] | ["0.3357","0.3399"] | ["50.50","59.50"] | ["SPHR"] | 55.0000 | 60.0000 | 92 | 92 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:06:27Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb1-8ac4-7910-8faf-6951db484b7d | IYR | 2026-09-16 15:28 | put_frontspread | 2 | 2 | 1800 | 122400.00 | long | ask | 98.1850 | 0.6000 | ["89","99"] | ["0.7513","0.2067"] | ["77.67","98.06"] | ["ARCO"] | 89.0000 | 99.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:29:02Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba7-a783-7cd3-85b2-7dac2010078a | BMY | 2026-09-16 15:18 | put_frontspread | 2 | 1 | 8000 | 1268000.00 | long | ask | 63.3400 | 0.2600 | ["50","60"] | ["0.3446","0.3390"] | ["41.81","58.19"] | ["XPHO"] | 50.0000 | 60.0000 | 93 | 93 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:18:21Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aadd-4ad3-7831-9fec-b8eb27d19ace | GLD | 2026-09-16 11:37 | put_frontspread | 2 | 1 | 1600 | 370800.00 | long | ask | 398.9700 | 0.1000 | ["395","397"] | ["0.7131","0.7321"] | ["390.11","396.63"] | ["SPHR"] | 395.0000 | 397.0000 | 0 | 0 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:37:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aacc-187b-7b02-b645-6b8a16ddf654 | IWM | 2026-09-16 11:18 | put_frontspread | 2 | 1 | 1500 | 161500.00 | long | ask | 286.3000 | 0.0200 | ["283","285"] | ["0.5914","0.5819"] | ["279.65","284.68"] | ["AMXO"] | 283.0000 | 285.0000 | 0 | 0 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:18:27Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa7e-f27b-7c40-8cdc-277ee40343bf | NYT | 2026-09-16 09:53 | put_frontspread | 2 | 1 | 3000 | 745500.00 | long | ask | 71.6800 | 1.8000 | ["62.5","67.5"] | ["0.3943","0.3922"] | ["57.75","67.25"] | ["XPHO"] | 62.5000 | 67.5000 | 65 | 65 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:54:04Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a6a0-c546-7e43-9de5-1f410f5932d2 | HYG | 2026-09-15 15:52 | put_frontspread | 2 | 2 | 16500 | 126500.00 | long | ask | 78.3950 | 0.0600 | ["77","78"] | ["0.1097","0.0910"] | ["75.17","77.92"] | ["AMXO"] | 77.0000 | 78.0000 | 3 | 3 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:52:52Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a65f-d05e-7c02-ba83-e40aeac8deb4 | INTC | 2026-09-15 14:41 | put_frontspread | 2 | 2 | 1800 | 384600.00 | long | ask | 96.8900 | 0.2000 | ["70","95"] | ["0.6588","0.5952"] | ["59.86","90.27"] | ["ARCO"] | 70.0000 | 95.0000 | 31 | 31 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:41:40Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a658-df06-7860-803c-9d901f608dd8 | NVST | 2026-09-15 14:33 | put_frontspread | 2 | 1 | 6000 | 273000.00 | long | ask | 24.8300 | 2.5500 | ["22.5","25"] | ["0.7753","0.7839"] | ["20.67","24.33"] | ["XPHO"] | 22.5000 | 25.0000 | 3 | 3 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:34:19Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5cf-8ac6-75d1-8271-b97b028602f4 | NDX | 2026-09-15 12:03 | put_frontspread | 2 | 1 | 100 | 1668000.00 | long | ask | 0.0000 | 10.1000 | ["28200","29000"] | ["0.2820","0.2226"] | ["27540","28860"] | ["XPHO"] | 28200.0000 | 29000.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:04:47Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0cd-d660-7a63-9c9b-46733dac5348 | XOP | 2026-09-14 12:43 | put_frontspread | 2 | 1 | 1800 | 758700.00 | long | ask | 196.2200 | 0.6900 | ["180","188"] | ["0.3525","0.3475"] | ["171.99"] | ["ARCO"] | 180.0000 | 188.0000 | 32 | 32 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:43:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a095-a3a8-7291-9682-0b7ab2975a32 | MSFT | 2026-09-14 11:42 | put_frontspread | 2 | 2 | 558 | 767529.00 | long | ask | 505.1900 | 0.8400 | ["410","500"] | ["0.3623","0.3074"] | ["336.95","483.05"] | ["ARCO"] | 410.0000 | 500.0000 | 67 | 67 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:42:54Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a083-d8f8-7a21-acf2-a36281ba1287 | AMD | 2026-09-14 11:23 | put_frontspread | 2 | 2 | 750 | 1683500.00 | long | ask | 485.8400 | 2.0500 | ["340","460"] | ["0.5508","0.5417"] | ["290.30","439.40"] | ["AMXO"] | 340.0000 | 460.0000 | 123 | 123 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:23:28Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091c9-04f0-71a0-9ab6-c9de79e79c64 | QQQ | 2026-09-11 14:44 | put_frontspread | 2 | 2 | 5000 | 62000.00 | long | ask | 716.1200 | 0.0200 | ["570","660"] | ["0.6084","0.3163"] | ["547.52","659.92"] | ["AMXO"] | 570.0000 | 660.0000 | 7 | 7 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:44:57Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0918c-2eb8-7881-9718-80bd2c1b452a | META | 2026-09-11 13:37 | put_frontspread | 2 | 2 | 1600 | 1923200.00 | long | ask | 650.1450 | 0.6300 | ["550","640"] | ["0.3936","0.3688"] | ["501.23","623.15"] | ["AMXO"] | 550.0000 | 640.0000 | 35 | 35 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:38:16Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09185-cde8-7921-94b5-62d60b656d50 | NDX | 2026-09-11 13:30 | put_frontspread | 2 | 1 | 45 | 4741680.00 | long | ask | 0.0000 | 38.6000 | ["24000","30000"] | ["0.3069","0.1974"] | ["14150","28925"] | ["XPHO"] | 24000.0000 | 30000.0000 | 98 | 98 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:31:08Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09116-56c0-7bb0-9163-2f5c5fa246bf | QQQ | 2026-09-11 11:29 | put_frontspread | 2 | 2 | 1000 | 417500.00 | long | ask | 717.3100 | 0.0300 | ["690","715"] | ["0.2375","0.1796"] | ["668.19","711.81"] | ["ARCO"] | 690.0000 | 715.0000 | 7 | 7 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:29:14Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090fe-3ec8-7583-a69b-b031dbf5d4d7 | MSTR | 2026-09-11 11:02 | put_frontspread | 2 | 3 | 780 | 5218680.00 | long | ask | 136.1100 | 4.2000 | ["90","130"] | ["0.8416","0.8346"] | ["5.83","115.25"] | ["ARCO"] | 90.0000 | 130.0000 | 826 | 826 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:03:15Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090e1-a290-7f42-b426-247b87a4c904 | MSTR | 2026-09-11 10:31 | put_frontspread | 2 | 4 | 260 | 1739800.00 | long | ask | 136.0100 | 5.0500 | ["90","130"] | ["0.8413","0.8343"] | ["5.83","115.25"] | ["ARCO"] | 90.0000 | 130.0000 | 826 | 826 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:31:46Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c65-4230-7e20-a554-71b334edc545 | LQD | 2026-09-10 13:37 | put_frontspread | 2 | 2 | 2500 | 272000.00 | long | ask | 104.6150 | 0.3000 | ["100","104"] | ["0.1068","0.1042"] | ["97.55","103.68"] | ["AMXO"] | 100.0000 | 104.0000 | 99 | 99 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:37:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08260-ab08-7842-af1d-7375cc65f5ff | QQQ | 2026-09-08 14:56 | put_frontspread | 2 | 2 | 450 | 305400.00 | long | ask | 719.2900 | 0.1000 | ["695","715"] | ["0.2224","0.1897"] | ["661.38","711.81"] | ["AMXO"] | 695.0000 | 715.0000 | 10 | 10 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:56:47Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081f0-0330-71a3-b84d-9ced85254a9d | QQQ | 2026-09-08 12:53 | put_frontspread | 2 | 2 | 1000 | 706000.00 | long | ask | 719.6450 | 0.1100 | ["700","720"] | ["0.2112","0.1805"] | ["682.64","717.36"] | ["AMXO"] | 700.0000 | 720.0000 | 10 | 10 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:53:38Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081e5-3d61-7a93-8442-cbd87f8e1031 | TSLA | 2026-09-08 12:41 | put_frontspread | 2 | 1 | 450 | 573000.00 | long | ask | 368.8500 | 0.4500 | ["280","370"] | ["0.4829","0.4543"] | ["244.9","350.2"] | ["XBOX"] | 280.0000 | 370.0000 | 73 | 73 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:41:46Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |