flipside

    Churn In & Out
    freemartianChurn In & Out
    Updated 2022-05-10
    SELECT COUNT(*) AS churning_count, date_trunc('day', block_timestamp) AS time, (CASE
    WHEN current_status = 'Active' THEN 'Churn in'
    WHEN current_status = 'Disabled' THEN 'Churn out'
    WHEN current_status = 'Standby' THEN 'Churn out'
    END) AS status
    FROM thorchain.update_node_account_status_events
    GROUP BY TIME, status
    Run a query to Download Data