fees as (

select

trunc(block_timestamp,'day') as date,

aave_version,

sum(premium_amount_usd) as daily_premium_fees

--sum(daily_premium_fees) over (partition by aave_version order by date) as cum_premium_fees

from flipside_prod_db.aave.flashloans where block_timestamp > CURRENT_DATE-90

group by 1,2

order by 1 asc

)

date,aave_version, case when daily_premium_fees is null then 0 else daily_premium_fees end as daily_premium_feess,

sum(daily_premium_feess) over (partition by aave_version order by date) as cum_premium_fees

from fees

--group by 1,2

order by 1 asc