FrodoDaily Blocks
    Updated 2024-03-12
    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