cypherETH miners
    Updated 2022-09-09
    with bins as (
    select
    floor(tx_count/1)*1 as bin_floor,
    count(tx_count) as count
    from ethereum.core.fact_blocks
    group by 1
    order by 1
    -- same query as above, just in a CTE
    )

    select
    bin_floor,
    bin_floor || ' - ' || (bin_floor + 1) as bin_range,
    count,
    row_number() over (order by bin_floor asc) as rank
    from bins
    order by 1;



    Run a query to Download Data