SELECT

DATE_TRUNC('day', block_timestamp) AS day,

MEDIAN(swap_to_amount / swap_from_amount) AS median_bonk

FROM solana.core.fact_swaps

WHERE

swap_to_mint IN (

'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v',

'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'

)

AND swap_from_mint LIKE 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

AND swap_to_amount > 0

AND swap_from_amount > 0

GROUP BY 1

),

daily_returns AS (

SELECT

day,

median_bonk,

LAG(median_bonk, 1) OVER (ORDER BY day) AS prev_median_bonk,

(median_bonk - LAG(median_bonk, 1) OVER (ORDER BY day)) / LAG(median_bonk, 1) OVER (ORDER BY day) AS daily_pct_change

FROM daily_prices

SELECT

day,

median_bonk,

daily_pct_change * 100 as daily_pct_change

FROM daily_returns