date_trunc('day', block_timestamp) AS day,

action,

SUM(event_amount) / POW(10,6) AS amount

FROM terra.staking

WHERE DATE(block_timestamp) >= '2021-01-01'

AND DATE(block_timestamp) <= '2021-08-30'

AND validator_address = 'terravaloper1hqyygjq0vdqk0xdpkffgamzr4f7tqqg5u9mg66'

GROUP BY 1,2

ORDER BY 3 DESC