BLOCK_TIMESTAMP::DATE as date,

action,

sum(AMOUNT) as volume,

avg(amount) as average_volume,

median(amount)as median_volume,

count(*) as number

from terra.core.ez_staking

where BLOCK_TIMESTAMP>='2022-12-25'

group by 1,2