tomwanhhosmosis
Updated 2023-06-25
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select *, sum(daily_staked+daily_unstaked) over (order by day) as cumulative_staked from (
select date_trunc('day',block_timestamp) as day,
sum(case when action = 'delegate' then
amount/1e6 end) as daily_staked,
sum(case when action = 'undelegate' then
amount/1e6*-1 end) as daily_unstaked
from osmosis.core.fact_staking
group by 1)a
Run a query to Download Data