-- *

date_trunc('day', block_timestamp) as block_day,

sum(event_amount_usd)

from terra.reward

where tx_status = 'SUCCEEDED'

and validator_address_name = 'operator_address'

and block_day >= '2021-1-1' and block_day <= '2021-12-31'

group by 1

order by 1