HOUR_ | MEDIAN_FEE | PERCT_95 | PERCT_05 | |
|---|---|---|---|---|
1 | 2025-04-09 10:00:00.000 | 0.0017 | 0.02 | 0.0011 |
2 | 2025-04-09 11:00:00.000 | 0.0035 | 0.0236 | 0.0011 |
3 | 2025-04-09 12:00:00.000 | 0.0017 | 0.0206 | 0.0011 |
4 | 2025-04-09 13:00:00.000 | 0.0017 | 0.0208 | 0.0011 |
5 | 2025-04-09 14:00:00.000 | 0.0011 | 0.0133 | 0.0011 |
6 | 2025-04-09 15:00:00.000 | 0.0017 | 0.0194 | 0.0011 |
7 | 2025-04-09 16:00:00.000 | 0.0024 | 0.0205 | 0.0011 |
8 | 2025-04-09 17:00:00.000 | 0.0023 | 0.0208 | 0.0011 |
9 | 2025-04-09 18:00:00.000 | 0.0024 | 0.0207 | 0.0011 |
10 | 2025-04-09 19:00:00.000 | 0.0017 | 0.0208 | 0.0011 |
11 | 2025-04-09 20:00:00.000 | 0.0024 | 0.0208 | 0.0011 |
12 | 2025-04-09 21:00:00.000 | 0.0023 | 0.0208 | 0.0011 |
13 | 2025-04-09 22:00:00.000 | 0.0017 | 0.0178 | 0.0011 |
14 | 2025-04-09 23:00:00.000 | 0.0019 | 0.0208 | 0.0011 |
15 | 2025-04-10 00:00:00.000 | 0.0024 | 0.0204 | 0.0011 |
16 | 2025-04-10 01:00:00.000 | 0.0028 | 0.0208 | 0.0011 |
17 | 2025-04-10 02:00:00.000 | 0.0032 | 0.0216 | 0.0011 |
18 | 2025-04-10 03:00:00.000 | 0.0021 | 0.0203 | 0.0011 |
19 | 2025-04-10 04:00:00.000 | 0.0028 | 0.0208 | 0.0011 |
20 | 2025-04-10 05:00:00.000 | 0.0028 | 0.0208 | 0.0011 |
Monad Metrics Guildtransaction-fees
Updated 1 day ago
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
date_trunc(hour, block_timestamp) as hour_
, round(median(tx_fee), 4) as median_fee
, round(percentile_disc(0.95) within group (order by tx_fee), 4) as perct_95
, round(percentile_disc(0.05) within group (order by tx_fee), 4) as perct_05
from monad.testnet.fact_transactions
where block_timestamp between (date_trunc(hour, sysdate() - interval '7 days')) and (date_trunc(hour, sysdate()) - interval '1 hour' - interval '1 second')
and tx_succeeded
group by 1
order by 1
Last run: 1 day ago
...
165
8KB
5s