Baselight
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;

Results limited to the first 500 rows.

datedaily_new_accountscumulative_accounts
2024-03-1228955609142
2024-03-1326695611811
2024-03-1424615614272
2024-03-1540015618273
2024-03-1629745621247
2024-03-1728005624047
2024-03-1823535626400
2024-03-1923635628763
2024-03-2024605631223
2024-03-2124305633653
2024-03-2220425635695
2024-03-2320455637740
2024-03-2417765639516
2024-03-2519065641422
2024-03-2621495643571
2024-03-2720385645609
2024-03-2820665647675
2024-03-2918945649569
2024-03-3017465651315
2024-03-3117195653034
2024-04-0115595654593
2024-04-0214375656030
2024-04-0314935657523
2024-04-0415945659117
2024-04-0515735660690
2024-04-0614225662112
2024-04-0714985663610
2024-04-0815595665169
2024-04-0914075666576
2024-04-1014435668019
2024-04-1114915669510
2024-04-1213845670894
2024-04-1313825672276
2024-04-1415035673779
2024-04-1513865675165
2024-04-1612225676387
2024-04-1713845677771
2024-04-1813625679133
2024-04-1913495680482
2024-04-2012555681737
2024-04-2111415682878
2024-04-2212795684157
2024-04-2311675685324
2024-04-2411085686432
2024-04-2510595687491
2024-04-2610905688581
2024-04-279895689570
2024-04-2810325690602
2024-04-299915691593
2024-04-3011725692765
2024-05-0112255693990
2024-05-0210085694998
2024-05-0310715696069
2024-05-0410125697081
2024-05-059565698037
2024-05-0610515699088
2024-05-079775700065
2024-05-089945701059
2024-05-099075701966
2024-05-108805702846
2024-05-117695703615
2024-05-127365704351
2024-05-138675705218
2024-05-148545706072
2024-05-159415707013
2024-05-1610245708037
2024-05-179705709007
2024-05-189865709993
2024-05-197715710764
2024-05-209585711722
2024-05-2110455712767
2024-05-229985713765
2024-05-2310255714790
2024-05-249775715767
2024-05-259675716734
2024-05-268805717614
2024-05-279825718596
2024-05-289105719506
2024-05-299725720478
2024-05-309015721379
2024-05-319365722315
2024-06-018625723177
2024-06-028015723978
2024-06-038795724857
2024-06-0410525725909
2024-06-0510795726988
2024-06-069565727944
2024-06-079915728935
2024-06-088885729823
2024-06-099185730741
2024-06-109445731685
2024-06-119405732625
2024-06-129245733549
2024-06-138005734349
2024-06-148085735157
2024-06-157705735927
2024-06-168195736746
2024-06-178285737574
2024-06-189385738512
2024-06-198955739407
2024-06-208565740263
2024-06-218435741106
2024-06-227995741905
2024-06-239795742884
2024-06-249125743796
2024-06-258605744656
2024-06-268435745499
2024-06-278765746375
2024-06-288105747185
2024-06-297485747933
2024-06-307105748643
2024-07-018615749504
2024-07-028445750348
2024-07-038665751214
2024-07-048535752067
2024-07-058925752959
2024-07-068075753766
2024-07-077945754560
2024-07-088125755372
2024-07-098635756235
2024-07-109035757138
2024-07-1111485758286
2024-07-1210145759300
2024-07-1311775760477
2024-07-149025761379
2024-07-159675762346
2024-07-1612895763635
2024-07-1715765765211
2024-07-1813085766519
2024-07-1913075767826
2024-07-2013215769147
2024-07-2111865770333
2024-07-2213985771731
2024-07-2312765773007
2024-07-2413785774385
2024-07-2513175775702
2024-07-2612605776962
2024-07-2711395778101
2024-07-2810115779112
2024-07-2911995780311
2024-07-3013425781653
2024-07-3116235783276
2024-08-0112565784532
2024-08-0212355785767
2024-08-0310535786820
2024-08-048885787708
2024-08-0514905789198
2024-08-0614545790652
2024-08-0713185791970
2024-08-0819025793872
2024-08-0914345795306
2024-08-1012155796521
2024-08-1110525797573
2024-08-1211375798710
2024-08-1312215799931
2024-08-1412625801193
2024-08-1512105802403
2024-08-1612525803655
2024-08-1711205804775
2024-08-1812235805998
2024-08-1912005807198
2024-08-2012855808483
2024-08-2111805809663
2024-08-2212015810864
2024-08-2311995812063
2024-08-2411195813182
2024-08-2510325814214
2024-08-2611665815380
2024-08-2712385816618
2024-08-2812975817915
2024-08-2911905819105
2024-08-3011775820282
2024-08-3110915821373
2024-09-0110935822466
2024-09-0213475823813
2024-09-0312475825060
2024-09-0412875826347
2024-09-0510865827433
2024-09-0610685828501
2024-09-079365829437
2024-09-089275830364
2024-09-099395831303
2024-09-109565832259
2024-09-118825833141
2024-09-1211135834254
2024-09-1310695835323
2024-09-149695836292
2024-09-159665837258
2024-09-169985838256
2024-09-1710315839287
2024-09-1810595840346
2024-09-1910855841431
2024-09-2010195842450
2024-09-219355843385
2024-09-229745844359
2024-09-2310945845453
2024-09-2411175846570
2024-09-2510805847650
2024-09-2611835848833
2024-09-2711855850018
2024-09-2811315851149
2024-09-2913315852480
2024-09-3013755853855
2024-10-0115165855371
2024-10-0213975856768
2024-10-0314225858190
2024-10-0411775859367
2024-10-059635860330
2024-10-069355861265
2024-10-0710655862330
2024-10-0810685863398
2024-10-0916615865059
2024-10-1012645866323
2024-10-1110055867328
2024-10-1215355868863
2024-10-139395869802
2024-10-1412045871006
2024-10-1511705872176
2024-10-1614375873613
2024-10-1715745875187
2024-10-1813425876529
2024-10-1927125879241
2024-10-2037075882948
2024-10-2135045886452
2024-10-2225065888958
2024-10-2322725891230
2024-10-2425045893734
2024-10-2531675896901
2024-10-261495897050
2024-10-2735075900557
2024-10-2826835903240
2024-10-2930505906290
2024-10-3021645908454
2024-10-3120565910510
2024-11-0119455912455
2024-11-0216725914127
2024-11-0314575915584
2024-11-0417545917338
2024-11-0517935919131
2024-11-0620175921148
2024-11-0720695923217
2024-11-0820475925264
2024-11-0918915927155
2024-11-1028145929969
2024-11-1127745932743
2024-11-1235965936339
2024-11-1331215939460
2024-11-1433025942762
2024-11-1551355947897
2024-11-1668365954733
2024-11-1748915959624
2024-11-1848255964449
2024-11-1940325968481
2024-11-2039065972387
2024-11-2143015976688
2024-11-2279955984683
2024-11-2372835991966
2024-11-2452445997210
2024-11-2551856002395
2024-11-2649406007335
2024-11-2746166011951
2024-11-2836596015610
2024-11-2966596022269
2024-11-30108726033141
2024-12-01209246054065
2024-12-02306416084706
2024-12-03202076104913
2024-12-04161666121079
2024-12-05128246133903
2024-12-06105066144409
2024-12-07113806155789
2024-12-08119756167764
2024-12-09101836177947
2024-12-1087656186712
2024-12-1198516196563
2024-12-1295586206121
2024-12-1394816215602
2024-12-14100826225684
2024-12-1588506234534
2024-12-1697156244249
2024-12-17152156259464
2024-12-1889866268450
2024-12-1986476277097
2024-12-2072516284348
2024-12-2165336290881
2024-12-2259176296798
2024-12-2360356302833
2024-12-2466606309493
2024-12-2567756316268
2024-12-2657156321983
2024-12-2764636328446
2024-12-2873406335786
2024-12-2973986343184
2024-12-3082336351417
2024-12-3193556360772
2025-01-0171326367904
2025-01-0271206375024
2025-01-0369136381937
2025-01-0465346388471
2025-01-0561216394592
2025-01-0664386401030
2025-01-0763886407418
2025-01-0865696413987
2025-01-0978646421851
2025-01-10100286431879
2025-01-1183566440235
2025-01-1279326448167
2025-01-1371606455327
2025-01-1487556464082
2025-01-15128516476933
2025-01-16151126492045
2025-01-17144306506475
2025-01-18127786519253
2025-01-19127326531985
2025-01-20126886544673
2025-01-2199116554584
2025-01-2296536564237
2025-01-2385126572749
2025-01-2485496581298
2025-01-2574676588765
2025-01-2676026596367
2025-01-2774146603781
2025-01-2876526611433
2025-01-2965556617988
2025-01-3067166624704
2025-01-3167266631430
2025-02-0158156637245
2025-02-0263136643558
2025-02-0379756651533
2025-02-0468276658360
2025-02-0572206665580
2025-02-0656906671270
2025-02-0755796676849
2025-02-0848396681688
2025-02-0953746687062
2025-02-1054106692472
2025-02-1157496698221
2025-02-1263676704588
2025-02-1358886710476
2025-02-1467286717204
2025-02-1563086723512
2025-02-1652736728785
2025-02-1752106733995
2025-02-1847426738737
2025-02-1946586743395
2025-02-2048326748227
2025-02-2161186754345
2025-02-2255956759940
2025-02-2348586764798
2025-02-2452906770088
2025-02-2553476775435
2025-02-2646816780116
2025-02-2745166784632
2025-02-2845536789185
2025-03-0145946793779
2025-03-0274796801258
2025-03-0359386807196
2025-03-0459866813182
2025-03-0552506818432
2025-03-0655506823982
2025-03-0754606829442
2025-03-0849306834372
2025-03-0943396838711
2025-03-1041786842889
2025-03-1147596847648
2025-03-1243066851954
2025-03-1339076855861
2025-03-1439436859804
2025-03-1538656863669
2025-03-1636606867329
2025-03-1736806871009
2025-03-1835156874524
2025-03-1948796879403
2025-03-2048116884214
2025-03-2145386888752
2025-03-2238966892648
2025-03-2341406896788
2025-03-2443986901186
2025-03-2548646906050
2025-03-2646226910672
2025-03-2740696914741
2025-03-2835656918306
2025-03-2940836922389
2025-03-3030906925479
2025-03-3135466929025
2025-04-0135646932589
2025-04-0234616936050
2025-04-0334096939459
2025-04-0431806942639
2025-04-0530656945704
2025-04-0632006948904
2025-04-0738546952758
2025-04-0834806956238
2025-04-0933636959601
2025-04-1033516962952
2025-04-1133606966312
2025-04-1231906969502
2025-04-1334516972953
2025-04-1431476976100
2025-04-1531646979264
2025-04-1631016982365
2025-04-1732306985595
2025-04-1826836988278
2025-04-1924886990766
2025-04-2026596993425
2025-04-2127286996153
2025-04-2228836999036
2025-04-2332247002260
2025-04-2431097005369
2025-04-2531567008525
2025-04-2630147011539
2025-04-2732137014752
2025-04-2840397018791
2025-04-2938837022674
2025-04-3037167026390
2025-05-0135517029941
2025-05-0235927033533
2025-05-0330797036612
2025-05-0430847039696
2025-05-0532317042927
2025-05-0632747046201
2025-05-0731687049369
2025-05-0835917052960
2025-05-0938067056766
2025-05-1031047059870
2025-05-1126497062519
2025-05-1232327065751
2025-05-1339947069745
2025-05-1441187073863
2025-05-1536137077476
2025-05-1635387081014
2025-05-1731877084201
2025-05-1831287087329
2025-05-1932417090570
2025-05-2035377094107
2025-05-2135887097695
2025-05-2245647102259
2025-05-2334327105691
2025-05-2432367108927
2025-05-2529197111846
2025-05-2631917115037
2025-05-2731557118192
2025-05-2834847121676
2025-05-2938657125541
2025-05-3035697129110
2025-05-3131967132306
2025-06-0141037136409
2025-06-0234187139827
2025-06-0336337143460
2025-06-0438117147271
2025-06-0534477150718
2025-06-0629457153663
2025-06-0729777156640
2025-06-0831447159784
2025-06-0938067163590
2025-06-1036337167223
2025-06-1140217171244
2025-06-1238277175071
2025-06-1338177178888
2025-06-1433747182262
2025-06-1537597186021
2025-06-1637387189759
2025-06-1737337193492
2025-06-1840257197517
2025-06-1931807200697
2025-06-2028537203550
2025-06-2128507206400
2025-06-2227417209141
2025-06-2329397212080
2025-06-2433637215443
2025-06-2532767218719
2025-06-2632747221993
2025-06-2733397225332
2025-06-2830537228385
2025-06-2928647231249
2025-06-3035347234783
2025-07-0142977239080
2025-07-0242127243292
2025-07-0340217247313
2025-07-0435057250818
2025-07-0533487254166
2025-07-0642637258429
2025-07-0750247263453
2025-07-0839637267416
2025-07-0963657273781
2025-07-1051107278891
2025-07-1168197285710
2025-07-1254107291120
2025-07-1359927297112
2025-07-1480447305156
2025-07-1566827311838
2025-07-1666717318509
2025-07-1786957327204
2025-07-18102797337483
2025-07-1965917344074
2025-07-2069247350998
2025-07-2181477359145
2025-07-2272467366391
2025-07-2369657373356
2025-07-2421567375512

Share link

Anyone who has the link will be able to view this.