core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg508,354 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 |
|---|
| 01a0d936-453f-77a2-abcf-69b6a2ad7c57 | DOW | 2026-09-25 11:36 | call_vertical_spread | 2 | 1 | 10000 | 1600000.00 | long | ask | 28.0850 | 0.1500 | ["30","32.5"] | ["0.4084","0.4029"] | ["30.62"] | ["XPHO"] | 30.0000 | 32.5000 | 56 | 56 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T15:37:10Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d912-abf7-7e02-a17c-d62e492b46a0 | DOW | 2026-09-25 10:57 | strangle | 2 | 1 | 2000 | 518000.00 | long | ask | 28.0350 | 0.1100 | ["27.5","30"] | ["0.4197","0.4130"] | ["24.91","32.59"] | ["AMXO"] | 27.5000 | 30.0000 | 56 | 56 | false | true | false | ||||||||||
| 01a0d912-07e7-79c3-8040-c4f97c7845ad | DOW | 2026-09-25 10:57 | strangle | 2 | 1 | 2000 | 518000.00 | long | ask | 28.0400 | 0.1100 | ["27.5","30"] | ["0.4202","0.4126"] | ["24.91","32.59"] | ["AMXO"] | 27.5000 | 30.0000 | 56 | 56 | true | true | false | ||||||||||
| 01a0c96f-0277-76b2-8868-014e293ef26c | DOW | 2026-09-22 10:04 | call_diagonal_spread | 2 | 1 | 1380 | 396060.00 | unknown | bid | 28.4200 | 0.8700 | ["40","45"] | ["0.3748","0.3718"] | [] | ["XISX"] | 40.0000 | 45.0000 | 360 | 486 | false | true | true | ||||||||||
| 01a0c460-510f-77d1-b513-ed031a4dcede | DOW | 2026-09-21 10:30 | put_ratio_spread | 2 | 1 | 3350 | 250100.00 | unknown | bid | 28.1600 | 0.1600 | ["27","27.5"] | ["0.4059","0.3928"] | ["27.33"] | ["SPHR"] | 27.0000 | 27.5000 | 11 | 11 | false | true | false | ||||||||||
| 01a0b572-c38f-7f93-b614-3a92e55c0c3d | DOW | 2026-09-18 12:56 | strangle | 2 | 1 | 1500 | 1335000.00 | short | bid | 28.5200 | 0.9000 | ["30","35"] | ["0.4571","0.3576"] | ["21.10","43.90"] | ["AMXO"] | 30.0000 | 35.0000 | 490 | 490 | false | false | false | ||||||||||
| 01a0b0ae-717b-7751-b9d6-8494b2eb8466 | DOW | 2026-09-17 14:43 | put_vertical_spread | 2 | 1 | 3366 | 4577760.00 | unknown | — | 29.6350 | 1.1000 | ["35","37.5"] | ["2.4490","3.1487"] | [] | ["XBOX"] | 35.0000 | 37.5000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0b0aa-3b5a-76d3-b1c3-cc9a6321a263 | DOW | 2026-09-17 14:38 | other | 4 | 1 | 354 | 425140.00 | unknown | — | 29.6550 | 4.1900 | ["32","32.5","37.5","42.5"] | ["2.4219","1.6753","4.0970","7.4322"] | [] | ["XBOX"] | 32.0000 | 42.5000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0b0a3-74fa-7f43-a6a5-bf3dd59589f7 | DOW | 2026-09-17 14:31 | other | 4 | 1 | 4300 | 6153200.00 | unknown | — | 29.7200 | 4.7500 | ["35","37.5","40","42.5"] | ["2.6848","3.6266","6.3905","7.5360"] | [] | ["XBOX"] | 35.0000 | 42.5000 | 1 | 1 | true | false | false | true | false | ||||||||
| 01a0a5a7-7126-7bb2-a993-e57c9c3007f7 | DOW | 2026-09-15 11:20 | put_diagonal_spread | 2 | 1 | 6700 | 275000.00 | unknown | — | 29.7050 | 0.1500 | ["27.5","28.5"] | ["0.4079","0.6109"] | [] | ["XPHO"] | 27.5000 | 28.5000 | 3 | 17 | true | true | true | true | false | ||||||||
| 01a091fe-5560-7750-8d72-f47408c581be | DOW | 2026-09-11 15:42 | other | 2 | 1 | 10000 | 1060000.00 | unknown | — | 28.9650 | 0.0600 | ["32","32.5"] | ["0.4382","0.4310"] | [] | ["XPHO"] | 32.0000 | 32.5000 | 7 | 70 | false | true | true | true | false | ||||||||
| 01a08c9a-e4a8-7d71-a8b6-4548eb648ee8 | DOW | 2026-09-10 14:35 | other | 3 | 1 | 290 | 272152.00 | unknown | — | 29.7450 | 2.0200 | ["31.5","32","37.5"] | ["1.6622","1.5426","1.2079"] | [] | ["XBOX"] | 31.5000 | 37.5000 | 1 | 8 | false | false | true | true | false | ||||||||
| 01a06def-d9dd-77c0-9f4c-4abe7d026907 | DOW | 2026-09-04 15:40 | put_diagonal_spread_bullish | 2 | 1 | 10000 | 655000.00 | long | bid | 29.3518 | 0.1400 | ["27.5","29"] | ["0.4037","0.3552"] | [] | ["XPHO"] | 27.5000 | 29.0000 | 7 | 14 | false | true | true |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:58:18Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:57:43Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:04:53Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:30:48Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:56:35Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:44:13Z"} |
| 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-17T18:39:43Z"} |
| 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-17T18:31:45Z"} |
| 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-15T15:20:25Z"} |
| 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-11T19:42:57Z"} |
| 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-10T18:36:02Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:40:36Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |