Chain | Total Transaction Fees (NEAR) | |
|---|---|---|
1 | NEAR | 263.266208 |
2 | Ethereum | 139.746955 |
3 | Zcash | 49.849889 |
4 | Solana | 37.241664 |
5 | Arbitrum | 18.043001 |
6 | Base | 16.042693 |
7 | Bitcoin | 15.399366 |
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 ChainData AS (
SELECT
token_id,
CASE
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('eth') THEN 'Ethereum'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('sol') THEN 'Solana'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('btc') THEN 'Bitcoin'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('gnosis') THEN 'Gnosis'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('arb') THEN 'Arbitrum'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('base') THEN 'Base'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('aurora') THEN 'Aurora'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('xrp') THEN 'XRP Ledger'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('bsc') THEN 'BNB Smart Chain'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('zec') THEN 'Zcash'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('doge') THEN 'Dogecoin'
WHEN REGEXP_REPLACE(SPLIT_PART(token_id, 'nep141:', 2), '[-.].*', '') IN ('bera') THEN 'Berachain'
ELSE 'NEAR'
END AS blockchain_name,
tx_hash
FROM near.defi.fact_intents
WHERE receipt_succeeded = TRUE
AND tx_hash IS NOT NULL
),
FeeData AS (
SELECT
c.tx_hash,
c.blockchain_name,
t.transaction_fee / POW(10, 24) AS fee_in_near
FROM near.core.fact_transactions t
INNER JOIN ChainData c ON t.tx_hash = c.tx_hash
WHERE t.transaction_fee IS NOT NULL
)
SELECT
blockchain_name AS "Chain",
ROUND(SUM(fee_in_near), 6) AS "Total Transaction Fees (NEAR)"
FROM FeeData
Last run: 24 days ago
7
150B
102s