bertaDAI on the Market_BURNED DAI and ETH PRICE
    Updated 2022-05-22
    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


    Run a query to Download Data