mondovdapps
Updated 2023-03-24
9
1
2
3
4
5
6
7
›
⌄
SELECT l.LABEL, l.label_type, l.label_subtype, COUNT(t.tx_hash) as "# of Txs"
FROM ethereum.core.dim_labels l
JOIN ethereum.core.fact_transactions t ON l.address = t.to_address
WHERE l.label_type = 'dapp' OR l.label_type = 'defi' OR l.label_type = 'dex' OR l.label_type = 'nft'
GROUP BY l.LABEL, l.label_type, l.label_subtype
ORDER BY "# of Txs" DESC
LIMIT 100
Run a query to Download Data