FEE_CATEGORY | NUM_TRANSACTIONS | |
|---|---|---|
1 | Ultra Low (< 0.000000001 BTC) | 492391 |
2 | Very Low (0.000000001 - 0.000001 BTC) | 7608 |
3 | Low (0.000001 - 0.00005 BTC) | 5498 |
4 | Moderate (0.00005 - 0.0005 BTC) | 629 |
5 | High (0.0005 - 0.005 BTC) | 80 |
6 | Extreme (>= 0.005 BTC) | 14 |
Afonso_DiazGrouping tx fee
Updated 3 days ago
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
›
⌄
WITH main AS (
SELECT
tx_hash,
block_timestamp,
from_address AS user,
tx_fee
FROM
mezo.testnet.fact_transactions
WHERE
tx_succeeded
),
categorized AS (
SELECT
CASE
WHEN tx_fee < 0.000000001 THEN 'Ultra Low (< 0.000000001 BTC)'
WHEN tx_fee < 0.000001 THEN 'Very Low (0.000000001 - 0.000001 BTC)'
WHEN tx_fee < 0.00005 THEN 'Low (0.000001 - 0.00005 BTC)'
WHEN tx_fee < 0.0005 THEN 'Moderate (0.00005 - 0.0005 BTC)'
WHEN tx_fee < 0.005 THEN 'High (0.0005 - 0.005 BTC)'
ELSE 'Extreme (>= 0.005 BTC)'
END AS fee_category
FROM main
)
SELECT
fee_category,
COUNT(*) AS num_transactions
FROM categorized
GROUP BY fee_category
ORDER BY COUNT(*) DESC
Last run: 3 days ago
6
230B
1s