TOTAL_TRANSACTIONS | ACTIVE_USERS | TOTAL_GAS | AVG_TRANSACTION_FEE | AVG_TRANSACTIONS_PER_SECOND | AVG_GAS_FEE_PER_TRANSACTION | AVG_GAS_SPENT_PER_USER | TOTAL_GAS_IN_USD | AVG_TRANSACTION_FEE_IN_USD | AVG_GAS_FEE_PER_TRANSACTION_IN_USD | AVG_GAS_SPENT_PER_USER_IN_USD | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 980697217 | 18081907 | 614251.528024593 | 0.0006263416653 | 31.097705 | 0.0006263416653 | 0.03397050588 | 1999104.24924419 | 0.002038452047 | 0.002038452047 | 0.1105582641 |
datavortexNear Total
Updated 2025-06-04
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 total_seconds AS (
SELECT
365 * 24 * 60 * 60 AS total_seconds_in_2025
),
NEARPrice AS (
SELECT
AVG(price) AS near_price
FROM
near.price.ez_prices_hourly
WHERE
symbol = 'NEAR'
AND hour >= '2025-01-01'
AND hour <= '2025-12-31'
),
transaction_metrics AS (
SELECT
COUNT(DISTINCT tx_hash) AS total_transactions,
COUNT(DISTINCT tx_signer) AS active_users,
SUM(transaction_fee) / POW(10, 24) AS total_gas,
AVG(transaction_fee) / POW(10, 24) AS avg_transaction_fee,
COUNT(DISTINCT tx_hash) / (365 * 24 * 60 * 60) AS avg_transactions_per_second,
SUM(transaction_fee) / COUNT(DISTINCT tx_hash) / POW(10, 24) AS avg_gas_fee_per_transaction,
SUM(transaction_fee) / COUNT(DISTINCT tx_signer) / POW(10, 24) AS avg_gas_spent_per_user
FROM
near.core.fact_transactions
WHERE
block_timestamp >= '2025-01-01'
AND block_timestamp <= '2025-12-31'
AND tx_succeeded = TRUE
),
gas_conversion AS (
SELECT
tm.total_transactions,
tm.active_users,
tm.total_gas,
tm.avg_transaction_fee,
Last run: 12 days ago
1
155B
129s