binhachonStability Fee - DAI mint burn
    Updated 2022-01-16
    with DAI_mint_burn_raw as (
    select
    date_trunc('day', block_timestamp) as blocktime,
    sum(amount) as amount
    from ethereum.udm_events
    where contract_address = '0x6b175474e89094c44da98b954eedeac495271d0f'
    and from_address = '0x0000000000000000000000000000000000000000'
    group by blocktime
    union all
    select
    date_trunc('day', block_timestamp) as blocktime,
    -sum(amount) as amount
    from ethereum.udm_events
    where contract_address = '0x6b175474e89094c44da98b954eedeac495271d0f'
    and to_address = '0x0000000000000000000000000000000000000000'
    group by blocktime
    ),
    DAI_mint_burn as (
    select
    blocktime,
    sum(case when amount > 0 then amount else 0 end) as mint_amount,
    sum(case when amount < 0 then amount else 0 end) as burn_amount,
    sum(amount) as net_mint_amount
    from DAI_mint_burn_raw
    group by blocktime
    )
    select
    blocktime,
    mint_amount,
    burn_amount,
    net_mint_amount as daily_net_mint_amount,
    mint_amount - burn_amount as volume,
    sum(net_mint_amount) over (order by blocktime) as total_mint_amount
    from DAI_mint_burn


    Run a query to Download Data