0xHaM-dAverage Hourly Fee
Updated 2024-09-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with
fee as (
select block_timestamp,
tx_fee
from kaia.core.fact_transactions
)
select
trunc(block_timestamp,'{{Time_Interval}}') as date,
avg(tx_fee) as "Avg Fee (KLAY)",
max(tx_fee) as max_fee_KLAY,
median(tx_fee) as median_fee_KLAY,
sum(tx_fee) as "Total Paid Fees (KLAY)"
from fee
where trunc(block_timestamp,'d') < current_date
group by 1
QueryRunArchived: QueryRun has been archived