saveryield AS (

SELECT

to_date(block_timestamp) as day,

REPLACE(pool_name, '.', '/') as pool_name,

sum(saver_e8) / POW(10, 8) as yield

from

thorchain.defi.fact_rewards_event_entries

where

saver_e8 > 0

and block_timestamp is not null

group by

day,

pool_name

order by

day DESC

),

yieldcumulative AS (

SELECT

day,

pool_name as saver_pool,

yield,

SUM(yield) OVER (

PARTITION BY

pool_name

ORDER BY

day ASC

) AS cumulative_yield

from

saveryield

ORDER BY

day DESC

),

prices AS (

SELECT