-- 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