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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c587-e11f-7801-86bd-28dff24d62b4 | META | 2026-09-21 15:53 | call_vertical_spread | 2 | 1 | 1496 | 592416.00 | long | ask | 748.6450 | 0.1000 | ["790","800"] | ["0.6464","0.6596"] | ["790.90"] | ["XBOX"] | 790.0000 | 800.0000 | 2 | 2 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:53:47Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c582-e3c7-7602-908b-0e39dfc89b44 | META | 2026-09-21 15:48 | call_backspread | 2 | 1 | 1000 | 8597500.00 | long | bid | 748.2500 | 1.2500 | ["750","830"] | ["0.4375","0.4418"] | ["927.45"] | ["AMXO"] | 750.0000 | 830.0000 | 116 | 116 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:48:24Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c52f-1e77-7372-9f13-f0c36fc2b162 | META | 2026-09-21 14:16 | call_vertical_spread | 2 | 1 | 75 | 1412400.00 | long | ask | 743.4200 | 3.6500 | ["850","1100"] | ["0.4453","0.4465"] | ["909.40"] | ["SPHR"] | 850.0000 | 1100.0000 | 452 | 452 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:16:40Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c52c-d09f-7d20-b39c-216a88696f38 | META | 2026-09-21 14:14 | put_vertical_spread | 2 | 1 | 600 | 943800.00 | long | ask | 743.7700 | 0.2500 | ["727.5","737.5"] | ["0.5747","0.5825"] | ["733.67"] | ["AMXO"] | 727.5000 | 737.5000 | 2 | 2 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:14:17Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4e1-584f-7951-a4fc-f67770098378 | META | 2026-09-21 12:51 | put_vertical_spread | 2 | 2 | 400 | 1412000.00 | long | ask | 728.6300 | 0.3500 | ["640","725"] | ["0.4435","0.4360"] | ["699.70"] | ["AMXO"] | 640.0000 | 725.0000 | 25 | 25 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:52:09Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4d4-a64f-7be0-92be-3ae093d47bab | META | 2026-09-21 12:37 | call_vertical_spread | 2 | 1 | 200 | 4304300.00 | long | ask | 728.2490 | 5.7500 | ["650","660"] | ["0.4418","0.4415"] | ["656.62"] | ["SPHR"] | 650.0000 | 660.0000 | 88 | 88 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:37:54Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c472-d73f-7e81-a9c6-5cff68e62b31 | META | 2026-09-21 10:50 | call_vertical_spread | 2 | 1 | 100 | 1530000.00 | long | ask | 710.4500 | 2.5500 | ["850","1100"] | ["0.4328","0.4331"] | ["902.56"] | ["AMXO"] | 850.0000 | 1100.0000 | 452 | 452 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:51:08Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c464-584f-7461-b186-e8efad4ec94e | META | 2026-09-21 10:35 | call_vertical_spread | 2 | 1 | 90 | 1178100.00 | long | ask | 712.5000 | 3.0000 | ["720","730"] | ["0.4180","0.4162"] | ["724.70"] | ["SPHR"] | 720.0000 | 730.0000 | 116 | 116 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:35:18Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c463-6def-79c1-8bf6-0cb759cb473f | META | 2026-09-21 10:34 | risk_reversal | 2 | 2 | 400 | 1619600.00 | long | ask | 711.7900 | 0.3500 | ["675","725"] | ["0.4137","0.4184"] | ["736.55"] | ["ARCO"] | 675.0000 | 725.0000 | 25 | 25 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:34:11Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c456-71b7-72c1-ac64-2055aee93e98 | META | 2026-09-21 10:19 | put_diagonal_spread | 2 | 1 | 300 | 916500.00 | long | ask | 711.3100 | 0.8000 | ["620","660"] | ["0.4321","0.4158"] | [] | ["SPHR"] | 620.0000 | 660.0000 | 25 | 88 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:20:07Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c443-62ce-7c40-9e87-94644cb2d8f9 | META | 2026-09-21 09:59 | call_vertical_spread | 2 | 1 | 50 | 260150.00 | long | ask | 710.0500 | 0.5500 | ["710","740"] | ["0.4222","0.4213"] | ["722.45"] | ["SPHR"] | 710.0000 | 740.0000 | 25 | 25 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:59:06Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5c1-e178-7e43-a67a-03f36628a703 | META | 2026-09-18 14:22 | straddle | 2 | 1 | 100 | 44400.00 | long | ask | 671.3650 | 0.3400 | ["670"] | ["0.5915"] | ["665.56","674.44"] | ["AMXO"] | 670.0000 | 670.0000 | 0 | 0 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:23:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b59f-de6f-7492-8296-d1724d31e853 | META | 2026-09-18 13:45 | straddle | 2 | 1 | 100 | 46000.00 | long | ask | 671.3750 | 0.5300 | ["670"] | ["0.5220"] | ["665.40","674.60"] | ["XPHO"] | 670.0000 | 670.0000 | 0 | 0 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:46:22Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b599-a4af-7b13-8e97-d399d35d41c0 | META | 2026-09-18 13:38 | call_diagonal_spread | 2 | 1 | 500 | 7746500.00 | long | ask | 670.6100 | 4.0500 | ["625","670"] | ["0.4380","0.4229"] | [] | ["SPHR"] | 625.0000 | 670.0000 | 63 | 154 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:39:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b556-3ec8-7260-9720-4fcde920c71d | META | 2026-09-18 12:25 | call_diagonal_spread | 2 | 1 | 135 | 741960.00 | long | ask | 669.6200 | 1.4500 | ["660","670"] | ["0.3882","0.3821"] | [] | ["XBOX"] | 660.0000 | 670.0000 | 14 | 28 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:25:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b510-67df-7b20-9f92-e593c2a6ab42 | META | 2026-09-18 11:09 | call_vertical_spread | 2 | 2 | 150 | 64200.00 | long | ask | 679.2100 | 0.4200 | ["690","700"] | ["0.2900","0.2914"] | ["691.92"] | ["AMXO"] | 690.0000 | 700.0000 | 3 | 3 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:09:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e5-48d0-7cb0-a6f2-aba5d50130f8 | META | 2026-09-18 10:21 | call_diagonal_spread | 2 | 1 | 60 | 596400.00 | long | ask | 673.7000 | 1.7000 | ["720","740"] | ["0.4043","0.4208"] | [] | ["SPHR"] | 720.0000 | 740.0000 | 119 | 154 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:22:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0abcb-b5fb-7790-a4a6-1b0bacb8db09 | META | 2026-09-16 15:57 | call_diagonal_spread | 2 | 1 | 50 | 77900.00 | long | ask | 672.7100 | 1.0500 | ["677.5","680"] | ["0.3623","0.4698"] | [] | ["SPHR"] | 677.5000 | 680.0000 | 2 | 5 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:57:32Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aae7-dddb-7f10-939d-4fca858362f8 | META | 2026-09-16 11:48 | put_vertical_spread | 2 | 1 | 50 | 1195800.00 | long | ask | 678.2700 | 9.8500 | ["795","800"] | ["1.2640","1.4441"] | ["796.50"] | ["SPHR"] | 795.0000 | 800.0000 | 2 | 2 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:48:59Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a031-e480-7a51-b2c5-bdd8100b7029 | META | 2026-09-14 09:53 | strangle | 2 | 1 | 100 | 175500.00 | long | ask | 661.8625 | 1.0000 | ["650","670"] | ["0.4757","0.4770"] | ["632.45","687.55"] | ["XBOX"] | 650.0000 | 670.0000 | 4 | 4 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:53:42Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 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 |
| 01a09162-1d30-7eb3-9f02-b6d39233f634 | META | 2026-09-11 12:51 | call_ratio_spread | 2 | 1 | 23 | 112828.00 | long | ask | 648.3299 | 1.8500 | ["650","970"] | ["0.4205","0.4300"] | ["704.50","1174.23"] | ["XPHO"] | 650.0000 | 970.0000 | 189 | 189 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:52:39Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0915d-0098-74f3-b7f2-f7d9a1b33bd9 | META | 2026-09-11 12:46 | call_vertical_spread | 2 | 1 | 150 | 1123200.00 | long | ask | 649.2300 | 1.3500 | ["605","625"] | ["0.3915","0.3614"] | ["622.48"] | ["SPHR"] | 605.0000 | 625.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:47:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cbd-fd08-7f72-b464-03cc512f3db7 | META | 2026-09-10 15:14 | call_vertical_spread | 2 | 1 | 3130 | 4986090.00 | long | ask | 645.7940 | 0.6500 | ["710","765"] | ["0.4023","0.4075"] | ["717.65"] | ["SPHR"] | 710.0000 | 765.0000 | 36 | 36 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:14:43Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c8d-d100-7cd3-8634-4f6fa03d3c4c | META | 2026-09-10 14:21 | risk_reversal | 2 | 1 | 55 | 26400.00 | long | bid | 646.8000 | 0.3500 | ["585","730"] | ["0.4109","0.4171"] | ["584.34"] | ["XBOX"] | 585.0000 | 730.0000 | 15 | 15 | false | true | false | true | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:21:45Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087b0-9f78-79d3-9418-f2a52048a401 | META | 2026-09-09 15:41 | straddle | 2 | 1 | 50 | 1011000.00 | long | ask | 654.6370 | 3.5000 | ["700"] | ["0.4343"] | ["497.80","902.20"] | ["SPHR"] | 700.0000 | 700.0000 | 281 | 281 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:41:42Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087a4-5308-7842-906d-c1690bae0867 | META | 2026-09-09 15:28 | call_calendar | 2 | 1 | 130 | 936390.00 | long | bid | 655.7350 | 2.8500 | ["620"] | ["2.3319"] | [] | ["SPHR"] | 620.0000 | 620.0000 | 0 | 2 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:28:32Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08711-1b88-7152-952e-9d0b913005dc | META | 2026-09-09 12:47 | risk_reversal | 2 | 1 | 380 | 1542800.00 | long | ask | 650.2600 | 0.9500 | ["615","675"] | ["0.3984","0.4045"] | ["682.50"] | ["XBOX"] | 615.0000 | 675.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 |
| 01a0870d-f2f0-7e90-94a9-537bd16301d3 | META | 2026-09-09 12:43 | straddle | 2 | 1 | 120 | 2097600.00 | long | ask | 650.4750 | 3.8000 | ["550"] | ["0.4362"] | ["375.20","724.80"] | ["SPHR"] | 550.0000 | 550.0000 | 191 | 191 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:44:02Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086bf-1b58-7f82-b47a-86ebb9ca0eed | META | 2026-09-09 11:17 | iron_condor | 4 | 1 | 100 | 631500.00 | long | ask | 657.0000 | 3.1000 | ["605","610","650","655"] | ["0.4316","0.4274","0.4167","0.4186"] | ["606.65","653.35"] | ["SPHR"] | 605.0000 | 655.0000 | 16 | 16 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:17:44Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08244-1e70-7b40-adb1-a56263384fa5 | META | 2026-09-08 14:24 | call_calendar | 2 | 2 | 200 | 683000.00 | long | ask | 616.6800 | 1.0500 | ["620"] | ["0.3647"] | [] | ["AMXO"] | 620.0000 | 620.0000 | 13 | 17 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:25:09Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |