avg(amount) as avg_staked,

sum(amount) as vol_staked,

sum(vol_staked) over (order by day) as total_staked,

count(distinct tx_id) as stakings,

sum(stakings) over (order by day) as total_stakings,

count(distinct delegator) as stakers,

sum(stakers) over (order by day) as total_stakers from flow.gov.ez_staking_actions where block_timestamp>= current_date-INTERVAL '1 MONTH' and action in ('UnstakedTokensWithdrawn','TokensWithdrawn')

group by 1 order by 1 desc