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 |
|---|
| 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 | true | 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 |
| 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 | 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 | 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 | true | ||||||||||
| 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 | true | ||||||||||
| 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 | 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 | false | ||||||||
| 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 | mlft | |||||||
| 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 | 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 | ||||||||
| 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 | mlft | |||||||
| 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 | mlet | |||||||
| 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 | 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 | 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 | mlet | |||||||
| 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 | mlat | |||||||
| 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 | ||||||||
| 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 | mlet | |||||||
| 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 | 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 | true | ||||||||
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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-14T18:11:24Z"} |
| 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-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-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-11T16:24:08Z"} |
| 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 |
| 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-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-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-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-04T19:53:21Z"} |
| 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-04T19:08:26Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |