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 |
|---|
| 01a0c97b-2bbf-7b33-8512-a4bdb5978d7f | JD | 2026-09-22 10:18 | call_calendar | 2 | 1 | 825 | 177375.00 | short | ask | 27.3600 | 0.2500 | ["26.5"] | ["0.3968"] | [] | ["BATO"] | 26.5000 | 26.5000 | 3 | 10 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T14:18:23Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0b507-672f-7720-bc1f-486720c3c0d7 | JD | 2026-09-18 10:59 | call_calendar | 2 | 1 | 565 | 242385.00 | unknown | ask | 26.9650 | 0.2200 | ["25"] | ["0.8915"] | [] | ["XPHO"] | 25.0000 | 25.0000 | 0 | 28 | false | false | true | false | |||||||||
| 01a0aba5-f9d3-7611-ac32-67f263438670 | JD | 2026-09-16 15:16 | ratio_risk_reversal | 2 | 3 | 7911 | 843750.00 | long | bid | 26.8900 | 0.1800 | ["27","33"] | ["0.3408","0.3860"] | ["26.70"] | ["AMXO","ARCO","XPHO"] | 27.0000 | 33.0000 | 93 | 93 | false | false | false | ||||||||||
| 01a0aba5-f9d3-7611-ac32-67ebbab4cb48 | JD | 2026-09-16 15:16 | ratio_risk_reversal | 2 | 5 | 13011 | 1385798.00 | long | bid | 26.9000 | 0.1800 | ["27","33"] | ["0.3412","0.3853"] | ["26.7"] | ["C2OX","EDGO","XCBO","XMIO","XPHO"] | 27.0000 | 33.0000 | 93 | 93 | false | false | false | ||||||||||
| 01a0aa78-244b-7283-afc9-052287e1097e | JD | 2026-09-16 09:46 | call_ratio_spread | 2 | 1 | 1000 | 119750.00 | unknown | — | 26.8850 | 1.5000 | ["26.5","27"] | ["0.3543","0.3711"] | [] | ["AMXO"] | 26.5000 | 27.0000 | 9 | 9 | false | false | false | true | false | ||||||||
| 01a0a678-bb46-7061-979d-8589409c7d59 | JD | 2026-09-15 15:08 | synthetic | 2 | 3 | 641 | 361524.00 | long | bid | 27.1050 | 0.4090 | ["29"] | ["0.3532"] | ["27.83"] | ["ARCO","MCRY","XBOX"] | 29.0000 | 29.0000 | 185 | 185 | false | false | false | false | |||||||||
| 01a0a644-1e86-7ec3-a77c-dcf3a40e839d | JD | 2026-09-15 14:11 | synthetic | 2 | 5 | 219 | 124830.00 | long | bid | 27.1650 | 0.4073 | ["29"] | ["0.3573"] | ["27.90"] | ["ARCO","EMLD","XBOX","XISX"] | 29.0000 | 29.0000 | 185 | 185 | false | false | false | false | |||||||||
| 01a0a546-9c15-7c10-bd1f-9a96fff12992 | JD | 2026-09-15 09:34 | call_calendar | 2 | 1 | 660 | 459360.00 | unknown | — | 27.3300 | 0.5000 | ["24"] | ["0.6108"] | [] | ["XPHO"] | 24.0000 | 24.0000 | 3 | 31 | false | false | true | false | false | mlet | |||||||
| 01a0a119-3b28-7fe2-8ad2-b897d0c7220d | JD | 2026-09-14 14:06 | synthetic | 2 | 4 | 223 | 128894.00 | long | bid | 27.3811 | 0.7282 | ["29"] | ["0.3601"] | ["28.17"] | ["ARCO","MCRY","XBOX","XMIO"] | 29.0000 | 29.0000 | 186 | 186 | true | false | false | false | |||||||||
| 01a090e4-bb88-7b70-bf8d-61aa541b209e | JD | 2026-09-11 10:35 | put_frontspread | 2 | 1 | 96 | 113920.00 | long | ask | 27.1850 | 0.7500 | ["33","36"] | ["0.3698","0.4448"] | ["26.78"] | ["AMXO"] | 33.0000 | 36.0000 | 98 | 98 | false | false | false | true | |||||||||
| 01a08729-fab8-7680-b962-66f529671fd0 | JD | 2026-09-09 13:14 | other | 2 | 1 | 80 | 102320.00 | unknown | — | 26.9545 | 1.0000 | ["32","33"] | ["0.4327","0.4512"] | [] | ["ARCO"] | 32.0000 | 33.0000 | 44 | 281 | false | false | true | true | false | mlet | |||||||
| 01a08702-98b0-7360-9ec5-2cb68305053d | JD | 2026-09-09 12:31 | other | 2 | 1 | 135 | 191705.00 | unknown | — | 26.9600 | 1.1500 | ["34","35"] | ["0.4931","0.4489"] | [] | ["XISX"] | 34.0000 | 35.0000 | 37 | 499 | false | false | true | true | false | mlet | |||||||
| 01a081d8-f0f0-7d72-b0ca-57dee7f2327d | JD | 2026-09-08 12:27 | risk_reversal | 2 | 4 | 292 | 108132.00 | long | bid | 27.4400 | 0.1100 | ["28","29"] | ["0.3502","0.3596"] | ["27.4"] | ["ARCO","EMLD","SPHR","XBOX"] | 28.0000 | 29.0000 | 101 | 101 | false | false | false | ||||||||||
| 01a081d1-c8e9-7391-8015-8f7d35c59a75 | JD | 2026-09-08 12:20 | strangle | 2 | 7 | 406 | 150616.00 | short | bid | 27.4400 | 0.0600 | ["28","29"] | ["0.3508","0.3602"] | ["24.29","32.71"] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR","XBOX"] | 28.0000 | 29.0000 | 101 | 101 | false | false | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:59:43Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:16:17Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:16:17Z"} |
| 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-16T13:46:40Z"} |
| 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-15T19:08:58Z"} |
| 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-15T18:11:37Z"} |
| 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-15T13:34:23Z"} |
| 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:06:21Z"} |
| 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-11T14:35:19Z"} |
| 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-09T17:14:38Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:31:37Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:28:11Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:20:23Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |