SELECT 
    date,
    daily_new_accounts,
    cumulative_accounts
FROM (
    SELECT 
        date::date as date,
        metric_accounts_created as daily_new_accounts,
        SUM(metric_accounts_created) OVER (
            ORDER BY date::date 
            ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
        ) as cumulative_accounts
    FROM @xrpscan.xrp_ledger.metrics
    WHERE metric_accounts_created IS NOT NULL
    ORDER BY date::date DESC
    LIMIT 500
) latest_500
ORDER BY date ASC;