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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4c8-4a3e-7a31-9409-bc8d90e47b6a | IBIT | 2026-09-21 12:24 | call_vertical_spread | 2 | 1 | 6250 | 2106250.00 | long | ask | 48.6150 | 0.0400 | ["53","63"] | ["0.4252","0.4558"] | ["54.73"] | ["AMXO"] | 53.0000 | 63.0000 | 88 | 88 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:24:25Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c46d-8bc7-7160-84a3-c7713f7404ea | IBIT | 2026-09-21 10:45 | put_frontspread | 2 | 1 | 3000 | 198000.00 | long | ask | 48.6000 | 0.0300 | ["37","43"] | ["0.4891","0.4343"] | ["34.09","42.82"] | ["AMXO"] | 37.0000 | 43.0000 | 60 | 60 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:45:13Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 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 |
| 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 |
| 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 |
| 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 |
| 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 |