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 |
|---|
| 01a0ca24-e8de-7352-a59c-5f5f2057ac85 | VGT | 2026-09-22 13:23 | call_diagonal_spread | 2 | 1 | 115 | 206310.00 | long | bid | 126.0850 | 3.7000 | ["121.88","126"] | ["0.2376","0.2152"] | [] | ["BATO"] | 121.8800 | 126.0000 | 115 | 150 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T17:23:40Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 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 | true | 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 | true | 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 | mlet | |||||||
| 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 | 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 | mlet | |||||||
| 01a0afc6-8663-70f0-8186-bffa2218b661 | VGT | 2026-09-17 10:30 | call_calendar | 2 | 1 | 144 | 1061856.00 | short | bid | 121.3900 | 4.3000 | ["85"] | ["0.5417"] | [] | ["BATO"] | 85.0000 | 85.0000 | 64 | 92 | false | false | true | false | false | ||||||||
| 01a0aaef-8e9b-7211-aecf-911c39d2b603 | VGT | 2026-09-16 11:56 | call_vertical_spread | 2 | 4 | 44 | 166760.00 | long | ask | 119.9239 | 5.8000 | ["108","110"] | ["0.2682","0.2532"] | ["109.80"] | ["ARCO","EMLD","SPHR","XPHO"] | 108.0000 | 110.0000 | 274 | 274 | false | false | false | true | |||||||||
| 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 | mlet | |||||||
| 01a0a573-12e6-7920-94f5-dc9c44b496bd | VGT | 2026-09-15 10:22 | call_calendar | 2 | 1 | 104 | 404456.00 | short | ask | 118.9700 | 2.0000 | ["100"] | ["0.7830"] | [] | ["XISX"] | 100.0000 | 100.0000 | 3 | 31 | false | false | true | false | 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 | mlet | |||||||
| 01a0a023-84d1-7441-9862-5561fca0ca36 | VGT | 2026-09-14 09:37 | call_diagonal_spread | 2 | 1 | 40 | 142960.00 | long | bid | 117.9200 | 5.1000 | ["100","125"] | ["0.3479","0.2865"] | [] | ["XMIO"] | 100.0000 | 125.0000 | 95 | 494 | false | false | true | true | false | ||||||||
| 01a08710-dd08-72f1-8d03-1a212e9d7446 | VGT | 2026-09-09 12:47 | call_vertical_spread | 2 | 1 | 40 | 105040.00 | short | bid | 120.9750 | 4.5000 | ["120","121"] | ["0.2713","0.2662"] | ["120.70"] | ["XMIO"] | 120.0000 | 121.0000 | 281 | 281 | false | false | false | true | |||||||||
| 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 | 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 |
| 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 |
| 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:30:19Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:57:36Z"} |
| 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-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-15T14:23:09Z"} |
| 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-14T13:38:02Z"} |
| 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-09T16:47:17Z"} |
| 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-08T18:10:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |