ACTION,

count(DISTINCT tx_id) as "Delegation Tx Count",

count(DISTINCT delegator_address) as "Delegators",

count(DISTINCT validator_address) as "Validators",

sum(amount) as "Staked Volume"

FROM terra.core.ez_staking

WHERE tx_succeeded = 'TRUE'

AND block_timestamp::date <= CURRENT_DATE-1

GROUP BY 1