lj10242024-03-18 12:14 PM
Updated 2024-03-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
floor(block_id / 432000) as "Epoch",
avg("block_fee") as "Average block fee",
stddev("block_fee") as "Std.dev. block fee",
from
(select
block_id,
sum(fee / 1e9 / 2) as "block_fee"
from solana.core.fact_transactions
where
date_trunc('day', block_timestamp) between '2024-03-01' and '2024-03-22'
group by block_id
)
group by floor(block_id / 432000)
order by floor(block_id / 432000) desc
QueryRunArchived: QueryRun has been archived