SELECT
SUM(event_amount_usd) AS Total_USD,
SUM(event_amount) AS Total_LUNA,
DATE_TRUNC('Week', block_timestamp) AS Week,
action
FROM terra.staking
WHERE validator_address = 'terravaloper1r843mpk5zzkfgtnduskd0dzgeltv0n503ckzy6'
AND Week >= '2021-08-29'
GROUP BY WEEK, ACTION
ORDER BY WEEK ASC