(select date(BLOCK_TIMESTAMP) as datetime,

contract_name as token,

decoded_log:"from" as from_address,

decoded_log:"to" as to_address,

decoded_log:"value"/power(10,18) as value

from berachain.testnet.ez_decoded_event_logs

where contract_address = lower('0xfd27998fa0eaB1A6372Db14Afd4bF7c4a58C5364')

and

event_name = 'Transfer'),

current_holder as

(select count(distinct address) as add_cnt

(select

token,

address,

sum(value) as bal

from

(select datetime,

token,

from_address as address,

-value as value

from full_data

union all

select datetime,

token,

to_address as address,

value as value

from full_data)

group by 1,2)

where bal > 0),

last_7d_holder as

(select count(distinct address) as add_cnt_7d