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_claims_raw_data as(

select

tx_id,

signers[0] as vote_account

from solana.core.fact_events_inner e

inner join date_filter df

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

where

program_id = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'

and instruction['parsed']['info']['owner'] = signers[0]

and instruction['parsed']['info']['mint'] = 's228VmFcuiEfroSCQTvEp1pYUownL7JRZMTd7FqHJVK'

,simd_claims_amounts as(

select

c.vote_account,

instruction['parsed']['info']['amount'] as claimed_amount

from simd_claims_raw_data c

inner join solana.core.fact_events_inner e