SELECT

DATE_TRUNC('hour', block_timestamp) AS recorded_Hour,

MEDIAN(swap_to_amount / swap_from_amount) AS MEW_Price

FROM solana.defi.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

select

date_trunc(day, recorded_Hour) as day,

avg(MEW_Price) as Price,

88888888888 as Circulating_Supply,

Price * Circulating_Supply as Market_Cap,

lag(Market_Cap, 1 , Market_Cap) over(order by day) as Prev_MC,

(Market_Cap - Prev_MC)/Prev_MC * 100 as "MC CHANGE %"

from MEW

group by 1

order by 1 desc