select

monthname(BLOCK_TIMESTAMP) AS Month, iff (action in ('Delegate','Redelegate'),'stake','unstake') as actions,

sum(AMOUNT) AS Volume,

avg(AMOUNT) AS avg_Volume,

count(distinct DELEGATOR_ADDRESS) as act_users,

count(distinct tx_id) as txns,

volume/txns as volume_per_tx,

volume/count(distinct BLOCK_TIMESTAMP::date ) as volume_per_day,

txns/act_users as txs_per_user,

txns/count(distinct BLOCK_TIMESTAMP::date ) as txs_per_day,

act_users/count(distinct BLOCK_TIMESTAMP::date ) as wallets_per_day

from terra.core.ez_staking

where

BLOCK_TIMESTAMP between '2022-12-20' and CURRENT_DATE -1

group by 1,2