datavortexGaS fEES Eth
Updated 2024-11-05
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
›
⌄
WITH CurrentETHPrice AS (
SELECT
price AS current_price
FROM
ethereum.price.ez_prices_hourly
WHERE
symbol ILIKE 'ETH'
ORDER BY
hour DESC
LIMIT 1
),
Swaps AS (
SELECT
tx_hash
FROM
ethereum.defi.ez_dex_swaps
WHERE
block_timestamp BETWEEN '2024-10-01' AND '2024-10-31'
)
SELECT
SUM(T.tx_fee) AS TotalGasFees,
COUNT(DISTINCT S.tx_hash) AS TotalSwaps,
(SELECT current_price FROM CurrentETHPrice) AS CurrentPrice,
SUM(T.tx_fee) * (SELECT current_price FROM CurrentETHPrice) AS TotalGasFeesUSD,
CASE
WHEN COUNT(DISTINCT S.tx_hash) > 0 THEN SUM(T.tx_fee) / COUNT(DISTINCT S.tx_hash)
ELSE 0
END AS AverageFeePerTransaction
FROM
Swaps S
JOIN
ethereum.core.fact_transactions T ON S.tx_hash = T.tx_hash;
QueryRunArchived: QueryRun has been archived