CarlOwOseth fees
Updated 2022-05-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH ETH_FEES AS (
SELECT
date(block_timestamp) as eth_date,
count(distinct FROM_ADDRESS) as eth_address_count,
count(distinct tx_id) as eth_tx_count ,
sum(fee_usd) as eth_fees,
eth_fees/eth_tx_count as eth_fees_per_tx
FROM ethereum.transactions
WHERE block_timestamp >= '2022-01-01'
GROUP BY 1
ORDER BY 1
)
SELECT
eth_date,
eth_address_count as "Unique Address",
eth_tx_count as "Transactions",
eth_fees as "Price (USD)",
eth_fees_per_tx
FROM ETH_FEES
Run a query to Download Data