SELECT

date_trunc('day', hour) as Date,

avg(price) as price

FROM solana.price.ez_prices_hourly

WHERE TOKEN_ADDRESS like '8wXtPeU6557ETkp9WHFY1n1EcU6NxDvbAggHGsMYiHsB'

GROUP BY 1

)

, GME AS (

SELECT

Date_trunc('day', block_timestamp) as Date,

SUM(CASE

WHEN swap_from_mint like '8wXtPeU6557ETkp9WHFY1n1EcU6NxDvbAggHGsMYiHsB' then swap_from_amount

ELSE swap_to_amount END) as Swap_amount,

COUNT(DISTINCT TX_ID) as Swaps,

COUNT(DISTINCT swapper) as Swappers

FROM solana.defi.fact_swaps

WHERE swap_from_mint like '8wXtPeU6557ETkp9WHFY1n1EcU6NxDvbAggHGsMYiHsB'

OR swap_to_mint like '8wXtPeU6557ETkp9WHFY1n1EcU6NxDvbAggHGsMYiHsB'

GROUP BY 1

)

GME.Date,

Swap_amount * price as Swap_Volume_USD,

SUM(Swap_amount * price) OVER (ORDER BY GME.Date) AS Cumulative_Swap_Volume_USD,

Swaps,

Swappers

GME

RIGHT OUTER JOIN Price

ON GME.date = Price.date