select * ,

case when symbols = 'ETH' then 'WETH' else symbols end as symbol from

(select *, replace(replace(TOKENs,'axl'),'st') symbols

from (select *,

iff (TOKEN_SYMBOL ilike '%.%',split(TOKEN_SYMBOL,'.')[1] ,TOKEN_SYMBOL) TOKENs

from axelar.core.ez_satellite

))

, p_t as (select

date(HOUR) as days,

symbol token ,

avg(PRICE) as price

from

ethereum.core.fact_hourly_token_prices

group by 1,2)

, base as (

select

*,

AMOUNT*price as amount_usd

from

raw

inner join p_t

on token = SYMBOL and BLOCK_TIMESTAMP::date = days)

select

date_trunc(day,BLOCK_TIMESTAMP)::date as date ,

avg(amount_usd) as avg_usd_amount,

avg(avg_usd_amount)over( order by date rows between 6 preceding and current row) as Mov_avg7,

avg(avg_usd_amount)over( order by date rows between 29 preceding and current row) as Mov_avg30,

avg(avg_usd_amount)over( order by date rows between 99 preceding and current row) as Mov_avg100

from