count(distinct DELEGATOR_ADDRESS) as delegators_count,

sum(amount) as amount,

action

from terra.core.ez_staking

where tx_succeeded = 'TRUE'

and block_timestamp >= CURRENT_DATE - {{Past_X_Days}}

group by action