Thread by @Kneteknilch

1|
When was the last time you did an analysis of the distribution of #XRP on the #XRPLedger?

How and where can you even do that?
And can you do it yourself at all?

I'm happy to show and I've also worked up the data (visually) directly.

2|
Next, for those who might not know, @xrpscan (xrpscan.com) and @bithomp (bithomp.com) are excellent blockchain explorers (and more) for the #XRPL!
Hearty shout out to the teams of both services whose provided data I used.

3|
And also to @WietseWind with whose help the easy creation of the pure data of the #XRPL was possible at all (for me) as well as to @Ripple and its operation of the "S1" server (s1.ripple.com) from which I extracted the data of the XRPLedger for this.

4|
Source:
@WietseWind had a service 1-2 years ago that displayed a rich list for the XRPL (ledger.exposed).
But he has stopped this service for reasons you can read there.
So there was no possibility to access a rich-list fast/easy anymore but he kindly put ...

5|
...the source-code for it on GitHub (github.com/WietseWind/xrp…) publicly.
With this it is possible to create a rich-list which as a final result creates a .json file which looks like this:

6|
A file that is 271.3MB small with all addresses/wallets (="a") on the XRPL and its XRP holdings (="b").
Running additional code from Wietse, it is possible to get another .json file with the following content:

7|
From which the following list can be created:

8|
So far - so good 🥳 !

Now one or the other of you may be like me a friend of visual representation, here you search unsuccessfully (at least as far as I know).
That's why I migrated the data into Excel and prepared it accordingly and would like to show you my results...

9|
First of all the basic data:
For this the Ledger (Ledger index): 76,688,291
on which the following number of wallets exist (accounts): 4,512,186
It is dated from (Ledger close time): 2022-Dec-26 | (10:59:32UTC)

10|
Accordingly, the holdings of XRP at the time were as follows:

11|
That there is a maximum of 100,000,000,000 #XRP's should be known,
but why does it say "Total XRP existing:": 99,989,171,380.91 XRPs instead?
This is because XRPs are burned during transactions (xrpl.org/transaction-co…).
...

12|
...It is therefore easy to calculate back or on xrpscan.com (@xrpscan) there is also always the current number (top right corner)

13|
Now comes a correspondingly visually prepared table of the rich list of the #XRPL with different categories (oriented to Wietse's data) as well as two "Doughnut"-charts:

14|
...and accordingly a visual resolution to the question "How much XRP to be in the top _%"?

15|
Now follows the list of all wallets (>minimum of 1,000 #XRP) according to their:
-Placement (Number),
-Wallet address,
-Balance (XRP),
-Name (if available, data from xrpscan.com),
-Activated,
-Last time active (send),
-Comments (for wallets > 100,000,000 #XRP)

16|
Comments are my very own by a viewing of the respective wallets and their behavior.
It is of course difficult to summarize in words what happened on the respective wallet but serves at least once, in addition to the other data, as a rough orientation...

17|
A few examples that have particularly caught my eye:

A
24: rhREXVHV938ToGkdJQ9NCYEY4x8kSEtjna
25: r476293LUcDqtjiSGJ5Dh44J1xBCDWeX3
26: r44CNwMWyJf4MEA1eHVMLPTkZ1LSv4Bzrv
27: rD6tdgGHG7hwGTA6P39aE7W89fbqxXRjzk
28: rDfrrrBJZshSQDvfT2kmL9oUBdish52unH

18|

B
32: rsrUwmVfEmLmydrESePifE8hTLzyR3PGJ1

19|

C
Wallet for the XRPL (XRP) to Binance Chain (XRP (BEP2)) Bridge
34: rJpj1Mv21gJzsbsVnkp1U4nqchZbmZ9pM5
___
2. Picture binance.com/en/support/ann…
3. Picture (BEP2)
explorer.bnbchain.org/asset/XRP-BF2
4. Picture (BEP20)
bscscan.com/token/0x1d2f0d…

20|

D
38: rPoJNiCk7XSFLR28nH2hAbkYqjtMC3hK2k

21|

E
39: rpMD8Hw7td1nLKSwPbEGhjJT8fhhpd7ZrC

22|

F
44: rwAmUbbEUGkbgtA4kCFQZii7eMyXAwJ2Wy

23|

G
46: rPh2BtTsJWsVLKUtp5RY6J9fTFekDgoQHN

24|

H
53: ragKXjY7cBTXUus32sYHZVfkY46Nt2Q829
54: rsXNUCJkXeyFuGHyfRnuWPita2ns32upBD
55: rJ5EJYsW6Vkeruj1LAmQYq3VP7QUQKBH1W
56: rsF9cc6gniHLTR2Jng29ng21ez7L9PpmPt
58: rQKZSMgmBJvv3FvWj1vuGjUXnegTqJc25z

25|

I
62: rEbKBkgKSQgm5x8PycZc5VjdCVTmqYfcY1

26|

J
78: r4GZxkmmgJ2q5di7QTn4nWZJWr3JPN1YHe

27|

K
12: rhEwsCWDCVxDiKxGJAKM6VuXC8EFtJP5gQ
13: rncKvRcdDq9hVJpdLdTcKoxsS3NSkXsvfM

xrparcade.com/escrow/
(Credit to @ArcadeXrp @LeoHadjiloizou)

28|
I hope you enjoyed this tread, feel free to comment what you think.

Maybe @bob_way could give a few"insights"or additional informations to some wallets(some were created maaany years ago)😁.
Also curious if @HammerToe have some additional infos maybe..

Just happy for everything new/additional in regards of the #XRPLedger.
Beside the ones already @ in the Thread,maybe also interesting for @krippenreiter @sentosumosaba @DeutschlandXrp @MrFreshTime @WKahneman @BankXRP @ThinkingCrypto1 @IOV_OWL @jungleincxrp @panosmek @Arturo_P_A

#xrp #xrpl #XRPLedger #XRPCommunity #XRPArmy