bachiarbi2
Updated 2022-08-10
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select project_name, count(DISTINCT tx_hash) as total_txns
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 2 desc
limit 10
Run a query to Download Data