Date, epoch, validator, sum(amount) as amount

from (

select

toDate(block_time) as Date,

toInt64(epoch) as epoch,

vote_account as validator,

toInt64(lamports)/pow(10,9) as amount

from stage_solana_optimized.rewards

where reward_type=‘voting’ )

group by Date, epoch, validator