TOTAL_TRANSACTIONS | ACTIVE_USERS | TOTAL_FEES_NEAR | TRANSACTION_CHANGE_PCT | USER_CHANGE_PCT | FEES_CHANGE_PCT | TOTAL_BLOCKS | AVG_BLOCKS_PER_DAY | |
|---|---|---|---|---|---|---|---|---|
1 | 2595628420 | 57967271 | 1491941.77773 | 183.66 | 44.29 | 28.22 | 27446155 | 75194.945205 |
datavortextotals
Updated 2025-04-30
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 this_year AS (
SELECT
COUNT(DISTINCT tx_hash) AS total_tx,
COUNT(DISTINCT tx_signer) AS active_users,
SUM(transaction_fee) / 1e24 AS total_fees
FROM
near.core.fact_transactions
WHERE
tx_succeeded = TRUE
AND block_timestamp >= DATEADD(year, -1, CURRENT_DATE)
AND block_timestamp < CURRENT_DATE
),
last_year AS (
SELECT
COUNT(DISTINCT tx_hash) AS total_tx,
COUNT(DISTINCT tx_signer) AS active_users,
SUM(transaction_fee) / 1e24 AS total_fees
FROM
near.core.fact_transactions
WHERE
tx_succeeded = TRUE
AND block_timestamp >= DATEADD(year, -2, CURRENT_DATE)
AND block_timestamp < DATEADD(year, -1, CURRENT_DATE)
),
blocks_data AS (
SELECT
COUNT(DISTINCT block_id) AS total_blocks,
COUNT(DISTINCT block_id) / 365.0 AS avg_blocks_per_day
FROM
near.core.fact_blocks
WHERE
block_timestamp >= DATEADD(year, -1, CURRENT_DATE)
AND block_timestamp < CURRENT_DATE
)
SELECT
ty.total_tx AS total_transactions,
Last run: 30 days ago
1
78B
434s