SELECT date_trunc('day',recorded_at) AS avg_price_day

,tokens.project_name AS symbol

,tokens.address

,tokens.decimal

,AVG(prices.price) as avg_token_price

FROM osmosis.core.dim_prices prices

JOIN osmosis.core.dim_tokens tokens

ON prices.symbol = tokens.project_name

GROUP BY 1,2,3,4)

SELECT avg_price_day

,symbol

,from_currency

,SUM((from_amount*(avg_token_price))/POW(10,decimal)) AS daily_wAVAX_swapped_out_volume_by_token

,SUM(daily_wAVAX_swapped_out_volume_by_token) OVER(PARTITION BY symbol ORDER BY avg_price_day) AS cumulative_wAVAX_swapped_out_volume_by_token

FROM osmosis.core.fact_swaps swaps

JOIN average_daily_token_prices

ON date_trunc('day', block_timestamp) = avg_price_day

AND swaps.from_currency = average_daily_token_prices.address

WHERE

to_currency = 'ibc/6F62F01D913E3FFE472A38C78235B8F021B511BC6596ADFF02615C8F83D3B373'

GROUP BY 1,2,3