thorname_data AS (

SELECT

*

FROM thorchain.core.fact_thorname_change_events

WHERE name = '{{address}}'

,tx_history AS (

SELECT

BLOCK_TIMESTAMP::DATE AS date,

CASE

WHEN '{{address}}' = FROM_ADDRESS THEN -1.0

ELSE 1

END * RUNE_AMOUNT AS RUNE_IN,

CASE

WHEN '{{address}}' = FROM_ADDRESS THEN -1.0

ELSE 1

END * RUNE_AMOUNT_USD AS RUNE_IN_USD

FROM thorchain.core.fact_transfers

WHERE '{{address}}' IN (FROM_ADDRESS, TO_ADDRESS)

, agg AS (

SELECT

date,

SUM(rune_in) AS rune_in,

SUM(rune_in_usd) AS rune_in_usd

FROM tx_history

GROUP BY 1

, cum_sum AS (

SELECT

date,

SUM(rune_in) OVER (ORDER BY date RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS rune_in,

SUM(rune_in_usd) OVER (ORDER BY date RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS rune_in_usd

FROM agg