mlhDaily Number of OpenBook Transactions and Active Users Over Time
Updated 2022-11-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with newuser as (select mindate::date as day,
count (distinct user1) as New_Users,
sum (new_users) over (order by day) as Total_Users
from (select instruction:accounts[1] as user1,
min (block_timestamp) as mindate
from solana.core.fact_events
where program_id = 'srmqPvymJeFKQ4zGQed1GFppgkRHL9kaELCbyksJtPX'
and succeeded = 'TRUE'
group by 1
)
group by 1
)
select block_timestamp::date as date,
New_Users,
Total_Users,
count (distinct tx_id) as trxs,
count (distinct instruction:accounts[1]) as users
from solana.core.fact_events a join newuser b on a.block_timestamp::Date = b.day
where program_id = 'srmqPvymJeFKQ4zGQed1GFppgkRHL9kaELCbyksJtPX'
and succeeded = 'TRUE'
group by 1,2,3
Run a query to Download Data