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 |
|---|
| 01a0c560-dcd7-7a93-84fd-05a5b24b4bdb | KLAC | 2026-09-21 15:10 | call_condor | 4 | 1 | 15 | 147270.00 | short | bid | 184.5000 | 16.3000 | ["234","250","350","370"] | ["0.5582","0.5540","0.5775","0.5747"] | ["236.04","363.96"] | ["XMIO"] | 234.0000 | 370.0000 | 487 | 487 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:11:19Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c521-e7a7-7961-bc2d-bbd1e686c8fd | KLAC | 2026-09-21 14:02 | call_vertical_spread | 2 | 1 | 19 | 128596.00 | unknown | ask | 184.1600 | 4.2000 | ["190","200"] | ["0.5699","0.5699"] | ["228.84"] | ["XBOX"] | 190.0000 | 200.0000 | 269 | 269 | false | true | false | true | |||||||||
| 01a0b083-f67a-7101-81c1-eae15607cd8d | KLAC | 2026-09-17 13:57 | call_vertical_spread | 2 | 1 | 5 | 126560.00 | long | ask | 168.6900 | 9.2000 | ["42","43"] | ["12.7061","12.6011"] | ["42.98"] | ["XCBO"] | 42.0000 | 43.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0afbc-f143-7202-9431-435f5d76a5a5 | KLAC | 2026-09-17 10:19 | other | 4 | 1 | 40 | 166200.00 | unknown | — | 169.0300 | 3.3000 | ["190","192","200","202"] | ["0.5546","0.5535","0.5825","0.5833"] | [] | ["XMIO"] | 190.0000 | 202.0000 | 64 | 120 | false | true | true | true | false | mlat | |||||||
| 01a0a67c-ddde-7f01-a64c-f24278466e7c | KLAC | 2026-09-15 15:13 | other | 4 | 1 | 127 | 180213.00 | unknown | — | 167.1600 | 1.3500 | ["175","180","182"] | ["0.5365","0.5930","0.6813"] | [] | ["XCBO"] | 175.0000 | 182.0000 | 3 | 31 | false | true | true | true | false | mlat | |||||||
| 01a0a651-0b1e-7a90-b68f-dfcc0559d368 | KLAC | 2026-09-15 14:25 | call_diagonal_spread | 2 | 1 | 10 | 162620.00 | short | bid | 166.9800 | 11.9000 | ["104","120"] | ["0.6022","0.5848"] | [] | ["XCBO"] | 104.0000 | 120.0000 | 493 | 857 | false | false | true | true | |||||||||
| 01a0a5c2-d4de-7781-b9db-b02f614490d0 | KLAC | 2026-09-15 11:50 | other | 4 | 1 | 2311 | 1509083.00 | unknown | — | 167.1900 | 1.1500 | ["172.5","177.5","190","197.5"] | ["0.5428","0.5519","0.7287","0.8546"] | [] | ["XCBO"] | 172.5000 | 197.5000 | 3 | 10 | false | true | true | true | false | mlat | |||||||
| 01a09133-7f98-7b91-a9ab-dff4c8d8eb54 | KLAC | 2026-09-11 12:01 | other | 4 | 1 | 2259 | 2762757.00 | unknown | — | 181.5200 | 3.5000 | ["175","180","190","197.5"] | ["1.3483","0.7936","0.5425","0.5460"] | [] | ["XMIO"] | 175.0000 | 197.5000 | 0 | 7 | false | false | true | true | false | mlat | |||||||
| 01a090ef-1bc8-7b01-a456-786aca0c83c1 | KLAC | 2026-09-11 10:46 | other | 4 | 1 | 126 | 167370.00 | unknown | — | 179.7000 | 3.6500 | ["172.5","182.5"] | ["0.7999","0.7739"] | [] | ["XMIO"] | 172.5000 | 182.5000 | 0 | 7 | false | false | true | true | false | mlat | |||||||
| 01a08c78-7ff8-7343-ac58-301fb16dea48 | KLAC | 2026-09-10 13:58 | call_condor | 4 | 1 | 127 | 126111.00 | short | bid | 177.4500 | 2.7500 | ["180","182","206","214"] | ["0.5624","0.5858","0.6321","0.7551"] | ["180.55","207.45"] | ["XCBO"] | 180.0000 | 214.0000 | 8 | 8 | false | true | false | true | |||||||||
| 01a08bdb-ea08-7fe2-a9f8-beaec081bf74 | KLAC | 2026-09-10 11:07 | other | 2 | 1 | 50 | 100050.00 | unknown | — | 179.8400 | 1.4000 | ["185"] | ["0.5716"] | [] | ["XCBO"] | 185.0000 | 185.0000 | 8 | 15 | false | false | true | false | false | mlat | |||||||
| 01a086f9-6538-7071-8cd0-19f50355f6ad | KLAC | 2026-09-09 12:21 | call_diagonal_spread | 2 | 1 | 10 | 215720.00 | long | ask | 181.4850 | 29.6000 | ["76","84"] | ["1.0187","0.6406"] | [] | ["XCBO"] | 76.0000 | 84.0000 | 100 | 499 | false | false | true | true | false | ||||||||
| 01a08688-7710-75b0-8ade-5b0ed2c15544 | KLAC | 2026-09-09 10:18 | risk_reversal | 2 | 1 | 60 | 111600.00 | short | ask | 185.3500 | 2.8000 | ["152","250"] | ["0.5851","0.6038"] | ["151.68"] | ["EDGO"] | 152.0000 | 250.0000 | 128 | 128 | false | true | false | true | true | ||||||||
| 01a08677-b218-70a3-b46e-7728f155e332 | KLAC | 2026-09-09 09:59 | call_diagonal_spread | 2 | 1 | 8 | 182608.00 | short | ask | 185.2700 | 13.5000 | ["70","80"] | ["3.7146","0.5823"] | [] | ["XMIO"] | 70.0000 | 80.0000 | 9 | 499 | false | false | true | true | false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:02:34Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:57:48Z"} |
| 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:19:52Z"} |
| 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-15T19:14:01Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:25:43Z"} |
| 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-15T15:50:06Z"} |
| 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-11T16:01:10Z"} |
| 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-11T14:46:24Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:59:05Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:07:55Z"} |
| 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-09T16:22:02Z"} |
| 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-09T14:18:09Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:00:00Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |