Pages:
Author

Topic: List of all Bitcoin addresses with a balance - page 4. (Read 7785 times)

newbie
Activity: 24
Merit: 8
How could I generate a dump like this from the blockchain? Any script available?

Hi LoyceV since you already have some useful data, did you believe that you can publish some list like "Public keys with balance".

Not OP, but are you looking for something like this:
Code:
address                                  balance         pubkey
12higDjoCCNXSA95xZMWUdPvXNmkAduhWv       0.00010000      044d05240cfbd8a2786eda9dadd520c1609b8593ff8641018d57703d02ba687cf2f187f0cee2221c3afb1b5ff7888caced2423916b61444666ca1216f26181398c
17afxUJouat3fkaaQ9tZrDThxdkXGL4WrM       0.00010000      0428ae82b094ace0e2753b55ade744f65580effe4be3940601cd5a6c51d5af7c5a3747741abcfebf48085010fc7983107da4fbc3dff8b72401779fcfbaa05bd5d3
1PhUXucRd8FzQved2KGK3g1eKfTHPGjgFu       50.00673279     04a2b3590604543737ef6a5cbdf438e44ef66d584efab1565759e1bafc72462d6b5f547466e4cbd610f2dcd65f2c0d6a419cf0170c15d7e783edf7d0247fa74f3b
1DNML6RyHdsqRS7te5SpCkMGoYEkVJU6wD       0.00000890      04ab6c62bcdc3ee4a5ded010007e48c6404347997624af22582147bf4ca7f2b7c3b725d1278f19c87f85652adcc8a198104c233353683bc6c2d1f8149c53c3782b
15J5MZxBkbo88hfHbY96UEDdWWtTJKTBgj       0.00000890      04aeb58ff7e7109ad1d2e8f4f574c733833a8c9c394082cec0f691d63a352ce56d3a1ac62473b62b70b238495808b8c904efff6c02ae9fc97e442f153404b64af2
1EGDbCKGbizMFgwjn4WNHTvAthsvrsixDv       1.00000000      042dfb87e38d92220d20fc181d358dca0f3677f2eabf64425b355deda0ae34a057127b369a80dcb69fb652ddbcb5e91b1c1bd43634be8c00fd1f0c74d3c6b9b8d6
1PyNKEyqtDFB4HBG8ueDVxdPZfgwC6gAqw       0.00001000      046bfe6fa9d6ab1383378cb1f30fb913e9bb18bc7f8cc81aadd2ac70bb5177d4dd73cd7a59373d58738602ba850622e1f470aa8ea45972673bd06b8bdc119f7ef4
1JXFXUBGs2ZtEDAQMdZ3tkCKo38nT2XSEp       0.00001000      04044ee968e705cba538788fd49bdd95ec4b8d96d6fe52c3c0788c4289d6c6ec3305cb603ac45462ffd6093aaddebd0f1201945165d8b0a2b9bb9a70e392aa4936
18FAoviy2XGWRBvDaA1QSUrKuPH2ST8pA2       2.38000000      04d21667e5ab6f05072fec925c9f598af3fcf40aafd31dd89b8994a63f516a7426da3cceb9ff437678dcd02abd8451b51d61075c58f0cc7e072fa71dd8f74b603c
14ccB2QFEKZnd1gLUtgr7vWg6JrMeXaQXK       0.00001000      045551caaca4caa1535fdea7e3dd6646720869e5c0187077aecfeafe60741aa61a35b013eb0f55081e30fc1b3b03bbc39e2430b31073574c39dbe60d122edb8a1b
12u6hecWRHEPceLYZ9yhubZvhgKYuLGf1J       151.00001435    046bd20f8fe764c28f5fe1c4eba69d26e0af42bf1853213d593a5098e075344d6fdc998e9c1e469cad7d799a0891f3bc47ae1f6a1eb6caabd62890a7994f4b6d5f
1XPTgDRhN8RFnzniWCddobD9iKZatrvH4        0.00015529      0434417dd8d89deaf0f6481c2c160d6de0921624ef7b956f38eef9ed4a64e36877be84b77cdee5a8d92b7d93694f89c3011bf1cbdf4fd7d8ca13b58a7bb4ab0804
1BiDsroMqEwDhBmzkKLvCSAddGn8QGmLFf       0.00001000      040bc7100ef382290a250654c0b77841ea844b5ad09843f55bf79fe6bb3a320f178a899280cf6f0a92befe316d922bffc3e8d6f93a8f1b788ac18c7ee44cf2f15a
1JCjFJckVFvN5EFs7oUmzKjPVLq8XyPiwc       10.00000000     04200af342e1bb4b50ada09233ebdca598446d4c7c3c92c915b3ec4fa36ef9c81937a204fe1909509d5b5b429ab00e378a3a1bf7e20e783974e0b1d5263c3bd38b
15Z5YJaaNSxeynvr6uW6jQZLwq3n1Hu6RX       7941.06426123   047a51392bace353f4c3788c9c090ef4f635ec211159ec3b9f1bb7da7679517e126e98e0012bcb4d2b023c479afaaa1ad703ea1b24e1910e2cdad38744ba7aab8a
1JiZxcwHpivk35obqHUYbdNoE1BA8ty5TB       5.00000000      04cb9648aa9f91795d111ded927f1a175c44a53537c817da4616eb071a9ec83a2670430628d20e70ee7a45b23494fc217d1020784d4d56b2f932754d79e4c3b808
legendary
Activity: 952
Merit: 1367
Hello,
What's the RPC command to do the dump on local full node?

