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

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: PawGo on February 05, 2022, 04:26:58 AM

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

PawGo

legendary

Activity: 952

Merit: 1386

Quote from: LoyceV on February 05, 2022, 04:20:02 AM

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 Tongue

https://www.youtube.com/watch?v=JKDo6g4CCeU

If you want to keep "fixed filename", maybe add one more, small file with "update date" inside.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

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 Tongue

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

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:
Image loading...

PawGo

legendary

Activity: 952

Merit: 1386

Quote from: LoyceV on January 11, 2022, 11:08:15 AM

Quote from: PawGo on January 11, 2022, 11:01:52 AM

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

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: PawGo on January 11, 2022, 11:01:52 AM

situation in Kazakhstan.

What are the odds they host this in Kazakhstan

PawGo

legendary

Activity: 952

Merit: 1386

Quote from: LoyceV on January 11, 2022, 10:38:52 AM

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.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

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.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: mynonce on January 06, 2022, 04:36:46 PM

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.

mynonce

full member

Activity: 233

Merit: 253

Quote from: bitmover on January 06, 2022, 08:40:45 PM

Quote from: mynonce on January 06, 2022, 04:36:46 PM

@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:
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 Huh

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)

bitmover

legendary

Activity: 2352

Merit: 6089

bitcoindata.science

Quote from: mynonce on January 06, 2022, 04:36:46 PM

@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:
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.

mynonce

full member

Activity: 233

Merit: 253

@LoyceV, @bitmover
Have you ever looked for mined but unmoved Bitcoin? Would be interesting to know how many there are.

bitmover

legendary

Activity: 2352

Merit: 6089

bitcoindata.science

Quote from: LoyceV on January 05, 2022, 04:46:25 PM

Quote from: mynonce on January 05, 2022, 02:26:44 PM

Maybe with percentage?

I created the json-file for bitmover, and I prefer his solution:

Quote from: bitmover on January 05, 2022, 03:03:20 PM

I am doing this in the front end, no need to add this information in the data itself. I think the data should e as raw as possible.
You can see the percentage here https://bitcoindata.science/bitcoin-funded-addresses.html

just added the taproot addresses to the front end:

The problem is that the numbers are still very small. Let's see how fast those numbers will grow so we can actually see those addresses in the charts.

mynonce

full member

Activity: 233

Merit: 253

Quote from: bitmover on January 05, 2022, 03:03:20 PM

I am doing this in the front end, no need to add this information in the data itself. I think the data should e as raw as possible.

Quote from: LoyceV on January 05, 2022, 04:46:25 PM

Quote from: mynonce on January 05, 2022, 02:26:44 PM

Maybe with percentage?

I created the json-file for bitmover, and I prefer his solution:

Quote from: bitmover on January 05, 2022, 03:03:20 PM

I am doing this in the front end, no need to add this information in the data itself. I think the data should e as raw as possible.
You can see the percentage here https://bitcoindata.science/bitcoin-funded-addresses.html

Thanks.
I didn't know this site https://bitcoindata.science/bitcoin-funded-addresses.html

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: mynonce on January 05, 2022, 02:26:44 PM

Maybe with percentage?

I created the json-file for bitmover, and I prefer his solution:

Quote from: bitmover on January 05, 2022, 03:03:20 PM

I am doing this in the front end, no need to add this information in the data itself. I think the data should e as raw as possible.
You can see the percentage here https://bitcoindata.science/bitcoin-funded-addresses.html

bitmover

legendary

Activity: 2352

Merit: 6089

bitcoindata.science

Quote from: mynonce on January 05, 2022, 02:26:44 PM

I like what you're doing, but only a proposal:

Code:

"05/01/2022":[
	{"total": 39633563, 100.00%,
	  "1": 23822618, 60.11%,
	  "3": 8421989, 21.25%, 
	  "bc1q": 7371925, 18.60%
	  "bc1p": 17027, 0.04%}]

Maybe with percentage?

I am doing this in the front end, no need to add this information in the data itself. I think the data should e as raw as possible.
You can see the percentage here
https://bitcoindata.science/bitcoin-funded-addresses.html

Quote from: LoyceV on January 05, 2022, 01:36:29 PM

Time to add Taproot addresses:

Quote from: dkbit98 on December 09, 2021, 05:59:59 AM

