Well, that is a pity, thanks for the fast reply.
I will stick to my current list of dormants-publickeys with subtracted values Total (3.5 Million public keys) at some 400 Gkeys/s
Wonderful work you made.
Thanks!
Topic: List of all Bitcoin addresses with a balance - page 6. (Read 7844 times)
can publish some list like "Public keys with balance".
As far as I know the public key is only known after a transaction was made from that address (or when a message was signed), and I haven't found this data in a format that I can easily scrape. It certainly won't be a very complete list.
Hi LoyceV since you already have some useful data, did you believe that you can publish some list like "Public keys with balance".
Can i ask you all what you all do with the data Form the file?
Best regards
Willi
Best regards
Willi
I downloaded your link. Thank you
At the moment the website is not working.
I don't know why, I don't see any down time on the server-site.Quote
Can you maybe split files so 1 file will contain only addresses that start with "1" for example "1jFkHrG18Hc6ae9jTxXyJxqHyzmUjNdyQ"?
For Linux users, that's very easy to get:Code:
wget -qO- http://addresses.loyce.club/blockchair_bitcoin_addresses_and_balance_LATEST.tsv.gz | gunzip | grep "^1" > Bitcoin_legacy_addy.txt
Quote
Also can I donate via Paypal?
No, I like my privacy. I can setup some altcoin though if that's okay.
At the moment the website is not working. Can you maybe split files so 1 file will contain only addresses that start with "1" for example "1jFkHrG18Hc6ae9jTxXyJxqHyzmUjNdyQ"?
Also can I donate via Paypal?
Also can I donate via Paypal?
I'll wait a bit to see if they fix it on their own before I contact them.
It looks like they fixed it: gz.blockchair.com/bitcoin/addresses/ is 1GB again (the faulty version was around 200MB). I ran an update yesterday, and tomorrow daily updates should be back to normal.I noticed my script skips a few days once in a while (for instance, there were no updates between September 27 and October 08). I think it also has to do with Blockchair's data, that's why I keep a few older versions.
Thanks, the correct format is easy to parse. It is very helpful 
This is what I got after extracting the content of the file provided by the link above. May I know how can I get the balance?
Thanks for this, it looks like gz.blockchair.com changed the file I use a few days ago: it's now much smaller and contains the wrong data. I'm pretty sure that's a mistake. I'll wait a bit to see if they fix it on their own before I contact them.I'll restore older versions for now.
Update: done! This is the latest version: addresses.loyce.club/blockchair_bitcoin_addresses_and_balance_October_28_2021.tsv.gz. I'll keep an eye on Blockchair to see when I can continue daily updates.
New: Direct link to LATEST versions
blockchair_bitcoin_addresses_and_balance_LATEST.tsv.gz (currently 862MB)
Bitcoin_addresses_LATEST.txt.gz (currently 750 MB)
blockchair_bitcoin_addresses_and_balance_LATEST.tsv.gz (currently 862MB)
Bitcoin_addresses_LATEST.txt.gz (currently 750 MB)
This is what I got after extracting the content of the file provided by the link above. May I know how can I get the balance?
Thx
Code:
block_id transaction_hash index time value value_usd recipient type script_hex is_from_coinbase is_spendable spending_block_id spending_transaction_hash spending_index spending_time spending_value_usd spending_sequence spending_signature_hex spending_witness lifespan cdd
707781 3b9e2e90f4fa4fe5bb88a02f6941556af8f96c8da24799f8247e00ea046c5dac 3 2021-11-01 23:57:34 495453564 304267.9375 17A16QmavnUfCW11DAApiJxp7ARnxN5pGX pubkeyhash 76a91443849383122ebb8a28268a89700c9f723663b5b888ac 0 -1 707782 a40e8ce34941857ab0a6d43608e4b3f46f9dec536b9996a0bbdaa4d03ee56483 0 2021-11-02 00:08:47 302479.3438 4294967295 4730440220657eaf1d7a7437bc43d5fed9fefe3a20050d851d20d84e49aae06ae77a282be302200de42995d1845351a51378af797995b417437f7b897d68f010be6d26a8bfb3c40141047146f0e0fcb3139947cf0beb870fe251930ca10d4545793d31033e801b5219abf56c11a3cf3406ca590e4c14b0dab749d20862b3adc4709153c280c2a78be10c 673 0.038592621362499996
707779 a2e73b31479e093808358d69fcd6ca7077784a221d0f2e1e012c81e64b2d4076 1 2021-11-01 23:45:32 8426099 5174.6357 3EJKvTDK4qfnmCZGTupkCJKwpYvcoPh3iC scripthash a9148a4f17a7a0a009defd16398346ff6676c56a54a087 0 -1 707782 2f3b6627353ad9b7a8f0e80b625bfee47658de46f3b92ca3b7ab6f836fb7618c 0 2021-11-02 00:08:47 5144.2178 4294967295 2200209d88df8678e20d25689764c898adf19acd527e6f3c3feb2a8357d92a7286eece ,3045022100c94a1fa096b44e433f28430622c072a85456620583b39134d95e914f21b1c90402204d2b33ad7f0fb23c3fdb9f7b0101efe7ae30b635c27db95d5a492c74e58f05a601,304402207ff9f64a641124f4141dda3283bbe4d26da670f6082745d4ac5e8bfb240cb1de022053b79f60104f6fa5381a1728ad102a6cf6ecacab68254f043ec28f0195a6478901,5221030daf2b128d8a9fb959664ee334b668ca43b74441367cea3616e208fbbaaf568c2103a34f5c21e98f801b0d848e6401538074e049f993e80c66b07c2f28d37e844eef2102778952c666d794865b42e39a2541781d216f9299477001023b8186a7faf57e0353ae 1395 0.0013604639010416665
707776 690c212f2010075bbaa393c3f2d7d3a8739d862ced53384eb596038c9f010109 0 2021-11-01 23:33:04 1029410682 632181.6875 115md8GZ5S8CmvUj8a8cW58YcKvv2SekYf pubkeyhash 76a91400e6e9c2ab476c627c157ccaa2a1a526b86fb79788ac 0 -1 707782 04ff6bbeabb0faa6fec86f7f2dd292b6f3d0524ddcc826b9fd1b62660d5c581e 0 2021-11-02 00:08:47 628465.5 4294967295 473044022053304e19fba6c8933139d647d06146d857a2483ba564f6c72440767a44260d6502204f43503fc1ccc5f4cf3ae2001ec825c3f0d7c85bde9a96e7dcee00bcda668b95012103b3c036c7b89095d00ddf9b23b93c4781d7c486420ea75ce9d6404344e4ddb4fb 2143 0.2553272096673611
707781 2289e6937ea7f96420f4f4a8303acfadb062be2cc9d40e1dc7ff7eee3d8baa0b 0 2021-11-01 23:57:34 1028078900 631363.8125 115md8GZ5S8CmvUj8a8cW58YcKvv2SekYf pubkeyhash 76a91400e6e9c2ab476c627c157ccaa2a1a526b86fb79788ac 0 -1 707782 6f34766bc533b55b108527254a37cdf883df3351a1d3063bca586bc08793305f 0 2021-11-02 00:08:47 627652.4375 4294967295 483045022100b88ac8d9e60b735bbf1cb7a46463257c847f4fa5e40874c2fa2a8a245e2e519e0220189ba4db5a8b95608eeaacdd906265719f006392fb4a94780e9bd4653921e084012103b3c036c7b89095d00ddf9b23b93c4781d7c486420ea75ce9d6404344e4ddb4fb 673 0.08008068283564815
707780 731c26594d1fa8048216542745ac8df127bad75d32289753c945f9adf4e9b218 5 2021-11-01 23:53:51 150000 92.118 32ECMLtoA4R92YLsZi3dVV3J3EhDdgSfkV scripthash a91405e5996d7a30bd3ba56b499e0359afd8679ac10f87 0 -1 707782 7d7607e72ebec8da5243785c5bcb238937dc97ae95198fa426ae5dc2e9de967f 0 2021-11-02 00:08:47 91.5765 4294967295 1600147532e84aaff981d8ac62f86769ba048f2733900b 304402201d96222e49702c434f60c81991169c5594a585dfc66799fd75aa4b6e416e3da70220385f85fdaca12c7b7ef59a6d9298c1a49203dd035424ec97b07f9f313148d71501,036cab780d415f14a6218b01cc435c4eb83d93e2faa2068a76c314485a6bfd4777 896 0.000015555555555555555
707776 a0269077bc0c5c824f5a33a20bc1bc0a912deeb8487cd7c15faa6df6e7e4f334 1 2021-11-01 23:33:04 249126 152.9933 3PbJsixkjmjzsjCpi4xAYxxaL5NnxrbF9B scripthash a914f03e6bf9b389bbd5d5669ff55c4dba30de99553587 0 -1 707782 7d7607e72ebec8da5243785c5bcb238937dc97ae95198fa426ae5dc2e9de967f 1 2021-11-02 00:08:47 152.0939 4294967295 160014f7bae6ee31d59e79da8e857fb63429637f9e0d57 3044022045be9d951d43a01075f501f9b2da5222597420cb9d2f4c9e86eb92ca836065fb022027a5e1f6347bb31253ad9f0725a4b8d129f2413ec4218ad79e6543b964396bf401,034ed258709969db6507e5b86568e6c57d903917034a853fd2f6b7604443431518 2143 0.00006179132152777778
707772 e8d7df31409460f4bc37f2a59389610cb6e34579fc171adadbf78f81a37da600 2 2021-11-01 23:14:31 11564045 7101.7114 bc1q4kmm0ud3qzml0frwcjxhgwlndmpfanzk48rkr2 witness_v0_scripthash 0014adb7b7f1b100b7f7a46ec48d743bf36ec29ecc56 0 -1 707782 73f16d7fadf951296d674880472e753000a6b0b35a362524f900ce13fe203a40 0 2021-11-02 00:08:47 7059.9653 4294967293 304402205761e08d6936715e98d6f1e939f19ab9776a56b1badecc79ab74811487dce17902206e42965c7fc5e0adbcb2556cc5f0dc9c9af37b1dfc46eed4eb0ff887333107b601,0279ac41a2bb9b0cedca41b9b7b9fad4cdff875d7fbb4a3474c3ad74588be19e27 3256 0.004357931773148148
Can you upload this big files for example to "Wetransfer" or "Torrent"... I Have 1 Gb/s downloading 800MB 45 minutes
No: I won't use Wetransfer and Torrent won't really help for these small files Addresses.loyce.club is working fine now. 800 MB should take you 1 or 2 minutes.
I'm hoping for a good Black Friday deal on a new storage servers, those have been scarce. Some say it's because of Chia hdd mining.
Can you upload this big files for example to "Wetransfer" or "Torrent"... I Have 1 Gb/s downloading 800MB 45 minutes
Update: it's back online, currently running today's update.
Before it went down, I noticed several daily updates were missed in the past month. I don't know the cause of that, I only noticed it afterwards.
If anyone knows an affordable (storage) VPS with enough bandwidth allocated, please let me know. Say 1 TB storage and 10 TB bandwidth. "Affordable" means this is just a side-project that I'm not willing to spend hundreds of dollars worth of Bitcoin on.
Thanks for the help!
not clear why, but it worked
Windows uses a different end of line character than Linux, and since comm compares the entire line, all your addresses will include a different character, and therefore won't match the list of funded addresses.Using fromdos fixes it.
This is how Blockchair.com shows OP_RETURN. From the main page the search field doesn't show them, but you can replace a Bitcoin address in the URL to find them: https://blockchair.com/bitcoin/address/d-d0d953f2e7043342540a1407243e49fe.
Eureka! It worked, not clear why, but it worked.
I use sort for Linux, it did not help.
What are the addresses in the list of the format:
m-f0038f17d4787569b404c383d2cdb031?
I use sort for Linux, it did not help.
What are the addresses in the list of the format:
m-f0038f17d4787569b404c383d2cdb031?
formatted in windows > sublime Text - UTF8
Try to add the fromdos pipe.
formatted in windows > sublime Text - UTF8
Where should this command output the results?
The matching addresses are shown on console.Does your list have spaces or Windows formatting by any chance?
Jump to: