mlhstaking behaviour
Updated 2022-10-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with aa as (select distinct instruction:accounts[0] as users,
label
from solana.core.fact_events LEFT outer JOIN solana.core.dim_labels
on program_id = address
where SUCCEEDED='TRUE'
and label_type in('dex', 'defi')
and block_timestamp::date >='2022-10-08'
)
SELECT count(distinct signers[0]) as stakers,
label,
case when block_timestamp::date <'2022-10-12' then 'before hack'
else 'after hack'
end as period
FROM solana.core.fact_staking_lp_actions inner join aa
on users=signers[0]
where SUCCEEDED='TRUE'
and block_timestamp::date >='2022-10-08'
group by 2, 3
Run a query to Download Data