saber-jldaily luna stake
Updated 2023-01-24Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
date_trunc('day',BLOCK_TIMESTAMP) as date,
CASE
when date >= '2023-01-07' and date < '2023-01-14' then 'befroe announcement'
when date >= '2023-01-14' and date <= '2023-01-20' then 'after announcement'
end as time_frame,
count(distinct tx_id) as tx_count,
count(distinct DELEGATOR_ADDRESS) as users,
sum(amount) as stake_amount,
(stake_amount/users) as "stake amount per user"
from terra.core.ez_staking
where TX_SUCCEEDED = 'TRUE'
and ACTION = 'Delegate'
and BLOCK_TIMESTAMP::date between '2023-01-07' and '2023-01-20'
group by 1,2
Run a query to Download Data