barbodDaily Number of (DAI Minted - DAI Repaid)
    Updated 2022-05-18
    WITH dai_minted AS (
    SELECT DATE_TRUNC('DAY', block_timestamp) as week,
    SUM(amount) as num_minted, SUM(amount_usd) as vol_usd_minted
    FROM ethereum.udm_events
    WHERE contract_address = '0x6b175474e89094c44da98b954eedeac495271d0f'
    AND from_address = '0x0000000000000000000000000000000000000000'
    GROUP BY week
    ),

    dai_repaid AS (
    SELECT DATE_TRUNC('DAY', block_timestamp) as week,
    SUM(amount) as num_repaid
    FROM ethereum.udm_events
    WHERE contract_address = '0x6b175474e89094c44da98b954eedeac495271d0f'
    AND to_address = '0x0000000000000000000000000000000000000000'
    GROUP BY week
    )


    SELECT a.week, num_minted, num_repaid,
    num_minted - num_repaid as daily_change, vol_usd_minted
    FROM dai_minted a INNER JOIN dai_repaid b
    ON a.week = b.week
    WHERE a.week BETWEEN '2021-11-19' AND '2022-05-19'

    Run a query to Download Data