with PriceTb as (

SELECT

recorded_hour::date as p_date,

avg(close) as price

FROM solana.price.ez_token_prices_hourly

WHERE token_address LIKE 'mb1eu7TzEc71KxDpsmsKoucSSuuoGLv1drys1oP2jh6'

GROUP BY 1

SELECT

date_trunc('week', block_timestamp) as week,

count(DISTINCT tx_id) as swaps,

count(DISTINCT SWAPPER) AS SWAPPERS,

sum(

price * CASE

when SWAP_FROM_MINT LIKE 'mb1eu7TzEc71KxDpsmsKoucSSuuoGLv1drys1oP2jh6'

then SWAP_FROM_AMOUNT

else SWAP_TO_AMOUNT end

) as volume

FROM solana.defi.fact_swaps

LEFT outer JOIN PriceTb

on date(block_timestamp) = p_date

WHERE (

SWAP_FROM_MINT LIKE 'mb1eu7TzEc71KxDpsmsKoucSSuuoGLv1drys1oP2jh6'

OR SWAP_TO_MINT LIKE 'mb1eu7TzEc71KxDpsmsKoucSSuuoGLv1drys1oP2jh6'

AND succeeded = TRUE

GROUP by 1