core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 01a0d412-044f-7990-9036-7913614cf012 | VGT | 2026-09-24 11:39 | call_diagonal_spread | 2 | 1 | 24 | 105600.00 | unknown | — | 124.1850 | 5.2000 | ["120","130"] | ["0.2636","0.2692"] | [] | ["BATO"] | 120.0000 | 130.0000 | 484 | 813 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T15:39:25Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0cedd-d926-7181-b002-a853753c0b50 | VGT | 2026-09-23 11:23 | call_diagonal_spread | 2 | 1 | 144 | 145440.00 | unknown | — | 125.7280 | 1.0000 | ["122","126.25"] | ["0.2340","0.2304"] | [] | ["SPHR"] | 122.0000 | 126.2500 | 23 | 58 | false | false | true | true | false | ||||||||
| 01a0ca5c-6fb7-7d10-b240-04ed9e9729a9 | VGT | 2026-09-22 14:24 | call_diagonal_spread | 2 | 1 | 122 | 764330.00 | unknown | — | 126.4150 | 4.3000 | ["97.5","102"] | ["0.2486","0.2650"] | [] | ["XCBO"] | 97.5000 | 102.0000 | 178 | 360 | false | false | true | true | false | ||||||||
| 01a0c9bd-c686-7f01-9c0a-cd2f74ec164e | VGT | 2026-09-22 11:30 | other | 4 | 1 | 30 | 113492.00 | unknown | ask | 125.7800 | 8.1500 | ["86.88","108.13","111","145"] | ["0.4484","0.2812","0.3015","0.2510"] | [] | ["C2OX"] | 86.8800 | 145.0000 | 87 | 486 | false | false | true | ||||||||||
| 01a0c9bd-c29f-7f93-b424-0479d2ee8608 | VGT | 2026-09-22 11:30 | other | 4 | 2 | 60 | 226440.00 | unknown | ask | 125.7800 | 8.1500 | ["86.88","108.13","111","145"] | ["0.4438","0.2828","0.3002","0.2504"] | [] | ["MCRY","SPHR"] | 86.8800 | 145.0000 | 87 | 486 | false | false | true | ||||||||||
| 01a0c57f-b35f-7cb2-919e-f198773d30df | VGT | 2026-09-21 15:44 | put_vertical_spread | 2 | 3 | 123 | 277365.00 | unknown | — | 125.5801 | 4.5000 | ["119","125"] | ["0.2954","0.2928"] | [] | ["XCBO","XISX"] | 119.0000 | 125.0000 | 487 | 487 | true | true | false | true | false | ||||||||
| 01a0c4c9-7707-77b1-b471-837eb60bb8af | VGT | 2026-09-21 12:25 | call_diagonal_spread | 2 | 2 | 28 | 131896.00 | unknown | bid | 124.8498 | 4.9607 | ["92.5","145"] | ["0.3663","0.2354"] | [] | ["ARCO","XBOX"] | 92.5000 | 145.0000 | 88 | 816 | false | false | true | ||||||||||
| 01a0b0a1-ea73-7881-ac15-1db46815886f | VGT | 2026-09-17 14:29 | call_diagonal_spread | 2 | 1 | 16 | 167200.00 | unknown | — | 121.4476 | 5.1000 | ["69.38","70"] | ["0.8883","0.4999"] | [] | ["XISX"] | 69.3800 | 70.0000 | 64 | 183 | false | false | true | true | false | ||||||||
| 01a0afc2-e89b-7881-8d99-e94a3a35a9a5 | VGT | 2026-09-17 10:26 | call_diagonal_spread | 2 | 1 | 40 | 150000.00 | unknown | — | 121.4100 | 3.7000 | ["103","110"] | ["1.5743","0.2688"] | [] | ["XISX"] | 103.0000 | 110.0000 | 1 | 246 | false | false | true | true | false | ||||||||
| 01a0a668-05ee-7aa0-8c32-c4697b666ead | VGT | 2026-09-15 14:50 | call_diagonal_spread | 2 | 1 | 80 | 319840.00 | unknown | — | 118.6750 | 4.9000 | ["104.38","107"] | ["0.3019","0.2823"] | [] | ["XISX"] | 104.3800 | 107.0000 | 185 | 275 | false | false | true | true | false | ||||||||
| 01a0a149-2c98-78a2-b446-a77c23814fa9 | VGT | 2026-09-14 14:58 | other | 2 | 1 | 40 | 366560.00 | unknown | — | 119.8399 | 4.6000 | ["76.25","80"] | ["0.5083","0.2696"] | [] | ["XISX"] | 76.2500 | 80.0000 | 123 | 641 | false | false | true | true | false | mlet | |||||||
| 01a0a02b-4530-7663-9189-b10b493154a1 | VGT | 2026-09-14 09:46 | call_diagonal_spread | 2 | 1 | 32 | 112576.00 | unknown | — | 118.5500 | 4.9000 | ["103.75","110"] | ["0.3013","0.2826"] | [] | ["XPHO"] | 103.7500 | 110.0000 | 95 | 276 | false | false | true | true | false | ||||||||
| 01a09148-a1c0-7cc0-a3fd-05382bfaa487 | VGT | 2026-09-11 12:24 | other | 2 | 1 | 59 | 153695.00 | unknown | — | 121.3300 | 4.3000 | ["115","123"] | ["0.2519","0.2591"] | [] | ["XCBO"] | 115.0000 | 123.0000 | 126 | 371 | false | false | true | true | false | mlat | |||||||
| 01a08236-7658-7c91-a33e-291b7c76f1c5 | VGT | 2026-09-08 14:09 | call_vertical_spread | 2 | 2 | 52 | 135200.00 | unknown | — | 121.3350 | 3.2500 | ["120","122"] | ["0.2682","0.2629"] | [] | ["AMXO","XISX"] | 120.0000 | 122.0000 | 282 | 282 | false | false | false | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:24:21Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:24:40Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:31:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:31:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:44:35Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:25:37Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:30:18Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:26:40Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:50:47Z"} |
| 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-14T18:59:12Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:46:33Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:24:54Z"} |
| 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-08T18:10:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |