flipside

    top 10 miner - number of transactions
    Hadisehtop 10 miner - number of transactions
    Updated 2022-09-10
    with t1 as ( select miner,sum(tx_count) as transaction_count
    from ethereum.core.fact_blocks
    where block_timestamp >= '2022-06-11'
    group by 1
    )
    select miner , transaction_count
    from t1
    order by transaction_count desc
    limit 10
    Run a query to Download Data