PS0G1eth 1
Updated 2022-11-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with new_user as (
SELECT
min(BLOCK_TIMESTAMP) as min_date,
FROM_ADDRESS
FROM ethereum.core.fact_transactions
WHERE TO_ADDRESS in ('0x07ced903e6ad0278cc32bc83a3fc97112f763722', '0x2657101a6bb5538dd84b0b8c8e2deac667b9c66c',
'0x13e9053d9090ed6a1fae3f59f9bd3c1fca4c5726')
GROUP by 2
)
SELECT
min_date::DATE as date,
COUNT(DISTINCT FROM_ADDRESS) as newUser_cnt,
sum(newUser_cnt) over (order by date) as cum_newUser_cnt
FROM new_user
GROUP by 1
order by 1
Run a query to Download Data