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 Action != 'undelegate'
AND Week >= '2021-05-30'
GROUP BY WEEK, action
ORDER BY WEEK ASC