AVG_TX_FEE_USD | |
|---|---|
1 | 0.0042998785 |
feyikemiNEAR Txn Fee
Updated 2025-03-25
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
›
⌄
WITH transaction_fees AS (
SELECT
(TRANSACTION_FEE / POW(10, 24)) AS tx_fee,
DATE_TRUNC('day', block_timestamp) AS date
FROM near.core.fact_transactions
WHERE block_timestamp::date >= '2024-01-01'
),
price_data AS (
SELECT
DATE_TRUNC('day', Hour) AS date,
AVG(price) AS avg_price
FROM near.price.ez_prices_hourly
WHERE symbol = 'LINEAR'
GROUP BY date
),
daily_fees AS (
SELECT
tf.date,
tf.tx_fee * pd.avg_price AS fee_usd
FROM transaction_fees tf
JOIN price_data pd ON tf.date = pd.date
)
SELECT
AVG(fee_usd) AS avg_tx_fee_usd
FROM daily_fees
Last run: 2 months ago
1
16B
91s