phu[Ethereum] zoom in the Aug 5 - Sep 14, 2022 period
    Updated 2022-09-17
    with
    miner_cte as (
    select
    BLOCK_TIMESTAMP::date date
    , miner
    from ethereum.core.fact_blocks
    )
    , before_aug_sep_cte as (
    select
    distinct
    miner
    from miner_cte
    where date < '2022-08-05'
    )
    , aug_sep_cte as (
    select
    distinct
    miner
    from miner_cte
    where date between '2022-08-05' and '2022-09-14'
    )
    select
    case
    when b.miner is null then 'New'
    else 'Return'
    end type
    , count(a.miner) miner
    from aug_sep_cte a
    left join before_aug_sep_cte b using(miner)
    group by 1
    Run a query to Download Data