bitxchange
Newbie
Offline
Activity: 6
Merit: 0
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
December 29, 2021, 05:14:17 AM Last edit: December 29, 2021, 07:10:28 PM by bitxchange |
|
You deserve praise for making the list available and keeping updates running. Have fun converting base58 and bech32 addresses to hash160, python style: import segwit_addr import base58 import argparse import sys import hashlib import binascii
parser = argparse.ArgumentParser() parser.add_argument('address', help='Enter bech32 address') args = parser.parse_args()
address = sys.argv[1]
def validate_base58(a): base58Decoder = base58.b58decode(a).hex() prefixAndHash = base58Decoder[:len(base58Decoder)-8] checksum = base58Decoder[len(base58Decoder)-8:] hash = prefixAndHash for x in range(1,3): hash = hashlib.sha256(binascii.unhexlify(hash)).hexdigest() #print("Hash#", x, " : ", hash) #print("--------------------------------------") if(checksum == hash[:8]): return True else: return False
if validate_base58(address) is True: base58_decoded = base58.b58decode_check(address).hex()[2:] print (base58_decoded) else: decoded = segwit_addr.decode('bc', address) if decoded[0] == 0: #print(decoded[2]) hash160_bin = [] for x in decoded[1]: hash160_bin.append(f'{x:08b}')
hash160_hex = [] for x in hash160_bin: hash160_hex.append(f'{int(x, 2):X}')
print(''.join(hash160_hex))
and running it: # python3 segwit_addr_decode.py 1P5ZEDWTKTFGxQjZphgWPQUpe554WKDfHQ f22f5563839ba6ba5aa8d3726fcbc675cb3e4c9e
# python3 segwit_addr_decode.py 34xp4vRoCGJym3xR7yCVPFHoCNxv4Twseo 23e522dfc6656a8fda3d47b4fa53f7585ac758cd
# python3 segwit_addr_decode.py bc1qxv55wuzz4qsfgss3uq2zwg5y88d7qv5hg67d2d 3329477042A820944211E01427228439DBE03297
useful information on bech32 encoding: https://en.bitcoin.it/wiki/Bech32test segwit address: https://bitcoin.sipa.be/bech32/demo/demo.htmltest base58 encoded address: http://lenschulwitz.com/base58
|
|
|
|
majika
Jr. Member
Offline
Activity: 64
Merit: 5
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
January 01, 2022, 12:13:04 PM Merited by JayJuanGee (1) |
|
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? ![Smiley](https://bitcointalk.org/Smileys/default/smiley.gif)
|
|
|
|
LoyceV (OP)
Legendary
Offline
Activity: 3430
Merit: 17357
Thick-Skinned Gang Leader and Golden Feather 2021
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
January 01, 2022, 12:46:50 PM Merited by JayJuanGee (1) |
|
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. 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": 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
|
|
|
|
LoyceV (OP)
Legendary
Offline
Activity: 3430
Merit: 17357
Thick-Skinned Gang Leader and Golden Feather 2021
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
January 05, 2022, 06:36:29 PM |
|
I have been monitoring the total number of funded addresses here , with the data provided by LoyceV hereTime to add Taproot addresses: 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: "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.
|
|
|
|
mynonce
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
January 05, 2022, 07:26:44 PM Last edit: January 05, 2022, 07:45:06 PM by mynonce |
|
I like what you're doing, but only a proposal: "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? ![Smiley](https://bitcointalk.org/Smileys/default/smiley.gif)
|
|
|
|
bitmover
Legendary
Offline
Activity: 2422
Merit: 6209
Crypto Swap Exchange🈺
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
January 05, 2022, 08:03:20 PM Merited by JayJuanGee (1) |
|
I like what you're doing, but only a proposal: "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? ![Smiley](https://bitcointalk.org/Smileys/default/smiley.gif) 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.htmlTime to add Taproot addresses: 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: "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
|
|
|
|
LoyceV (OP)
Legendary
Offline
Activity: 3430
Merit: 17357
Thick-Skinned Gang Leader and Golden Feather 2021
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
January 05, 2022, 09:46:25 PM |
|
Maybe with percentage? ![Smiley](https://bitcointalk.org/Smileys/default/smiley.gif) I created the json-file for bitmover, and I prefer his solution:
|
|
|
|
mynonce
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
January 05, 2022, 10:32:03 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.
Maybe with percentage? ![Smiley](https://bitcointalk.org/Smileys/default/smiley.gif) I created the json-file for bitmover, and I prefer his solution: Thanks. I didn't know this site https://bitcoindata.science/bitcoin-funded-addresses.html
|
|
|
|
bitmover
Legendary
Offline
Activity: 2422
Merit: 6209
Crypto Swap Exchange🈺
|
Maybe with percentage? ![Smiley](https://bitcointalk.org/Smileys/default/smiley.gif) I created the json-file for bitmover, and I prefer his solution: just added the taproot addresses to the front end: ![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fi.imgur.com%2FAi1YXyF.png&t=665&c=cTSfjmHlGVR8iA) 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
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
January 06, 2022, 09:36:46 PM |
|
@LoyceV, @bitmover Have you ever looked for mined but unmoved Bitcoin? Would be interesting to know how many there are.
|
|
|
|
|
mynonce
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
January 07, 2022, 02:10:14 AM |
|
We have block 0 in that list ![Huh](https://bitcointalk.org/Smileys/default/huh.gif) 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)
|
|
|
|
LoyceV (OP)
Legendary
Offline
Activity: 3430
Merit: 17357
Thick-Skinned Gang Leader and Golden Feather 2021
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
January 07, 2022, 07:42:32 AM |
|
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.
|
|
|
|
LoyceV (OP)
Legendary
Offline
Activity: 3430
Merit: 17357
Thick-Skinned Gang Leader and Golden Feather 2021
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
January 11, 2022, 03:38:52 PM |
|
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.
|
|
|
|
PawGo
Legendary
Offline
Activity: 952
Merit: 1373
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
January 11, 2022, 04:01:52 PM |
|
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 (OP)
Legendary
Offline
Activity: 3430
Merit: 17357
Thick-Skinned Gang Leader and Golden Feather 2021
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
January 11, 2022, 04:08:15 PM |
|
situation in Kazakhstan. What are the odds they host this in Kazakhstan ![](https://bitcointalk.org/Smileys/default/afro.gif)
|
|
|
|
|
LoyceV (OP)
Legendary
Offline
Activity: 3430
Merit: 17357
Thick-Skinned Gang Leader and Golden Feather 2021
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
January 25, 2022, 09:49:33 AM |
|
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...](https://ip.bitcointalk.org/?u=https%3A%2F%2Floyce.club%2Fother%2Fbandwidth.gif&t=665&c=GVrP5i9WzCuHMQ)
|
|
|
|
LoyceV (OP)
Legendary
Offline
Activity: 3430
Merit: 17357
Thick-Skinned Gang Leader and Golden Feather 2021
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
February 05, 2022, 09: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://bitcointalk.org/Smileys/default/tongue.gif)
|
|
|
|
PawGo
Legendary
Offline
Activity: 952
Merit: 1373
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
February 05, 2022, 09:26:58 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://bitcointalk.org/Smileys/default/tongue.gif) https://www.youtube.com/watch?v=JKDo6g4CCeUIf you want to keep "fixed filename", maybe add one more, small file with "update date" inside.
|
|
|
|
|