Hey, does anyone know where I can find a CSV that has at least the BTC block number along with the current USD price? I’ve seen some tools that do daily or hourly updates, but nothing that aligns with the exact block time. This is mainly for tax purposes.
BTC Block Number and USD Price CSV Download
3 replies 181 views
There is block data available in the LoyceV thread but I don't know if it includes the price check this link below
- https://bitcointalk.org/index.php?topic=5246271.0
I also tried to search, what you looking for is block counts and price history but it seems it does not yet exist. You will need two different data with time frames including block counts and Bitcoin price history and put it into the sheet to sort them.
I suggest maybe you can find some useful tools under this https://bitcointalk.org/index.php?topic=5287823 about what you need.
titan_degenMember
Posts: 790 · Reputation: 114
#3Oct 19, 2018, 03:08 PM
In Bitcoin block data available in CSV format, I have several columns with "usd". It's probably easiest to use generation_usd, and divide it by the block reward.
So import those 2 files into a spreadsheet:
https://loyce.club/blockdata/generation.txt
https://loyce.club/blockdata/reward_usd.txt
Note that there is no "one Bitcoin price". It's probably a good estimate, but different sources can have slightly different values. My data comes from Blockchair.com, which didn't exist in the first years of Bitcoin and I have no idea where they got the data from.
Thanks all for the replies. I was able to put something together with the above.
?Reply
Sign in to reply to this topic
Related topics
- Here we go again! ANTPOOL mined an empty block 19
- COMPARING BTC MINING AND DOLLAR COST AVERAGING 11
- Bitcoin Block Party || Group Run A 19
- Need Help Recovering BTC Mined Back in 2009 6
- using miner exhaust to power a small wind turbine 19
- Have you thought about getting compensation from your miner hosting service? 3