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 |
|---|
| 01a08740-ab50-79f0-b14a-2f32830a9e70 | IYR | 2026-09-09 13:39 | put_calendar | 2 | 1 | 262 | 260166.00 | long | bid | 100.9750 | 3.9000 | ["105"] | ["0.1905"] | [] | ["C2OX"] | 105.0000 | 105.0000 | 37 | 72 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:39:15Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08c8e-55d0-7a73-9078-f2cd8cb5cdb5 | IYR | 2026-09-10 14:22 | put_vertical_spread | 2 | 1 | 1000 | 356931.00 | short | bid | 99.9800 | 0.5500 | ["100","101"] | ["0.1913","0.1997"] | ["100.39"] | ["AMXO"] | 100.0000 | 101.0000 | 15 | 15 | false | false | false | true | |||||||||
| 01a08ca0-f370-73f1-a326-9db080322ca3 | IYR | 2026-09-10 14:42 | put_vertical_spread | 2 | 1 | 1000 | 178000.00 | short | bid | 99.9400 | 0.4000 | ["96","100"] | ["0.1930","0.1915"] | ["98.78"] | ["XPHO"] | 96.0000 | 100.0000 | 15 | 15 | false | false | false | true | |||||||||
| 01a0c430-117f-7513-b3cd-262717f69c59 | IYR | 2026-09-21 09:37 | put_vertical_spread | 2 | 1 | 1107 | 560142.00 | short | bid | 98.6100 | 1.1000 | ["90","101"] | ["0.2054","0.1822"] | ["97.50"] | ["SPHR"] | 90.0000 | 101.0000 | 88 | 88 | false | false | false | true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:22:29Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:43:02Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:37:58Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |