List of all Bitcoin addresses with a balance - page 7.

CKKwan

newbie

Activity: 2

Merit: 2

Quote from: LoyceV on June 11, 2020, 11:30:34 AM

New: Direct link to LATEST versions
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

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: jovica888 on October 31, 2021, 05:36:13 PM

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.

jovica888

jr. member

Activity: 42

Merit: 11

Can you upload this big files for example to "Wetransfer" or "Torrent"... I Have 1 Gb/s downloading 800MB 45 minutes

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

~~This webhost is temporarily offline. See Twitter for my host's status updates. Current estimate is about 2 days of downtime to go.~~
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.

PrivatePerson

member

Activity: 173

Merit: 12

Thanks for the help!

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: PrivatePerson on August 25, 2021, 04:28:11 PM

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.

Quote from: LoyceV on August 01, 2020, 05:05:46 AM

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.

PrivatePerson

member

Activity: 173

Merit: 12

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?

LoyceMobile

hero member

Activity: 1659

Merit: 687

LoyceV on the road. Or couch.

Quote from: PrivatePerson on August 25, 2021, 03:50:19 PM

formatted in windows > sublime Text - UTF8

Try to add the fromdos pipe.

PrivatePerson

member

Activity: 173

Merit: 12

formatted in windows > sublime Text - UTF8

LoyceMobile

hero member

Activity: 1659

Merit: 687

LoyceV on the road. Or couch.

Quote from: PrivatePerson on August 25, 2021, 03:06:04 PM

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?

PrivatePerson

member

Activity: 173

Merit: 12

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.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: PrivatePerson on August 25, 2021, 10:07:34 AM

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.
You can just use the sort command on it (make sure there are no tabs left in the file), or download the other file.

PrivatePerson

member

Activity: 173

Merit: 12

i had blockchair_bitcoin_addresses_and_balance file
I removed the balances from it. Do you want both files to be sorted by name?

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: PrivatePerson on August 25, 2021, 07:06:55 AM

Code:

comm -12 bitcoin_addresses_25.08.2021.txt <(cat My-addresses.txt | sort | uniq)
comm: file 1 is not in sorted order

Need to sort the bitcoin_addresses_25.08.2021.txt file somehow?

Your file name is different from mine: did you download (and uncompress) addresses.loyce.club/Bitcoin_addresses_August_24_2021.txt.gz?
That file is sorted already, and I just checked the command to confirm it still works. What exactly did you do to get this file?

PrivatePerson

member

Activity: 173

Merit: 12

Need help

Code:

comm -12 bitcoin_addresses_25.08.2021.txt <(cat My-addresses.txt | sort | uniq)
comm: file 1 is not in sorted order

Need to sort the bitcoin_addresses_25.08.2021.txt file somehow?

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: GhostOfCommunism on August 08, 2021, 04:55:42 AM

How to get latest block numbers?

You can choose from many different methods. For instance: in Bitcoin Core, click Window > Information, It shows: "Current block height 694768". Or use Blockchain.com's explorer's Latest Blocks.

If you want a nice visualization with it, use Billfold's BitBonkers. Turn on your sound, put it to full screen, and watch transactions and blocks drop from the sky. Click balls for details.

This doesn't have much to do with this topic, so I'm not sure what exactly you're looking for.

GhostOfCommunism

newbie

Activity: 1

Merit: 0

Hi! How to get latest block numbers?

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: LeTH3knXoDArzm on July 07, 2021, 06:32:53 AM

1) There's a fee to be paid monthly (6 euros)

I want this to be a long-term project. If it's going to cost 720 euro for 10 years, I won't keep it up forever.

Quote

2) The hassle to upload the files every day on that seedbox

I've never used a seedbox, but a regular VPS is very convenient.

Quote

3) You should implement some google captcha to download directly from loyce.club.

Those are more annoying for humans than for bots, so I won't do that. I'd rather implement a 10 sat LN payment for each download

LeTH3knXoDArzm

newbie

Activity: 5

Merit: 2

Quote from: LoyceV on July 07, 2021, 05:52:54 AM

Quote from: LeTH3knXoDArzm on July 07, 2021, 05:46:41 AM

you can upload the content on https://wetransfer.com/ and use that for the main link, and somewhere in the page add the link on your host. It would save loooooots of traffic.

Thanks for the suggestion, but I'm not going to do this. I don't like using a third party that requires additional attention from the downloader. If anything, I'll use Torrent in the future.

Or so! It's a great option, took a look on google for seedboxes and found this (first link) https://seedbox.io/shared-seedbox/ there's a monthly payment (6 euros) but there's unlimited traffic.
But there are some cons:
1) There's a fee to be paid monthly (6 euros)
2) The hassle to upload the files every day on that seedbox
3) You should implement some google captcha to download directly from loyce.club.
..
..
..
it worth the work?

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: LeTH3knXoDArzm on July 07, 2021, 05:46:41 AM

you can upload the content on https://wetransfer.com/ and use that for the main link, and somewhere in the page add the link on your host. It would save loooooots of traffic.

Thanks for the suggestion, but I'm not going to do this. I don't like using a third party that requires additional attention from the downloader. If anything, I'll use Torrent in the future.

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