BTC Block / USD Price

[davidkierz]

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..

[1714745889]

1714745889

[1714745889]

1714745889

[1714745889]

1714745889

[1714745889]

1714745889

[1714745889]

1714745889

[BitMaxz]

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.

[LoyceV]

There is block data available in the LoyceV thread

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

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.

[davidkierz]

Thanks all for the replies. I was able to put something together with the above.