AnalyticSagesTotal Gas Fee
Updated 2024-02-18
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
›
⌄
--Trading Volume
WITH PriceS AS (
SELECT
HOUR::date AS qdate,
AVG(price) AS USD
FROM crosschain.price.ez_hourly_token_prices
WHERE SYMBOL = 'WETH'
GROUP BY 1
)
SELECT
--date_trunc('day', TIMESTAMP) AS Days,
COUNT(DISTINCT tx_hash) AS txs,
COUNT(DISTINCT CONTRACT) AS users,
(txs/users) AS "TXS Per Users",
SUM(ACTUAL_FEE / pow(10,18)) AS "Gas Fee (ETH)",
SUM(ACTUAL_FEE * usd) / pow(10, 18) AS "Gas Fee (USD)"
FROM external.tokenflow_starknet.decoded_transactions
LEFT JOIN PriceS ON qdate = DATE(TIMESTAMP)
WHERE CHAIN_ID = 'mainnet'
AND TIMESTAMP < current_date
--GROUP BY 1
--ORDER BY 1 DESC
QueryRunArchived: QueryRun has been archived