PERCENTILE_5 | PERCENTILE_10 | PERCENTILE_15 | PERCENTILE_20 | PERCENTILE_25 | PERCENTILE_30 | PERCENTILE_35 | PERCENTILE_40 | PERCENTILE_45 | PERCENTILE_50 | PERCENTILE_55 | PERCENTILE_60 | PERCENTILE_65 | PERCENTILE_70 | PERCENTILE_75 | PERCENTILE_80 | PERCENTILE_85 | PERCENTILE_90 | PERCENTILE_95 | PERCENTILE_100 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.0011 | 0.0011 | 0.0011 | 0.0011 | 0.0011 | 0.0011 | 0.0011 | 0.0011 | 0.0011 | 0.0011 | 0.0011 | 0.0011 | 0.0011 | 0.0012 | 0.0013 | 0.0013 | 0.0016 | 0.0021 | 0.0022 | 21000 |
JeffersPercentiles gas fee
Updated 2025-03-05
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
35
36
›
⌄
WITH percentiles AS (
SELECT
ROUND(PERCENTILE_CONT(0.05) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_5,
ROUND(PERCENTILE_CONT(0.10) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_10,
ROUND(PERCENTILE_CONT(0.15) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_15,
ROUND(PERCENTILE_CONT(0.20) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_20,
ROUND(PERCENTILE_CONT(0.25) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_25,
ROUND(PERCENTILE_CONT(0.30) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_30,
ROUND(PERCENTILE_CONT(0.35) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_35,
ROUND(PERCENTILE_CONT(0.40) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_40,
ROUND(PERCENTILE_CONT(0.45) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_45,
ROUND(PERCENTILE_CONT(0.50) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_50, -- median
ROUND(PERCENTILE_CONT(0.55) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_55,
ROUND(PERCENTILE_CONT(0.60) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_60,
ROUND(PERCENTILE_CONT(0.65) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_65,
ROUND(PERCENTILE_CONT(0.70) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_70,
ROUND(PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_75,
ROUND(PERCENTILE_CONT(0.80) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_80,
ROUND(PERCENTILE_CONT(0.85) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_85,
ROUND(PERCENTILE_CONT(0.90) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_90,
ROUND(PERCENTILE_CONT(0.95) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_95,
ROUND(PERCENTILE_CONT(1.00) WITHIN GROUP (ORDER BY t.tx_fee) OVER (), 4) AS percentile_100
FROM monad.testnet.fact_transactions t
LEFT JOIN monad.testnet.dim_contracts c
ON t.to_address = c.address
WHERE t.value > 0
AND t.block_timestamp >= '2025-02-19 15:00'
AND t.tx_succeeded = 'TRUE'
AND c.address IS NULL
AND t.from_address != t.to_address; -- Exclude self-transfers
)
SELECT DISTINCT
percentile_5,
percentile_10,
percentile_15,
percentile_20,
Last run: about 2 months ago
1
142B
8s