greyswan2024-03-22 01:18 PM
Updated 2024-03-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
date_trunc('month', first_tx_date) as first_month,
count (distinct a.signers[0]) as number_of_users
from
solana.core.fact_events a
left join solana.core.ez_signers b on a.signers [0] = b.signer
where
program_id = 'PERPHjGBqRHArX4DySjwM6UJHiR3sWAatqfdBS2qQJu'
and BLOCK_TIMESTAMP >= current_date - 180
group by date_trunc('month', first_tx_date)
order by count (distinct a.signers[0]) desc
QueryRunArchived: QueryRun has been archived