25 rows yesterday at 3:48 PM
1
2
3
4
5
6
7
8
9
10
11
12
13
select
date_trunc('hour', timestamp) as chart_x,
anyLast(base_fee_per_gas) / 1e9 as chart_y_base,
quantilesArray (0.5, 0.9) (transaction_effective_gas_price / 1e9) as "quantile",
"quantile" [1] as chart_y_average,
"quantile" [2] as chart_y_fast
from
evm_blocks_ethereum_mainnet_v1
where
timestamp >= now() - interval 1 day
group by
chart_x