BTC Block Number and USD Price CSV Download

3 replies 181 views
the_bearHero Member
Posts: 89 · Reputation: 2528
#1Oct 19, 2018, 08:38 AM
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.
5 Reply Quote Share
blockhubMember
Posts: 1033 · Reputation: 43
#2Oct 19, 2018, 02:18 PM
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.
1 Reply Quote Share
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.
3 Reply Quote Share
the_bearHero Member
Posts: 89 · Reputation: 2528
#4Oct 20, 2018, 01:37 PM
Thanks all for the replies. I was able to put something together with the above.
3 Reply Quote Share
?Reply
Sign in to reply to this topic

Related topics