recorded_hour::DATE AS date,

currency,

AVG(price) AS token_price

FROM osmosis.price.ez_prices

GROUP BY 1, 2

SELECT

--date_trunc('month', block_timestamp) AS date,

COUNT(DISTINCT tx_id) AS Total_No_of_Swaps,

COUNT(DISTINCT trader) AS Total_No_of_Swappers,

SUM(token_price*to_amount/pow(10, a.DECIMAL)) AS Trading_Volume_in_USD

--AVG(token_price*to_amount/pow(10, a.DECIMAL)) AS "Avg Trading Volume in USD"

FROM osmosis.defi.fact_swaps b

LEFT JOIN price c ON b.block_timestamp::DATE= date AND b.to_currency = c.currency

LEFT JOIN osmosis.core.dim_tokens a ON b.to_currency = a.address

--WHERE block_timestamp >= '2023-01-01'

--AND block_timestamp < CURRENT_DATE--'2024-04-03'

AND tx_succeeded = 'TRUE'

AND a.DECIMAL IS NOT NULL

AND a.DECIMAL>0

--GROUP BY 1