snowmanUntitled Query
Updated 2022-11-08
9
1
2
3
4
5
›
⌄
select sum(amount/1e6) as "amount" ,avg(amount/1e6) as "avrage amount", count(distinct tx_id) ,count(distinct delegator_address) ,
case when action='delegate' or action='redelegate' then 'Stake'
else 'Unstake' end as actions ,date_trunc('month', block_timestamp) as "time" from osmosis.core.fact_staking
-- else 'Unstake' end as actions ,date_trunc('month', block_timestamp) as "time" from osmosis.core.fact_staking
group by actions,"time"
Run a query to Download Data