MoDeFignosis analysis - 5 new users
    Updated 2022-10-16
    with users as (
    select FROM_ADDRESS, min(BLOCK_TIMESTAMP) as BLOCK_TIMESTAMP
    from (
    select FROM_ADDRESS, BLOCK_TIMESTAMP
    from gnosis.core.fact_transactions
    where STATUS='SUCCESS'
    union all
    select TO_ADDRESS, BLOCK_TIMESTAMP
    from gnosis.core.fact_transactions
    where STATUS='SUCCESS')
    group by FROM_ADDRESS)

    select * from
    (select *,
    sum(users) over (order by date) as total_users
    from
    (select date_trunc(day,BLOCK_TIMESTAMP) as date, count(distinct FROM_ADDRESS) as users
    from users
    group by date))
    where date>=CURRENT_DATE-60

    Run a query to Download Data