Flipside TeamNew Users - $DOGE
Updated 2024-07-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
-- forked from New Users - $DOGE @ https://flipsidecrypto.xyz/edit/queries/bc29fcee-8b9a-438a-a58a-6e671e50a5f8
-- forked from New Users - $PEPE @ https://flipsidecrypto.xyz/edit/queries/309db622-f676-437d-82a6-738fef598398
with first as(with new as (select date_trunc('day',BLOCK_TIMESTAMP) as date
, ORIGIN_TO_ADDRESS as USER_ADDRESS
from bsc.core.ez_token_transfers
where CONTRACT_ADDRESS = '0xba2ae424d960c26247dd6c32edc70b295c744c43'
)
select USER_ADDRESS ,min(date)as first_date
from new
group by 1)
select first_date as date
, count(USER_ADDRESS) as "New Users"
from first
WHERE date >= '2024-01-01'
group by 1
QueryRunArchived: QueryRun has been archived