with

price_{{Blokchain}} as (

select

date_trunc({{Granularity}}, HOUR) as date,

avg(PRICE) as avg_Price

from

{{Blokchain}}.price.ez_hourly_token_prices

where

1=1

and TOKEN_ADDRESS is not NULL

and symbol in (case when '{{Blokchain}}' = 'Avalanche' then 'WAVAX'

when '{{Blokchain}}' = 'Bsc' then 'WBNB' else 'WETH' end)

group by

1

),

platforms as (

select

tx_hash

from {{Blokchain}}.defi.ez_dex_swaps

where 1=1

and platform in ('trader-joe-v1', 'trader-joe-v2')

and block_timestamp::date between '{{Start_date}}' and '{{End_date}}'

date::date as date,

round("Fee Volume ($)", 2) as "Fee Volume ($)",

round(sum("Fee Volume ($)") over (

order by

date

), 2) as "Cum. Fee Volume ($)",

avg("Fee Volume ($)") over(order by date rows between 6 preceding and current row) as "MA 7D - Fee Volume ($)"

(

SELECT