core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext |
|---|
| 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 |
|---|
| 01a08749-bf88-7f50-bc45-659c38d55650 | SPCX | 2026-09-09 13:49 | straddle | 2 | 1 | 100 | 490792.00 | long | ask | 147.1200 | 0.6000 | ["160"] | ["0.5534"] | ["110.92","209.08"] | ["EDGO"] | 160.0000 | 160.0000 | 191 | 191 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:50:02Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0820d-fef8-7500-980f-b747fdfe6042 | SPCX | 2026-09-08 13:25 | straddle | 2 | 1 | 50 | 268000.00 | long | ask | 152.7701 | 0.6500 | ["170"] | ["0.5729"] | ["116.40","223.60"] | ["EDGO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | ||||||||
| 01a0820d-eb70-7b23-ad33-217c2f2bcdf9 | SPCX | 2026-09-08 13:25 | straddle | 2 | 1 | 49 | 262640.00 | long | ask | 152.8200 | 0.7000 | ["170"] | ["0.5729"] | ["116.40","223.60"] | ["EDGO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | ||||||||
| 01a0820d-37c0-77a1-a891-903ef2847e27 | SPCX | 2026-09-08 13:24 | straddle | 2 | 1 | 50 | 268000.00 | long | ask | 152.9050 | 0.5500 | ["170"] | ["0.5729"] | ["116.40","223.60"] | ["EDGO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | ||||||||
| 01a0820d-1c68-7221-b694-dc19f17283b2 | SPCX | 2026-09-08 13:24 | straddle | 2 | 1 | 38 | 203528.00 | long | ask | 152.9250 | 0.5000 | ["170"] | ["0.5724"] | ["116.44","223.56"] | ["EDGO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | ||||||||
| 01a0820d-1880-7d13-833a-6e1ef02f684a | SPCX | 2026-09-08 13:24 | straddle | 2 | 1 | 20 | 107000.00 | short | bid | 152.9250 | 0.3500 | ["170"] | ["0.5717"] | ["116.50","223.50"] | ["XMIO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | ||||||||
| 01a0820d-10b0-7dc1-9b2b-ae09089a2d95 | SPCX | 2026-09-08 13:24 | straddle | 2 | 1 | 22 | 117700.00 | short | bid | 152.9350 | 0.2000 | ["170"] | ["0.5717"] | ["116.50","223.50"] | ["EDGO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | ||||||||
| 01a0820d-08e0-7e01-83d4-fd4cc2854099 | SPCX | 2026-09-08 13:24 | straddle | 2 | 1 | 5 | 26750.00 | short | bid | 152.9300 | 0.4000 | ["170"] | ["0.5717"] | ["116.50","223.50"] | ["XMIO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | ||||||||
| 01a0820c-8410-76a2-ae01-31e8e326a758 | SPCX | 2026-09-08 13:24 | straddle | 2 | 1 | 5 | 26750.00 | short | bid | 152.9745 | 0.4000 | ["170"] | ["0.5717"] | ["116.50","223.50"] | ["XMIO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | ||||||||
| 01a0820b-dc18-7972-8ba2-a0efb77f5ab8 | SPCX | 2026-09-08 13:23 | straddle | 2 | 1 | 6 | 32100.00 | unknown | — | 152.9650 | 0.2000 | ["170"] | ["0.5717"] | [] | ["EDGO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | mlet | |||||||
| 01a0820b-8628-7490-9835-e3f4af215e37 | SPCX | 2026-09-08 13:23 | straddle | 2 | 1 | 7 | 37450.00 | unknown | — | 152.8800 | 0.3000 | ["170"] | ["0.5717"] | [] | ["EDGO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | mlet | |||||||
| 01a0820b-8240-71a1-949d-974e51372838 | SPCX | 2026-09-08 13:23 | straddle | 2 | 2 | 20 | 107000.00 | long | ask | 152.8800 | 0.2500 | ["170"] | ["0.5717"] | ["116.50","223.50"] | ["EDGO","XMIO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | ||||||||
| 01a0820b-2868-76a3-8b84-2ac1d3141500 | SPCX | 2026-09-08 13:22 | straddle | 2 | 3 | 30 | 160500.00 | long | ask | 152.8500 | 0.3500 | ["170"] | ["0.5717"] | ["116.50","223.50"] | ["XBOX","XMIO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | ||||||||
| 01a0820b-2868-76a3-8b84-2aa8898604d2 | SPCX | 2026-09-08 13:22 | straddle | 2 | 1 | 22 | 117700.00 | long | ask | 152.8700 | 0.3500 | ["170"] | ["0.5717"] | ["116.50","223.50"] | ["EDGO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | ||||||||
| 01a0820a-8071-7b11-aaaa-526f5b2ac4cc | SPCX | 2026-09-08 13:21 | straddle | 2 | 1 | 126 | 674100.00 | long | ask | 152.9897 | 0.8000 | ["170"] | ["0.5718"] | ["116.50","223.50"] | ["EDGO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | ||||||||
| 01a0820a-0370-7750-9c7e-2335169745b9 | SPCX | 2026-09-08 13:21 | straddle | 2 | 1 | 61 | 325740.00 | long | ask | 152.7650 | 0.8500 | ["170"] | ["0.5706"] | ["116.60","223.40"] | ["EDGO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | ||||||||
| 01a08209-d0a8-78c1-8761-028ed1787aec | SPCX | 2026-09-08 13:21 | straddle | 2 | 1 | 43 | 229405.00 | unknown | — | 152.7700 | 0.7000 | ["170"] | ["0.5700"] | [] | ["XMIO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | mlet | |||||||
| 01a08209-b550-7151-950d-2b5ce8b8316b | SPCX | 2026-09-08 13:21 | straddle | 2 | 1 | 32 | 170560.00 | long | ask | 152.8150 | 1.2500 | ["170"] | ["0.5695"] | ["116.70","223.30"] | ["EDGO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true | ||||||||
| 01a08209-b550-7151-950d-2b4c616a7877 | SPCX | 2026-09-08 13:21 | straddle | 2 | 1 | 39 | 207870.00 | long | ask | 152.8150 | 1.4500 | ["170"] | ["0.5695"] | ["116.70","223.30"] | ["EDGO"] | 170.0000 | 170.0000 | 192 | 192 | false | false | false | false | true |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:26: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-08T17:26: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-08T17:25:27Z"} |
| 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-08T17:25:27Z"} |
| 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-08T17:25:27Z"} |
| 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-08T17:25:27Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:25:27Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:24:40Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:23:47Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:23:47Z"} |
| 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-08T17:23:47Z"} |
| 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-08T17:23:01Z"} |
| 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-08T17:23:01Z"} |
| 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-08T17:22:04Z"} |
| 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-08T17:22:04Z"} |
| 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-08T17:22:04Z"} |
| 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-08T17:21:13Z"} |
| 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-08T17:21:13Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |