Elprognerd2 new users
Updated 2023-02-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with t1 as (SELECT
from_address as new_user,
min(block_timestamp) as date1
from polygon.core.fact_transactions
GROUP by 1)
SELECT
date_trunc('day', date1) as date,
case when date < '2023-01-18' then 'Before hard fork'
else 'After hard fork' end as date_cat,
count(*) as n_new_users
from t1
where date1 >= '2023-01-01'
GROUP by 1, 2
order by 1
Run a query to Download Data