core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | net_side |
|---|
| 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 |
|---|
| 01a0d8dd-579f-78e3-b424-f45bde94121a | SOFI | 2026-09-25 09:59 | put_diagonal_spread | 2 | 1 | 752 | 122576.00 | short | bid | 16.7750 | 0.0500 | ["17","17.5"] | ["0.4300","1.0989"] | [] | ["XISX"] | 17.0000 | 17.5000 | 0 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T13:59:55Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d8d2-f377-7d70-81f3-6b59da160ca1 | SOFI | 2026-09-25 09:48 | call_vertical_spread | 2 | 1 | 111 | 107226.00 | unknown | bid | 16.6700 | 0.2500 | ["15","17"] | ["0.5745","0.5750"] | ["20.83"] | ["XCBO"] | 15.0000 | 17.0000 | 448 | 448 | false | false | false | true | |||||||||
| 01a0d4ba-4e56-73e2-ab04-9e1ef80f017c | SOFI | 2026-09-24 14:42 | other | 5 | 1 | 1026 | 1848762.00 | unknown | bid | 16.7099 | 0.9000 | ["18","19.5","20","23","45"] | ["0.9169","1.6372","2.2716","0.5950","0.9132"] | [] | ["XBOX"] | 18.0000 | 45.0000 | 1 | 631 | false | false | true | true | |||||||||
| 01a0d4b8-db3f-72c0-939f-48c6426c5555 | SOFI | 2026-09-24 14:41 | put_ladder | 3 | 1 | 2982 | 934986.00 | unknown | bid | 16.7250 | 0.1600 | ["18","18.5","19"] | ["0.9519","1.1080","1.3397"] | ["16.76"] | ["XBOX"] | 18.0000 | 19.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0d435-14df-7d12-a28f-c51bd9db1c43 | SOFI | 2026-09-24 12:17 | put_calendar | 2 | 1 | 124 | 121644.00 | long | bid | 16.5200 | 0.4500 | ["20"] | ["0.5775"] | [] | ["XCBO"] | 20.0000 | 20.0000 | 85 | 449 | false | false | true | false | false | ||||||||
| 01a0d3b6-8287-71d2-a405-8ac431cea592 | SOFI | 2026-09-24 09:59 | call_vertical_spread | 2 | 1 | 200 | 134600.00 | short | bid | 16.2550 | 0.2000 | ["27","30"] | ["0.5796","0.5825"] | ["27.43"] | ["XCBO"] | 27.0000 | 30.0000 | 848 | 848 | false | true | false | true | |||||||||
| 01a0d39c-3810-7b21-9a57-2bf3f995ccae | SOFI | 2026-09-24 09:30 | call_calendar | 2 | 1 | 240 | 147840.00 | short | bid | 16.4500 | 0.2300 | ["15"] | ["0.5471"] | [] | ["XMIO"] | 15.0000 | 15.0000 | 113 | 176 | false | false | true | false | false | ||||||||
| 01a0cfd9-9e47-7570-ba4c-b665349f8264 | SOFI | 2026-09-23 15:58 | call_vertical_spread | 2 | 1 | 200 | 142588.00 | unknown | bid | 16.5250 | 0.2000 | ["27","30"] | ["0.5900","0.5882"] | ["32.06"] | ["XCBO"] | 27.0000 | 30.0000 | 849 | 849 | false | true | false | true | |||||||||
| 01a0cfd9-4087-79d1-9057-5f153247449f | SOFI | 2026-09-23 15:58 | call_diagonal_spread | 2 | 1 | 166 | 137448.00 | long | bid | 16.5250 | 0.2500 | ["12","27"] | ["0.5917","0.5925"] | [] | ["SPHR"] | 12.0000 | 27.0000 | 30 | 814 | false | false | true | true | false | ||||||||
| 01a0cebb-a73f-7f81-851b-664c86ce9601 | SOFI | 2026-09-23 10:46 | put_vertical_spread | 2 | 1 | 390 | 129480.00 | unknown | bid | 16.8200 | 0.0600 | ["16","17"] | ["0.5194","0.5177"] | ["14.84"] | ["EDGO"] | 16.0000 | 17.0000 | 114 | 114 | false | false | false | true | |||||||||
| 01a0ca15-122f-7920-8655-11b05d23430c | SOFI | 2026-09-22 13:06 | call_diagonal_spread | 2 | 1 | 50 | 107450.00 | long | bid | 17.2150 | 0.4000 | ["1","22"] | ["4.4360","0.5931"] | [] | ["XPHO"] | 1.0000 | 22.0000 | 59 | 850 | false | false | true | true | false | ||||||||
| 01a0b5a9-e8bf-7621-8dce-3588a32818d8 | SOFI | 2026-09-18 13:56 | put_diagonal_spread | 2 | 1 | 54 | 142776.00 | unknown | bid | 17.0350 | 0.7500 | ["27","30"] | ["0.6690","0.6830"] | [] | ["BATO"] | 27.0000 | 30.0000 | 819 | 854 | false | false | true | true | |||||||||
| 01a0b542-a727-7fe0-a116-5e0a6006c176 | SOFI | 2026-09-18 12:03 | strangle | 2 | 1 | 1000 | 547000.00 | short | bid | 16.8414 | 0.1500 | ["15","17"] | ["0.5622","0.5802"] | ["9.53","22.47"] | ["ARCO"] | 15.0000 | 17.0000 | 272 | 272 | false | true | false | true | true | ||||||||
| 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 | |||||||||
| 01a0afa5-7973-7ca3-9c4b-7c135688beb0 | SOFI | 2026-09-17 09:54 | put_vertical_spread | 2 | 1 | 175 | 338625.00 | short | bid | 16.7906 | 0.8000 | ["17","30"] | ["0.6052","0.6733"] | ["20.55"] | ["ARCO"] | 17.0000 | 30.0000 | 855 | 855 | false | false | false | true | |||||||||
| 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 | |||||||||
| 01a0ab9a-af33-7f91-909d-571dea509f88 | SOFI | 2026-09-16 15:03 | put_diagonal_spread | 2 | 1 | 100 | 128500.00 | short | bid | 16.7050 | 0.4000 | ["22","24"] | ["2.5155","0.5724"] | [] | ["SPHR"] | 22.0000 | 24.0000 | 2 | 121 | false | false | true | true | false | ||||||||
| 01a0a17f-3888-7172-b87d-6134bd7decd6 | SOFI | 2026-09-14 15:57 | call_diagonal_spread | 2 | 1 | 200 | 138600.00 | short | bid | 17.6550 | 0.2100 | ["25","30"] | ["0.6073","0.6092"] | [] | ["XMIO"] | 25.0000 | 30.0000 | 459 | 858 | false | true | true | true | false | ||||||||
| 01a0a174-ad50-7ea2-aab4-9088fc061036 | SOFI | 2026-09-14 15:46 | call_diagonal_spread | 2 | 1 | 500 | 201500.00 | long | bid | 17.6700 | 0.1000 | ["32","40"] | ["0.6103","0.6191"] | [] | ["XMIO"] | 32.0000 | 40.0000 | 494 | 641 | false | true | true | true | false | ||||||||
| 01a0a059-e2c8-7731-b1a7-6b1be73f34d4 | SOFI | 2026-09-14 10:37 | call_calendar | 2 | 1 | 160 | 196160.00 | short | bid | 17.3500 | 0.4000 | ["18"] | ["0.6194"] | [] | ["XMIO"] | 18.0000 | 18.0000 | 641 | 823 | false | true | true | false | false | ||||||||
| 01a081fd-49a0-7de3-b89c-9f12804d6144 | SOFI | 2026-09-08 13:07 | put_calendar | 2 | 1 | 201 | 195171.00 | short | bid | 18.1650 | 0.3000 | ["23"] | ["0.6913"] | [] | ["XISX"] | 23.0000 | 23.0000 | 10 | 24 | false | false | true | false | false | ||||||||
| 01a06dab-954d-7c43-89c4-610b388f55a1 | SOFI | 2026-09-04 14:25 | call_vertical_spread | 2 | 1 | 300 | 288900.00 | short | bid | 18.3100 | 0.3000 | ["13","14"] | ["1.0799","0.8806"] | ["13.97"] | ["ARCO"] | 13.0000 | 14.0000 | 14 | 14 | false | false | false | true | |||||||||
| 01a06d96-6b55-76f0-a598-746379906085 | SOFI | 2026-09-04 14:02 | call_calendar | 2 | 2 | 1246 | 107755.00 | short | bid | 18.2150 | 0.0500 | ["18.5"] | ["0.7657"] | [] | ["AMXO","XISX"] | 18.5000 | 18.5000 | 0 | 28 | false | true | true | false | false | ||||||||
| 01a06d93-bfbe-7193-bcca-a88e1ba0a263 | SOFI | 2026-09-04 13:59 | call_calendar | 2 | 1 | 1470 | 124950.00 | short | bid | 18.1850 | 0.0300 | ["18.5"] | ["0.7551"] | [] | ["XISX"] | 18.5000 | 18.5000 | 0 | 28 | false | true | true | false | false | ||||||||
| 01a06d52-3e35-7ca0-9fd5-960c0b031d8a | SOFI | 2026-09-04 12:48 | put_calendar | 2 | 1 | 400 | 123200.00 | short | bid | 18.1950 | 0.0900 | ["15"] | ["0.5715"] | [] | ["XMIO"] | 15.0000 | 15.0000 | 133 | 378 | false | true | true | false | false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:48:27Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:43:24Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:41:41Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:17:35Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:59:14Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:30:32Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:59:16Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:58:55Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:47:01Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:06:23Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:56:46Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:04:02Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:54:18Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:04:00Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:57:47Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:46:46Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:37:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:08:18Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:25:55Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:03:22Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:00:05Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:48:56Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |