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
Topic: List of all Bitcoin addresses with a balance - page 5. (Read 8765 times)
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. 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.
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?
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
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
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.
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
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
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 assume people who use a normal browser will see the dates typed on addresses.loyce.club/.
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.
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
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 
https://www.youtube.com/watch?v=JKDo6g4CCeU
If you want to keep "fixed filename", maybe add one more, small file with "update date" inside.
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
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:
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:
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
situation in Kazakhstan.
What are the odds they host this in Kazakhstan 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.
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.
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.
@LoyceV, @bitmover
Have you ever looked for mined but unmoved Bitcoin? Would be interesting to know how many there are.
I just made a search here:Have you ever looked for mined but unmoved Bitcoin? Would be interesting to know how many there are.
https://blockchair.com/bitcoin/outputs?s=time(desc)&q=is_from_coinbase(true),is_spendable(true)#f=is_from_coinbase,time,is_spendable
According to blockchair.com, there are 196,479 outputs of coinbase transactions which are spendable. I.e, they are unmoved.
We have block 0 in that list
But block 0 output is unspendable.These are the number of outputs but not how many Bitcoin. It should be > 1 million Bitcoin (at least)
@LoyceV, @bitmover
Have you ever looked for mined but unmoved Bitcoin? Would be interesting to know how many there are.
Have you ever looked for mined but unmoved Bitcoin? Would be interesting to know how many there are.
I just made a search here:
https://blockchair.com/bitcoin/outputs?s=time(desc)&q=is_from_coinbase(true),is_spendable(true)#f=is_from_coinbase,time,is_spendable
According to blockchair.com, there are 196,479 outputs of coinbase transactions which are spendable. I.e, they are unmoved.
@LoyceV, @bitmover
Have you ever looked for mined but unmoved Bitcoin? Would be interesting to know how many there are.
Have you ever looked for mined but unmoved Bitcoin? Would be interesting to know how many there are.
Jump to: