superflyUntitled Query
Updated 2022-12-20Copy Reference Fork
9
1
2
3
4
5
6
7
8
›
⌄
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