winnie-fsStats Monthly 3 copy
Updated 2023-08-28
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
27
28
›
⌄
-- forked from Abbas_ra21 / Stats Monthly 3 @ https://flipsidecrypto.xyz/Abbas_ra21/q/sXj7X8euPQ2c/stats-monthly-3
-- forked from Stats Monthly 2 @ https://flipsidecrypto.xyz/edit/queries/ed91545a-6bac-41e2-ba78-a75e8dfc8ac7
-- forked from Stats Monthly @ https://flipsidecrypto.xyz/edit/queries/4db44afd-0e8c-43e8-910f-8af294d8855b
select
date_trunc('Month', First_seen)::DATE AS Month,
Count(Address) AS "New Stakers",
sum("New Stakers") over (order by Month) AS "Total Users"
from
(
select
Address,
min(BLOCK_TIMESTAMP)::DATE AS First_seen
from solana.core.fact_stake_pool_actions
where
STAKE_POOL_NAME = 'blazestake'
and SUCCEEDED = TRUE
and (ACTION like '%deposit%'
or ACTION like '%withdraw%') group by 1)
group by 1
Run a query to Download Data