flipside

    daily average transaction per block(last 30 days)
    rezarwzdaily average transaction per block(last 30 days)
    Updated 2022-07-27
    select
    count(distinct(TX_HASH))/COUNT(distinct(BLOCK_NUMBER)),
    date_trunc('day',block_timestamp) as date
    from polygon.core.fact_transactions
    GROUP BY date
    Run a query to Download Data