core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↑timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| 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 |
|---|
| 01a06dd2-6e9d-7072-a80e-6b7b6f009e39 | RIOT | 2026-09-04 15:08 | call_vertical_spread | 2 | 1 | 2059 | 955376.00 | unknown | — | 21.5950 | 0.3000 | ["19","19.5"] | ["9.1230","7.3543"] | [] | ["EDGO"] | 19.0000 | 19.5000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:08:26Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06ddb-406d-70b2-ade5-eaafe49e0b9d | RIOT | 2026-09-04 15:17 | call_diagonal_spread_bearish | 2 | 1 | 618 | 220008.00 | short | bid | 21.6250 | 0.1100 | ["20","20.5"] | ["4.1511","0.7731"] | [] | ["XISX"] | 20.0000 | 20.5000 | 0 | 14 | false | false | |||||||||||
| 01a06dfb-6eb5-7751-902a-329b769e396a | RIOT | 2026-09-04 15:53 | iron_butterfly | 4 | 1 | 454 | 107598.00 | unknown | — | 21.6250 | 0.2500 | ["20","22","24"] | ["0.7400","0.7589","0.8149"] | [] | ["XCBO"] | 20.0000 | 24.0000 | 7 | 7 | false | false | false | true | |||||||||
| 01a08136-1d59-7860-bffb-06fc580d534a | RIOT | 2026-09-08 09:30 | call_vertical_spread | 2 | 1 | 50 | 120700.00 | unknown | — | 21.7900 | 1.9000 | ["13","15"] | ["0.9148","0.8984"] | [] | ["XPHO"] | 13.0000 | 15.0000 | 500 | 500 | false | false | false | true | |||||||||
| 01a08be5-9e69-7ba0-8eae-a9e92d50cd03 | RIOT | 2026-09-10 11:17 | other | 2 | 1 | 618 | 222480.00 | unknown | — | 21.4900 | 0.2000 | ["20.5","21"] | ["0.8221","0.8278"] | [] | ["XISX"] | 20.5000 | 21.0000 | 8 | 22 | false | false | true | true | false | ||||||||
| 01a08c98-0261-7b72-835e-8b7e3bb6575a | RIOT | 2026-09-10 14:32 | other | 3 | 1 | 120 | 113600.00 | unknown | — | 21.1400 | 3.5000 | ["25","26","28"] | ["2.5009","2.6225","6.5612"] | [] | ["XBOX"] | 25.0000 | 28.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a090ce-3db8-7cb3-b4e6-9373f43ee689 | RIOT | 2026-09-11 10:10 | other | 2 | 1 | 247 | 132886.00 | unknown | — | 21.6400 | 0.7700 | ["20","21"] | ["0.8136","0.8616"] | [] | ["XCBO"] | 20.0000 | 21.0000 | 14 | 49 | false | false | true | true | false | ||||||||
| 01a090d0-2600-7d11-a434-fc74dfbab3fa | RIOT | 2026-09-11 10:12 | other | 2 | 1 | 275 | 148775.00 | unknown | — | 21.6050 | 0.7200 | ["20","21"] | ["0.8381","0.8752"] | [] | ["MCRY"] | 20.0000 | 21.0000 | 14 | 49 | false | false | true | true | false | ||||||||
| 01a09148-3078-7bb1-81ce-4d1213803048 | RIOT | 2026-09-11 12:23 | other | 4 | 1 | 8425 | 1390125.00 | unknown | — | 21.5800 | 0.2000 | ["20","20.5","21","22"] | ["2.2775","0.7786","1.1533","0.7684"] | [] | ["XPHO"] | 20.0000 | 22.0000 | 0 | 7 | false | false | true | true | |||||||||
| 01a091ea-38f0-76e3-bb49-111043942975 | RIOT | 2026-09-11 15:20 | other | 4 | 1 | 2017 | 185564.00 | unknown | — | 21.3400 | 0.1100 | ["21.5","22","22.5","23"] | ["1.1867","0.7135","3.4507","0.7387"] | [] | ["XPHO"] | 21.5000 | 23.0000 | 0 | 7 | false | true | true | true | |||||||||
| 01a0a046-b4a0-79d0-9899-3ccc87c3e400 | RIOT | 2026-09-14 10:16 | other | 2 | 1 | 4870 | 810855.00 | unknown | — | 21.0299 | 0.2200 | ["22","25"] | ["0.8244","0.8371"] | [] | ["MCRY"] | 22.0000 | 25.0000 | 32 | 32 | false | true | false | true | false | ||||||||
| 01a0a0b8-3350-7961-99e1-ca2c28bb43ec | RIOT | 2026-09-14 12:20 | other | 2 | 1 | 2000 | 465000.00 | unknown | — | 20.9800 | 0.1900 | ["23","28"] | ["0.8572","0.8667"] | [] | ["XPHO"] | 23.0000 | 28.0000 | 67 | 67 | true | true | false | true | false | ||||||||
| 01a0a11d-80e8-78b2-a596-c0e71d87fc20 | RIOT | 2026-09-14 14:10 | call_calendar | 2 | 1 | 618 | 176748.00 | unknown | — | 21.0650 | 0.1900 | ["21"] | ["0.8328"] | [] | ["BATO"] | 21.0000 | 21.0000 | 11 | 18 | false | false | true | false | false | ||||||||
| 01a0a573-a756-7f60-8bc5-21e097dab947 | RIOT | 2026-09-15 10:23 | put_vertical_spread | 2 | 1 | 5000 | 2865000.00 | unknown | — | 20.1900 | 0.5400 | ["10","15"] | ["0.8945","0.8693"] | [] | ["SPHR"] | 10.0000 | 15.0000 | 493 | 493 | false | true | false | true | |||||||||
| 01a0aabc-becb-7e71-8b1d-4f95c7f33b09 | RIOT | 2026-09-16 11:01 | other | 2 | 1 | 500 | 140500.00 | unknown | — | 20.4950 | 0.3400 | ["18","25"] | ["0.8251","0.8306"] | [] | ["SPHR"] | 18.0000 | 25.0000 | 30 | 93 | false | true | true | true | true | ||||||||
| 01a0b0b4-3223-7c22-904a-42e1464ed112 | RIOT | 2026-09-17 14:49 | put_ladder | 3 | 1 | 1002 | 980540.00 | unknown | — | 21.7250 | 2.9500 | ["26","27","28"] | ["2.2522","2.8701","8.1723"] | [] | ["XBOX"] | 26.0000 | 28.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0b55f-08c8-7c33-8cbd-22acf58419b2 | RIOT | 2026-09-18 12:34 | risk_reversal | 2 | 1 | 399 | 142842.00 | short | bid | 23.0067 | 0.1400 | ["22","23"] | ["0.8120","0.7981"] | ["23.54"] | ["XPHO"] | 22.0000 | 23.0000 | 28 | 28 | false | false | |||||||||||
| 01a0b59a-44d7-7380-b179-2919cd998e2a | RIOT | 2026-09-18 13:39 | other | 4 | 1 | 8512 | 1710912.00 | unknown | bid | 23.0250 | 0.1500 | ["20.5","22","22.5","23.5"] | ["4.5264","1.8577","0.7859","0.7509"] | [] | ["AMXO"] | 20.5000 | 23.5000 | 0 | 7 | false | false | |||||||||||
| 01a0b5a4-a12f-7560-ba28-743de96ebc2b | RIOT | 2026-09-18 13:50 | other | 4 | 1 | 1981 | 580433.00 | unknown | ask | 23.2450 | 0.1700 | ["22","23","23.5","24.5"] | ["2.1077","1.1762","0.7471","0.7581"] | [] | ["AMXO"] | 22.0000 | 24.5000 | 0 | 7 | false | false | |||||||||||
| 01a0b5b5-623f-7cb3-93ad-0776e9d5e38e | RIOT | 2026-09-18 14:09 | other | 4 | 1 | 379 | 297894.00 | unknown | bid | 23.4700 | 0.7100 | ["20","20.5","23.5","24.5"] | ["7.6351","6.7031","0.7760","0.8006"] | [] | ["XPHO"] | 20.0000 | 24.5000 | 0 | 7 | false | false | |||||||||||
| 01a0b5cd-9d5f-7630-8a9e-5bb9e89a8ca7 | RIOT | 2026-09-18 14:35 | put_diagonal_spread | 2 | 1 | 250 | 162500.00 | short | bid | 23.3800 | 0.1400 | ["23","25"] | ["0.8335","0.8038"] | [] | ["XISX"] | 23.0000 | 25.0000 | 28 | 91 | false | false | |||||||||||
| 01a0b5ce-b2b7-7000-b465-c7882d392d51 | RIOT | 2026-09-18 14:36 | call_vertical_spread | 2 | 1 | 978 | 192666.00 | unknown | bid | 23.4150 | 0.1400 | ["22.5","25"] | ["0.7685","0.7972"] | ["24.47"] | ["ARCO"] | 22.5000 | 25.0000 | 7 | 7 | false | false | |||||||||||
| 01a0b5d1-98e8-78b0-a077-117ebb6da14c | RIOT | 2026-09-18 14:40 | put_diagonal_spread | 2 | 1 | 179 | 137830.00 | long | ask | 23.3650 | 0.3000 | ["23","26"] | ["0.8298","0.8144"] | [] | ["XISX"] | 23.0000 | 26.0000 | 28 | 119 | false | false | |||||||||||
| 01a0b5db-495f-7a53-98c3-f1e760d21c85 | RIOT | 2026-09-18 14:50 | call_vertical_spread | 2 | 2 | 965 | 196175.00 | short | bid | 23.4750 | 0.0907 | ["22.5","25"] | ["0.7609","0.8088"] | ["23.55"] | ["AMXO"] | 22.5000 | 25.0000 | 7 | 7 | false | false | |||||||||||
| 01a0b5fa-6637-7201-bfbe-3b6bec3cd1e9 | RIOT | 2026-09-18 15:24 | call_diagonal_spread | 2 | 1 | 350 | 339500.00 | short | bid | 23.7050 | 0.5000 | ["21","23"] | ["0.8616","0.8372"] | [] | ["XISX"] | 21.0000 | 23.0000 | 63 | 119 | false | false | |||||||||||
| 01a0b600-a3e0-79a2-a320-130c617d35b2 | RIOT | 2026-09-18 15:31 | call_diagonal_spread | 2 | 1 | 510 | 225052.00 | unknown | — | 23.7350 | 0.4300 | ["21","24"] | ["7.4222","0.7971"] | [] | ["XCBO"] | 21.0000 | 24.0000 | 0 | 28 | false | false | true | true | |||||||||
| 01a0b614-df8f-7650-a840-717d6c225f02 | RIOT | 2026-09-18 15:53 | iron_butterfly | 4 | 1 | 396 | 110880.00 | unknown | — | 24.0000 | 0.3300 | ["21.5","23.5","25.5"] | ["0.7462","0.7813","0.8269"] | [] | ["XCBO"] | 21.5000 | 25.5000 | 7 | 7 | false | false | false | true | |||||||||
| 01a0c98b-cd8f-71a2-8fa1-014a40f80ef8 | RIOT | 2026-09-22 10:36 | call_diagonal_spread | 2 | 1 | 500 | 168000.00 | short | bid | 25.2750 | 0.1800 | ["27","30"] | ["0.8175","0.8543"] | [] | ["XISX"] | 27.0000 | 30.0000 | 24 | 59 | false | true |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:18:22Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:53:21Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:30:01Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:18:12Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:33:02Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:10:31Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:12:48Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:24:08Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:20:43Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:16:23Z"} |
| 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-14T16:20:47Z"} |
| 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-14T18:11:24Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:23:59Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:01:56Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:49:56Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:35:18Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:40:12Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:51:21Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:09:21Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:36:18Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:37:27Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:40:21Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:51:00Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:24:45Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:31:35Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:53:49Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:36:21Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |