ACTIVE_USERS | TOTAL_TRANSACTIONS | TOTAL_RON_VOLUME | TOTAL_TXN_FEE_GENERATED | TOTAL_VOLUME_USD | |
|---|---|---|---|---|---|
1 | 3073682 | 85501974 | 701716471.914595 | 205152.520215062 | 4353570420.72866 |
permaryOverall Ronin Stats for q1
Updated 2025-04-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH address_stats AS (
-- Get distinct addresses to avoid double counting
SELECT COUNT(DISTINCT address) AS active_users
FROM (
SELECT from_address AS address FROM ronin.core.fact_transactions
WHERE block_timestamp >= '2025-01-01' AND block_timestamp < '2025-04-01'
AND from_address IS NOT NULL
UNION
SELECT to_address AS address FROM ronin.core.fact_transactions
WHERE block_timestamp >= '2025-01-01' AND block_timestamp < '2025-04-01'
AND to_address IS NOT NULL
) unique_addresses
),
transaction_stats AS (
-- Get transaction metrics in a separate query
SELECT
COUNT(*) AS total_transactions,
SUM(value) AS total_ron_volume,
SUM(tx_fee) AS total_txn_fee_generated
FROM ronin.core.fact_transactions
WHERE block_timestamp >= '2025-01-01' AND block_timestamp < '2025-04-01'
),
volume_stats AS (
SELECT
SUM(COALESCE(amount_usd, 0)) AS total_volume_usd
FROM (
-- Native Transfers (RON)
SELECT amount_usd
FROM ronin.core.ez_native_transfers
WHERE block_timestamp >= '2025-01-01' AND block_timestamp < '2025-04-01'
UNION ALL
-- Token Transfers (ERC-20, ERC-721, etc.)
Last run: 25 days ago
1
71B
7s