TRANSACTIONS | USER | FEES | AVERAGE_FEE | FEE_USD | AVERAGE_FEE_USD | |
|---|---|---|---|---|---|---|
1 | 4006789 | 66449 | 9.610273521 | 0.00000239849753 | 33025.304600464 | 0.008242336844 |
freemartianTotal Transactions
Updated 2025-01-14
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
›
⌄
with prices AS(
SELECT hour::date AS price_day, AVG(price) AS price
FROM ethereum.price.ez_prices_hourly
WHERE symbol = 'WETH'
AND hour::date >= '2024-12-06'
GROUP BY 1
),
total_transactions as(
SELECT
*, tx_fee * price AS tx_fee_usd
FROM ink.core.fact_transactions
left join prices on (block_timestamp::date = price_day)
WHERE block_timestamp::date >= '2024-12-09 '
)
SELECT
count(DISTINCT tx_hash) as transactions,
count(DISTINCT from_address) AS user,
SUM(tx_fee) AS fees,
AVG(tx_fee) AS average_fee,
SUM(tx_fee_usd) AS fee_usd,
avg(tx_fee_usd) AS average_fee_usd
FROM total_transactions
-- left join prices on (price_day = day)
WHERE block_timestamp::date >= '2024-12-09 '
Last run: 2 months ago
1
77B
2s