In the list of founded addresses there is unnecessary line "address" (kind of column header) between addresses "3.." and "bc..", line 31808561. Like you had separated lists and you concatenated them.
Thanks! That "address" should have been removed (but due to copying code I tried to remove the header from another file). It will be fixed in tomorrow's update. 
Topic: List of all Bitcoin addresses with a balance - page 3. (Read 7844 times)
I'll take this quote from another topic here:
I found 18635073 wallets having this form x-ff8bb9190e0e969f5b8176dba0c0f161
where x can be s,d,m or another letter followed by - and a string of hex digits ...
they don't look like hash160 representation so what are they ?
It's Blockchair.com's way of showing OP_RETURN outputs. I'm not sure how "real" those are, and if you'd get the same result if you'd get the data from your own Bitcoin Core installation. For most purposes you can ignore them.where x can be s,d,m or another letter followed by - and a string of hex digits ...
they don't look like hash160 representation so what are they ?
To be precise:
18125075 d-
10092 s-
499906 m-
18635073 Total
I found 18635073 wallets having this form x-ff8bb9190e0e969f5b8176dba0c0f161
where x can be s,d,m or another letter followed by - and a string of hex digits ...
they don't look like hash160 representation so what are they ?
It's Blockchair.com's way of showing OP_RETURN outputs. I'm not sure how "real" those are, and if you'd get the same result if you'd get the data from your own Bitcoin Core installation. For most purposes you can ignore them. where x can be s,d,m or another letter followed by - and a string of hex digits ...
they don't look like hash160 representation so what are they ?
Maybe a dumb question:
I downloaded this file all_Bitcoin_addresses_ever_used_sorted.txt.gz from this site http://addresses.loyce.club and I found 18635073 wallets having this form x-ff8bb9190e0e969f5b8176dba0c0f161
where x can be s,d,m or another letter followed by - and a string of hex digits ...
they don't look like hash160 representation so what are they ?
Thank you:
I downloaded this file all_Bitcoin_addresses_ever_used_sorted.txt.gz from this site http://addresses.loyce.club and I found 18635073 wallets having this form x-ff8bb9190e0e969f5b8176dba0c0f161
where x can be s,d,m or another letter followed by - and a string of hex digits ...
they don't look like hash160 representation so what are they ?
Thank you:
They are P2PK addresses.
Thanks, that link explains why the pubkey for those addresses is known without sending a transaction:Can you prepare another list with all addresses with known pubkey and positive balance in the same format as you did before?
If you can get me an example showing what part of the block data you need, I can get it for you. See this post for a sample of the data.Please edit your post instead of making 2 posts in a row, see forum rules.
Can you prepare another list with all addresses with known pubkey and positive balance in the same format as you did before?
Regards,
Regards,
LoyceV,
Those addresses are V1 bitcoin addresses used in the inception up to around the end of ~ 2012. Presumably by Satoshi et al. They are P2PK addresses.
Regards,
You're looking for public keys that can be used to brute-force private keys, right? I'm still not sure what the pubkey in my list belongs to.
Those addresses are V1 bitcoin addresses used in the inception up to around the end of ~ 2012. Presumably by Satoshi et al. They are P2PK addresses.
Regards,
The list is good.
After thinking it over: I don't think it's correct. This address for example has never sent anything, so as far as I know, it's pubkey can't be known. And yet, it's in my list, while other addresses that have been used to send funds aren't in there.You're looking for public keys that can be used to brute-force private keys, right? I'm still not sure what the pubkey in my list belongs to.
LoyceV,
Those addresses are V1 bitcoin addresses used in the inception up to around the end of ~ 2012. Presumably by Satoshi et al. They are P2PK addresses.
Regards,
You're looking for public keys that can be used to brute-force private keys, right? I'm still not sure what the pubkey in my list belongs to.
Those addresses are V1 bitcoin addresses used in the inception up to around the end of ~ 2012. Presumably by Satoshi et al. They are P2PK addresses.
Regards,
The list is good.
After thinking it over: I don't think it's correct. This address for example has never sent anything, so as far as I know, it's pubkey can't be known. And yet, it's in my list, while other addresses that have been used to send funds aren't in there.You're looking for public keys that can be used to brute-force private keys, right? I'm still not sure what the pubkey in my list belongs to.
do you have addresses like that:
It's in there:Code:
5000000000 1H5G1HXeMMQGowH98rF6FpGWDnxvdVeTUr 4104b1aac4d864cad13f9d168e2fed8a8f1db59d33f5e4041f32882aa75d5b083e80bba9e05ba25a61f68053fe7e0889e822c56519c9f0653c4f9534ca91f4f56ad6ac
The list is good.
After thinking it over: I don't think it's correct. This address for example has never sent anything, so as far as I know, it's pubkey can't be known. And yet, it's in my list, while other addresses that have been used to send funds aren't in there.You're looking for public keys that can be used to brute-force private keys, right? I'm still not sure what the pubkey in my list belongs to.
I did not check your list, but do you have addresses like that:
https://blockchair.com/bitcoin/address/1H5G1HXeMMQGowH98rF6FpGWDnxvdVeTUr
Code:
04b1aac4d864cad13f9d168e2fed8a8f1db59d33f5e4041f32882aa75d5b083e80bba9e05ba25a61f68053fe7e0889e822c56519c9f0653c4f9534ca91f4f56ad6
The list is good.
After thinking it over: I don't think it's correct. This address for example has never sent anything, so as far as I know, it's pubkey can't be known. And yet, it's in my list, while other addresses that have been used to send funds aren't in there.You're looking for public keys that can be used to brute-force private keys, right? I'm still not sure what the pubkey in my list belongs to.
Can you say how you've compiled it, scripts or Linux commands, etc?
did you pull it from the blockchain, utxo?
I don't want to keep going off-topic, so I'll make a new topic for it.did you pull it from the blockchain, utxo?
See Get pubkeys out of Bitcoin block data.
LoyceV,
Thanks for the list. The list is good.
Can you say how you've compiled it, scripts or Linux commands, etc?
did you pull it from the blockchain, utxo?
I would like to learn how to manipulate the data as you did.
Regards,
Thanks for the list. The list is good.
Can you say how you've compiled it, scripts or Linux commands, etc?
did you pull it from the blockchain, utxo?
I would like to learn how to manipulate the data as you did.
Regards,
It took me longer than I expected (because it was more work). Next time it's easy 
If I search all data, I get 3,669,383 lines. I don't think any address type ever stopped being used, it's still backwards compatible.
If I check how many of those addresses currently have a balance, I get 39,208 from the shortest list. The full list has 39,979 addresses. I'll continue with this one.
I'm not sure why the hash length varies this much:
Final result: balance_addy_pubkey.txt (6.5 MB). It's sorted by balance, highest first.
Sample:
Based on my what I've seen on the block chain, p2pk addresses were used up to block 278,298.
Searching through the first 278,298 blocks (about 1821 daily "outputs" data dumps), I get 901,980 lines that contain the word pubkey. Without duplicate addresses, it's 203,283.If I search all data, I get 3,669,383 lines. I don't think any address type ever stopped being used, it's still backwards compatible.
If I check how many of those addresses currently have a balance, I get 39,208 from the shortest list. The full list has 39,979 addresses. I'll continue with this one.
I'm not sure why the hash length varies this much:
Code:
367569 c59bd606c40e325841f17d1365d917f953507040ccb540b351967a402999a02e 2015-07-30 00:50:12 2450 0.0072 1aajpztNecNzGBDjJhGfkrsUJFgeyhBgY pubkey 2103d68f90ba81455256cb7a0df14fb3930d6df61393207f2f3e71659414d296e0f0ac 0 1
367631 72f822c0a805d88706a5d696a1715d9e08006dcc2433a278a4a91f41db587b75 2015-07-30 12:50:57 70000 0.2048 1aajpztNecNzGBDjJhGfkrsUJFgeyhBgY pubkey 2103d68f90ba81455256cb7a0df14fb3930d6df61393207f2f3e71659414d296e0f0ac 0 1
367679 3fecf7434af30ca54fdadf03dd7e12c52fcdc753f82afe1f545ebf5fc04388fb 2015-07-30 20:53:11 2435048 7.1252 1Kz5QaUPDtKrj5SqW5tFkn7WZh8LmQaQi4 pubkey 4104ffd03de44a6e11b9917f3a29f9443283d9871c9d743ef30d5eddcd37094b64d1b3d8090496b53256786bf5c82932ec23c3b74d9f05a6f95a8b5529352656664bac 1 1
367699 2bb1cf36f7004de8b93978e1b57a924e9e410ba5f1ac1fcf42abe64d9b51decb 2015-07-31 00:54:39 2340276 6.7798 1Kz5QaUPDtKrj5SqW5tFkn7WZh8LmQaQi4 pubkey 4104ffd03de44a6e11b9917f3a29f9443283d9871c9d743ef30d5eddcd37094b64d1b3d8090496b53256786bf5c82932ec23c3b74d9f05a6f95a8b5529352656664bac 1 1
Maybe it's the difference between compressed and uncompressed addresses?367631 72f822c0a805d88706a5d696a1715d9e08006dcc2433a278a4a91f41db587b75 2015-07-30 12:50:57 70000 0.2048 1aajpztNecNzGBDjJhGfkrsUJFgeyhBgY pubkey 2103d68f90ba81455256cb7a0df14fb3930d6df61393207f2f3e71659414d296e0f0ac 0 1
367679 3fecf7434af30ca54fdadf03dd7e12c52fcdc753f82afe1f545ebf5fc04388fb 2015-07-30 20:53:11 2435048 7.1252 1Kz5QaUPDtKrj5SqW5tFkn7WZh8LmQaQi4 pubkey 4104ffd03de44a6e11b9917f3a29f9443283d9871c9d743ef30d5eddcd37094b64d1b3d8090496b53256786bf5c82932ec23c3b74d9f05a6f95a8b5529352656664bac 1 1
367699 2bb1cf36f7004de8b93978e1b57a924e9e410ba5f1ac1fcf42abe64d9b51decb 2015-07-31 00:54:39 2340276 6.7798 1Kz5QaUPDtKrj5SqW5tFkn7WZh8LmQaQi4 pubkey 4104ffd03de44a6e11b9917f3a29f9443283d9871c9d743ef30d5eddcd37094b64d1b3d8090496b53256786bf5c82932ec23c3b74d9f05a6f95a8b5529352656664bac 1 1
Final result: balance_addy_pubkey.txt (6.5 MB). It's sorted by balance, highest first.
Sample:
Code:
323317181009 1PTYXwamXXgQoAhDbmUf98rY2Pg1pYXhin 4104633280c0a93b45217059013ddadab8d35b9a858336028fecdff64c6a5e068fadaf7d2b73bc22795fa160c2304703320516e1b0b20e43d613fa5975787c8287e4ac
87500062957 16mEzobs4wQPuAMq1C8QSQafcDHvzczVcs 410469119c7e7d8e8b9f404d70c36cc09cae033e86d259554fd945c9263560fdc9ddea108db86e5673b3894b0bf97807ff8ac6e322791cf8d4d22f7c55a0e812720aac
80000077848 1P2ZAuW9nUrFfwgVjfL2SA9sPXSruCfzp8 4104a9c9c642db7941be7d9d467786c05b66d13c4fdafeb81d66815fb336e7e19d42981f62f2624826898152444b99b590476c90ea7f2e15f50a00e726368d6ec7c1ac
75000064054 15UkFYLMs5nytwiKWqGgkkVo1fjLFAeJhs 41044da39d1810bb01f7039fa7cdfa3dca6de313bbf2d9db9f24170e87b0206f079adb64cccc5cdf6283a54826adaf265087b3f8eba02577153aeaa6cdea8165d6dfac
55000168944 15BKWJjL5YWXtaP449WAYqVYZQE1szicTn 41042e3d29ccb78680a0da35bac8dc7adf895feb2b8eb9dbc5058400d811f6d7ce46faf0099ef63a05f3a8340e7e95530515303d652f27c2d9b379174b41bfd7046bac
.........
.........
.........
1 13P4fnmSVrHa7g6SiYh6mYF8ucB273TqXR 210354e528107cddb35020d91d28549818cc6a0ac57627eec88d48e248ce381fed98ac
1 13DAZmeDhHreHYTqeY7ZdpZt8oW84BwXEQ 2102fd985d1b8352ac5ae0426d4037cfdc34b6d71043e765ef2879d0d6c00aa88285ac
1 12fBP1Dck3pLUqGG7czQqVKAGHNwUCBZxT 21038b9bdf9d80e0e5f40880fc26d425700cbd71de87b232b2cffb6fecf97fa70214ac
1 12f7dZYL1pTkB7smfU6jf6hNhzP3sTASso 21020454e3b33d1df7037ab7767665219bfe9a99ff4aea5672f3a1e9379ef9703a16ac
1 12d9tPargbPamzfhxEh4wdh5jauA5dtobM 210375106eb0bdf4ed504356e8debd010050c57f9c5a03cea95a8dc6d0d6f0cd48ccac
87500062957 16mEzobs4wQPuAMq1C8QSQafcDHvzczVcs 410469119c7e7d8e8b9f404d70c36cc09cae033e86d259554fd945c9263560fdc9ddea108db86e5673b3894b0bf97807ff8ac6e322791cf8d4d22f7c55a0e812720aac
80000077848 1P2ZAuW9nUrFfwgVjfL2SA9sPXSruCfzp8 4104a9c9c642db7941be7d9d467786c05b66d13c4fdafeb81d66815fb336e7e19d42981f62f2624826898152444b99b590476c90ea7f2e15f50a00e726368d6ec7c1ac
75000064054 15UkFYLMs5nytwiKWqGgkkVo1fjLFAeJhs 41044da39d1810bb01f7039fa7cdfa3dca6de313bbf2d9db9f24170e87b0206f079adb64cccc5cdf6283a54826adaf265087b3f8eba02577153aeaa6cdea8165d6dfac
55000168944 15BKWJjL5YWXtaP449WAYqVYZQE1szicTn 41042e3d29ccb78680a0da35bac8dc7adf895feb2b8eb9dbc5058400d811f6d7ce46faf0099ef63a05f3a8340e7e95530515303d652f27c2d9b379174b41bfd7046bac
.........
.........
.........
1 13P4fnmSVrHa7g6SiYh6mYF8ucB273TqXR 210354e528107cddb35020d91d28549818cc6a0ac57627eec88d48e248ce381fed98ac
1 13DAZmeDhHreHYTqeY7ZdpZt8oW84BwXEQ 2102fd985d1b8352ac5ae0426d4037cfdc34b6d71043e765ef2879d0d6c00aa88285ac
1 12fBP1Dck3pLUqGG7czQqVKAGHNwUCBZxT 21038b9bdf9d80e0e5f40880fc26d425700cbd71de87b232b2cffb6fecf97fa70214ac
1 12f7dZYL1pTkB7smfU6jf6hNhzP3sTASso 21020454e3b33d1df7037ab7767665219bfe9a99ff4aea5672f3a1e9379ef9703a16ac
1 12d9tPargbPamzfhxEh4wdh5jauA5dtobM 210375106eb0bdf4ed504356e8debd010050c57f9c5a03cea95a8dc6d0d6f0cd48ccac
It took me longer than I expected (because it was more work). Next time it's easy
If I search all data, I get 3,669,383 lines. I don't think any address type ever stopped being used, it's still backwards compatible.
If I check how many of those addresses currently have a balance, I get 39,208 from the shortest list. The full list has 39,979 addresses. I'll continue with this one.
I'm not sure why the hash length varies this much:
Final result: balance_addy_pubkey.txt (6.5 MB). It's sorted by balance, highest first.
Sample:
Based on my what I've seen on the block chain, p2pk addresses were used up to block 278,298.
Searching through the first 278,298 blocks (about 1821 daily "outputs" data dumps), I get 901,980 lines that contain the word pubkey. Without duplicate addresses, it's 203,283.If I search all data, I get 3,669,383 lines. I don't think any address type ever stopped being used, it's still backwards compatible.
If I check how many of those addresses currently have a balance, I get 39,208 from the shortest list. The full list has 39,979 addresses. I'll continue with this one.
I'm not sure why the hash length varies this much:
Code:
367569 c59bd606c40e325841f17d1365d917f953507040ccb540b351967a402999a02e 2015-07-30 00:50:12 2450 0.0072 1aajpztNecNzGBDjJhGfkrsUJFgeyhBgY pubkey 2103d68f90ba81455256cb7a0df14fb3930d6df61393207f2f3e71659414d296e0f0ac 0 1
367631 72f822c0a805d88706a5d696a1715d9e08006dcc2433a278a4a91f41db587b75 2015-07-30 12:50:57 70000 0.2048 1aajpztNecNzGBDjJhGfkrsUJFgeyhBgY pubkey 2103d68f90ba81455256cb7a0df14fb3930d6df61393207f2f3e71659414d296e0f0ac 0 1
367679 3fecf7434af30ca54fdadf03dd7e12c52fcdc753f82afe1f545ebf5fc04388fb 2015-07-30 20:53:11 2435048 7.1252 1Kz5QaUPDtKrj5SqW5tFkn7WZh8LmQaQi4 pubkey 4104ffd03de44a6e11b9917f3a29f9443283d9871c9d743ef30d5eddcd37094b64d1b3d8090496b53256786bf5c82932ec23c3b74d9f05a6f95a8b5529352656664bac 1 1
367699 2bb1cf36f7004de8b93978e1b57a924e9e410ba5f1ac1fcf42abe64d9b51decb 2015-07-31 00:54:39 2340276 6.7798 1Kz5QaUPDtKrj5SqW5tFkn7WZh8LmQaQi4 pubkey 4104ffd03de44a6e11b9917f3a29f9443283d9871c9d743ef30d5eddcd37094b64d1b3d8090496b53256786bf5c82932ec23c3b74d9f05a6f95a8b5529352656664bac 1 1
Maybe it's the difference between compressed and uncompressed addresses?367631 72f822c0a805d88706a5d696a1715d9e08006dcc2433a278a4a91f41db587b75 2015-07-30 12:50:57 70000 0.2048 1aajpztNecNzGBDjJhGfkrsUJFgeyhBgY pubkey 2103d68f90ba81455256cb7a0df14fb3930d6df61393207f2f3e71659414d296e0f0ac 0 1
367679 3fecf7434af30ca54fdadf03dd7e12c52fcdc753f82afe1f545ebf5fc04388fb 2015-07-30 20:53:11 2435048 7.1252 1Kz5QaUPDtKrj5SqW5tFkn7WZh8LmQaQi4 pubkey 4104ffd03de44a6e11b9917f3a29f9443283d9871c9d743ef30d5eddcd37094b64d1b3d8090496b53256786bf5c82932ec23c3b74d9f05a6f95a8b5529352656664bac 1 1
367699 2bb1cf36f7004de8b93978e1b57a924e9e410ba5f1ac1fcf42abe64d9b51decb 2015-07-31 00:54:39 2340276 6.7798 1Kz5QaUPDtKrj5SqW5tFkn7WZh8LmQaQi4 pubkey 4104ffd03de44a6e11b9917f3a29f9443283d9871c9d743ef30d5eddcd37094b64d1b3d8090496b53256786bf5c82932ec23c3b74d9f05a6f95a8b5529352656664bac 1 1
Final result: balance_addy_pubkey.txt (6.5 MB). It's sorted by balance, highest first.
Sample:
Code:
323317181009 1PTYXwamXXgQoAhDbmUf98rY2Pg1pYXhin 4104633280c0a93b45217059013ddadab8d35b9a858336028fecdff64c6a5e068fadaf7d2b73bc22795fa160c2304703320516e1b0b20e43d613fa5975787c8287e4ac
87500062957 16mEzobs4wQPuAMq1C8QSQafcDHvzczVcs 410469119c7e7d8e8b9f404d70c36cc09cae033e86d259554fd945c9263560fdc9ddea108db86e5673b3894b0bf97807ff8ac6e322791cf8d4d22f7c55a0e812720aac
80000077848 1P2ZAuW9nUrFfwgVjfL2SA9sPXSruCfzp8 4104a9c9c642db7941be7d9d467786c05b66d13c4fdafeb81d66815fb336e7e19d42981f62f2624826898152444b99b590476c90ea7f2e15f50a00e726368d6ec7c1ac
75000064054 15UkFYLMs5nytwiKWqGgkkVo1fjLFAeJhs 41044da39d1810bb01f7039fa7cdfa3dca6de313bbf2d9db9f24170e87b0206f079adb64cccc5cdf6283a54826adaf265087b3f8eba02577153aeaa6cdea8165d6dfac
55000168944 15BKWJjL5YWXtaP449WAYqVYZQE1szicTn 41042e3d29ccb78680a0da35bac8dc7adf895feb2b8eb9dbc5058400d811f6d7ce46faf0099ef63a05f3a8340e7e95530515303d652f27c2d9b379174b41bfd7046bac
.........
.........
.........
1 13P4fnmSVrHa7g6SiYh6mYF8ucB273TqXR 210354e528107cddb35020d91d28549818cc6a0ac57627eec88d48e248ce381fed98ac
1 13DAZmeDhHreHYTqeY7ZdpZt8oW84BwXEQ 2102fd985d1b8352ac5ae0426d4037cfdc34b6d71043e765ef2879d0d6c00aa88285ac
1 12fBP1Dck3pLUqGG7czQqVKAGHNwUCBZxT 21038b9bdf9d80e0e5f40880fc26d425700cbd71de87b232b2cffb6fecf97fa70214ac
1 12f7dZYL1pTkB7smfU6jf6hNhzP3sTASso 21020454e3b33d1df7037ab7767665219bfe9a99ff4aea5672f3a1e9379ef9703a16ac
1 12d9tPargbPamzfhxEh4wdh5jauA5dtobM 210375106eb0bdf4ed504356e8debd010050c57f9c5a03cea95a8dc6d0d6f0cd48ccac
87500062957 16mEzobs4wQPuAMq1C8QSQafcDHvzczVcs 410469119c7e7d8e8b9f404d70c36cc09cae033e86d259554fd945c9263560fdc9ddea108db86e5673b3894b0bf97807ff8ac6e322791cf8d4d22f7c55a0e812720aac
80000077848 1P2ZAuW9nUrFfwgVjfL2SA9sPXSruCfzp8 4104a9c9c642db7941be7d9d467786c05b66d13c4fdafeb81d66815fb336e7e19d42981f62f2624826898152444b99b590476c90ea7f2e15f50a00e726368d6ec7c1ac
75000064054 15UkFYLMs5nytwiKWqGgkkVo1fjLFAeJhs 41044da39d1810bb01f7039fa7cdfa3dca6de313bbf2d9db9f24170e87b0206f079adb64cccc5cdf6283a54826adaf265087b3f8eba02577153aeaa6cdea8165d6dfac
55000168944 15BKWJjL5YWXtaP449WAYqVYZQE1szicTn 41042e3d29ccb78680a0da35bac8dc7adf895feb2b8eb9dbc5058400d811f6d7ce46faf0099ef63a05f3a8340e7e95530515303d652f27c2d9b379174b41bfd7046bac
.........
.........
.........
1 13P4fnmSVrHa7g6SiYh6mYF8ucB273TqXR 210354e528107cddb35020d91d28549818cc6a0ac57627eec88d48e248ce381fed98ac
1 13DAZmeDhHreHYTqeY7ZdpZt8oW84BwXEQ 2102fd985d1b8352ac5ae0426d4037cfdc34b6d71043e765ef2879d0d6c00aa88285ac
1 12fBP1Dck3pLUqGG7czQqVKAGHNwUCBZxT 21038b9bdf9d80e0e5f40880fc26d425700cbd71de87b232b2cffb6fecf97fa70214ac
1 12f7dZYL1pTkB7smfU6jf6hNhzP3sTASso 21020454e3b33d1df7037ab7767665219bfe9a99ff4aea5672f3a1e9379ef9703a16ac
1 12d9tPargbPamzfhxEh4wdh5jauA5dtobM 210375106eb0bdf4ed504356e8debd010050c57f9c5a03cea95a8dc6d0d6f0cd48ccac
I'm looking for all of the entries with script-type pubkey (P2PK) only and is unspent. Primarly between blocks 0 to 278,298. It is about ~34,300 entries. The fields I would like are: block_id transaction_hash time value value_usd recipient type script_hex is_from_coinbase is_spendable.
If I get this from "outputs", you get it for all outputs when they were created. So they're all "spendable" (unless they were used again in the same block), even though most of them were spent later on already.If you need a list similar to what TheArchaeologist showed, you don't need most of the data you're asking for. Now the output looks like this:
Code:
160345 3abd1b599fe1e69147c6d375d0c85f47999ba99b5ddfbc090370bcb1d1775760 2012-01-03 00:38:50 1375309318 71.6536 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160345 ff0b0816051a55f0e50820f3551df083491114bff0048e214dca75adf52f7506 2012-01-03 00:38:50 2943300000 153.3459 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160345 61622dff47f8f242ffeeae9f3b382fa975d309be45248af9f044e5350323b014 2012-01-03 00:38:50 1174309318 61.1815 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160345 a91453015e530f092013d24b063d821d46a739b6cddb913bd7f7fd30710b1971 2012-01-03 00:38:50 2780300000 144.8536 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160345 bcec7c219b25a598750a85c136446d2992ba336f8e2c2c0a2e1c2248adeacef5 2012-01-03 00:38:50 1072309318 55.8673 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 c3d575d5773035585fcd65d9f8f3291e2dc0aa2f52e28f3a6c6c2ad11ffb4e29 2012-01-03 00:39:37 5001000000 260.5521 1CkjArEYChyvBhjrfw69SZXeMbCLooRvyD pubkey 410408e007dd2c04b76beeb5a17c43ed81a8393174575bd80ba38b82097611f2ea0ff6bea432e69c22d5c67694462dc9d424477f130d55b35c595e8ec36ef774637cac 1 1
160346 7ea972403219e1b29db5b2dc7370ef3ef01317adca2520520f9934e0a35816ae 2012-01-03 00:39:37 2294300000 119.533 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 6f7a8a7733a44710b239f914b902d47013abf768c09a92c3c82448567dae0e57 2012-01-03 00:39:37 968309318 50.4489 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 5e434a0b0b670073b7c3b9983b73f6b71fccf4d88b200205451ada84da776ec0 2012-01-03 00:39:37 2187300000 113.9583 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 80bdaf438a966115587de07654e271b89bd6c2be4f158d114ff23f9f09295c96 2012-01-03 00:39:37 845309318 44.0406 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 c2827d8e852bb0e0b0938fba7a214ea6387030773e42f524c805ebc622f9225a 2012-01-03 00:39:37 2159300000 112.4995 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 caedb38e300073a08fa7cb04bf4da34018a8016506eb6c0fac15601ed375ccca 2012-01-03 00:39:37 745309318 38.8306 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 b53520a99ea46c541f8bcb2c3327d439a525ed897928a3771385550312fafdd1 2012-01-03 00:39:37 2142300000 111.6138 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 0d11d8a4cd909bb7aba2b0e39fa3ee3f26a4253a6ffe34ffb1b948206826aaba 2012-01-03 00:39:37 741309318 38.6222 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 a0107298cf53abfeb699402def5949763721186ddac81e88e4f55154043bea91 2012-01-03 00:39:37 2025300000 105.5181 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 7d5e8972f79b61ce3004a74fc5a1bda1e8d5531099ed5dfad3bb675c1982841c 2012-01-03 00:39:37 726309318 37.8407 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 f89d13dfcc18724e1d99a34e0149e7320277ff3e75ffacdd9008573d6c2ac8b2 2012-01-03 00:39:37 1834300000 95.567 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 54e0dd5717434d69c0e761dbf3791b8df39d13fb8e8578f22e6f161475069280 2012-01-03 00:39:37 712309318 37.1113 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 588329950a7cd00e492ea40c1f2b79c9b3648767dd5c0d8be6b1e51030ace4a5 2012-01-03 00:39:37 1707300000 88.9503 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 4c7636192f99c3e49cba193615e0a9f9e679725f0a545b2ef53206d321b7674c 2012-01-03 00:39:37 556309318 28.9837 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 5960134323fef0e8a6f945306eb3d6d8a1283265de1e61d1068c041c5f5d3d9f 2012-01-03 00:39:37 1686300000 87.8562 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 559b2e1ccbe450d3ca276955dd76677226c00ba82a514397159646a0722c6d6a 2012-01-03 00:39:37 505309318 26.3266 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 aacfd9b0f72603d533bdce3c217f4c291be181b733a7930aa16876dba768270f 2012-01-03 00:39:37 1670300000 87.0226 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 40092b4c718d1078a20edb7e9ead9456314cdedb4daea9d868cab53d7a66f396 2012-01-03 00:39:37 358309318 18.6679 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 5963ff2d7969842dd60a82b47b208037d09e6c47c6db2f4225167a4cade79b7d 2012-01-03 00:39:37 1585300000 82.5941 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
I'm still not sure if the long hash at the end of each line is really what you need, but if it is, I could get only the address and hex from each line, remove the duplicates, match the addresses with the current list of addresses with a balance, and only show those. Would that be more useful? Otherwise you'll end up with a couple hundred GB of data.160345 ff0b0816051a55f0e50820f3551df083491114bff0048e214dca75adf52f7506 2012-01-03 00:38:50 2943300000 153.3459 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160345 61622dff47f8f242ffeeae9f3b382fa975d309be45248af9f044e5350323b014 2012-01-03 00:38:50 1174309318 61.1815 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160345 a91453015e530f092013d24b063d821d46a739b6cddb913bd7f7fd30710b1971 2012-01-03 00:38:50 2780300000 144.8536 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160345 bcec7c219b25a598750a85c136446d2992ba336f8e2c2c0a2e1c2248adeacef5 2012-01-03 00:38:50 1072309318 55.8673 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 c3d575d5773035585fcd65d9f8f3291e2dc0aa2f52e28f3a6c6c2ad11ffb4e29 2012-01-03 00:39:37 5001000000 260.5521 1CkjArEYChyvBhjrfw69SZXeMbCLooRvyD pubkey 410408e007dd2c04b76beeb5a17c43ed81a8393174575bd80ba38b82097611f2ea0ff6bea432e69c22d5c67694462dc9d424477f130d55b35c595e8ec36ef774637cac 1 1
160346 7ea972403219e1b29db5b2dc7370ef3ef01317adca2520520f9934e0a35816ae 2012-01-03 00:39:37 2294300000 119.533 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 6f7a8a7733a44710b239f914b902d47013abf768c09a92c3c82448567dae0e57 2012-01-03 00:39:37 968309318 50.4489 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 5e434a0b0b670073b7c3b9983b73f6b71fccf4d88b200205451ada84da776ec0 2012-01-03 00:39:37 2187300000 113.9583 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 80bdaf438a966115587de07654e271b89bd6c2be4f158d114ff23f9f09295c96 2012-01-03 00:39:37 845309318 44.0406 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 c2827d8e852bb0e0b0938fba7a214ea6387030773e42f524c805ebc622f9225a 2012-01-03 00:39:37 2159300000 112.4995 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 caedb38e300073a08fa7cb04bf4da34018a8016506eb6c0fac15601ed375ccca 2012-01-03 00:39:37 745309318 38.8306 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 b53520a99ea46c541f8bcb2c3327d439a525ed897928a3771385550312fafdd1 2012-01-03 00:39:37 2142300000 111.6138 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 0d11d8a4cd909bb7aba2b0e39fa3ee3f26a4253a6ffe34ffb1b948206826aaba 2012-01-03 00:39:37 741309318 38.6222 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 a0107298cf53abfeb699402def5949763721186ddac81e88e4f55154043bea91 2012-01-03 00:39:37 2025300000 105.5181 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 7d5e8972f79b61ce3004a74fc5a1bda1e8d5531099ed5dfad3bb675c1982841c 2012-01-03 00:39:37 726309318 37.8407 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 f89d13dfcc18724e1d99a34e0149e7320277ff3e75ffacdd9008573d6c2ac8b2 2012-01-03 00:39:37 1834300000 95.567 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 54e0dd5717434d69c0e761dbf3791b8df39d13fb8e8578f22e6f161475069280 2012-01-03 00:39:37 712309318 37.1113 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 588329950a7cd00e492ea40c1f2b79c9b3648767dd5c0d8be6b1e51030ace4a5 2012-01-03 00:39:37 1707300000 88.9503 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 4c7636192f99c3e49cba193615e0a9f9e679725f0a545b2ef53206d321b7674c 2012-01-03 00:39:37 556309318 28.9837 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 5960134323fef0e8a6f945306eb3d6d8a1283265de1e61d1068c041c5f5d3d9f 2012-01-03 00:39:37 1686300000 87.8562 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 559b2e1ccbe450d3ca276955dd76677226c00ba82a514397159646a0722c6d6a 2012-01-03 00:39:37 505309318 26.3266 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 aacfd9b0f72603d533bdce3c217f4c291be181b733a7930aa16876dba768270f 2012-01-03 00:39:37 1670300000 87.0226 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 40092b4c718d1078a20edb7e9ead9456314cdedb4daea9d868cab53d7a66f396 2012-01-03 00:39:37 358309318 18.6679 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
160346 5963ff2d7969842dd60a82b47b208037d09e6c47c6db2f4225167a4cade79b7d 2012-01-03 00:39:37 1585300000 82.5941 1VayNert3x1KzbpzMGt2qdqrAThiRovi8 pubkey 4104a39b9e4fbd213ef24bb9be69de4a118dd0644082e47c01fd9159d38637b83fbcdc115a5d6e970586a012d1cfe3e3a8b1a3d04e763bdc5a071c0e827c0bd834a5ac 0 1
Why end at block 278,298 if I you don't mind me asking?
Hi LoyceV,
I'm looking for all of the entries with script-type pubkey (P2PK) only and is unspent. Primarly between blocks 0 to 278,298. It is about ~34,300 entries. The fields I would like are: block_id transaction_hash time value value_usd recipient type script_hex is_from_coinbase is_spendable.
This is what I ultimately need.
But even if you get everything: the address I checked hasn't sent funds yet, so if you're looking for the pubkey, it's not what you need, right?
If I take a random output, it has this data:
I'm looking for all of the entries with script-type pubkey (P2PK) only and is unspent. Primarly between blocks 0 to 278,298. It is about ~34,300 entries. The fields I would like are: block_id transaction_hash time value value_usd recipient type script_hex is_from_coinbase is_spendable.
This is what I ultimately need.
The only method I've found that gives me something close to the aforementioned is on Blockchair.com. Can you export that dataset to a tsv/csv file? The option "Get this dataset in .tsv format" on the site takes you to the Database Dumps.
I don't think I can easily get this data, other than clicking "Load more" 3000 times.But even if you get everything: the address I checked hasn't sent funds yet, so if you're looking for the pubkey, it's not what you need, right?
Quote
I have no idea how to extract the data in that format from the outputs dump files. If you know some linux commands to parse them and give a similar output, that would be appreciated.
If you tell me exactly which part of the data dump you need, I can quite easily get it for you. It just takes a few hours to process all the data. Or I'll get you a short script that loops through the data, but to use it you'll need to download everything first.If I take a random output, it has this data:
Code:
block_id transaction_hash index time value value_usd recipient type script_hex is_from_coinbase is_spendable
158078 968937595d4777356aa3dbd61148c4ddcf0aef44e6295a479731f34998ee392c 0 2011-12-19 00:08:29 5008750000 160.28 1J6iKnrn9RPM6D23VZ6o1z5muVLUjJ9NuT pubkey 4104eacd3bfaf2d76524763c4416db596cc26e4ff20c13f12ac7d3cc5b5cec3ec88b53ff35b349fb47421976facdc25e63ea365416c3a4ace7acb7884caa6a6d7a52ac 1 1
158078 5c717d331dae3919337f11722e0e3f62b8c27230ee154f4c6c67b36a60bc4dd5 0 2011-12-19 00:08:29 1000000 0.032 1KSiuy6DeeDefyj2Ls8mnMvhRPb25xs6jx pubkeyhash 76a914ca4fa68a872fb740f16ca1caaa414bd989362aa788ac 0 -1
158078 5c717d331dae3919337f11722e0e3f62b8c27230ee154f4c6c67b36a60bc4dd5 1 2011-12-19 00:08:29 119721000000 3831.072 1LaN6ooQJpCqC5nFb5TCinceDkCc24eetR pubkeyhash 76a914d6b9bae958a79b931072b93a52e632f2464ae37e88ac 0 -1
158078 1c4e4dfa580566cb92ec3eb43e3650e542ba1ce7a35415b671f59794da702de4 0 2011-12-19 00:08:29 78812408397 2521.9971 1HT5UX8eSiT65fUZSskZYJ4nPPPL58Rzic pubkeyhash 76a914b4709009d5e5844f643b02ecafa7d55d7acb3f7d88ac 0 -1
158078 1c4e4dfa580566cb92ec3eb43e3650e542ba1ce7a35415b671f59794da702de4 1 2011-12-19 00:08:29 100000000 3.2 17gN64BPHtxi4mEM3qWrxdwhieUvRq8R2r pubkeyhash 76a914494294730abf03c846988654f15d1864469c737a88ac 0 -1
158078 bc9822da9fb69f43f1fe33682cd8007ad247deb75f5a6edb641751e456e18b93 0 2011-12-19 00:08:29 3578400000 114.5088 1KDE7sAtyhzJnLXcmJmAMYN9Xk3MRLsDxT pubkeyhash 76a914c7c234d085dd3d5dbc342d59cca174335f554fa988ac 0 -1
Would you be looking for "4104eacd3bfaf2d76524763c4416db596cc26e4ff20c13f12ac7d3cc5b5cec3ec88b53ff35b349f b47421976facdc25e63ea365416c3a4ace7acb7884caa6a6d7a52ac"?158078 968937595d4777356aa3dbd61148c4ddcf0aef44e6295a479731f34998ee392c 0 2011-12-19 00:08:29 5008750000 160.28 1J6iKnrn9RPM6D23VZ6o1z5muVLUjJ9NuT pubkey 4104eacd3bfaf2d76524763c4416db596cc26e4ff20c13f12ac7d3cc5b5cec3ec88b53ff35b349fb47421976facdc25e63ea365416c3a4ace7acb7884caa6a6d7a52ac 1 1
158078 5c717d331dae3919337f11722e0e3f62b8c27230ee154f4c6c67b36a60bc4dd5 0 2011-12-19 00:08:29 1000000 0.032 1KSiuy6DeeDefyj2Ls8mnMvhRPb25xs6jx pubkeyhash 76a914ca4fa68a872fb740f16ca1caaa414bd989362aa788ac 0 -1
158078 5c717d331dae3919337f11722e0e3f62b8c27230ee154f4c6c67b36a60bc4dd5 1 2011-12-19 00:08:29 119721000000 3831.072 1LaN6ooQJpCqC5nFb5TCinceDkCc24eetR pubkeyhash 76a914d6b9bae958a79b931072b93a52e632f2464ae37e88ac 0 -1
158078 1c4e4dfa580566cb92ec3eb43e3650e542ba1ce7a35415b671f59794da702de4 0 2011-12-19 00:08:29 78812408397 2521.9971 1HT5UX8eSiT65fUZSskZYJ4nPPPL58Rzic pubkeyhash 76a914b4709009d5e5844f643b02ecafa7d55d7acb3f7d88ac 0 -1
158078 1c4e4dfa580566cb92ec3eb43e3650e542ba1ce7a35415b671f59794da702de4 1 2011-12-19 00:08:29 100000000 3.2 17gN64BPHtxi4mEM3qWrxdwhieUvRq8R2r pubkeyhash 76a914494294730abf03c846988654f15d1864469c737a88ac 0 -1
158078 bc9822da9fb69f43f1fe33682cd8007ad247deb75f5a6edb641751e456e18b93 0 2011-12-19 00:08:29 3578400000 114.5088 1KDE7sAtyhzJnLXcmJmAMYN9Xk3MRLsDxT pubkeyhash 76a914c7c234d085dd3d5dbc342d59cca174335f554fa988ac 0 -1
The only method I've found that gives me something close to the aforementioned is on Blockchair.com. Can you export that dataset to a tsv/csv file? The option "Get this dataset in .tsv format" on the site takes you to the Database Dumps.
I don't think I can easily get this data, other than clicking "Load more" 3000 times.But even if you get everything: the address I checked hasn't sent funds yet, so if you're looking for the pubkey, it's not what you need, right?
Quote
I have no idea how to extract the data in that format from the outputs dump files. If you know some linux commands to parse them and give a similar output, that would be appreciated.
If you tell me exactly which part of the data dump you need, I can quite easily get it for you. It just takes a few hours to process all the data. Or I'll get you a short script that loops through the data, but to use it you'll need to download everything first.If I take a random output, it has this data:
Code:
block_id transaction_hash index time value value_usd recipient type script_hex is_from_coinbase is_spendable
158078 968937595d4777356aa3dbd61148c4ddcf0aef44e6295a479731f34998ee392c 0 2011-12-19 00:08:29 5008750000 160.28 1J6iKnrn9RPM6D23VZ6o1z5muVLUjJ9NuT pubkey 4104eacd3bfaf2d76524763c4416db596cc26e4ff20c13f12ac7d3cc5b5cec3ec88b53ff35b349fb47421976facdc25e63ea365416c3a4ace7acb7884caa6a6d7a52ac 1 1
158078 5c717d331dae3919337f11722e0e3f62b8c27230ee154f4c6c67b36a60bc4dd5 0 2011-12-19 00:08:29 1000000 0.032 1KSiuy6DeeDefyj2Ls8mnMvhRPb25xs6jx pubkeyhash 76a914ca4fa68a872fb740f16ca1caaa414bd989362aa788ac 0 -1
158078 5c717d331dae3919337f11722e0e3f62b8c27230ee154f4c6c67b36a60bc4dd5 1 2011-12-19 00:08:29 119721000000 3831.072 1LaN6ooQJpCqC5nFb5TCinceDkCc24eetR pubkeyhash 76a914d6b9bae958a79b931072b93a52e632f2464ae37e88ac 0 -1
158078 1c4e4dfa580566cb92ec3eb43e3650e542ba1ce7a35415b671f59794da702de4 0 2011-12-19 00:08:29 78812408397 2521.9971 1HT5UX8eSiT65fUZSskZYJ4nPPPL58Rzic pubkeyhash 76a914b4709009d5e5844f643b02ecafa7d55d7acb3f7d88ac 0 -1
158078 1c4e4dfa580566cb92ec3eb43e3650e542ba1ce7a35415b671f59794da702de4 1 2011-12-19 00:08:29 100000000 3.2 17gN64BPHtxi4mEM3qWrxdwhieUvRq8R2r pubkeyhash 76a914494294730abf03c846988654f15d1864469c737a88ac 0 -1
158078 bc9822da9fb69f43f1fe33682cd8007ad247deb75f5a6edb641751e456e18b93 0 2011-12-19 00:08:29 3578400000 114.5088 1KDE7sAtyhzJnLXcmJmAMYN9Xk3MRLsDxT pubkeyhash 76a914c7c234d085dd3d5dbc342d59cca174335f554fa988ac 0 -1
Would you be looking for "4104eacd3bfaf2d76524763c4416db596cc26e4ff20c13f12ac7d3cc5b5cec3ec88b53ff35b349f b47421976facdc25e63ea365416c3a4ace7acb7884caa6a6d7a52ac"? 158078 968937595d4777356aa3dbd61148c4ddcf0aef44e6295a479731f34998ee392c 0 2011-12-19 00:08:29 5008750000 160.28 1J6iKnrn9RPM6D23VZ6o1z5muVLUjJ9NuT pubkey 4104eacd3bfaf2d76524763c4416db596cc26e4ff20c13f12ac7d3cc5b5cec3ec88b53ff35b349fb47421976facdc25e63ea365416c3a4ace7acb7884caa6a6d7a52ac 1 1
158078 5c717d331dae3919337f11722e0e3f62b8c27230ee154f4c6c67b36a60bc4dd5 0 2011-12-19 00:08:29 1000000 0.032 1KSiuy6DeeDefyj2Ls8mnMvhRPb25xs6jx pubkeyhash 76a914ca4fa68a872fb740f16ca1caaa414bd989362aa788ac 0 -1
158078 5c717d331dae3919337f11722e0e3f62b8c27230ee154f4c6c67b36a60bc4dd5 1 2011-12-19 00:08:29 119721000000 3831.072 1LaN6ooQJpCqC5nFb5TCinceDkCc24eetR pubkeyhash 76a914d6b9bae958a79b931072b93a52e632f2464ae37e88ac 0 -1
158078 1c4e4dfa580566cb92ec3eb43e3650e542ba1ce7a35415b671f59794da702de4 0 2011-12-19 00:08:29 78812408397 2521.9971 1HT5UX8eSiT65fUZSskZYJ4nPPPL58Rzic pubkeyhash 76a914b4709009d5e5844f643b02ecafa7d55d7acb3f7d88ac 0 -1
158078 1c4e4dfa580566cb92ec3eb43e3650e542ba1ce7a35415b671f59794da702de4 1 2011-12-19 00:08:29 100000000 3.2 17gN64BPHtxi4mEM3qWrxdwhieUvRq8R2r pubkeyhash 76a914494294730abf03c846988654f15d1864469c737a88ac 0 -1
158078 bc9822da9fb69f43f1fe33682cd8007ad247deb75f5a6edb641751e456e18b93 0 2011-12-19 00:08:29 3578400000 114.5088 1KDE7sAtyhzJnLXcmJmAMYN9Xk3MRLsDxT pubkeyhash 76a914c7c234d085dd3d5dbc342d59cca174335f554fa988ac 0 -1
@LoyceV,
The only method I've found that gives me something close to the aforementioned is on Blockchair.com. Can you export that dataset to a tsv/csv file? The option "Get this dataset in .tsv format" on the site takes you to the Database Dumps.
I have no idea how to extract the data in that format from the outputs dump files. If you know some linux commands to parse them and give a similar output, that would be appreciated.
Regards,
The only method I've found that gives me something close to the aforementioned is on Blockchair.com. Can you export that dataset to a tsv/csv file? The option "Get this dataset in .tsv format" on the site takes you to the Database Dumps.
I have no idea how to extract the data in that format from the outputs dump files. If you know some linux commands to parse them and give a similar output, that would be appreciated.
Regards,
Hi @LoyceV,
I've perused your dump and indeed that info cannot be generated from them. Nevertheless, your blockchain dumps are cool and useful. Thanks again for that!
I was hoping that @albert0bsd or @TheArchaeologist could help with a script that can parse the blockchain.
I'll check the rusty-blockparser. If I do get something I'll share the same here.
Regards,
I've perused your dump and indeed that info cannot be generated from them. Nevertheless, your blockchain dumps are cool and useful. Thanks again for that!
I was hoping that @albert0bsd or @TheArchaeologist could help with a script that can parse the blockchain.
I'll check the rusty-blockparser. If I do get something I'll share the same here.
Regards,
How could I generate a dump like this from the blockchain?
I don't know how to do this. I don't think this data has the information, so you'll really have to get it from your own blockchain. If rusty-blockparser (see 2 posts up) can do it, I might be able to add it to my daily updates. Let me know if you find a way, I'm not checking it myself.
Hi @LoyceV,
I've perused your dump and indeed that info cannot be generated from them. Nevertheless, your blockchain dumps are cool and useful. Thanks again for that!
I was hoping that @albert0bsd or @TheArchaeologist could help with a script that can parse the blockchain.
I'll check the rusty-blockparser. If I do get something I'll share the same here.
Regards,
I've perused your dump and indeed that info cannot be generated from them. Nevertheless, your blockchain dumps are cool and useful. Thanks again for that!
I was hoping that @albert0bsd or @TheArchaeologist could help with a script that can parse the blockchain.
I'll check the rusty-blockparser. If I do get something I'll share the same here.
Regards,
How could I generate a dump like this from the blockchain?
I don't know how to do this. I don't think this data has the information, so you'll really have to get it from your own blockchain. If rusty-blockparser (see 2 posts up) can do it, I might be able to add it to my daily updates. Let me know if you find a way, I'm not checking it myself.How could I generate a dump like this from the blockchain?
I don't know how to do this. I don't think this data has the information, so you'll really have to get it from your own blockchain. If rusty-blockparser (see 2 posts up) can do it, I might be able to add it to my daily updates. Let me know if you find a way, I'm not checking it myself. Jump to: