L as(select * from $query('41c012d3-5814-4cfb-86a6-3ad87173bc2f') ),

X as(

select block_timestamp, 0+amount as balance, from_address as contract, contract_address from ethereum.core.ez_token_transfers union all

select block_timestamp, 0-amount as balance, to_address as contract, contract_address from ethereum.core.ez_token_transfers union all

select block_timestamp, 0+amount as balance, from_address as contract, contract_address from base.core.ez_token_transfers union all

select block_timestamp, 0-amount as balance, to_address as contract, contract_address from base.core.ez_token_transfers union all

select block_timestamp, 0+amount as balance, from_address as contract, contract_address from polygon.core.ez_token_transfers union all

select block_timestamp, 0-amount as balance, to_address as contract, contract_address from polygon.core.ez_token_transfers union all

select block_timestamp, 0+amount as balance, from_address as contract, contract_address from bsc.core.ez_token_transfers union all

select block_timestamp, 0-amount as balance, to_address as contract, contract_address from bsc.core.ez_token_transfers

),

A as(

select ticker, a.contract as holder, sum(0-balance) as balance, min(block_timestamp) as time

from X as a

join L as b on a.contract_address = lower(b.contract)

group by 1,2

having sum(0-balance) > 0 )

select ticker, count(distinct holder) as holder

from A

where date(time) >= current_date - interval '7 days'

group by 1

order by holder desc