date(block_timestamp) as date,

sum(num_votes) as votes

from

solana.gov.fact_votes_agg_block

group by 1

having date is not null

order by 1 desc