zakkisyedSolana: Weekly average users
Updated 2022-01-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
--this query refreshes daily
select avg(no_of_users), weekly
from
(
select count (distinct (tx_from_address)) as no_of_users, --select number of unique wallet addresses
date_trunc('week', block_timestamp) as weekly --truncate block_timestamp data to a day grouping
from solana.transactions
where block_timestamp >= '2022-01-01'
and succeeded = 'TRUE'---- -- filter out successful transactions for accuracy
group by 2
order by 2 asc
)
group by 2
order by 1 desc
Run a query to Download Data