1SELECT 
2    date,
3    daily_new_accounts,
4    cumulative_accounts
5FROM (
6    SELECT 
7        date::date as date,
8        metric_accounts_created as daily_new_accounts,
9        SUM(metric_accounts_created) OVER (
10            ORDER BY date::date 
11            ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
12        ) as cumulative_accounts
13    FROM @xrpscan.xrp_ledger.metrics
14    WHERE metric_accounts_created IS NOT NULL
15    ORDER BY date::date DESC
16    LIMIT 500
17) latest_500
18ORDER BY date ASC;