Successful Transactions | Total Transaction Fees (NEAR) | Average Transaction Fee (NEAR) | |
|---|---|---|---|
1 | 208533 | 244.104794 | 0.001171 |
datavortextx_fees
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
›
⌄
WITH SuccessfulTx AS (
SELECT
DISTINCT tx_hash
FROM
near.defi.fact_intents
WHERE
receipt_succeeded = TRUE
AND tx_hash IS NOT NULL
),
FeeData AS (
SELECT
t.tx_hash,
t.transaction_fee / POW(10, 24) AS fee_in_near
FROM
near.core.fact_transactions t
INNER JOIN SuccessfulTx s ON t.tx_hash = s.tx_hash
WHERE
t.transaction_fee IS NOT NULL
)
SELECT
COUNT(DISTINCT tx_hash) AS "Successful Transactions",
ROUND(SUM(fee_in_near), 6) AS "Total Transaction Fees (NEAR)",
ROUND(AVG(fee_in_near), 6) AS "Average Transaction Fee (NEAR)"
FROM
FeeData;
Last run: 27 days ago
1
30B
102s