malekibehzad-b-6XqJ2023-08-27 12:20 AM
    Updated 2023-08-26
    select
    a.hour::date as day,
    avg (a.price) as eth_price_usd,
    avg (b.price) as reth_price_usd
    from ethereum.core.fact_hourly_token_prices a
    join ethereum.core.fact_hourly_token_prices b
    on a.hour::date = b.hour::date
    where a.symbol = 'WETH' --ETH
    and b.token_address = lower('0xae78736Cd615f374D3085123A210448E74Fc6393') --rETH
    group by 1
    order by 1

    Run a query to Download Data