superflyUntitled Query
    Updated 2022-12-20
    select day , n_address as "Number of New User Address", sum(n_address) OVER(ORDER BY day asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS "New User Growth"
    from (select date_trunc('day',tm) as day , count(distinct from_address) as n_address
    from (select FROM_ADDRESS, min(block_timestamp) as tm from optimism.core.fact_transactions
    group by 1)
    group by 1 order by 1)
    where day>='2022-09-01'
    order by 1
    Run a query to Download Data