--DATE(block_timestamp) AS day,

COUNT(DISTINCT tx_id) AS No_Of_Transaction,

COUNT(DISTINCT swapper) AS DAU

FROM solana.defi.fact_swaps

LEFT OUTER JOIN (

SELECT

DATE_TRUNC('day', recorded_hour) AS Date,

MEDIAN(close) AS ACS_Price

FROM solana.price.ez_token_prices_hourly

WHERE token_address = '5MAYDfq5yxtudAhtfyuMBuHZjgAbaS9tbEyEQYAhDS5y'

AND date >= '2022-12-30'

GROUP BY 1

) price_info ON DATE(block_timestamp) = price_info.Date

WHERE

(swap_from_mint = '5MAYDfq5yxtudAhtfyuMBuHZjgAbaS9tbEyEQYAhDS5y' OR swap_to_mint = '5MAYDfq5yxtudAhtfyuMBuHZjgAbaS9tbEyEQYAhDS5y')

--GROUP BY 1