Afonso_DiazUntitled Query
Updated 2023-01-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with t as (
select
delegator_address as user,
min(block_timestamp)::date as min_date
from osmosis.core.fact_staking
group by 1
)
select
min_date as day,
count(distinct delegator_address) as stakers_count,
count(distinct user) as new_stakers_count,
sum(new_stakers_count) over (order by day) as cumulative_new_stakers_count,
sum(stakers_count) over (order by day) as cumulative_stakers_count
from osmosis.core.fact_staking
left join t
on block_timestamp::date = min_date
where day > current_date - interval '6 months'
group by 1
order by 1
Run a query to Download Data