date_trunc('day', block_timestamp) day,

sum(case

when from_address = '0x0000000000000000000000000000000000000000' then amount

else 0 end) -

sum(case

when to_address = '0x0000000000000000000000000000000000000000' then amount

else 0 end) euroc_amount,

case when euroc_amount < 0 then 'burn'

else 'mint' end type,

sum(euroc_amount) over(order by day) cum_total_supply

from

avalanche.core.ez_token_transfers

where contract_address = '0xc891eb4cbdeff6e073e859e987815ed1505c2acd'

and (from_address = '0x0000000000000000000000000000000000000000'

or to_address = '0x0000000000000000000000000000000000000000')

group by day

order by day