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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 01a0b50e-dd58-78a0-bb7e-3d8dc073f0b9 | META | 2026-09-18 11:07 | call_vertical_spread | 2 | 1 | 800 | 384000.00 | unknown | ask | 680.4591 | 0.4100 | ["690","700"] | ["0.2892","0.2911"] | ["694.80"] | ["AMXO"] | 690.0000 | 700.0000 | 3 | 3 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:07:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b04e-b5ab-7960-a1cb-e83731c71661 | META | 2026-09-17 12:59 | call_vertical_spread | 2 | 2 | 125 | 1118750.00 | unknown | — | 677.7500 | 1.4500 | ["800","1000"] | ["0.4207","0.4244"] | [] | ["AMXO"] | 800.0000 | 1000.0000 | 273 | 273 | false | true | false | 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 |
| 01a0b03b-451b-7040-809f-5bad655adb15 | META | 2026-09-17 12:37 | call_vertical_spread | 2 | 1 | 100 | 257300.00 | short | bid | 678.7000 | 0.8500 | ["800","820"] | ["0.4339","0.4377"] | ["802.75"] | ["SPHR"] | 800.0000 | 820.0000 | 64 | 64 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:38:26Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab85-0c23-70a0-ab7f-65bba4a9fee7 | META | 2026-09-16 14:40 | call_vertical_spread | 2 | 1 | 50 | 54600.00 | short | bid | 681.3100 | 0.8500 | ["687.5","695"] | ["0.4638","0.4696"] | ["689.9"] | ["SPHR"] | 687.5000 | 695.0000 | 2 | 2 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:40:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a035-2c58-77d0-bdc4-8a2fbf0318da | META | 2026-09-14 09:57 | call_vertical_spread | 2 | 1 | 380 | 3657500.00 | short | bid | 661.7340 | 2.6000 | ["700","800"] | ["0.4231","0.4300"] | ["728.65"] | ["XPHO"] | 700.0000 | 800.0000 | 158 | 158 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:57:20Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 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 |
| 01a08b86-f408-7c01-8a21-8b4664748e71 | META | 2026-09-10 09:34 | call_vertical_spread | 2 | 1 | 225 | 1329975.00 | short | bid | 657.2201 | 4.8000 | ["650","655"] | ["0.4090","0.4127"] | ["652.35"] | ["SPHR"] | 650.0000 | 655.0000 | 22 | 22 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:34:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0875a-4218-77f2-858c-0486912f3d4c | META | 2026-09-09 14:07 | call_vertical_spread | 2 | 1 | 400 | 244800.00 | unknown | — | 651.5900 | 0.1400 | ["700","705"] | ["0.4252","0.4275"] | [] | ["XBOX"] | 700.0000 | 705.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:07:26Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08261-6e58-7012-865c-ad3f71652483 | META | 2026-09-08 14:56 | call_vertical_spread | 2 | 1 | 5700 | 11764800.00 | short | bid | 616.4100 | 1.0400 | ["650","750"] | ["0.3784","0.4098"] | ["664.80"] | ["XBOX"] | 650.0000 | 750.0000 | 38 | 38 | false | true | false | true | false | mlft | market_whale | 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 |