MONTH | TRANSACTION_CATEGORY | TOTAL_TRANSACTIONS | |
|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | games | 24029955 |
2 | 2025-01-01 00:00:00.000 | token | 1013226 |
3 | 2025-01-01 00:00:00.000 | nft | 534513 |
4 | 2025-01-01 00:00:00.000 | dex | 200554 |
5 | 2025-01-01 00:00:00.000 | cex | 26882 |
6 | 2025-01-01 00:00:00.000 | operator | 2 |
7 | 2025-02-01 00:00:00.000 | games | 19875199 |
8 | 2025-02-01 00:00:00.000 | token | 885503 |
9 | 2025-02-01 00:00:00.000 | nft | 408234 |
10 | 2025-02-01 00:00:00.000 | dex | 125775 |
11 | 2025-02-01 00:00:00.000 | dapp | 78977 |
12 | 2025-02-01 00:00:00.000 | cex | 30090 |
13 | 2025-03-01 00:00:00.000 | games | 17124525 |
14 | 2025-03-01 00:00:00.000 | token | 962004 |
15 | 2025-03-01 00:00:00.000 | nft | 375447 |
16 | 2025-03-01 00:00:00.000 | dex | 112667 |
17 | 2025-03-01 00:00:00.000 | cex | 22383 |
18 | 2025-03-01 00:00:00.000 | dapp | 11282 |
19 | 2025-03-01 00:00:00.000 | operator | 9 |
permaryTransaction breakdown
Updated 4 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
DATE_TRUNC('month', t.block_timestamp) AS month,
dl.label_type AS transaction_category,
COUNT(*) AS total_transactions
FROM ronin.core.fact_transactions t
LEFT JOIN ronin.core.dim_labels dl
ON t.to_address = dl.address
WHERE t.block_timestamp >= '2025-01-01' AND t.block_timestamp < '2025-04-01'
AND dl.label_type IS NOT NULL -- Exclude transactions with no label
GROUP BY 1, 2
ORDER BY 1, 3 DESC;
Last run: 4 days ago
19
796B
4s