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 | directiontext | net_side |
|---|
| 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 |
|---|
| 01a0817e-e629-7ef2-86a0-7e32810d5d1e | DRAM | 2026-09-08 10:49 | call_vertical_spread | 2 | 2 | 200 | 591200.00 | unknown | — | 61.4000 | 0.9000 | ["45","60"] | ["0.6562","0.6449"] | [] | ["AMXO"] | 45.0000 | 60.0000 | 129 | 129 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:49:40Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0816a-6fe0-7cb1-bd9c-d385a4289581 | DRAM | 2026-09-08 10:27 | call_vertical_spread | 2 | 1 | 133 | 110523.00 | long | ask | 61.2550 | 0.2200 | ["60","70"] | ["0.6620","0.6698"] | ["63.55"] | ["MCRY"] | 60.0000 | 70.0000 | 38 | 38 | false | false | false | true | |||||||||
| 01a08163-dc49-7fb3-be9b-3c3385865d3c | DRAM | 2026-09-08 10:19 | call_diagonal_spread | 2 | 1 | 190 | 118180.00 | long | ask | 61.0382 | 0.3500 | ["67","75"] | ["0.6670","0.6773"] | [] | ["XISX"] | 67.0000 | 75.0000 | 38 | 73 | false | true | true | true | false | ||||||||
| 01a0814c-5ca8-7723-aff8-0a1b6891504d | DRAM | 2026-09-08 09:54 | other | 2 | 1 | 150 | 350925.00 | unknown | — | 61.2200 | 2.0500 | ["40","50"] | ["0.6903","0.7827"] | [] | ["BATO"] | 40.0000 | 50.0000 | 10 | 164 | false | false | true | true | false | mlet | |||||||
| 01a08144-cf10-7a30-89b8-a408a4e3b8f2 | DRAM | 2026-09-08 09:46 | put_calendar | 2 | 1 | 232 | 115304.00 | short | bid | 61.1400 | 0.3800 | ["60"] | ["0.6665"] | [] | ["XMIO"] | 60.0000 | 60.0000 | 10 | 17 | false | true | true | false | false | ||||||||
| 01a08144-55f8-7571-a38d-6e3655530a8b | DRAM | 2026-09-08 09:45 | put_calendar | 2 | 1 | 250 | 124250.00 | short | ask | 61.0825 | 0.2500 | ["60"] | ["0.6612"] | [] | ["XMIO"] | 60.0000 | 60.0000 | 10 | 17 | false | true | true | false | false | ||||||||
| 01a08142-1ba8-7b53-b095-c2140f890d97 | DRAM | 2026-09-08 09:43 | strangle | 2 | 4 | 1027 | 306723.00 | short | bid | 61.0900 | 0.0600 | ["55","62"] | ["0.7054","0.6700"] | ["52.01","64.99"] | ["AMXO","XCBO","XISX","XPHO"] | 55.0000 | 62.0000 | 10 | 10 | false | true | false | true | true | ||||||||
| 01a08138-6b31-71b3-a407-050d932769dd | DRAM | 2026-09-08 09:32 | put_diagonal_spread | 2 | 2 | 725 | 297975.00 | long | ask | 61.3612 | 0.5500 | ["59","59.5"] | ["0.6395","0.6887"] | [] | ["AMXO"] | 59.0000 | 59.5000 | 10 | 17 | false | true | true | true | false | ||||||||
| 01a06e01-75ae-75b0-a622-3ea401250a30 | DRAM | 2026-09-04 15:59 | call_diagonal_spread_bearish | 2 | 1 | 50 | 125850.00 | long | bid | 59.7550 | 2.6500 | ["60","80"] | ["0.6095","0.6247"] | [] | ["ARCO"] | 60.0000 | 80.0000 | 259 | 504 | false | true | true | true | |||||||||
| 01a06dbc-759d-73d3-863c-03cbc0ad1b1d | DRAM | 2026-09-04 14:44 | call_ratio_spread | 2 | 2 | 1500 | 210472.00 | long | ask | 59.1650 | 1.0100 | ["88","115"] | ["0.6163","0.6632"] | ["128.52"] | ["EDGO","XBOX"] | 88.0000 | 115.0000 | 133 | 133 | false | true | false | true | |||||||||
| 01a06d8c-e1ed-7822-a747-ebccf0ab4b30 | DRAM | 2026-09-04 13:52 | call_ratio_spread | 2 | 1 | 162 | 173502.00 | long | ask | 58.8700 | 1.4000 | ["90","122"] | ["0.6209","0.6280"] | ["155.70"] | ["XISX"] | 90.0000 | 122.0000 | 504 | 504 | false | true | false | true | false | ||||||||
| 01a06d82-5a9d-72e0-9068-fc468a5f2aac | DRAM | 2026-09-04 13:40 | risk_reversal | 2 | 1 | 800 | 171200.00 | long | bid | 58.9000 | 0.1300 | ["49","75"] | ["0.6250","0.6361"] | ["48.82"] | ["AMXO"] | 49.0000 | 75.0000 | 42 | 42 | false | true | false | true | true | ||||||||
| 01a06d78-4c65-7bb2-b06e-c102bd1227fa | DRAM | 2026-09-04 13:29 | call_vertical_spread | 2 | 1 | 500 | 152000.00 | unknown | — | 58.8700 | 0.0500 | ["60","65"] | ["0.5885","0.5922"] | [] | ["EDGO"] | 60.0000 | 65.0000 | 14 | 14 | false | true | false | true | false | mlet | |||||||
| 01a06d53-bd05-7461-bcaa-ee5119af607b | DRAM | 2026-09-04 12:49 | call_diagonal_spread_bearish | 2 | 2 | 33 | 141306.00 | long | ask | 59.1800 | 1.2333 | ["40","50"] | ["0.6282","0.6153"] | [] | ["EMLD","XBOX"] | 40.0000 | 50.0000 | 133 | 504 | false | false | true | true | |||||||||
| 01a06d31-f496-7ad2-b650-92f300281a51 | DRAM | 2026-09-04 12:13 | call_vertical_spread | 2 | 1 | 150 | 100500.00 | long | ask | 58.9900 | 0.1600 | ["60","65"] | ["0.5749","0.5717"] | ["61.80"] | ["XMIO"] | 60.0000 | 65.0000 | 42 | 42 | false | true | false | true | |||||||||
| 01a06d2e-ef25-7521-81ac-35f71b68b162 | DRAM | 2026-09-04 12:09 | risk_reversal | 2 | 4 | 998 | 237124.00 | long | ask | 58.9100 | 0.0200 | ["55","62"] | ["0.5676","0.5493"] | ["62.35"] | ["AMXO","XCBO","XISX","XPHO"] | 55.0000 | 62.0000 | 14 | 14 | false | true | false | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:27:11Z"} |
| 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-08T14:20:14Z"} |
| 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-08T13:54:31Z"} |
| 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-08T13:46:19Z"} |
| 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-08T13:45:38Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:43:12Z"} |
| 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-08T13:32:32Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:59:49Z"} |
| 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-04T18:44:57Z"} |
| 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-04T17:53:05Z"} |
| 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-04T17:41:43Z"} |
| 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-04T17:30:19Z"} |
| 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-04T16:50:23Z"} |
| 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-04T16:13:11Z"} |
| 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-04T16:09:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |