core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 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 |
|---|
| 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-09T14:00:00Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 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 | |||||||||
| 01a08691-9700-7bb2-ba8d-455684a0a740 | KLAC | 2026-09-09 10:28 | put_diagonal_spread | 2 | 1 | 40 | 113240.00 | short | bid | 184.6000 | 1.5000 | ["182.5","185"] | ["0.6126","0.6059"] | [] | ["C2OX"] | 182.5000 | 185.0000 | 9 | 100 | false | false | true | true | |||||||||
| 01a08752-0c88-7c90-a2be-22f59bccac63 | KLAC | 2026-09-09 13:58 | call_diagonal_spread | 2 | 1 | 54 | 837000.00 | short | ask | 181.9200 | 8.5000 | ["84","150"] | ["3.3562","0.5950"] | [] | ["BATO"] | 84.0000 | 150.0000 | 9 | 281 | false | false | true | true | |||||||||
| 01a08c42-4910-73b2-9646-833d72c3561e | KLAC | 2026-09-10 12:59 | call_diagonal_spread | 2 | 1 | 20 | 316620.00 | short | bid | 178.9250 | 12.4000 | ["100","120"] | ["1.6002","0.5852"] | [] | ["XMIO"] | 100.0000 | 120.0000 | 8 | 498 | false | false | true | true | |||||||||
| 01a08c4d-bac0-7973-85c9-b350d2600cd0 | KLAC | 2026-09-10 13:11 | call_vertical_spread | 2 | 2 | 100 | 388550.00 | short | bid | 178.5100 | 5.2000 | ["150","205"] | ["0.6054","0.5972"] | ["176.80"] | ["ARCO","XPHO"] | 150.0000 | 205.0000 | 43 | 43 | true | false | false | true | |||||||||
| 01a08c4d-ed88-7853-a43c-92bc01da41a1 | KLAC | 2026-09-10 13:11 | call_vertical_spread | 2 | 1 | 50 | 192550.00 | short | bid | 178.4800 | 3.4000 | ["150","205"] | ["0.5908","0.5931"] | ["176.65"] | ["XPHO"] | 150.0000 | 205.0000 | 43 | 43 | false | false | false | true | |||||||||
| 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 | |||||||||
| 01a0913e-e1a8-7242-aede-5d52acfd7a8f | KLAC | 2026-09-11 12:13 | call_vertical_spread | 2 | 1 | 10 | 107080.00 | short | bid | 181.5800 | 7.8000 | ["104","150"] | ["2.4388","1.0123"] | ["149.50"] | ["BATO"] | 104.0000 | 150.0000 | 7 | 7 | false | false | false | true | |||||||||
| 01a0a027-9bb0-75d1-95a4-5436e0244cc8 | KLAC | 2026-09-14 09:42 | put_calendar | 2 | 3 | 127 | 283018.00 | short | ask | 170.3000 | 3.5071 | ["154"] | ["0.6214"] | [] | ["EMLD","SPHR","XPHO"] | 154.0000 | 154.0000 | 67 | 95 | false | true | true | false | |||||||||
| 01a0a027-baf0-7e22-b66d-2ceeeeb901cf | KLAC | 2026-09-14 09:42 | put_calendar | 2 | 5 | 456 | 1015550.00 | short | bid | 170.0600 | 3.3000 | ["154"] | ["0.6187"] | [] | ["AMXO","MCRY","SPHR","XISX","XMIO"] | 154.0000 | 154.0000 | 67 | 95 | false | true | true | false | |||||||||
| 01a0a027-baf0-7e22-b66d-2d0c5e073eeb | KLAC | 2026-09-14 09:42 | put_calendar | 2 | 2 | 260 | 578240.00 | short | bid | 170.0600 | 3.3000 | ["154"] | ["0.6182"] | [] | ["BATO","XCBO"] | 154.0000 | 154.0000 | 67 | 95 | false | true | true | false | |||||||||
| 01a0a640-7506-71a3-87c8-09b9a6b3fa36 | KLAC | 2026-09-15 14:07 | call_diagonal_spread | 2 | 1 | 10 | 165100.00 | short | bid | 167.1900 | 14.6000 | ["103","120"] | ["0.6320","0.5888"] | [] | ["XMIO"] | 103.0000 | 120.0000 | 493 | 857 | false | false | true | true | |||||||||
| 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 | |||||||||
| 01a0c46b-f96f-7ee0-81cf-5751c78fdc3d | KLAC | 2026-09-21 10:43 | put_vertical_spread | 2 | 2 | 160 | 119360.00 | short | bid | 180.7100 | 0.5500 | ["175","182.5"] | ["0.5974","0.5833"] | ["179.3"] | ["XISX"] | 175.0000 | 182.5000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c4af-c8cf-7870-b763-9038181ed907 | KLAC | 2026-09-21 11:57 | call_vertical_spread | 2 | 1 | 50 | 217500.00 | short | bid | 182.3100 | 2.0000 | ["170","215"] | ["0.5720","0.5717"] | ["187.40"] | ["XMIO"] | 170.0000 | 215.0000 | 116 | 116 | false | false | false | true | |||||||||
| 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 |
| mlat |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:28:23Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:58:35Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:59:47Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:11:45Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:12:45Z"} |
| 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-10T17:59:05Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:13:35Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:42:36Z"} |
| 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-14T13:42:36Z"} |
| 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-14T13:42:36Z"} |
| 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-15T18:07:24Z"} |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:43:41Z"} |
| 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-21T15:57:42Z"} |
| 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-21T19:11:19Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |