SELECT

swap_from_mint,

swap_to_mint,

SUM(swap_from_amount) AS "swap amount"

FROM

solana.defi.fact_swaps

WHERE

block_timestamp BETWEEN '2024-09-01' AND '2024-09-30'

AND (

(swap_from_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' AND swap_to_mint = 'So11111111111111111111111111111111111111112') OR

(swap_from_mint = 'So11111111111111111111111111111111111111112' AND swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v') OR

(swap_from_mint = '5PRAVHPXrPJgM4uP1k9ZN2vnPe2epZRRJ8r6ETXTZs8r' AND swap_to_mint = 'So11111111111111111111111111111111111111112') OR

(swap_from_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' AND swap_to_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB') OR

(swap_from_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' AND swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v') OR

(swap_from_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' AND swap_to_mint = 'So11111111111111111111111111111111111111112') OR

(swap_from_mint = 'So11111111111111111111111111111111111111112' AND swap_to_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB') OR

(swap_from_mint = 'So11111111111111111111111111111111111111112' AND swap_to_mint = 'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm') OR

(swap_from_mint = 'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm' AND swap_to_mint = 'So11111111111111111111111111111111111111112') OR

(swap_from_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' AND swap_to_mint = '7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr')

)

GROUP BY

swap_from_mint, swap_to_mint

),

prices AS (

SELECT

token_address,

PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY price) AS "prices"

FROM

solana.price.ez_prices_hourly

WHERE

hour BETWEEN '2024-09-01 00:00:00' AND '2024-09-30 23:59:59'

GROUP BY

token_address

SELECT