MLDZMNzd2
Updated 2023-03-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
block_timestamp::date as date,
case
when PROGRAM_ID in ('ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD') then 'Zeta'
when PROGRAM_ID in ('dammHkt7jmytvbS3nHTxQNEcP59aE57nxwV21YdqEDNm','dRiftyHA39MWEi3m9aunc5MzRF1JYuBsbn6VPcn33UH') then 'Drift'
end as programs,
count(distinct SIGNERS[0]) as no_users,
Count(distinct tx_id) as no_txn,
sum(no_users) over (partition by programs order by date) as total_users
from solana.core.fact_events
where SUCCEEDED='TRUE'
and BLOCK_TIMESTAMP >= '2023-01-01'
group by 1,2 having programs is not null
Run a query to Download Data