CryptoIcicleCopy of Total No. of dApps
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- SQL Credit https://app.flipsidecrypto.com/velocity/queries/10524399-68e9-4673-8a9c-81dd6c0f1369
with dapp as (
select
contract_address as address,
count(tx_hash) as popularity
from arbitrum.core.fact_event_logs
where event_name = 'Approval'
group by address
)
select
labels.project_name as dapp,
sum(dapp.popularity) as popularity
from arbitrum.core.dim_labels as labels
inner join dapp on labels.address = dapp.address
group by labels.project_name
order by popularity desc
limit 1000
Run a query to Download Data