FROM solana.core.fact_swaps

WHERE swap_from_mint = 'So11111111111111111111111111111111111111112' 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),

BTC_price AS (

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

median(swap_to_amount/swap_from_amount) as btc_price

FROM solana.core.fact_swaps

WHERE swap_from_mint = '9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E'

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

),

ETH_price AS (

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

median(swap_to_amount/swap_from_amount) as eth_price

FROM solana.core.fact_swaps

WHERE swap_from_mint = '2FPyTwcZLUg1MDrwsyoP4D6s1tM7hAkHYRjkNb5w6Pxk'

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

),

ray_price AS (