TOTAL_BLOCKS | TOTAL_TRANSACTION_FEE_NEAR | Average Transaction Fee Per Block (USD) | |
|---|---|---|---|
1 | 13316377 | 614719.345081676 | 0.1502181726 |
datavortexavg feees per block
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 usd_conversion AS (
SELECT
avg(price) AS near_price_usd
FROM
near.price.ez_prices_hourly
WHERE
symbol = 'NEAR'
AND hour >= '2025-01-01'
AND hour <= '2025-12-31'
),
transactions_with_gas AS (
SELECT
tx_hash,
block_id,
transaction_fee,
block_timestamp
FROM
near.core.fact_transactions
WHERE
block_timestamp >= '2025-01-01'
AND block_timestamp <= '2025-12-31'
AND tx_succeeded = TRUE
),
transactions_with_price AS (
SELECT
t.tx_hash,
t.block_id,
t.transaction_fee,
t.block_timestamp,
u.near_price_usd
FROM
transactions_with_gas t
CROSS JOIN
usd_conversion u
)
SELECT
Last run: 10 days ago
1
42B
515s