mmdrezaWeekly users and new users in MakerDao
    Updated 2022-09-04
    with tab1 as (select voter,min(date_trunc('week',block_timestamp)) as mdate
    from ethereum.maker.ez_governance_votes
    group by voter),
    tab2 as (select mdate,count(*) as new_voter
    from tab1
    group by mdate)
    select
    mdate,new_voter,sum(new_voter) over (ORDER BY mdate) as total_users
    from tab2
    order by mdate asc

    Run a query to Download Data