Get list of all addresses with a balance over x? - page 9.

starmyc

full member

Activity: 198

Merit: 130

Some random software engineer

Quote from: aplistir on February 12, 2018, 01:55:01 PM

Is there any way to get the extraNonce values of every mined block from 1 -> 150000 ?

I am interested in doing some blockchain archaelogy like this:
https://bitcointalksearch.org/topic/chain-archaeology-answers-from-the-early-blockchain-507458

I already have those for blocks 1-36288, but I would like to have them all the way until block 150000. (After that the extraNonce becomes meaningless.)

The extraNonce value for each block can be found from the block-reward transaction from coinbase.
https://bitcoin.stackexchange.com/questions/48540/how-is-the-extra-nonce-formatted

Would be great if someone either has those, or can help me getting them myself.

Can you check this file: https://transfer.sh/oZFQr/extranonces.final.gz ? Format is height;hash;extranonce value.

I've got values for ~180k first blocks. Didn't check if all coinbase input scripts had the same format, just exported 2nd value pushed in stack of coinbase input script using my export tools. If values doesn't match yours, please send me your values so I can fix my scripts, but so far, it seems to match values from the order thread.

Cheers.

btctousd81

sr. member

Activity: 434

Merit: 270

Quote from: aplistir on February 12, 2018, 01:55:01 PM

Is there any way to get the extraNonce values of every mined block from 1 -> 150000 ?

I am interested in doing some blockchain archaelogy like this:
https://bitcointalksearch.org/topic/chain-archaeology-answers-from-the-early-blockchain-507458

I already have those for blocks 1-36288, but I would like to have them all the way until block 150000. (After that the extraNonce becomes meaningless.)

The extraNonce value for each block can be found from the block-reward transaction from coinbase.
https://bitcoin.stackexchange.com/questions/48540/how-is-the-extra-nonce-formatted

Would be great if someone either has those, or can help me getting them myself.

what are you saying ?

satoshi secretly mined and has more than 50 btc which are from genesis block ?

aplistir

full member

Activity: 378

Merit: 197

Is there any way to get the extraNonce values of every mined block from 1 -> 150000 ?

I am interested in doing some blockchain archaelogy like this:
https://bitcointalksearch.org/topic/chain-archaeology-answers-from-the-early-blockchain-507458

I already have those for blocks 1-36288, but I would like to have them all the way until block 150000. (After that the extraNonce becomes meaningless.)

The extraNonce value for each block can be found from the block-reward transaction from coinbase.
https://bitcoin.stackexchange.com/questions/48540/how-is-the-extra-nonce-formatted

Would be great if someone either has those, or can help me getting them myself.

btctousd81

sr. member

Activity: 434

Merit: 270

Quote from: tilistor on February 11, 2018, 12:27:27 PM

You mentioned that the export file has address, hash160 and balance.

yes.

Quote from: tilistor on February 11, 2018, 12:27:27 PM

Can you please let me know if the address is WIF compressed or uncompressed? Or what type of address it is?

Thanks!

its base58 address , p2pk staring with 1 and some are starring with 3 p2sh addressess.

tilistor

newbie

Activity: 1

Merit: 0

You mentioned that the export file has address, hash160 and balance.
Can you please let me know if the address is WIF compressed or uncompressed? Or what type of address it is?

Thanks!

starmyc

full member

Activity: 198

Merit: 130

Some random software engineer

Quote from: btctousd81 on February 10, 2018, 12:02:21 AM

Quote from: starmyc on February 09, 2018, 11:27:14 PM

Hi everyone,

I've opensourced a small software to parse the chainstate & output all utxos with their addresses (including latest bech32) in CSV format. As for today, computation takes ~8 minutes & creates a 6 GB CSV file (there is 60M utxos).
Feel free to give it a try: https://github.com/mycroft/chainstate

Thank you, finally someone who is developer and want to help others.,

I Really appreciate it.

i will post results once i try it., Thanks.

In fact, I just tumbled upon this forum after I started working on this and felt it was appropriate to share this stuff...
Ijust got some interests about parsing blockchain recently (wrote my own parser as well, but not opensourced it yet) then chainstate.

btctousd81

sr. member

Activity: 434

Merit: 270

Quote from: starmyc on February 09, 2018, 11:27:14 PM

Hi everyone,

I've opensourced a small software to parse the chainstate & output all utxos with their addresses (including latest bech32) in CSV format. As for today, computation takes ~8 minutes & creates a 6 GB CSV file (there is 60M utxos).
Feel free to give it a try: https://github.com/mycroft/chainstate

Thank you, finally someone who is developer and want to help others.,

I Really appreciate it.

i will post results once i try it., Thanks.

starmyc

full member

Activity: 198

Merit: 130

Some random software engineer

Hi everyone,

