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 |
|---|
| 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 |
|---|
| 01a0da20-206f-7a13-9390-f174d408ab5c | RIOT | 2026-09-25 15:52 | iron_butterfly | 4 | 1 | 418 | 101992.00 | unknown | — | 23.0050 | 0.2600 | ["21","23","25"] | ["0.7313","0.7442","0.7780"] | [] | ["XCBO"] | 21.0000 | 25.0000 | 7 | 7 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T19:52:23Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d9c2-f0f6-7302-8c1d-347b93f66a2d | RIOT | 2026-09-25 14:10 | other | 4 | 1 | 2259 | 262044.00 | unknown | — | 22.8400 | 0.0900 | ["23.5","24.5"] | ["1.1209","1.6847"] | [] | ["XPHO"] | 23.5000 | 24.5000 | 0 | 7 | false | true | true | true | |||||||||
| 01a0d9a0-45f6-7e02-842c-b226fbbe1f1b | RIOT | 2026-09-25 13:32 | call_ratio_spread | 2 | 4 | 848 | 120204.00 | unknown | ask | 22.7250 | 0.0700 | ["24","27"] | ["0.7980","0.8023"] | ["24.58","34.26"] | ["AMXO","EDGO","XCBO","XPHO"] | 24.0000 | 27.0000 | 21 | 21 | false | true | |||||||||||
| 01a0d972-2d2f-7153-ba66-3588274c1497 | RIOT | 2026-09-25 12:42 | other | 4 | 1 | 3826 | 1021542.00 | unknown | bid | 22.9200 | 0.4100 | ["22.5","23.5"] | ["0.9272","0.8673"] | [] | ["XPHO"] | 22.5000 | 23.5000 | 0 | 7 | false | false | |||||||||||
| 01a0d4c2-5cd6-72d1-8957-15e21d86ac0a | RIOT | 2026-09-24 14:51 | put_ladder | 3 | 1 | 134 | 122980.00 | unknown | bid | 24.0450 | 2.4000 | ["28","29","30"] | ["2.9668","3.1019","3.9349"] | ["24.55"] | ["XBOX"] | 28.0000 | 30.0000 | 1 | 1 | false | false | |||||||||||
| 01a0d473-c7a7-7832-86f7-5b3aa7af9bee | RIOT | 2026-09-24 13:25 | call_diagonal_spread | 2 | 1 | 600 | 360000.00 | unknown | — | 23.8950 | 0.6000 | ["21","21.5"] | ["1.6206","0.8410"] | [] | ["XISX"] | 21.0000 | 21.5000 | 1 | 15 | 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:10:32Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:33:02Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:42:39Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:52:12Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T17:25:54Z"} |
| 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-18T19:53:49Z"} |
| 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 |
| 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 |
| 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 |
| 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-18T17:40:12Z"} |
| 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-17T18:49:56Z"} |
| 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-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-15T14:23:59Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| 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-14T16:20:47Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| 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 |
| 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 |
| 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 |
| mlet |
| 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-11T14:10:31Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlft |
| 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 |
| mlet |
| 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 |
| 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 |
| 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 |
| 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 |