select

date_trunc('day',block_timestamp) as day, sum(fee/pow(10,6)) as fees_adj

from cosmos.core.fact_transactions

where tx_succeeded = 'TRUE'

group by 1

),

token_priceUSD as (

select

date_trunc('day',recorded_at) as date_time,symbol,avg(price) as priceUSD

from osmosis.core.dim_prices

where symbol = 'ATOM'

group by date_time, symbol

)

day,(fees_adj*priceUSD) as fees_USD,

sum(fees_adj*priceUSD) over (order by day rows between 29 preceding and current row) as cum_30D_fees_USD

from daily_fees

left join token_priceUSD

on day = date_time

where day >= current_date-90

order by day asc