MadiNew wallets count
Updated 2023-01-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
WITH joindate as (
SELECT
FROM_ADDRESS,
min(date_trunc('day',BLOCK_TIMESTAMP)) as min_date
from optimism.core.fact_transactions
where STATUS = 'SUCCESS'
GROUP BY 1 ORDER by 2
)
SELECT
-- min_date as "Join date",
COUNT(FROM_ADDRESS) as new_users
FROM
joindate
WHERE min_date >= DATEADD(day, -{{Period}}, CAST(GETDATE() AS date)) and min_date != CURRENT_DATE
Run a query to Download Data