Sbhn_NPTop 10 Destinations of GOO Token (By TX Count)
Updated 2022-11-03Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
--credit : alik110
select origin_to_address,
case when origin_to_address = '0x600000000a36f3cd48407e35eb7c5c910dc1f7a8' then 'GOO Token'
when origin_to_address = '0x60bb1e2aa1c9acafb4d34f71585d7e959f387769' then 'Art Gobblers: GOBBLER Token'
when origin_to_address = '0xb9aa14b6774dbc9f84b15e7ff659c0dba0d9ddf5' then 'uniswap'
when origin_to_address = '0x6af1a16fde7346e7729fa921ad2ddf6a462061e2' then 'MEV Bot'
else label end as destination_label,
count (distinct tx_hash) as TX_Count,
count (distinct origin_from_address) as Users_Count
from ethereum.core.fact_event_logs t1 left outer join ethereum.core.dim_labels t2 on t1.origin_to_address = t2.address
where contract_address = '0x600000000a36f3cd48407e35eb7c5c910dc1f7a8'
and destination_label is not null
group by 1,2
order by 3 desc
limit 10
Run a query to Download Data