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'