HaisenbergRAY-Active-wallets
Updated 2023-10-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH UserActivityData AS (
SELECT
tx_from AS users,
DATE_TRUNC('DAY', block_timestamp) AS day
FROM
solana.core.fact_transfers
WHERE
mint = '4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R' -- RAY TOKEN
AND block_timestamp >= '2023-01-01'
)
SELECT
day,
COUNT(DISTINCT users) AS Total_Users
FROM
UserActivityData
GROUP BY
1
ORDER BY
1 DESC;
Run a query to Download Data