LABEL_TYPE | TOTAL_BLOCKS | |
|---|---|---|
1 | dapp | 27426037 |
2 | games | 23432639 |
3 | defi | 13468576 |
4 | token | 10357047 |
5 | bridge | 6869445 |
6 | chadmin | 1245267 |
7 | cex | 714381 |
8 | nft | 575477 |
9 | operator | 134981 |
10 | dex | 24 |
datavortexblocks per labels
Updated 2025-04-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
label_type,
COUNT(DISTINCT t1.BLOCK_ID) AS Total_Blocks
FROM
near.core.fact_transactions t1
JOIN
near.core.dim_address_labels t2
ON t1.tx_receiver = t2.address
WHERE
block_timestamp >= DATEADD(year, -1, CURRENT_DATE)
GROUP BY
label_type
ORDER BY
Total_Blocks DESC;
Last run: about 1 month ago
10
175B
73s