It is not RPC way, but I was using rusty-blockparser for doing dumps from local node. It uses local files, not rpc connection.
https://github.com/gcarq/rusty-blockparser
legendary
Activity: 3262
Merit: 16303
Thick-Skinned Gang Leader and Golden Feather 2021
What's the RPC command to do the dump on local full node?
You may be interested in Bitcoin UTXO Dump.
I haven't had the time yet to test it (use at your own risk).
newbie
Activity: 2
Merit: 0
Hello,
What's the RPC command to do the dump on local full node?

Is it possible to use remote RPC server for it, like electrum?

Cheers
legendary
Activity: 3262
Merit: 16303
Thick-Skinned Gang Leader and Golden Feather 2021
Open way to mine Monero on free cpu ;-)
It can produce $0.06 per day. I'm not turning electricity into heat for that, even if someone else pays for it.

Quote
Do you plan to run a full-node (with incoming connections) and maybe electrum server?
I've already almost filled it's disk, so that won't work.
legendary
Activity: 952
Merit: 1367
The above post opened a new door: an anonymous Bitcointalk reader donated a dedicated server for this project! That means lots of storage (1 TB), lots of bandwidth (50 TB/month), and potentially more than once a day updates by parsing the Bitcoin blockchain instead of getting data from Blockchair.com!
I'm still setting it up now.

WOW, congratulations!
Open way to mine Monero on free cpu ;-)
Do you plan to run a full-node (with incoming connections) and maybe electrum server?
legendary
Activity: 3262
Merit: 16303
Thick-Skinned Gang Leader and Golden Feather 2021
Update: the new server is online, at the old location: addresses.loyce.club.
Because of the much larger disk space, I'll now keep more daily and monthly snapshots. It will take a couple of months to collect them all.
Enjoy the bandwidth Smiley
legendary
Activity: 3262
Merit: 16303
Thick-Skinned Gang Leader and Golden Feather 2021
This project has already used up 1.5 out of it's 2 TB bandwidth for this month. To prevent the server from being suspended, I've scheduled to take down the Apache webserver in 5 days. I'll restart it on April 1st.
The above post opened a new door: an anonymous Bitcointalk reader donated a dedicated server for this project! That means lots of storage (1 TB), lots of bandwidth (50 TB/month), and potentially more than once a day updates by parsing the Bitcoin blockchain instead of getting data from Blockchair.com!
I'm still setting it up now.
legendary
Activity: 3262
Merit: 16303
Thick-Skinned Gang Leader and Golden Feather 2021
This project has already used up 1.5 out of it's 2 TB bandwidth for this month. To prevent the server from being suspended, I've scheduled to take down the Apache webserver in 5 days. I'll restart it on April 1st.

It's now the second time I have to take this precaution. I've paid this webhost for the next 1.5 years, and I'm at the maximum bandwidth for this package already. I don't really want to upgrade to another server yet (I use 4 different servers for 4 different projects).
If anyone's in urgent need for this data when it's offline: post here Smiley
legendary
Activity: 3262
Merit: 16303
Thick-Skinned Gang Leader and Golden Feather 2021
You should check in accessLog how many requests you have from curl/wget type tools and how many from normal browser.
I never look at logs. Now that I did, it turns out logs don't get rotated, so it goes back more than a year.
Some counts:
Code:
"mozill": 688k
"chrom": 539k
"wget": 415k
I've wiped the logs now.

