with date_filter as(

select

-- just to reduce table size and make the process faster

--cast('2024-05-17' as timestamp) as start_date,

--cast('2024-05-27' as timestamp) as end_date

cast('2025-03-04' as timestamp) as start_date,

cast('2025-03-15' as timestamp) as end_date

,simd_votes_raw_data as(

select

tx_from as vote_account,

case

when tx_to = 'YESsimd228111111111111111111111111111111111' then 'Yes'

when tx_to = 'nosimd2281111111111111111111111111111111111' then 'No'

when tx_to = 'ABSTA1Nsimd22811111111111111111111111111111' then 'Abstain'

end as vote_type,

amount

from solana.core.fact_transfers t

inner join date_filter df

on t.block_timestamp between df.start_date and df.end_date

where

(tx_to = 'YESsimd228111111111111111111111111111111111'

or tx_to = 'nosimd2281111111111111111111111111111111111'

or tx_to = 'ABSTA1Nsimd22811111111111111111111111111111')

and mint = 's228VmFcuiEfroSCQTvEp1pYUownL7JRZMTd7FqHJVK'

,aggregate_vote as(