select

date_trunc('day', block_timestamp) as "Day",

action as "Actions",

count(distinct tx_id) as "tx count",

count(distinct delegator_address) as "Unique wallet",

sum(amount) as "Volume",

avg(amount) as "AVG tx volume"

from terra.core.ez_staking

where tx_succeeded = 'TRUE' and

"Day" >= current_date - 90

group by 1, 2

select

"Actions",

avg("tx count") as "AVG tx count",

avg("Unique wallet") as "AVG unique wallet",

avg("Volume") as "AVG volume",

avg("AVG tx volume") as "AVG TX volume"

from info

group by 1