dim_convert AS (

SELECT block_timestamp, block_id

FROM thorchain.core.dim_block

),

churn_blocks AS (

SELECT DISTINCT block_timestamp

FROM thorchain.update_node_account_status_events

ORDER BY block_timestamp DESC

LIMIT 2

),

churned_out_node_addresses AS

SELECT block_timestamp, former_status, node_address

FROM thorchain.core.fact_update_node_account_status_events

WHERE block_timestamp = (SELECT MAX(block_timestamp) FROM churn_blocks)

AND (former_status = 'Active')

),

x_axis_start AS (

SELECT MIN(block_timestamp) AS block_timestamp

FROM churn_blocks

),

before_reference AS

SELECT DISTINCT block_timestamp,

SUM(slash_points) OVER(PARTITION BY node_address ORDER BY block_timestamp ASC) AS cumulative_slash_points,

CONCAT('.', RIGHT(node_address, 4)) AS node_abbreviation

FROM thorchain.core.fact_slash_points

WHERE (block_timestamp >= (SELECT block_timestamp FROM x_axis_start))

AND (reason <> 'fail keysign')

AND (node_address IN (SELECT DISTINCT node_address FROM churned_out_node_addresses))

),