MLDZMNCompare1
Updated 2023-04-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
case
when PROGRAM_ID in ('ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD') then 'Zeta'
when PROGRAM_ID in ('dammHkt7jmytvbS3nHTxQNEcP59aE57nxwV21YdqEDNm','dRiftyHA39MWEi3m9aunc5MzRF1JYuBsbn6VPcn33UH') then 'Drift'
when PROGRAM_ID in ('4MangoMjqJ2firMokCjjGgoK8d4MXcrgL7XJaL3w6fVg') then 'Mango Markets'
end as programs,
count(distinct SIGNERS[0]) as no_users,
Count(distinct tx_id) as no_txn,
no_txn/no_users as transaction_per_user,
no_users/count(distinct date_trunc(day, block_timestamp)) as average_user_day,
no_users/count(distinct date_trunc('week', block_timestamp)) as average_user_week
from solana.core.fact_events
where SUCCEEDED='TRUE'
and BLOCK_TIMESTAMP >= '2023-01-01'
group by 1 having programs is not null
Run a query to Download Data