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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06dbc-1bc5-73b2-93ff-eb0f0ab01fa3 | IBIT | 2026-09-04 14:43 | call_vertical_spread | 2 | 1 | 989 | 298678.00 | long | ask | 45.1200 | 0.0500 | ["50","55"] | ["0.4141","0.4263"] | ["50.98"] | ["XBOX"] | 50.0000 | 55.0000 | 87 | 87 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:44:16Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 01a0a5f0-fd46-7b31-b10f-1ed2473958a6 | IBIT | 2026-09-15 12:40 | call_frontspread | 2 | 2 | 233 | 174190.00 | long | bid | 43.1822 | 0.3000 | ["36","37"] | ["1.1480","1.0821"] | ["43.26"] | ["AMXO"] | 36.0000 | 37.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:40:52Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0aa8d-07f3-7711-9247-4128bb833e0b | IBIT | 2026-09-16 10:09 | straddle | 2 | 1 | 1950 | 2043600.00 | long | ask | 42.7250 | 0.3500 | ["46"] | ["0.4170"] | ["35.52","56.48"] | ["SPHR"] | 46.0000 | 46.0000 | 184 | 184 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:09:26Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa90-3473-7f32-94df-f863ad4d764f | IBIT | 2026-09-16 10:12 | straddle | 2 | 1 | 500 | 193500.00 | long | ask | 42.6701 | 0.0700 | ["44"] | ["0.3792"] | ["40.13","47.87"] | ["SPHR"] | 44.0000 | 44.0000 | 30 | 30 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:13:13Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 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 |
| 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 |
| 01a0b5e1-543f-77b2-97df-d37da9d41710 | IBIT | 2026-09-18 14:57 | call_diagonal_spread | 2 | 1 | 500 | 598000.00 | short | bid | 45.8301 | 0.2000 | ["40","42"] | ["6.7352","0.4093"] | [] | ["SPHR"] | 40.0000 | 42.0000 | 0 | 91 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:57:35Z"} | 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 |
| 01a0b60b-a82f-74b1-8fff-9b2ed0437192 | IBIT | 2026-09-18 15:43 | put_calendar | 2 | 1 | 154 | 125818.00 | short | ask | 46.0100 | 0.2500 | ["50"] | ["4.8755"] | [] | ["SPHR"] | 50.0000 | 50.0000 | 0 | 14 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:43:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 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 |