flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
2024-01-15 02:52 PM
Keyrock
2024-01-15 02:52 PM
Updated 2024-01-15
Copy Reference
Fork
9
1
2
3
4
5
6
›
SELECT symbol, hour, avg(price) as price
FROM crosschain.price.ez_hourly_token_prices
WHERE symbol IN ('WBTC','WETH','USDC','USDT','USDD')
AND blockchain = 'ethereum'
AND hour > '2022-10-01'
group by 1,2
Results
QueryRunArchived: QueryRun has been archived