search

blockchain-etl / bitcoin-etl

ETL scripts for Bitcoin, Litecoin, Dash, Zcash, Doge, Bitcoin Cash. Available in Google BigQuery https://goo.gl/oY5BCQ
https://twitter.com/BlockchainETL
MIT License
410 stars 123 forks source link

how to get list of all adresses on bitcoin block chain #50

Open MohammadAsadolahi opened 3 years ago

MohammadAsadolahi commented 3 years ago

how can i get all addresses on bitcoin blockchain i mean every address that comited a transaction on blockchain no matter it has balance or not? for example get list of all addresses in text file no balance or transaction or anything else just adresses of all time thank you

medvedev1088 commented 3 years ago

You can query this information in BigQuery. See some example queries here https://github.com/blockchain-etl/awesome-bigquery-views#top-bitcoin-balances that you can adjust to your task

a5m0 commented 2 years ago

You can query this information in BigQuery. See some example queries here https://github.com/blockchain-etl/awesome-bigquery-views#top-bitcoin-balances that you can adjust to your task

Looking at the double entry book example here https://github.com/blockchain-etl/awesome-bigquery-views#top-bitcoin-balances the addresses array is flattened to a string and I've taken a closer looks at the inputs/outputs and it looks like the addresses have an array of addresses including never-used addresses. How can we query just addresses with balance?