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.
date | daily_new_accounts | cumulative_accounts |
---|---|---|
2024-03-12 | 2895 | 5609142 |
2024-03-13 | 2669 | 5611811 |
2024-03-14 | 2461 | 5614272 |
2024-03-15 | 4001 | 5618273 |
2024-03-16 | 2974 | 5621247 |
2024-03-17 | 2800 | 5624047 |
2024-03-18 | 2353 | 5626400 |
2024-03-19 | 2363 | 5628763 |
2024-03-20 | 2460 | 5631223 |
2024-03-21 | 2430 | 5633653 |
2024-03-22 | 2042 | 5635695 |
2024-03-23 | 2045 | 5637740 |
2024-03-24 | 1776 | 5639516 |
2024-03-25 | 1906 | 5641422 |
2024-03-26 | 2149 | 5643571 |
2024-03-27 | 2038 | 5645609 |
2024-03-28 | 2066 | 5647675 |
2024-03-29 | 1894 | 5649569 |
2024-03-30 | 1746 | 5651315 |
2024-03-31 | 1719 | 5653034 |
2024-04-01 | 1559 | 5654593 |
2024-04-02 | 1437 | 5656030 |
2024-04-03 | 1493 | 5657523 |
2024-04-04 | 1594 | 5659117 |
2024-04-05 | 1573 | 5660690 |
2024-04-06 | 1422 | 5662112 |
2024-04-07 | 1498 | 5663610 |
2024-04-08 | 1559 | 5665169 |
2024-04-09 | 1407 | 5666576 |
2024-04-10 | 1443 | 5668019 |
2024-04-11 | 1491 | 5669510 |
2024-04-12 | 1384 | 5670894 |
2024-04-13 | 1382 | 5672276 |
2024-04-14 | 1503 | 5673779 |
2024-04-15 | 1386 | 5675165 |
2024-04-16 | 1222 | 5676387 |
2024-04-17 | 1384 | 5677771 |
2024-04-18 | 1362 | 5679133 |
2024-04-19 | 1349 | 5680482 |
2024-04-20 | 1255 | 5681737 |
2024-04-21 | 1141 | 5682878 |
2024-04-22 | 1279 | 5684157 |
2024-04-23 | 1167 | 5685324 |
2024-04-24 | 1108 | 5686432 |
2024-04-25 | 1059 | 5687491 |
2024-04-26 | 1090 | 5688581 |
2024-04-27 | 989 | 5689570 |
2024-04-28 | 1032 | 5690602 |
2024-04-29 | 991 | 5691593 |
2024-04-30 | 1172 | 5692765 |
2024-05-01 | 1225 | 5693990 |
2024-05-02 | 1008 | 5694998 |
2024-05-03 | 1071 | 5696069 |
2024-05-04 | 1012 | 5697081 |
2024-05-05 | 956 | 5698037 |
2024-05-06 | 1051 | 5699088 |
2024-05-07 | 977 | 5700065 |
2024-05-08 | 994 | 5701059 |
2024-05-09 | 907 | 5701966 |
2024-05-10 | 880 | 5702846 |
2024-05-11 | 769 | 5703615 |
2024-05-12 | 736 | 5704351 |
2024-05-13 | 867 | 5705218 |
2024-05-14 | 854 | 5706072 |
2024-05-15 | 941 | 5707013 |
2024-05-16 | 1024 | 5708037 |
2024-05-17 | 970 | 5709007 |
2024-05-18 | 986 | 5709993 |
2024-05-19 | 771 | 5710764 |
2024-05-20 | 958 | 5711722 |
2024-05-21 | 1045 | 5712767 |
2024-05-22 | 998 | 5713765 |
2024-05-23 | 1025 | 5714790 |
2024-05-24 | 977 | 5715767 |
2024-05-25 | 967 | 5716734 |
2024-05-26 | 880 | 5717614 |
2024-05-27 | 982 | 5718596 |
2024-05-28 | 910 | 5719506 |
2024-05-29 | 972 | 5720478 |
2024-05-30 | 901 | 5721379 |
2024-05-31 | 936 | 5722315 |
2024-06-01 | 862 | 5723177 |
2024-06-02 | 801 | 5723978 |
2024-06-03 | 879 | 5724857 |
2024-06-04 | 1052 | 5725909 |
2024-06-05 | 1079 | 5726988 |
2024-06-06 | 956 | 5727944 |
2024-06-07 | 991 | 5728935 |
2024-06-08 | 888 | 5729823 |
2024-06-09 | 918 | 5730741 |
2024-06-10 | 944 | 5731685 |
2024-06-11 | 940 | 5732625 |
2024-06-12 | 924 | 5733549 |
2024-06-13 | 800 | 5734349 |
2024-06-14 | 808 | 5735157 |
2024-06-15 | 770 | 5735927 |
2024-06-16 | 819 | 5736746 |
2024-06-17 | 828 | 5737574 |
2024-06-18 | 938 | 5738512 |
2024-06-19 | 895 | 5739407 |
2024-06-20 | 856 | 5740263 |
2024-06-21 | 843 | 5741106 |
2024-06-22 | 799 | 5741905 |
2024-06-23 | 979 | 5742884 |
2024-06-24 | 912 | 5743796 |
2024-06-25 | 860 | 5744656 |
2024-06-26 | 843 | 5745499 |
2024-06-27 | 876 | 5746375 |
2024-06-28 | 810 | 5747185 |
2024-06-29 | 748 | 5747933 |
2024-06-30 | 710 | 5748643 |
2024-07-01 | 861 | 5749504 |
2024-07-02 | 844 | 5750348 |
2024-07-03 | 866 | 5751214 |
2024-07-04 | 853 | 5752067 |
2024-07-05 | 892 | 5752959 |
2024-07-06 | 807 | 5753766 |
2024-07-07 | 794 | 5754560 |
2024-07-08 | 812 | 5755372 |
2024-07-09 | 863 | 5756235 |
2024-07-10 | 903 | 5757138 |
2024-07-11 | 1148 | 5758286 |
2024-07-12 | 1014 | 5759300 |
2024-07-13 | 1177 | 5760477 |
2024-07-14 | 902 | 5761379 |
2024-07-15 | 967 | 5762346 |
2024-07-16 | 1289 | 5763635 |
2024-07-17 | 1576 | 5765211 |
2024-07-18 | 1308 | 5766519 |
2024-07-19 | 1307 | 5767826 |
2024-07-20 | 1321 | 5769147 |
2024-07-21 | 1186 | 5770333 |
2024-07-22 | 1398 | 5771731 |
2024-07-23 | 1276 | 5773007 |
2024-07-24 | 1378 | 5774385 |
2024-07-25 | 1317 | 5775702 |
2024-07-26 | 1260 | 5776962 |
2024-07-27 | 1139 | 5778101 |
2024-07-28 | 1011 | 5779112 |
2024-07-29 | 1199 | 5780311 |
2024-07-30 | 1342 | 5781653 |
2024-07-31 | 1623 | 5783276 |
2024-08-01 | 1256 | 5784532 |
2024-08-02 | 1235 | 5785767 |
2024-08-03 | 1053 | 5786820 |
2024-08-04 | 888 | 5787708 |
2024-08-05 | 1490 | 5789198 |
2024-08-06 | 1454 | 5790652 |
2024-08-07 | 1318 | 5791970 |
2024-08-08 | 1902 | 5793872 |
2024-08-09 | 1434 | 5795306 |
2024-08-10 | 1215 | 5796521 |
2024-08-11 | 1052 | 5797573 |
2024-08-12 | 1137 | 5798710 |
2024-08-13 | 1221 | 5799931 |
2024-08-14 | 1262 | 5801193 |
2024-08-15 | 1210 | 5802403 |
2024-08-16 | 1252 | 5803655 |
2024-08-17 | 1120 | 5804775 |
2024-08-18 | 1223 | 5805998 |
2024-08-19 | 1200 | 5807198 |
2024-08-20 | 1285 | 5808483 |
2024-08-21 | 1180 | 5809663 |
2024-08-22 | 1201 | 5810864 |
2024-08-23 | 1199 | 5812063 |
2024-08-24 | 1119 | 5813182 |
2024-08-25 | 1032 | 5814214 |
2024-08-26 | 1166 | 5815380 |
2024-08-27 | 1238 | 5816618 |
2024-08-28 | 1297 | 5817915 |
2024-08-29 | 1190 | 5819105 |
2024-08-30 | 1177 | 5820282 |
2024-08-31 | 1091 | 5821373 |
2024-09-01 | 1093 | 5822466 |
2024-09-02 | 1347 | 5823813 |
2024-09-03 | 1247 | 5825060 |
2024-09-04 | 1287 | 5826347 |
2024-09-05 | 1086 | 5827433 |
2024-09-06 | 1068 | 5828501 |
2024-09-07 | 936 | 5829437 |
2024-09-08 | 927 | 5830364 |
2024-09-09 | 939 | 5831303 |
2024-09-10 | 956 | 5832259 |
2024-09-11 | 882 | 5833141 |
2024-09-12 | 1113 | 5834254 |
2024-09-13 | 1069 | 5835323 |
2024-09-14 | 969 | 5836292 |
2024-09-15 | 966 | 5837258 |
2024-09-16 | 998 | 5838256 |
2024-09-17 | 1031 | 5839287 |
2024-09-18 | 1059 | 5840346 |
2024-09-19 | 1085 | 5841431 |
2024-09-20 | 1019 | 5842450 |
2024-09-21 | 935 | 5843385 |
2024-09-22 | 974 | 5844359 |
2024-09-23 | 1094 | 5845453 |
2024-09-24 | 1117 | 5846570 |
2024-09-25 | 1080 | 5847650 |
2024-09-26 | 1183 | 5848833 |
2024-09-27 | 1185 | 5850018 |
2024-09-28 | 1131 | 5851149 |
2024-09-29 | 1331 | 5852480 |
2024-09-30 | 1375 | 5853855 |
2024-10-01 | 1516 | 5855371 |
2024-10-02 | 1397 | 5856768 |
2024-10-03 | 1422 | 5858190 |
2024-10-04 | 1177 | 5859367 |
2024-10-05 | 963 | 5860330 |
2024-10-06 | 935 | 5861265 |
2024-10-07 | 1065 | 5862330 |
2024-10-08 | 1068 | 5863398 |
2024-10-09 | 1661 | 5865059 |
2024-10-10 | 1264 | 5866323 |
2024-10-11 | 1005 | 5867328 |
2024-10-12 | 1535 | 5868863 |
2024-10-13 | 939 | 5869802 |
2024-10-14 | 1204 | 5871006 |
2024-10-15 | 1170 | 5872176 |
2024-10-16 | 1437 | 5873613 |
2024-10-17 | 1574 | 5875187 |
2024-10-18 | 1342 | 5876529 |
2024-10-19 | 2712 | 5879241 |
2024-10-20 | 3707 | 5882948 |
2024-10-21 | 3504 | 5886452 |
2024-10-22 | 2506 | 5888958 |
2024-10-23 | 2272 | 5891230 |
2024-10-24 | 2504 | 5893734 |
2024-10-25 | 3167 | 5896901 |
2024-10-26 | 149 | 5897050 |
2024-10-27 | 3507 | 5900557 |
2024-10-28 | 2683 | 5903240 |
2024-10-29 | 3050 | 5906290 |
2024-10-30 | 2164 | 5908454 |
2024-10-31 | 2056 | 5910510 |
2024-11-01 | 1945 | 5912455 |
2024-11-02 | 1672 | 5914127 |
2024-11-03 | 1457 | 5915584 |
2024-11-04 | 1754 | 5917338 |
2024-11-05 | 1793 | 5919131 |
2024-11-06 | 2017 | 5921148 |
2024-11-07 | 2069 | 5923217 |
2024-11-08 | 2047 | 5925264 |
2024-11-09 | 1891 | 5927155 |
2024-11-10 | 2814 | 5929969 |
2024-11-11 | 2774 | 5932743 |
2024-11-12 | 3596 | 5936339 |
2024-11-13 | 3121 | 5939460 |
2024-11-14 | 3302 | 5942762 |
2024-11-15 | 5135 | 5947897 |
2024-11-16 | 6836 | 5954733 |
2024-11-17 | 4891 | 5959624 |
2024-11-18 | 4825 | 5964449 |
2024-11-19 | 4032 | 5968481 |
2024-11-20 | 3906 | 5972387 |
2024-11-21 | 4301 | 5976688 |
2024-11-22 | 7995 | 5984683 |
2024-11-23 | 7283 | 5991966 |
2024-11-24 | 5244 | 5997210 |
2024-11-25 | 5185 | 6002395 |
2024-11-26 | 4940 | 6007335 |
2024-11-27 | 4616 | 6011951 |
2024-11-28 | 3659 | 6015610 |
2024-11-29 | 6659 | 6022269 |
2024-11-30 | 10872 | 6033141 |
2024-12-01 | 20924 | 6054065 |
2024-12-02 | 30641 | 6084706 |
2024-12-03 | 20207 | 6104913 |
2024-12-04 | 16166 | 6121079 |
2024-12-05 | 12824 | 6133903 |
2024-12-06 | 10506 | 6144409 |
2024-12-07 | 11380 | 6155789 |
2024-12-08 | 11975 | 6167764 |
2024-12-09 | 10183 | 6177947 |
2024-12-10 | 8765 | 6186712 |
2024-12-11 | 9851 | 6196563 |
2024-12-12 | 9558 | 6206121 |
2024-12-13 | 9481 | 6215602 |
2024-12-14 | 10082 | 6225684 |
2024-12-15 | 8850 | 6234534 |
2024-12-16 | 9715 | 6244249 |
2024-12-17 | 15215 | 6259464 |
2024-12-18 | 8986 | 6268450 |
2024-12-19 | 8647 | 6277097 |
2024-12-20 | 7251 | 6284348 |
2024-12-21 | 6533 | 6290881 |
2024-12-22 | 5917 | 6296798 |
2024-12-23 | 6035 | 6302833 |
2024-12-24 | 6660 | 6309493 |
2024-12-25 | 6775 | 6316268 |
2024-12-26 | 5715 | 6321983 |
2024-12-27 | 6463 | 6328446 |
2024-12-28 | 7340 | 6335786 |
2024-12-29 | 7398 | 6343184 |
2024-12-30 | 8233 | 6351417 |
2024-12-31 | 9355 | 6360772 |
2025-01-01 | 7132 | 6367904 |
2025-01-02 | 7120 | 6375024 |
2025-01-03 | 6913 | 6381937 |
2025-01-04 | 6534 | 6388471 |
2025-01-05 | 6121 | 6394592 |
2025-01-06 | 6438 | 6401030 |
2025-01-07 | 6388 | 6407418 |
2025-01-08 | 6569 | 6413987 |
2025-01-09 | 7864 | 6421851 |
2025-01-10 | 10028 | 6431879 |
2025-01-11 | 8356 | 6440235 |
2025-01-12 | 7932 | 6448167 |
2025-01-13 | 7160 | 6455327 |
2025-01-14 | 8755 | 6464082 |
2025-01-15 | 12851 | 6476933 |
2025-01-16 | 15112 | 6492045 |
2025-01-17 | 14430 | 6506475 |
2025-01-18 | 12778 | 6519253 |
2025-01-19 | 12732 | 6531985 |
2025-01-20 | 12688 | 6544673 |
2025-01-21 | 9911 | 6554584 |
2025-01-22 | 9653 | 6564237 |
2025-01-23 | 8512 | 6572749 |
2025-01-24 | 8549 | 6581298 |
2025-01-25 | 7467 | 6588765 |
2025-01-26 | 7602 | 6596367 |
2025-01-27 | 7414 | 6603781 |
2025-01-28 | 7652 | 6611433 |
2025-01-29 | 6555 | 6617988 |
2025-01-30 | 6716 | 6624704 |
2025-01-31 | 6726 | 6631430 |
2025-02-01 | 5815 | 6637245 |
2025-02-02 | 6313 | 6643558 |
2025-02-03 | 7975 | 6651533 |
2025-02-04 | 6827 | 6658360 |
2025-02-05 | 7220 | 6665580 |
2025-02-06 | 5690 | 6671270 |
2025-02-07 | 5579 | 6676849 |
2025-02-08 | 4839 | 6681688 |
2025-02-09 | 5374 | 6687062 |
2025-02-10 | 5410 | 6692472 |
2025-02-11 | 5749 | 6698221 |
2025-02-12 | 6367 | 6704588 |
2025-02-13 | 5888 | 6710476 |
2025-02-14 | 6728 | 6717204 |
2025-02-15 | 6308 | 6723512 |
2025-02-16 | 5273 | 6728785 |
2025-02-17 | 5210 | 6733995 |
2025-02-18 | 4742 | 6738737 |
2025-02-19 | 4658 | 6743395 |
2025-02-20 | 4832 | 6748227 |
2025-02-21 | 6118 | 6754345 |
2025-02-22 | 5595 | 6759940 |
2025-02-23 | 4858 | 6764798 |
2025-02-24 | 5290 | 6770088 |
2025-02-25 | 5347 | 6775435 |
2025-02-26 | 4681 | 6780116 |
2025-02-27 | 4516 | 6784632 |
2025-02-28 | 4553 | 6789185 |
2025-03-01 | 4594 | 6793779 |
2025-03-02 | 7479 | 6801258 |
2025-03-03 | 5938 | 6807196 |
2025-03-04 | 5986 | 6813182 |
2025-03-05 | 5250 | 6818432 |
2025-03-06 | 5550 | 6823982 |
2025-03-07 | 5460 | 6829442 |
2025-03-08 | 4930 | 6834372 |
2025-03-09 | 4339 | 6838711 |
2025-03-10 | 4178 | 6842889 |
2025-03-11 | 4759 | 6847648 |
2025-03-12 | 4306 | 6851954 |
2025-03-13 | 3907 | 6855861 |
2025-03-14 | 3943 | 6859804 |
2025-03-15 | 3865 | 6863669 |
2025-03-16 | 3660 | 6867329 |
2025-03-17 | 3680 | 6871009 |
2025-03-18 | 3515 | 6874524 |
2025-03-19 | 4879 | 6879403 |
2025-03-20 | 4811 | 6884214 |
2025-03-21 | 4538 | 6888752 |
2025-03-22 | 3896 | 6892648 |
2025-03-23 | 4140 | 6896788 |
2025-03-24 | 4398 | 6901186 |
2025-03-25 | 4864 | 6906050 |
2025-03-26 | 4622 | 6910672 |
2025-03-27 | 4069 | 6914741 |
2025-03-28 | 3565 | 6918306 |
2025-03-29 | 4083 | 6922389 |
2025-03-30 | 3090 | 6925479 |
2025-03-31 | 3546 | 6929025 |
2025-04-01 | 3564 | 6932589 |
2025-04-02 | 3461 | 6936050 |
2025-04-03 | 3409 | 6939459 |
2025-04-04 | 3180 | 6942639 |
2025-04-05 | 3065 | 6945704 |
2025-04-06 | 3200 | 6948904 |
2025-04-07 | 3854 | 6952758 |
2025-04-08 | 3480 | 6956238 |
2025-04-09 | 3363 | 6959601 |
2025-04-10 | 3351 | 6962952 |
2025-04-11 | 3360 | 6966312 |
2025-04-12 | 3190 | 6969502 |
2025-04-13 | 3451 | 6972953 |
2025-04-14 | 3147 | 6976100 |
2025-04-15 | 3164 | 6979264 |
2025-04-16 | 3101 | 6982365 |
2025-04-17 | 3230 | 6985595 |
2025-04-18 | 2683 | 6988278 |
2025-04-19 | 2488 | 6990766 |
2025-04-20 | 2659 | 6993425 |
2025-04-21 | 2728 | 6996153 |
2025-04-22 | 2883 | 6999036 |
2025-04-23 | 3224 | 7002260 |
2025-04-24 | 3109 | 7005369 |
2025-04-25 | 3156 | 7008525 |
2025-04-26 | 3014 | 7011539 |
2025-04-27 | 3213 | 7014752 |
2025-04-28 | 4039 | 7018791 |
2025-04-29 | 3883 | 7022674 |
2025-04-30 | 3716 | 7026390 |
2025-05-01 | 3551 | 7029941 |
2025-05-02 | 3592 | 7033533 |
2025-05-03 | 3079 | 7036612 |
2025-05-04 | 3084 | 7039696 |
2025-05-05 | 3231 | 7042927 |
2025-05-06 | 3274 | 7046201 |
2025-05-07 | 3168 | 7049369 |
2025-05-08 | 3591 | 7052960 |
2025-05-09 | 3806 | 7056766 |
2025-05-10 | 3104 | 7059870 |
2025-05-11 | 2649 | 7062519 |
2025-05-12 | 3232 | 7065751 |
2025-05-13 | 3994 | 7069745 |
2025-05-14 | 4118 | 7073863 |
2025-05-15 | 3613 | 7077476 |
2025-05-16 | 3538 | 7081014 |
2025-05-17 | 3187 | 7084201 |
2025-05-18 | 3128 | 7087329 |
2025-05-19 | 3241 | 7090570 |
2025-05-20 | 3537 | 7094107 |
2025-05-21 | 3588 | 7097695 |
2025-05-22 | 4564 | 7102259 |
2025-05-23 | 3432 | 7105691 |
2025-05-24 | 3236 | 7108927 |
2025-05-25 | 2919 | 7111846 |
2025-05-26 | 3191 | 7115037 |
2025-05-27 | 3155 | 7118192 |
2025-05-28 | 3484 | 7121676 |
2025-05-29 | 3865 | 7125541 |
2025-05-30 | 3569 | 7129110 |
2025-05-31 | 3196 | 7132306 |
2025-06-01 | 4103 | 7136409 |
2025-06-02 | 3418 | 7139827 |
2025-06-03 | 3633 | 7143460 |
2025-06-04 | 3811 | 7147271 |
2025-06-05 | 3447 | 7150718 |
2025-06-06 | 2945 | 7153663 |
2025-06-07 | 2977 | 7156640 |
2025-06-08 | 3144 | 7159784 |
2025-06-09 | 3806 | 7163590 |
2025-06-10 | 3633 | 7167223 |
2025-06-11 | 4021 | 7171244 |
2025-06-12 | 3827 | 7175071 |
2025-06-13 | 3817 | 7178888 |
2025-06-14 | 3374 | 7182262 |
2025-06-15 | 3759 | 7186021 |
2025-06-16 | 3738 | 7189759 |
2025-06-17 | 3733 | 7193492 |
2025-06-18 | 4025 | 7197517 |
2025-06-19 | 3180 | 7200697 |
2025-06-20 | 2853 | 7203550 |
2025-06-21 | 2850 | 7206400 |
2025-06-22 | 2741 | 7209141 |
2025-06-23 | 2939 | 7212080 |
2025-06-24 | 3363 | 7215443 |
2025-06-25 | 3276 | 7218719 |
2025-06-26 | 3274 | 7221993 |
2025-06-27 | 3339 | 7225332 |
2025-06-28 | 3053 | 7228385 |
2025-06-29 | 2864 | 7231249 |
2025-06-30 | 3534 | 7234783 |
2025-07-01 | 4297 | 7239080 |
2025-07-02 | 4212 | 7243292 |
2025-07-03 | 4021 | 7247313 |
2025-07-04 | 3505 | 7250818 |
2025-07-05 | 3348 | 7254166 |
2025-07-06 | 4263 | 7258429 |
2025-07-07 | 5024 | 7263453 |
2025-07-08 | 3963 | 7267416 |
2025-07-09 | 6365 | 7273781 |
2025-07-10 | 5110 | 7278891 |
2025-07-11 | 6819 | 7285710 |
2025-07-12 | 5410 | 7291120 |
2025-07-13 | 5992 | 7297112 |
2025-07-14 | 8044 | 7305156 |
2025-07-15 | 6682 | 7311838 |
2025-07-16 | 6671 | 7318509 |
2025-07-17 | 8695 | 7327204 |
2025-07-18 | 10279 | 7337483 |
2025-07-19 | 6591 | 7344074 |
2025-07-20 | 6924 | 7350998 |
2025-07-21 | 8147 | 7359145 |
2025-07-22 | 7246 | 7366391 |
2025-07-23 | 6965 | 7373356 |
2025-07-24 | 2156 | 7375512 |