adriaparcerisasmango hack 3
Updated 2022-10-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH
transactions as (
SELECT
trunc (block_timestamp,'day') as date,
label,
case when block_timestamp < '2022-10-11' then 'Previous to hack' else 'After the hack' end as period,
count(distinct tx_id) as txs,
count(distinct INSTRUCTION:accounts[1]) as users
from solana.core.fact_events
join solana.core.dim_labels on program_id = address
WHERE label_type IN ('dex', 'defi') AND block_timestamp >= '2022-10-01'
GROUP BY 1, 2,3
order by 1 asc
)
SELECT
label, period,
avg(txs) as avg_transactions,
avg(users) as avg_active_users
from transactions
group by 1,2
Run a query to Download Data