Elprognerd5 - optimism new
Updated 2023-02-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with t1 as (select FROM_ADDRESS as "New User Address" , min(block_timestamp) as date1
from optimism.core.fact_transactions
where STATUS='SUCCESS'
GROUP by 1)
SELECT
date_trunc('day', date1) as date,
case when date >= '2023-01-01' then '2023' else '2022' end as "Year",
COUNT("New User Address") as "Number of New Users per Day",
sum("Number of New Users per Day") over (order by date asc) as "Cumulative Number of New Users per Day"
from t1
WHERE date >= CURRENT_DATE - INTERVAL '90 days'
GROUP by 1, 2
order by 1
Run a query to Download Data