connorhETH Price By Block #
    Updated 2021-11-10
    WITH blockhours AS (

    SELECT date_trunc('hour',block_timestamp) AS blockhour, MAX(block_id) AS block_id
    FROM ethereum.udm_events
    WHERE block_id >= 8000000
    GROUP BY 1
    )

    SELECT hour, block_id,price
    FROM blockhours
    LEFT JOIN
    ethereum.token_prices_hourly
    ON hour = blockhour
    WHERE symbol = 'WETH'
    Run a query to Download Data