jrian
Jr. Member
Offline
Activity: 39
Merit: 6
|
|
January 30, 2018, 04:15:01 PM |
|
here it is latest dump [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!
|
|
|
|
btctousd81
|
|
January 30, 2018, 04:20:21 PM |
|
here it is latest dump [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
Jr. Member
Offline
Activity: 36
Merit: 3
|
|
January 31, 2018, 05:38:23 AM |
|
Hi @btctousd81! Please tell what tool you use for to create such database?
|
|
|
|
|
coder0x15
Jr. Member
Offline
Activity: 36
Merit: 3
|
|
January 31, 2018, 10:26:25 AM |
|
What bitcoin-tool you use to get 'address to hash160'? You working using bitcoind rpc, not directly with blockchain disk data?
|
|
|
|
btctousd81
|
|
January 31, 2018, 10:36:11 AM Last edit: January 31, 2018, 10:48:15 AM by btctousd81 |
|
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-toolref: https://github.com/matja/bitcoin-tool/issues/20but 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
Offline
Activity: 36
Merit: 3
|
|
January 31, 2018, 01:47:09 PM |
|
@btctousd81 you can convert Base58 back to ripemd160?
|
|
|
|
btctousd81
|
|
January 31, 2018, 01:49:21 PM |
|
@btctousd81 you can convert Base58 back to ripemd160?
yes, i can do Base58 to ripemd160 and other way around too., Thanks
|
|
|
|
coder0x15
Jr. Member
Offline
Activity: 36
Merit: 3
|
|
January 31, 2018, 02:00:00 PM |
|
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
|
|
January 31, 2018, 02:03:11 PM |
|
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
Offline
Activity: 36
Merit: 3
|
|
January 31, 2018, 04:24:55 PM Last edit: January 31, 2018, 04:49:55 PM by coder0x15 |
|
@btctousd81 can you provide UTXOs for to each address?
|
|
|
|
btctousd81
|
|
February 01, 2018, 01:51:38 AM Last edit: February 01, 2018, 02:12:16 AM by 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
Member
Offline
Activity: 183
Merit: 35
|
|
February 02, 2018, 02:15:51 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
|
|
February 02, 2018, 02:25:52 PM Last edit: February 02, 2018, 02:45:16 PM by 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
Newbie
Offline
Activity: 12
Merit: 0
|
|
February 02, 2018, 07:55:57 PM |
|
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
Full Member
Offline
Activity: 198
Merit: 130
Some random software engineer
|
|
February 10, 2018, 04:27:14 AM |
|
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
|
|
February 10, 2018, 05:02:21 AM |
|
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/chainstateThank 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
Offline
Activity: 198
Merit: 130
Some random software engineer
|
|
February 10, 2018, 05:09:06 AM |
|
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/chainstateThank 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
Newbie
Offline
Activity: 1
Merit: 0
|
|
February 11, 2018, 05:27:27 PM |
|
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
|
|
February 12, 2018, 09:33:46 AM |
|
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.
|
|
|
|
|