SIMD228 Vote - Casted Vote Table - wrong vote

MostlyData_SIMD228 Vote - Casted Vote Table - wrong vote

Updated 2025-03-18

-- forked from SIMD228 Vote - Casted Vote Table @ https://flipsidecrypto.xyz/studio/queries/9ec89899-e150-44b5-aa62-d5eca3e4aa7d

-- forked from SIMD228 Vote - Casted Vote @ https://flipsidecrypto.xyz/studio/queries/98e06609-701a-47ad-8ba0-16742844d59b

-- forked from SIMD228 Vote - Claims share (bars @ https://flipsidecrypto.xyz/studio/queries/9212a7df-f450-4d1a-9147-3d9b3ac5d00b

-- tot_supply = 379050125089013001

-- tot_val = 1349

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_id,

tx_from as vote_account,

mint,

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'

Last run: 15 days ago

	TX_ID	Vote Account	Validator Idendity	Vote	Size	MINT
1	4qsMW8WnRGviNpoNHPKRCvLatS819cCdj3egxbeRZbkjAVujaGY8zS63jQZt2KYa33iUkj9r...	met...wwR	MetaDAO	Abstain	34451.541443486	s228VmFcuiEfroSCQTvEp1pYUownL7JRZMTd7FqHJVK
2	2dFvsvmfMPDaJasSRE1FnJnHub1pdaDNhboMCwtzo9Zeqq62iBNqvx6W1Ez1sN92NNUL23cQ...	gri...cAd	Grid Systems - Running on Firedancer!	Abstain	245277.316368265	s1233un3oMnNWo4EuKsEjtV7QtXfimhybHMQP7GLPwM
3	3d3U2qTkatjwzscaQLmFoCqw6dg4GAomTPif1bGMobDehhCHYuoKexqFx6V3b1r29YefG2KT...	met...wwR	MetaDAO	Abstain	34451.541443486	s1233un3oMnNWo4EuKsEjtV7QtXfimhybHMQP7GLPwM
4	4L2kFkL1R1TU6HSFvg3je1mM8MqmELvUWq4T9SKzGVZDYTwR52fMMBntjSotUd96RvywHvxK...	gri...cAd	Grid Systems - Running on Firedancer!	Abstain	245277.316368265	s228VmFcuiEfroSCQTvEp1pYUownL7JRZMTd7FqHJVK

811B

14s