Afonso_Diaz2023-06-15 11:45 PM
Updated 2023-06-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
with t as (
select
tx_id,
block_timestamp,
signers[0] as user,
case
when program_id = 'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA' then 'MarginFi'
when program_id = 'ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD' then 'Zeta'
else 'Jupiter'
end as platform
from solana.core.fact_events
where program_id in (
'JUP3c2Uh3WA4Ng34tw6kPd2G4C5BB21Xo36Je1s32Ph',
'JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB',
'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA',
'ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD',
'JUP6i4ozu5ydDCnLiMogSckDPpbtr7BJ4FtzYWkb5Rk',
'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo'
)
)
select
platform,
count(distinct tx_id) as transactions,
count(distinct user) as users,
transactions / count(distinct block_timestamp::date) as daily_average_transactions,
users / count(distinct block_timestamp::date) as daily_average_users
from t
where block_timestamp::date >= current_date - 60
group by 1
Run a query to Download Data