select date_trunc (day,block_timestamp) as date1,

to_address as Wallet,

coalesce (sum (amount),0) as Amount

from avalanche.core.ez_token_transfers

where contract_address ='0x3fe4902b275caf603c46c81f3d921bb8515b5bc0'

group by 1,2),

sendt as (

select date_trunc (day,block_timestamp) as date1,

from_address as Wallet,

coalesce (sum (amount),0)*-1 as Amount

from avalanche.core.ez_token_transfers

where contract_address ='0x3fe4902b275caf603c46c81f3d921bb8515b5bc0'

group by 1,2),

holderst as (

select distinct Wallet

from (

select Wallet,

round(sum(Amount),0) as balance

from (select * from sendt union all select * from receivet)

group by 1)),

datet1 as (

select date_day

from ethereum.core.dim_dates

where date_day >= '2025-01-01' and date_day <= current_date

group by date_day),

table1 as (

select *

from datet1 cross join holderst),

balance1 as (

select date1,