amirrzDaily Active Users on Solana DeFi on Average
Updated 2022-10-15Copy Reference Fork
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
›
⌄
with
table1 as (
select
block_timestamp::date as date,
case
when
block_timestamp >= '2022-09-11' and block_timestamp <'2022-10-11 23:00:00.000' then 'Before Mango Hack'
when
block_timestamp >= '2022-10-11 23:00:00.000' then 'After Mango Hack' else null end as timespan,
count (distinct tx_id) as TX_Count,
count (distinct signers[0]) as Users_Count
from
solana.core.fact_transactions t1 join solana.core.dim_labels t2 on t1.instructions[0]:programId = t2.address
where
address_name not in ('token program','associated token account','systeminstruction','memo program','config_instruction','token 2022 program','pyth oracle')
and
timespan is not null
and
succeeded = 'TRUE' group by 1,2)
select
timespan,
avg (tx_count) as Average_TX_Count,
avg (users_Count) as Average_Users_Count
from
table1 group by 1
Run a query to Download Data