Query editor
select block_date,sum(case when action = 'stake' then amount/1e6 end) as staked_amounts,sum(case when action = 'unstake' then amount/1e6 end) as unstaked_amounts,count(distinct case when action = 'stake' then user end) as staked_users,count(distinct case when action = 'unstake' then user end) as unstaked_users,SUM(SUM(amount/1e6)) OVER (ORDER BYblock_date ROWS BETWEEN UNBOUNDED PRECEDINGAND CURRENT ROW) AS total_stakedfrom query_4478641group by 1order by 1 desc