MetiocreAdded DAI vs BTC Price
    WITH mint_dai AS(SELECT
    date_trunc('day', block_timestamp) as date,
    sum(amount) as mint_amount
    FROM ethereum.udm_events
    WHERE
    event_name = 'transfer' AND FROM_address='0x0000000000000000000000000000000000000000' AND
    symbol = 'DAI' AND
    amount > 0 AND block_timestamp >= GETDATE() - interval'365 days'
    GROUP BY date),
    burn_dai AS(
    SELECT
    date_trunc('day', block_timestamp) as date,
    sum(amount) as burn_amount
    FROM ethereum.udm_events
    WHERE
    event_name = 'transfer' AND To_address='0x0000000000000000000000000000000000000000' AND
    symbol = 'DAI' AND
    amount > 0 AND block_timestamp >= GETDATE() - interval'365 days'
    GROUP BY date),
    btc_price AS(
    SELECT
    date_trunc('day', hour) as date, avg(price) AS btc_price
    FROM ethereum.token_prices_hourly
    where symbol = 'WBTC'
    AND date >= GETDATE() - interval'365 days'
    GROUP BY date)

    SELECT mint_dai.date, mint_amount, burn_amount, ( mint_amount-burn_amount) AS added_dai, btc_price,
    sum(added_dai) over(order by mint_dai.date) AS cumulative_added_dai
    FROM mint_dai
    INNER JOIN burn_dai
    INNER JOIN btc_price
    ON mint_dai.date=burn_dai.date AND mint_dai.date=btc_price.date
    Run a query to Download Data