I assume people who use a normal browser will see the dates typed on addresses.loyce.club/.
legendary
Activity: 952
Merit: 1367
If you want to keep "fixed filename", maybe add one more, small file with "update date" inside.
The update date is in the file's time stamp. It used to be easy to see, but since I added an index.html it doesn't show anymore.
I had to search a bit, Super User.com gave this command:
Code:
wget --server-response --spider  http://addresses.loyce.club/Bitcoin_addresses_LATEST.txt.gz 2>&1 | grep -i Last-Modified
  Last-Modified: Mon, 31 Jan 2022 00:57:38 GMT

Too technical. But maybe will be enough. You should check in accessLog how many requests you have from curl/wget type tools and how many from normal browser.
legendary
Activity: 3262
Merit: 16303
Thick-Skinned Gang Leader and Golden Feather 2021
If you want to keep "fixed filename", maybe add one more, small file with "update date" inside.
The update date is in the file's time stamp. It used to be easy to see, but since I added an index.html it doesn't show anymore.
I had to search a bit, Super User.com gave this command:
Code:
wget --server-response --spider  http://addresses.loyce.club/Bitcoin_addresses_LATEST.txt.gz 2>&1 | grep -i Last-Modified
  Last-Modified: Mon, 31 Jan 2022 00:57:38 GMT
legendary
Activity: 952
Merit: 1367
Last month, I killed my webserver for the last days to stop my VPS from being suspended. I turned it back on this month, but Blockchair hasn't updated their data dumps yet this month so you're all downloading the same version over and over again Tongue

https://www.youtube.com/watch?v=JKDo6g4CCeU

If you want to keep "fixed filename", maybe add one more, small file with "update date" inside.
legendary
Activity: 3262
Merit: 16303
Thick-Skinned Gang Leader and Golden Feather 2021
Last month, I killed my webserver for the last days to stop my VPS from being suspended. I turned it back on this month, but Blockchair hasn't updated their data dumps yet this month so you're all downloading the same version over and over again Tongue
legendary
Activity: 3262
Merit: 16303
Thick-Skinned Gang Leader and Golden Feather 2021
Blockchair's problems have long been resolved.

I'm closing in on another potential problem: this VPS might run out of bandwidth (2TB) before the end of this month. If that happens it will get suspended, and be back online next month. This hosting package doesn't allow adding more bandwidth, and I've paid this server until November 2023, so I'm not switching elsewhere any time soon.

I'm glad to see this data is in high demand though:
Image loading...
legendary
Activity: 952
Merit: 1367
situation in Kazakhstan.
What are the odds they host this in Kazakhstan

https://status.blockchair.com/
Quote
General status: Some of our servers are currently unavailable due to a global Internet shutdown in Kazakhstan: https://twitter.com/disclosetv/status/1478694856402817026. We're working on activating our reserve infrastructure. Some historical Ethereum transactions may be missing. Situation updates will be available at https://status.blockchair.com/ and at https://twitter.com/Blockchair/status/1478698203792949249
legendary
Activity: 3262
Merit: 16303
Thick-Skinned Gang Leader and Golden Feather 2021
situation in Kazakhstan.
What are the odds they host this in Kazakhstan
legendary
Activity: 952
Merit: 1367
My LATEST version is currently stuck at January 5, 2022. It turns out Blockchair hasn't updated their archives in the last 6 days, and before that their archives were offline for a few days. I'm hoping it will be back online eventually.

They informed about troubles, AFAIK something related to situation in Kazakhstan. Archive pages were completely inaccessible recently, now they are back, but with old data.
legendary
Activity: 3262
Merit: 16303
Thick-Skinned Gang Leader and Golden Feather 2021
My LATEST version is currently stuck at January 5, 2022. It turns out Blockchair hasn't updated their archives in the last 6 days, and before that their archives were offline for a few days. I'm hoping it will be back online eventually.
legendary
Activity: 3262
Merit: 16303
Thick-Skinned Gang Leader and Golden Feather 2021
Have you ever looked for mined but unmoved Bitcoin? Would be interesting to know how many there are.
You can probably get this from Bitcoin block data (550 GB): inputs, outputs and transactions, but I still don't have a(n affordable) webhost for this data, and https://gz.blockchair.com/ has been offline for a few days.
It would be interesting to create an all-time graph, showing how the number of unspent new Bitcoins changes since the creation of Bitcoin. But I'll skip this one: too much data to process.
Pages:
Jump to: