SELECT date_trunc('day', block_timestamp) as date,

median(swap_to_amount/swap_from_amount) as SRM_price

FROM solana.core.fact_swaps

WHERE swap_from_mint = 'SRMuApVNdxXokk5GT7XD5cUUgXMBCoAz2LHeuAoKWRt'

and (swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' or swap_to_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'

or swap_to_mint = 'BQcdHdAQW1hczDbBi9hiegXAR7A98Q9jx3X3iBBBDiq4')

and succeeded = 'TRUE'

AND swap_from_amount is not NULL

AND swap_from_amount > 10

AND date < CURRENT_DATE

GROUP BY date

ORDER BY DATE DESC

select INSTRUCTION:accounts[0] AS wallet,

sum(INNER_INSTRUCTION:instructions[0]:parsed:info:amount::INTEGER/1e9*srm_price) AS "climed fcSRM"

from solana.core.fact_events inner join price on BLOCK_TIMESTAMP::date=date

where PROGRAM_ID='VoLT1mJz1sbnxwq5Fv2SXjdVDgPXrb9tJyC8WpMDkSp'

and INNER_INSTRUCTION:index=0 and INNER_INSTRUCTION:instructions[0]:parsed:info:authority='6asST5hurmxJ8uFvh7ZRWkrMfSEzjEAJ4DNR1is3G6eH'

and INSTRUCTION:accounts[0]!='DxMJgeSVoe1cWo1NPExiAsmn83N3bADvkT86dSP1k7WE'

group by 1 order by 2 desc limit 50