core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_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 | ||||||||
| 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 | ||||||||||
| 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 | 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 | 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 | ||||||||
| 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 | |||||||
| 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 |
| 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 |
| 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 |
| 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: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-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 |