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

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: LoyceV on November 14, 2020, 01:00:02 PM

If all goes well, it'll keep 6 snapshots. When I have a few, I'll see how I can keep some older ones too instead of only the most recent days.

Update: I changed my script to keep 9 snapshots. I'll keep 4 from the last 3-4 days, and 5 snapshots from the last 4-5 months. The older snapshots will be created in the coming months, I don't have them yet.

I couldn't test this yet, I'll see next month if it works as expected.

alevlaslo

hero member

Activity: 1988

Merit: 593

thanks, but I no longer work on the address list, I use the public key to one address

Vod

legendary

Activity: 3668

Merit: 3010

Licking my boob since 1970

Quote from: alevlaslo on October 19, 2020, 10:37:14 AM

I have Notepad++, but I don't have enough RAM, it freezes after selecting all the text and ALT+SHIFT+>>>

Try the free Libre suite. https://www.libreoffice.org/discover/calc/

Also, Visual Studio code can open large files/

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

~~I'm moving this to a new webhost. As a temporary location, the data will be available on http://old.loyce.club/?C=M;O=D until I'm done.~~
Done! This project now gets 1 TB per month bandwidth (4 times more), and a few more snapshots.

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

See addresses.loyce.club.

If all goes well, it'll keep 6 snapshots. When I have a few, I'll see how I can keep some older ones too instead of only the most recent days.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Interesting: I noticed Bitcoin_addresses_November_09._2020.txt.gz is 2 MB smaller than Bitcoin_addresses_November_08_2020.txt.gz. I checked if the newer file might be incomplete, but it doesn't look like that.
It turns out there were 45,303 funded addresses less on the 9^th than on the 8^th, which means someone (or many people) have been consolidating inputs to take advantage of the lower fees during the weekend.
Once I have a different host for these files, I can keep daily snapshots a bit longer to see if there's a pattern.

A day later, there are 149,295 less funded Bitcoin addresses. I didn't expect such a large daily difference.

alevlaslo

hero member

Activity: 1988

Merit: 593

well alphabetically, thank you, it is convenient to delete unnecessary things with this command

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Update: It works again! I'll see what Black Friday brings for hosting offers

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

This subdomain is currently offline:

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

The data
See addresses.loyce.club.

~~I think~~ I ran out of bandwidth (250 GB) this month. I haven't hit this limit before, so ~~I don't know if it requires manual intervention to be online again in November.~~
Update: it should be online again November 1^st. I'll upgrade the hosting when transaction fees drop. I need to wait for the current hosting to be online again to copy data anyway.

alevlaslo

hero member

Activity: 1988

Merit: 593

for 130000000000000000000000000000000000/24000000 years I will find privkey of one address

but if I shall lucky, than I can find it in one second

alevlaslo

hero member

Activity: 1988

Merit: 593

thank you, I already figured it out, I have an old hard drive, I had to wait 1 hour.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: alevlaslo on October 19, 2020, 08:03:12 AM

how do I remove extra characters?

You mean remove the balance? I just use cut. I got you 3 new files with only addresses.

alevlaslo

hero member

Activity: 1988

Merit: 593

I have Notepad++, but I don't have enough RAM, it freezes after selecting all the text and ALT+SHIFT+>>>

bitmover

legendary

Activity: 2352

Merit: 6089

bitcoindata.science

Quote from: alevlaslo on October 19, 2020, 08:03:12 AM

how do I remove extra characters? The program does not accept with them, each line only must has an address only, there should be nothing else

Which program are you using?
You will struggle a lot to manipulate this kind of data in apps such as excel.

personally, I could only open that 1GB files in my python environment. All other programs just froze

Edit: I was able to open the larger file in Notepad++.

alevlaslo

hero member

Activity: 1988

Merit: 593

how do I remove extra characters? The program does not accept with them, each line only must has an address only, there should be nothing else

alevlaslo

hero member

Activity: 1988

Merit: 593

thank you very much!

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: alevlaslo on October 19, 2020, 06:37:06 AM

I have Windows, where do I need to set this command and what program to install?

I have no idea Tongue

So I got you this instead: http://alladdresses.loyce.club:20319/tmp/
It won't be updated, and it's scheduled to be deleted in 7 days.

alevlaslo

hero member

Activity: 1988

Merit: 593

thank you, but I have Windows, where do I need to set this command and what program to install?

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: alevlaslo on October 19, 2020, 01:40:49 AM

Hello, please divide the addresses into three groups

I won't add different file formats for specific uses (because of restrictions on disk space and server load).

You're free to do that yourself though, it's quite easy:
For all Bech32 addresses:

Code:

wget http://addresses.loyce.club/blockchair_bitcoin_addresses_and_balance_October_19_2020.tsv.gz -O - | gunzip | grep "^b" > Bech32_bitcoin_addresses_and_balance_October_19_2020.tsv

Replace the "b" by "1" or "3" for other addresses, and adjust the file date for the latest version.

I'm glad to see this addresses subdomain consumes more data than the rest of loyce.club combined, that means it's being used

alevlaslo

hero member

Activity: 1988

Merit: 593

Hello, please divide the addresses into three groups, we can not import different types into the Vanitysearch program at the same time

btc_enigma

hero member

Activity: 692

Merit: 569

Quote from: bitwise on September 17, 2020, 10:45:08 AM

AFAIK you don't need to download this if you run a node
on any bitcoind node you can run dumptxoutset command and then just parse it

and when https://github.com/bitcoin/bitcoin/pull/18689/ gets merged, you won't even need to parse it

This feature would be really nice. Thanks for highlighting it

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