I wonder how to download bitcoin data to csv files. I would like to get all blocks, transactions in csv files. What is the fastest way to achieve this?
Been there, done that. Trust me unless your searching skill is way better mine then
LoyceV's blockdata will be your best source, alternatively, you can download the "Blockchair Database Dumps" from
blockchair, but if you don't have a script/bot to do that for you, then you will need to manually download 10 years worth of DAILY data, assuming we never had a whole day without finding a block then you are going to download about 3650 files, so I suggest you stick to the former option.
Keep in mind that LoyceV has that data in a .txt file, so for you to convert it to CSV you going to need a workaround, and the
easiest one would be using MS Excel.
It is really great work by LoyceV but it hasn't resolved my problem. I want to download all transactions with input and output addresses. I only tried bitcoin-etl (
) but I calculated that it takes more than one month to download it and save to small csv files (e.g. 50-150 blocks in one). Do you know something else ?