jimmysandsnapshot3
    Updated 2022-08-21
    with base as (select id, min(proposal_start_time) as first_tx from ethereum.core.ez_snapshot group by 1),
    base2 as (select id, date_trunc('day', first_tx) as day, date_trunc('month', first_tx) as month, 1 as counts
    from base)
    select day, month, sum(counts) as numbering from base2
    group by 1,2

    Run a query to Download Data