CryptoLionPrice BTC ETH
    Updated 2022-03-12
    SELECT
    date_trunc('week',hour) as week,
    symbol,
    token_address,
    avg(price) as price
    FROM ethereum.token_prices_hourly
    WHERE hour >= getdate() - interval '10 weeks'
    AND (token_address = '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599'
    OR token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2')
    GROUP BY 1,2,3
    ORDER BY 1 DESC
    Run a query to Download Data