bachisolana stake % users
Updated 2022-07-07
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 staked_sol as (
SELECT
date(block_timestamp) as day,
(COUNT(DISTINCT instruction['accounts'][0])/2) as wallets,
(sum(instruction:parsed:info:lamports/pow(10,9))/23) as staked_sol
FROM solana.core.fact_events where block_timestamp >= dateadd(month, -3, getdate())
GROUP BY 1) ,
total_sol as (
SELECT
date(block_timestamp) as day,
COUNT(DISTINCT instruction['accounts'][0]) as wallets,
sum(instruction:parsed:info:lamports/pow(10,9)) as total_sol
FROM solana.core.fact_events where block_timestamp >= dateadd(month, -3, getdate())
GROUP BY 1
)
--data as (
select a.day, (a.staked_sol/a.wallets) as avg_staked_sol_per_day, (b.total_sol/b.wallets) as avg_tot_sol_per_day,
((avg_tot_sol_per_day * 100)/avg_tot_sol_per_day) as daily_percent_staked_sol_per_user from staked_sol a join total_sol b
on a.day = b.day
-- )
Run a query to Download Data