I know that Taproot addresses are starting with bc1p, and Native Sewgit addresses start with bc1q.

Starting today, I've added bc1p-addresses to total_number_of_funded_addresses.txt and total_number_of_funded_addresses.json:

Code:

"03/01/2022":[
	{"total": 39644562,
	  "1": 23810601,
	  "3": 8474856,
	  "bc1q": 7342678}],
"04/01/2022":[
	{"total": 39631173,
	  "1": 23822116,
	  "3": 8429494,
	  "bc1q": 7362835}],
"05/01/2022":[
	{"total": 39633563,
	  "1": 23822618,
	  "3": 8421989,
	  "bc1q": 7371925,
	  "bc1p": 17027}]
}

I'm curious to see how fast those numbers will go up.

I will add this by tomorrow
Thanks for the heads-up

mynonce

full member

Activity: 233

Merit: 253

I like what you're doing, but only a proposal:

Code:

"05/01/2022":[
	{"total": 39633563, 100.00%,
	  "1": 23822618, 60.11%,
	  "3": 8421989, 21.25%, 
	  "bc1q": 7371925, 18.60%
	  "bc1p": 17027, 0.04%}]

Maybe with percentage?

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: bitmover on June 03, 2021, 12:29:55 PM

I have been monitoring the total number of funded addresses here , with the data provided by LoyceV here

Time to add Taproot addresses:

Quote from: dkbit98 on December 09, 2021, 05:59:59 AM

I know that Taproot addresses are starting with bc1p, and Native Sewgit addresses start with bc1q.

Starting today, I've added bc1p-addresses to total_number_of_funded_addresses.txt and total_number_of_funded_addresses.json:

Code:

"03/01/2022":[
	{"total": 39644562,
	  "1": 23810601,
	  "3": 8474856,
	  "bc1q": 7342678}],
"04/01/2022":[
	{"total": 39631173,
	  "1": 23822116,
	  "3": 8429494,
	  "bc1q": 7362835}],
"05/01/2022":[
	{"total": 39633563,
	  "1": 23822618,
	  "3": 8421989,
	  "bc1q": 7371925,
	  "bc1p": 17027}]
}

I'm curious to see how fast those numbers will go up.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: majika on January 01, 2022, 07:13:04 AM

However call me stupid BUT a far simpler way would be to parse data directly from your own node?

As far as I know, that's not so simple. But if you can figure it out, I'd love to see your results. I expect it to be quite slow.

Quote

PS. What about a "BTC Address Rich List" This is fundamentally based on a similar principle as what your wishing to achieve, is it not?

The list with balance is a "Rich List":

Code:

