with tab_main as (

select

date_trunc('day', block_timestamp) as Date,

'Minted' as Type,

to_address as User,

sum(amount) as amount,

sum(amount_usd) as amount_usd

from arbitrum.core.ez_token_transfers

where symbol like 'ezETH'

and from_address like '0x0000000000000000000000000000000000000000'

and contract_address like lower('0x2416092f143378750bb29b79ed961ab195cceea5')

group by 1, 2, 3

Union All

select

date_trunc('day', block_timestamp) as Date,

'Burned' as Type,

from_address as User,

sum(amount) as amount,

sum(amount_usd) as amount_usd

from arbitrum.core.ez_token_transfers

where symbol like 'ezETH'

and to_address like '0x0000000000000000000000000000000000000000'

and contract_address like lower('0x2416092f143378750bb29b79ed961ab195cceea5')

group by 1, 2, 3

),

tab_users as (

select

User,

sum(case when Type like 'Minted' then amount else amount*-1 end) as Total_ezETH,

sum(case when Type like 'Minted' then amount_usd else amount_usd*-1 end) as Total_ezETH_USD

from tab_main

group by User

)