SELECT
event_attributes:validator::string as validator,
SUM(event_attributes:amount[0]:amount::float)/POW(10,6) as top10_total_amount
FROM terra.transitions
WHERE
block_timestamp >= CURRENT_DATE - 30
AND
event='rewards'
AND
transition_type='end_block'
GROUP BY 1
ORDER BY 2 DESC
LIMIT 10