wget -qO- http://addresses.loyce.club/blockchair_bitcoin_addresses_and_balance_LATEST.tsv.gz | gunzip | grep -vP "address\tbalance" | head -n 50 
34xp4vRoCGJym3xR7yCVPFHoCNxv4Twseo      26547968732321
bc1qgdjqv0av3q56jvd82tkdjpy7gdp9ut8tlqmgrpmv24sq90ecnvqqjwvw97  16800998536372
1P5ZEDWTKTFGxQjZphgWPQUpe554WKDfHQ      12038957274655
37XuVSEpWW4trkfmvWzegTHQt7BdktSKUs      9450511456719
38UmuUqPCrFmQo4khkomQwZ4VbY2nZMJ67      8406701772536
1FeexV6bAHb8ybZjqQMjJrcCrHGW9sb6uF      7995721697629
3Kzh9qAqVWQhEsfQz7zEQL1EuSx5tyNLNS      7642003887352
3LYJfcfHPXYJreMsASk2jkn69LWEYKzexb      7360113647202
3M219KR5vEneNb47ewrPfWyb5jQ2DjxRP6      7143400000000
bc1qa5wkgaew2dkv56kfvj49j0av5nml45x9ek9hz6      6937017585302
1LdRcdxfbSnmCYYNdeYpUnztiYzVfBEQeC      5388006072455
1AC4fMwgY8j9onSbXEWeH6Zan8QGMSdmtA      5183035998549
3FpYfDGJSdkMAvZvCrwPHDqdmGqUkTsJys      4579246787700
1LruNZjwamWJXThX2Y8C2d47QqhAkkc5os      4400008617726
3Gpex6g5FPmYWm26myFq7dW12ntd8zMcCY      4001396038553
bc1q5shngj24323nsrmxv99st02na6srekfctt30ch      4000032768183
385cR5DM96n1HvBDMzLHPYcw89fZAXULJP      3860186558087
3LQUu4v9z6KNch71j7kbj8GPeAGUo1FW6a      3792697744959
bc1q7ydrtdn8z62xhslqyqtyt38mm4e2c4h3mxjkug      3600041000054
159QgP4Ewvadjc4HDpaaR6pir2R4ZfzVfQ      3441500117745
bc1q5pucatprjrqltdp58f92mhqkfuvwpa43vhsjwpxlryude0plzyhqjkqazp  3369998788200
3LCGsSmfr24demGvriN4e3ft8wEcDuHFqh      3322004105156
12XqeqZRVkBDgmPLVY4ZC6Y4ruUUEug8Fx      3235400000564
bc1qx9t2l3pyny2spqpqlye8svce70nppwtaxwdrp4      3141523355441
3FHNBLobJnbCTFTVakh5TXmEneyf5PT61B      3127534535966
12ib7dApVFvg82TXKycWBNpN8kFyiAN1dr      3100007042388
3FupZp77ySr7jwoLYEJ9mwzJpvoNBXsBnE      2949754539921
12tkqA9xSoowkzoERHMWNKsTey55YEBqkv      2815105848732
3JJpCZCk4h4TpQeU7SA1yhH768Xgbtdbfg      2660550102022
1ftuUgzrr5hnVzXnFBDjELvVe69rPtBRi       2589500002000
3JZq4atUahhuA9rLhXLMhhTo133J9rF97j      2550364890459
17MWdxfjPYP2PYhdy885QtihfbW181r1rn      2449535042970
35ULMyVnFoYaPaMxwHTRmaGdABpAThM4QR      2430500118088
19D5J8c59P2bAkWKvxSYw8scD3KUNWoZ1C      2396900153670
1aXzEKiDJKzkPxTZy9zGc3y1nCDwDPub2       2363051758452
bc1qjysjfd9t9aspttpjqzv68k0ydpe7pvyd5vlyn37868473lell5tqkz456m  2328178254950
1932eKraQ3Ad9MeNBHb14WFQbNrLaKeEpT      2289999043553
19iqYbeATe4RxghQZJnYVFU4mjUUu76EA6      2243324021699
1MDq7zyLw6oKichbFiDDZ3aaK59byc6CT8      2240000017757
bc1qd4ysezhmypwty5dnw7c8nqy5h5nxg0xqsvaefd0qn5kq32vwnwqqgv4rzr  2200000010000
3DVJfEsDTPkGDvqPCLC41X85L1B1DQWDyh      2040626414582
3HSMPBUuAPQf6CU5B3qa6fALrrZXswHaF1      2020488810100
bc1q4jchcr7nla277su5lpjzttxp3xg5j8wds5lcwg      2017184466165
bc1qtw30nantkrh7y5ue73gm4mmy0zezfqxug3psr94sd967qwg7f76scfmr9p  2013623538292
17rm2dvb439dZqyMe2d4D6AQJSgg6yeNRn      2000800192617
1PeizMg76Cf96nUQrYg8xuoZWLQozU5zGW      1941443070193
3K5dmrkBMS8ZVgERMLwiw7PJuG8GWTbo8e      1860004653628
bc1qvpgyac88vqtslewxu7yu9dqwp8rd83zch55zpm3xgn3mgg72w3kqv0s8qa  1792998389600
1AjPJ1eq4VMt3NxBZwAD5BvpajxoGUJ89n      1727771271755
15HEcdBfaDD9tUxfPxgiPbTJi6ooQb11B2      1681996864863

majika

jr. member

Activity: 64

Merit: 5

Hi LoyceV

I can see the utility of having the data in this format..
However call me stupid BUT a far simpler way would be to parse data directly from your own node?

> Dump out in raw addresses which have a positive int, then parse/query. Or am I missing something here??
I suppose another method would be to check for DATES where pub_key was involved in OUTPUT. to figure out addresses with positive balance.
I'm sure there is a far more elegant solution to the problem, with which a little touch of Python could go a long way to solving the BTC address > balance question.

PS. What about a "BTC Address Rich List" This is fundamentally based on a similar principle as what your wishing to achieve, is it not?

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