afonsoUntitled Query
Updated 2023-01-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with
t1 as (
select
min(block_timestamp)::date as day,
delegator_address
from terra.core.ez_staking
group by delegator_address
),
t2 as (
select
day,
count(delegator_address) as new_stakers_count
from t1
where year(day) >= 2023
group by day
)
select
avg(new_stakers_count) as average_new_stakers
from t2
Run a query to Download Data