Eman-RazTop 20 SAND Senders Based on Transfers Count
Updated 2023-04-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with tab1 as (select origin_from_address as sender, count(distinct tx_hash) as transfers, count(distinct to_address) as receivers
from ethereum.core.ez_token_transfers
where symbol='SAND' and block_timestamp::date>='2021-01-01' and amount_usd is not null
group by 1
order by 2 desc
limit 20),
tab2 as (select address, address_name
from ethereum.core.dim_labels)
select sender, address_name, transfers, receivers, case
when address_name is not null then address_name
else sender
end as wallet_name
from tab1 left join tab2 on tab1.sender=tab2.address
order by 3
Run a query to Download Data