mondov2023-03-22 08:24 PM
Updated 2023-10-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
coalesce(initcap(project_name), origin_to_address) as Destination,
count(distinct tx_hash) as TX_Count,
count(distinct origin_from_address) as Users_Count
from
avalanche.core.ez_decoded_event_logs t1
join avalanche.core.dim_labels t2 on t1.origin_to_address = t2.address
where
contract_address = '0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd'
group by
1
order by
2 DESC
Run a query to Download Data