jimmysandsnapshot3
Updated 2022-08-21
9
1
2
3
4
5
6
›
⌄
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