flipside

    5 The biggest blocks of Ethereum(L1)
    Drsimon 5 The biggest blocks of Ethereum(L1)
    Updated 2022-07-26
    select top 5 BLOCK_NUMBER, avg(TX_HASH) as Avg_transactions, SUM(TX_HASH) as Total_transactions
    from ethereum.core.fact_transactions
    group by BLOCK_NUMBER
    order by SUM(TX_HASH) desc

    Run a query to Download Data