MahrooUntitled Query
Updated 2022-11-02Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
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 1'
when origin_to_address = '0xe8c060f8052e07423f71d445277c61ac5138a2e5' then 'MEV Bot 2'
when origin_to_address = '0x9008d19f58aabd9ed0d60971565aa8510560ab41' then 'Cow Protocol'
when origin_to_address = '0x617dee16b86534a5d792a4d7a62fb491b544111e' then 'MetaAggregationRouter'
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'
group by 1,2
order by 4 desc
limit 10
Run a query to Download Data