alfredfx10gas fee in native token
Updated 2024-08-08
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
›
⌄
WITH Total_Transactions_Fees AS (
SELECT STATUS,TX_FEE,'Arbitrum' AS Chain
FROM arbitrum.core.fact_transactions
WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')
UNION ALL
SELECT STATUS,TX_FEE, 'Base' AS Chain
FROM base.core.fact_transactions
WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')
UNION ALL
SELECT STATUS,TX_FEE, 'Blast' AS Chain
FROM blast.core.fact_transactions
WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')
UNION ALL
SELECT STATUS,TX_FEE, 'Bsc' AS Chain
FROM bsc.core.fact_transactions
WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')
UNION ALL
SELECT STATUS,TX_FEE, 'Polygon' AS Chain
FROM polygon.core.fact_transactions
WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')
UNION ALL
SELECT STATUS,TX_FEE, 'Optimism' AS Chain
FROM optimism.core.fact_transactions
WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7'))
SELECT STATUS,Chain,
SUM (TX_FEE) AS "Total Transaction Fee"
FROM Total_Transactions_Fees
WHERE STATUS='SUCCESS'
GROUP BY Chain, STATUS
QueryRunArchived: QueryRun has been archived