bachiarbi6
Updated 2022-08-11
9
1
2
3
4
5
6
7
8
9
›
⌄
select project_name, count(DISTINCT tx_hash) as total_txns_count,
count(distinct origin_from_address) as no_of_users
from (SELECT * from arbitrum.core.dim_labels
inner join arbitrum.core.fact_event_logs
on contract_address = address)
where label_type = 'dex'
GROUP by 1
order by 3 desc
limit 10
Run a query to Download Data