shadilCollateral Impact (May 13) - Dai mint volume and collateral
    Updated 2022-05-14
    -- mint

    select date(block_timestamp) as date,
    sum(amount_usd) as amount,
    'Dai Mint' as type
    from ethereum.udm_events
    where symbol = 'DAI'
    and from_address_name = 'genesis'
    and origin_function_signature = '0x1cff79cd'
    and event_name = 'transfer'
    group by date

    UNION
    -- collateral
    select date(block_timestamp) as date,
    sum(amount_usd) as amount,
    'collateral' as type
    from ethereum.udm_events
    where to_label = 'maker'
    and event_name = 'transfer'
    and origin_function_signature = '0x1cff79cd'
    group by date
    Run a query to Download Data