LABEL_TYPE | TOTAL_BLOCKS | |
|---|---|---|
1 | dapp | 29725283 |
2 | games | 23212776 |
3 | defi | 13014075 |
4 | token | 9256502 |
5 | bridge | 6519048 |
6 | cex | 917588 |
7 | chadmin | 848464 |
8 | nft | 408578 |
9 | operator | 155294 |
10 | dex | 77 |
datavortexblocks per labels
Updated 2025-06-13
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: 22 days ago
10
173B
93s