freemartianSolana Average block time
9
1
2
3
4
5
6
7
8
›
⌄
with base as (select block_id as first_block_number, block_timestamp from solana.core.fact_transactions where block_timestamp > CURRENT_DATE - 45),
base1 as (select first_block_number + 1 as second_block_number, block_timestamp from base),
info as (select ft.block_id as bn, timestampdiff('SECOND', base1.BLOCK_TIMESTAMP, base.block_timestamp) AS time_diff
from solana.core.fact_transactions ft
inner join base on base.first_block_number = ft.block_id
inner join base1 on base1.second_block_number = ft.block_id)
select sum(time_diff)/count(bn) as average_block_time, 'Solana' as label
from info
Run a query to Download Data