bintuparis1 month Daily New Wallets
Updated 2025-02-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
SELECT
DATE_TRUNC('day', EARLIEST) as daily,
COUNT(OWNER) AS new_wallets
FROM
(
SELECT
OWNER,
min(block_timestamp) AS EARLIEST
FROM
solana.core.fact_token_balances
WHERE
mint LIKE 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
AND PRE_BALANCE = 0
AND BALANCE > 0
and block_timestamp::date >= current_date - interval '1 month'
GROUP BY
OWNER
)
group by
1
order by
1
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived