WITH

dim_convert AS (

SELECT dim_block_id, block_id

FROM thorchain.core.dim_block

),

donates AS (

SELECT DATE(block_timestamp) AS date,

block_id,

SPLIT(pool_name, '-')[0] AS synth,

POWER(10, -8) * SUM(asset_e8) OVER(partition by date, synth) AS synth_minted

FROM (thorchain.core.fact_add_events AS table1 INNER JOIN dim_convert ON table1.dim_block_id = dim_convert.dim_block_id)

WHERE (memo = 'THOR-SAVERS-YIELD')

AND (from_address = '{{address}}')

--Minter Module from_address; ignore imitations.

AND pool_name LIKE '%/%'

--For an extra check that 'synth_amount' refers to synths.

QUALIFY (block_id = MAX(block_id) OVER(PARTITION BY date, synth))

AND (date <> (SELECT DATE(MAX(block_timestamp)) FROM thorchain.core.fact_rewards_events)) --Not complete yet, so leave it out.

SELECT date, synth,

synth_minted AS day_synth_minted,

SUM(synth_minted) OVER(PARTITION BY synth ORDER BY date ASC) AS cumulative_synth_minted

FROM donates

ORDER BY date DESC, synth ASC