MLDZMNmng1
Updated 2023-04-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
min(block_timestamp) as first_txn,
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 PROGRAM_ID = '4MangoMjqJ2firMokCjjGgoK8d4MXcrgL7XJaL3w6fVg'
Run a query to Download Data