select program_name, block_timestamp as created_at from (
select program_name, block_timestamp, row_number() over (partition by program_name order by block_timestamp asc) as n from solana.core.fact_proposal_votes
where succeeded = 1
and GOVERNANCE_PLATFORM = 'realms'
group by program_name, block_timestamp
qualify n = 1
order by block_timestamp desc
)