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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b520-abef-7eb2-aab8-9472d74b2377 | SOFI | 2026-09-18 11:26 | call_butterfly_spread | 3 | 1 | 5000 | 1117514.00 | unknown | bid | 16.9164 | 0.2700 | ["40","45","47"] | ["0.6154","0.6262","0.6317"] | ["42.79"] | ["XPHO"] | 40.0000 | 47.0000 | 455 | 455 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:27:02Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0a3-abab-73a0-8326-ac7960fa85d4 | SOFI | 2026-09-17 14:31 | other | 4 | 1 | 735 | 1340250.00 | unknown | — | 16.7950 | 0.5000 | ["22","24","25","32"] | ["2.9409","3.6731","1.4999","0.8625"] | [] | ["XBOX"] | 22.0000 | 32.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:32:30Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a3-3293-75f3-867b-5959eeefd42e | SOFI | 2026-09-17 14:31 | put_vertical_spread | 2 | 1 | 2362 | 3188700.00 | unknown | — | 16.7900 | 0.2000 | ["22","25"] | ["2.8836","3.9352"] | [] | ["XBOX"] | 22.0000 | 25.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:31:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a3-1b23-75f2-8a50-14b75db672e3 | SOFI | 2026-09-17 14:31 | other | 4 | 1 | 15000 | 8234000.00 | unknown | — | 16.7950 | 0.3700 | ["19","20","22","22.5"] | ["1.4222","1.8793","2.9409","3.1333"] | [] | ["XBOX"] | 19.0000 | 22.5000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:31:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a2-e473-7ce3-877a-58fedeee01d5 | SOFI | 2026-09-17 14:30 | put_ladder | 3 | 1 | 1350 | 1199204.00 | unknown | — | 16.7950 | 0.2800 | ["19.5","21","22"] | ["1.7617","2.5338","2.8905"] | [] | ["XBOX"] | 19.5000 | 22.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:30:58Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a2-c533-7e21-8aa5-ed0ac4d64b89 | SOFI | 2026-09-17 14:30 | other | 3 | 1 | 5298 | 18102300.00 | unknown | — | 16.7950 | 0.6000 | ["22","23","47"] | ["2.9409","3.3191","0.9323"] | [] | ["XBOX"] | 22.0000 | 47.0000 | 1 | 638 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:30:58Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa4-e11b-7543-993c-b770ae8823d6 | SOFI | 2026-09-17 09:53 | put_vertical_spread | 2 | 1 | 225 | 435600.00 | short | bid | 16.8200 | 0.8000 | ["17","30"] | ["0.6096","0.6727"] | ["20.60"] | ["SPHR"] | 17.0000 | 30.0000 | 855 | 855 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:53:42Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a09123-c058-7fa2-88f4-8e62034042b5 | SOFI | 2026-09-11 11:43 | call_calendar | 2 | 1 | 402 | 273360.00 | short | ask | 17.3650 | 0.1000 | ["14"] | ["3.2157"] | [] | ["SPHR"] | 14.0000 | 14.0000 | 0 | 14 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:44:25Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cb3-42f0-7c30-ba40-4267e423e20c | SOFI | 2026-09-10 15:02 | other | 8 | 1 | 878 | 620340.00 | unknown | — | 17.2450 | 0.8300 | ["19.5","20","20.5","21","21.5","22","24","27"] | ["1.5882","1.6366","2.0633","2.2837","2.4946","2.6971","3.4376","0.9592"] | [] | ["XBOX"] | 19.5000 | 27.0000 | 1 | 36 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:02:56Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |