select *

from ethereum.core.ez_token_transfers

where BLOCK_TIMESTAMP::date > CURRENT_DATE -61 and BLOCK_TIMESTAMP::date < CURRENT_DATE

and ORIGIN_TO_ADDRESS = '0xabea9132b05a70803a4e85094fd0e1800777fbef' --(zkSync)

select

count(DISTINCT ORIGIN_FROM_ADDRESS) as wallets,

sum(AMOUNT_USD) as total_usd,

avg(amount_usd) as avg_usd,

sum(AMOUNT) as total,

count(DISTINCT TX_HASH) as num_tx,

SYMBOL,

row_number() over(order by total_usd desc ) as rank,

row_number() over(order by avg_usd desc ) as rank_avg

from token

where AMOUNT_USD>0

group by symbol

order by total_usd desc

limit {{TopX}}