CryptoLionPrice History
    Updated 2022-11-28
    SELECT
    date_trunc('day',block_hour) as day,
    underlying_symbol,
    avg(ctoken_price) as ctoken_price,
    avg(price) as price
    FROM compound.market_stats
    INNER JOIN ethereum.token_prices_hourly on hour = block_hour and underlying_symbol = symbol
    WHERE block_hour >= getdate() - interval '60 days'
    AND contract_name <> 'cSAI'
    AND contract_name <> 'cWBTC'
    GROUP BY day, 2
    ORDER BY day
    Run a query to Download Data