I've opensourced a small software to parse the chainstate & output all utxos with their addresses (including latest bech32) in CSV format. As for today, computation takes ~8 minutes & creates a 6 GB CSV file (there is 60M utxos).
Feel free to give it a try: https://github.com/mycroft/chainstate

lookingdream21

newbie

Activity: 12

Merit: 0

I would recommend ABE, but with it, if you start importing from block 0, it might take a month or two to fully import the blockchain, unless of course you have an SSD and fast RAM.

btctousd81

sr. member

Activity: 434

Merit: 270

Quote from: mugt on February 02, 2018, 09:15:51 AM

Quote from: btctousd81 on January 31, 2018, 08:51:38 PM

previoulsy i could, but i no more keep track of UTXOs .

i only keep track of

address, hash160, unspent output count, amount.

so every vout is +1

and every vin is -1

same goes with amount.

every vout amount is old amount + new amount
every vin amount is old amount - new amount

@btctousd81 How do you read segwit addresses?

you mean bech32 (starting "bc1") ? then i dont think that bitcoin-core supports it yet for rpc. so cant read/parse those addresses using rpc.

but if you mean P2SH (starting with a "3") then those are p2sh addresses those can be returned by bitcoin-core json/rpc .

mugt

member

Activity: 183

Merit: 35

Quote from: btctousd81 on January 31, 2018, 08:51:38 PM

previoulsy i could, but i no more keep track of UTXOs .

i only keep track of

address, hash160, unspent output count, amount.

so every vout is +1

and every vin is -1

same goes with amount.

every vout amount is old amount + new amount
every vin amount is old amount - new amount

@btctousd81 How do you read segwit addresses?

btctousd81

sr. member

Activity: 434

Merit: 270

Quote from: coder0x15 on January 31, 2018, 11:24:55 AM

@btctousd81 can you provide UTXOs for to each address?

previoulsy i could, but i no more keep track of UTXOs .

i only keep track of

address, hash160, unspent output count, amount.

so every vout is +1

and every vin is -1

same goes with amount.

every vout amount is old amount + new amount
every vin amount is old amount - new amount

coder0x15

jr. member

Activity: 36

Merit: 3

@btctousd81 can you provide UTXOs for to each address?

btctousd81

sr. member

Activity: 434

Merit: 270

Quote from: coder0x15 on January 31, 2018, 09:00:00 AM

Quote from: btctousd81 on January 31, 2018, 08:49:21 AM

yes, i can do Base58 to ripemd160

You do not understand anything what you are talking about.
It is possible in the one way, when you know ripemd160 and make base58. Not versa)
Or you invented reverse method?

alright lets not complicate it.

i can convert

1A1zP1eP5QGefi2DMPTfTL5SLmv7DivfNa

to

62e907b15cbf27d5425399ebf6f0fb50ebb88f18

AND

i can convert

62e907b15cbf27d5425399ebf6f0fb50ebb88f18

to

1A1zP1eP5QGefi2DMPTfTL5SLmv7DivfNa

sorry for confusion, i am not very good with technical words ripemd and base58.

hope this helps.,

coder0x15

jr. member

Activity: 36

Merit: 3

Quote from: btctousd81 on January 31, 2018, 08:49:21 AM

yes, i can do Base58 to ripemd160

You do not understand anything what you are talking about.
It is possible in the one way, when you know ripemd160 and make base58. Not versa)
Or you invented reverse method?

btctousd81

sr. member

Activity: 434

Merit: 270

Quote from: coder0x15 on January 31, 2018, 08:47:09 AM

@btctousd81 you can convert Base58 back to ripemd160?

yes, i can do Base58 to ripemd160 and other way around too.,

Thanks

coder0x15

jr. member

Activity: 36

Merit: 3

@btctousd81 you can convert Base58 back to ripemd160?

btctousd81

sr. member

Activity: 434

Merit: 270

Quote from: coder0x15 on January 31, 2018, 05:26:25 AM

Quote from: btctousd81 on January 31, 2018, 05:05:38 AM

Quote from: coder0x15 on January 31, 2018, 12:38:23 AM

Hi @btctousd81! Please tell what tool you use for to create such database?

please check this

https://bitcointalksearch.org/topic/m.28087082

What bitcoin-tool you use to get 'address to hash160'?
You working using bitcoind rpc, not directly with blockchain disk data?

at initial level, when i needed to convert 20 million+ bitcoin address to hash160, i used bitcoin-tool

ref : https://github.com/matja/bitcoin-tool

ref: https://github.com/matja/bitcoin-tool/issues/20

but for newer blocks data i am using php code to calculate hash160 from address.

i am using bitcoind rpc and not reading blockchain disk data.,

cronjob runs my php script every 6 hours i guess, and parses all new blocks and insrts then in mysql.,

coder0x15

jr. member

Activity: 36

Merit: 3