Bitcoin Forum

Bitcoin => Mining => Topic started by: davidkierz on January 08, 2023, 06:38:20 PM



Title: BTC Block / USD Price
Post by: davidkierz on January 08, 2023, 06:38:20 PM
Does anyone know where I can download or export a CSV that includes at a minimum the BTC block number and the current USD price? I have found some products on line that go daily, hourly, but nothing that matches up at the exact block time.. This is for taxes..


Title: Re: BTC Block / USD Price
Post by: BitMaxz on January 08, 2023, 11:41:06 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.


Title: Re: BTC Block / USD Price
Post by: LoyceV on January 09, 2023, 11:49:41 AM
There is block data available in the LoyceV thread
In Bitcoin block data available in CSV format (https://bitcointalk.org/index.php?topic=5246271.0), 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

that matches up at the exact block time.. This is for taxes..
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.


Title: Re: BTC Block / USD Price
Post by: davidkierz on January 13, 2023, 03:14:38 AM
Thanks all for the replies. I was able to put something together with the above.