with price AS (select trunc(hour,'day') as day1, avg(price) as ETH_price
from ethereum.token_prices_hourly
where symbol = 'WETH' and day1 >= '2021-01-01' and day1 <= '2022-05-1'
group by 1),
burned AS (SELECT trunc(block_timestamp,'day') as day, SUM(amount) as burned_DAI
FROM ethereum.udm_events
WHERE to_address ilike '0x0000000000000000000000000000000000000000'
and contract_address = '0x6b175474e89094c44da98b954eedeac495271d0f' and symbol like 'DAI'
and day >= '2021-01-01' and day <= '2022-05-17'
GROUP BY 1)
SELECT day, ETH_price, burned_DAI
FROM burned join price
on day = day1