Get list of all addresses with a balance over x?

[jrian]

here it is latest dump

Code:

[root@btcnode tmp]# head btctousd81_29jan2018.csv
1111111111111111111114oLvT2,0000000000000000000000000000000000000000,6531128743
111111111111111111112BEH2ro,000000000000000000000000000000000000000a,10940
111111111111111111112xT3273,0000000000000000000000000000000000000011,5340
1111111111111111111141MmnWZ,000000000000000000000000000000000000001a,5340
111111111111111111114ysyUW1,0000000000000000000000000000000000000023,5340
11111111111111111111BZbvjr,0000000000000000000000000000000000000001,1028212

can you, please, sort it by balance row next time? Thanks!

[1714935552]

1714935552

[1714935552]

1714935552

[1714935552]

1714935552

[btctousd81]

here it is latest dump

Code:

[root@btcnode tmp]# head btctousd81_29jan2018.csv
1111111111111111111114oLvT2,0000000000000000000000000000000000000000,6531128743
111111111111111111112BEH2ro,000000000000000000000000000000000000000a,10940
111111111111111111112xT3273,0000000000000000000000000000000000000011,5340
1111111111111111111141MmnWZ,000000000000000000000000000000000000001a,5340
111111111111111111114ysyUW1,0000000000000000000000000000000000000023,5340
11111111111111111111BZbvjr,0000000000000000000000000000000000000001,1028212

can you, please, sort it by balance row next time? Thanks!

yes, i can do that.,

you can do that too, by loading it in mysql or any other db or
load it in excel. and do sort by amount.

[coder0x15]

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

[btctousd81]

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

please check this

https://bitcointalk.org/index.php?topic=267618.msg28087082#msg28087082

[coder0x15]

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

please check this

https://bitcointalk.org/index.php?topic=267618.msg28087082#msg28087082

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

[btctousd81]

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

please check this

https://bitcointalk.org/index.php?topic=267618.msg28087082#msg28087082

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]

@btctousd81 you can convert Base58 back to ripemd160?

[btctousd81]

@btctousd81 you can convert Base58 back to ripemd160?

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

Thanks

[coder0x15]

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]

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]

@btctousd81 can you provide UTXOs for to each address?

[btctousd81]

@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

[mugt]

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]

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 .

[lookingdream21]

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.

[starmyc]

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

[btctousd81]

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]

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.

[tilistor]

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!

[btctousd81]

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

yes.

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.