Afonso_DiazGrouping fee
Updated 2025-04-03
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 main AS (
SELECT
tx_hash,
block_timestamp,
from_address AS user,
tx_fee,
CASE
WHEN tx_fee < 0.00001 THEN 'Less than 0.00001 ETH'
WHEN tx_fee < 0.00005 THEN '0.00001 - 0.00005 ETH'
WHEN tx_fee < 0.0001 THEN '0.00005 - 0.0001 ETH'
WHEN tx_fee < 0.0005 THEN '0.0001 - 0.0005 ETH'
WHEN tx_fee < 0.001 THEN '0.0005 - 0.001 ETH'
WHEN tx_fee < 0.0025 THEN '0.001 - 0.0025 ETH'
WHEN tx_fee < 0.005 THEN '0.0025 - 0.005 ETH'
WHEN tx_fee < 0.01 THEN '0.005 - 0.01 ETH'
WHEN tx_fee < 0.025 THEN '0.01 - 0.025 ETH'
WHEN tx_fee < 0.05 THEN '0.025 - 0.05 ETH'
WHEN tx_fee < 0.1 THEN '0.05 - 0.1 ETH'
ELSE 'More than 0.1 ETH'
END AS fee_group
FROM
boba.core.fact_transactions
WHERE
tx_succeeded
)
SELECT
fee_group,
COUNT(DISTINCT tx_hash) AS transactions,
COUNT(DISTINCT user) AS users
FROM
main
GROUP BY 1
ORDER BY 1
QueryRunArchived: QueryRun has been archived