afonsoaverage affect of bonk
Updated 2023-01-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with t as (
select
block_timestamp::date as day,
iff(day > '2022-12-24', 'After BONK Activation', 'Before BONK Activation') as type,
count (distinct (tx_id)) as txn_count,
count (distinct (signers[0])) as users_count
from solana.core.fact_transactions
where day between date('2022-12-24') - interval '2 weeks' and date('2022-12-24') + interval '2 weeks'
group by day, type
)
select
type,
avg(txn_count) as average_txn_count,
avg(users_count) as average_users_count
from t
group by type
order by type
Run a query to Download Data