Flipside TeamNew Users - $WIF
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
23
24
25
26
›
⌄
-- forked from New Users - $WIF @ https://flipsidecrypto.xyz/edit/queries/7192d290-01a0-4720-a651-c413614f924d
-- 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
, TX_FROM as USER_ADDRESS
from solana.core.fact_transfers
where MINT = 'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm'
)
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