select

block_timestamp :: date as date,

CASE WHEN block_timestamp :: date = '2020-07-12' THEN

1500000

ELSE

sum(flashloan_amount_usd)

END as total_flashloan_amount,

CASE WHEN block_timestamp :: date = '2020-07-12' THEN

1500

ELSE

sum(premium_amount_usd)

END as total_premium_amount

from ethereum.aave.ez_flashloans

where premium_amount_usd is not NULL

GROUP BY block_timestamp :: date

order by block_timestamp :: date ASC

)

SELECT

date,

AVG(total_flashloan_amount) OVER (

ORDER BY date ROWS BETWEEN 9 PRECEDING AND CURRENT ROW

) as total_flashloan_amount,

AVG(total_premium_amount) OVER (

ORDER BY date ROWS BETWEEN 9 PRECEDING AND CURRENT ROW

) as total_premium_amount

FROM base