peteer8 light
Updated 2023-01-21
9
1
2
3
4
5
6
7
›
⌄
select sum(amount) , block_timestamp::date , CASE
when action in ('Redelegate' , 'Delegate') then 'stake'
when action='Undelegate' then 'unstake' end as staking
from terra.core.ez_staking where year(block_timestamp)=2023 and block_timestamp::date >='2023-01-07' and block_timestamp::date <='2023-01-13'
group by 2,3
Run a query to Download Data