max(SPLIT(pool_name, '-')[0]) AS blockchain,

avg(POWER(10,-8) * asset_e8) AS asset_change_cumulative

FROM thorchain.defi.fact_block_pool_depths

WHERE (pool_name LIKE '%/%')

AND (pool_name = 'BTC/BTC')

GROUP BY day)

SELECT *, asset_change_cumulative - coalesce(lag(asset_change_cumulative) over (order by day), 0) as asset_change

FROM daily_saver_depth

WHERE day IS NOT NULL

ORDER BY day DESC