Can i ask you all what you all do with the data Form the file?
Best regards
Willi
Topic: List of all Bitcoin addresses with a balance - page 7. (Read 8765 times)
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?
Where should this command output the results?
I intentionally inserted one of my addresses into the list of addresses with balances and at the end of the check nothing was displayed.
Both lists are sorted.
I intentionally inserted one of my addresses into the list of addresses with balances and at the end of the check nothing was displayed.
Both lists are sorted.
i had blockchair_bitcoin_addresses_and_balance file
I removed the balances from it.
That explains why it isn't sorted: the files with balance is sorted by balance (highest first). The comm command requires the file to be sorted alphabetically.I removed the balances from it.
You can just use the sort command on it (make sure there are no tabs left in the file), or download the other file.
i had blockchair_bitcoin_addresses_and_balance file
I removed the balances from it. Do you want both files to be sorted by name?
I removed the balances from it. Do you want both files to be sorted by name?
Jump to: