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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b60d-e27f-72b3-af01-bab1f1c7289a | IBIT | 2026-09-18 15:45 | call_diagonal_spread | 2 | 2 | 1703 | 127725.00 | unknown | ask | 45.9901 | 0.0300 | ["46","50"] | ["1.1039","0.3815"] | [] | ["AMXO"] | 46.0000 | 50.0000 | 0 | 28 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:46:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5fe-f62f-7d71-bd9c-e2b03101a0f8 | IBIT | 2026-09-18 15:29 | put_ratio_spread | 2 | 3 | 3000 | 278500.00 | unknown | — | 46.0450 | 0.0400 | ["37","43"] | ["0.4475","0.3968"] | [] | ["AMXO"] | 37.0000 | 43.0000 | 63 | 63 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:29:40Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0b0-a013-79d1-a1b0-7dfba874ebef | IBIT | 2026-09-17 14:45 | other | 3 | 1 | 336 | 897840.00 | unknown | — | 43.3650 | 0.4500 | ["48","50","100"] | ["1.2225","1.5953","1.0389"] | [] | ["XBOX"] | 48.0000 | 100.0000 | 1 | 120 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:46:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0ac-71c3-7842-93b3-e465599c6ed8 | IBIT | 2026-09-17 14:41 | put_ladder | 5 | 1 | 1244 | 1266872.00 | unknown | — | 43.2950 | 0.5000 | ["47","49","50","52","55"] | ["0.9651","1.3389","1.5132","1.8420","2.2955"] | [] | ["XBOX"] | 47.0000 | 55.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:41:47Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a5f0-fd46-7b31-b10f-1ee2d611053b | IBIT | 2026-09-15 12:40 | other | 5 | 5 | 827 | 629780.00 | unknown | — | 43.1822 | 0.3200 | ["29","30","36","37"] | ["0.8721","0.8340","0.6178","0.8388"] | [] | ["AMXO"] | 29.0000 | 37.0000 | 3 | 17 | false | false | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:40:52Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5dd-b3c6-7d30-acf4-90d69470b31b | IBIT | 2026-09-15 12:19 | other | 5 | 4 | 1156 | 1049768.00 | unknown | — | 43.2200 | 0.3700 | ["30","39","40"] | ["0.8081","0.5809","0.5492"] | [] | ["AMXO"] | 30.0000 | 40.0000 | 3 | 17 | false | false | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:19:46Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a061-5cd8-7561-aebd-6ad1fd2d49db | IBIT | 2026-09-14 10:45 | other | 4 | 4 | 3250 | 1813500.00 | unknown | — | 44.4200 | 0.0800 | ["44"] | ["0.4039"] | [] | ["AMXO"] | 44.0000 | 44.0000 | 4 | 32 | false | false | true | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:45:31Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08cee-2cf8-7371-9ce0-ec811c00ef06 | IBIT | 2026-09-10 16:06 | other | 2 | 1 | 100 | 773200.00 | unknown | — | 43.6600 | 6.7500 | ["65","100"] | ["0.6024","0.9582"] | [] | ["XPHO"] | 65.0000 | 100.0000 | 43 | 127 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T20:07:38Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cb5-d330-7bc0-9b49-fea524262987 | IBIT | 2026-09-10 15:05 | other | 7 | 1 | 278 | 794300.00 | unknown | — | 43.6650 | 1.0000 | ["47.5","48","49","50","52","53","100"] | ["1.0550","1.1551","1.3475","1.2384","1.5376","1.6800","0.9796"] | [] | ["XBOX"] | 47.5000 | 100.0000 | 1 | 127 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:05:25Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c8a-e6e8-7313-a394-307b227429b9 | IBIT | 2026-09-10 14:18 | call_vertical_spread | 2 | 1 | 100 | 174000.00 | unknown | — | 43.5700 | 0.8700 | ["40","100"] | ["0.5214","0.5165"] | [] | ["SPHR"] | 40.0000 | 100.0000 | 645 | 645 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:18:43Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bd8-7739-7f62-8238-5ca1a7e7b80a | IBIT | 2026-09-10 11:03 | put_vertical_spread | 2 | 2 | 600 | 161400.00 | unknown | — | 43.7500 | 0.1100 | ["30","36"] | ["0.4895","0.4467"] | [] | ["AMXO"] | 30.0000 | 36.0000 | 190 | 190 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:03:57Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087a1-fd60-7433-8fba-c07756cb5b09 | IBIT | 2026-09-09 15:25 | call_vertical_spread | 2 | 1 | 1200 | 271200.00 | unknown | — | 44.4700 | 0.0400 | ["45.5","49"] | ["0.3960","0.4050"] | [] | ["SPHR"] | 45.5000 | 49.0000 | 30 | 30 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:25:50Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08208-d2c0-7150-a86d-bd06e37fe00b | IBIT | 2026-09-08 13:20 | synthetic | 2 | 1 | 5000 | 1575000.00 | unknown | — | 44.4950 | 0.0500 | ["45"] | ["0.4069"] | [] | ["XBOX"] | 45.0000 | 45.0000 | 17 | 17 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:20:23Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |