FrodoDaily Blocks
Updated 2024-03-12
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date(BLOCK_TIMESTAMP) as date,
count(distinct BLOCK_NUMBER) as blocks_count,
count(distinct (case when tx_count = '0' then BLOCK_NUMBER end)) as block_with_zero_tx,
(block_with_zero_tx/blocks_count * 100) as percent,
sum(TX_COUNT) as TXS_COUNT,
TXS_COUNT/blocks_count as avg_txs_per_block
from aurora.core.fact_blocks
where BLOCK_TIMESTAMP::date != '1970-01-01'
group by 1
order by 1
QueryRunArchived: QueryRun has been archived