Bitcoin Forum

Bitcoin => Project Development => Topic started by: spore1998 on February 02, 2020, 02:51:00 PM



Title: How can I get full Historical Data prices ? ALTS + Bitcoin
Post by: spore1998 on February 02, 2020, 02:51:00 PM
Hi there!
I am a finance student trying to do school work and trying to apply some financial models to crypto assets.

Do you know where I can get full historical data from at least the top 100 crypto? It could be with an API or with a CSV file.

Thank you


Title: Re: How can I get full Historical Data prices ? ALTS + Bitcoin
Post by: 20kevin20 on February 02, 2020, 03:07:06 PM
I believe you can use CoinMarketCap's API (or website) to pull data from their servers. I've imported web data from CMC to Excel to make a personalized, automated Cryptocurrency Portfolio and it's quite easy to do so. The only thing I don't like is their free limits (the limits are small if you want to pull data from multiple pages, I individually pulled price data from coins and after 6-7 coins it stopped), but it is what it is.

If you want to pull data from a high number of pages through their API, there's a paid plan you can go for. However, unless you want to make auto-updating lists of data, I think the second link below will be more than enough.

Here's a link to the api: https://coinmarketcap.com/api/
And here is a page of the historical data from 28th of April 2013 until today. Might help you: https://coinmarketcap.com/historical/


Title: Re: How can I get full Historical Data prices ? ALTS + Bitcoin
Post by: spore1998 on February 02, 2020, 04:47:58 PM
hi there,
you cant get full historical data from their API.

what i wanted was the daily prices of each currency since ever.




Title: Re: How can I get full Historical Data prices ? ALTS + Bitcoin
Post by: o_e_l_e_o on February 02, 2020, 08:19:52 PM
what i wanted was the daily prices of each currency since ever.
You can still get this on coinmarketcap.

Just click on Bitcoin (or the coin you want the data for), click on the "Historical Data" tab, and then on the date selection boxes on the right hand side, use the drop down menu to select "All time". It will give you the Open, High, Low, and Close price, on each day, as well as the daily volume.

You could also use https://www.cryptodatadownload.com/data/ to download daily or even hourly data from various exchanges in .csv format.

There's also https://coinmetrics.io/data-downloads/ which will give you more data than you will probably ever need on a bunch of different coins. Be sure to check their "data dictionary" (link at top of the list) to figure out what you are actually looking at.


Title: Re: How can I get full Historical Data prices ? ALTS + Bitcoin
Post by: hatshepsut93 on February 02, 2020, 11:12:27 PM
Alternative to coinmarketcap - coingecko: https://www.coingecko.com/en/api

They provide free public api, so you don't need to register any accounts and get api keys. The link I included has the official API docs, it seems you will be most interested in these endpoints:
Code:
/coins/{id}/market_chart
/coins/{id}/market_chart/range
.

Coingecko supports thousands of coins and tokens, so you can include much more than top 100 coins into your research, if you want to.


Title: Re: How can I get full Historical Data prices ? ALTS + Bitcoin
Post by: bitmover on February 03, 2020, 07:57:25 AM
You can get historical data here
https://coinmarketcap.com/historical/


And chose any specific day you want by entering the url
https://coinmarketcap.com/historical/20131215/


Title: Re: How can I get full Historical Data prices ? ALTS + Bitcoin
Post by: spore1998 on February 04, 2020, 02:47:31 PM
what i wanted was the daily prices of each currency since ever.
You can still get this on coinmarketcap.

Just click on Bitcoin (or the coin you want the data for), click on the "Historical Data" tab, and then on the date selection boxes on the right hand side, use the drop down menu to select "All time". It will give you the Open, High, Low, and Close price, on each day, as well as the daily volume.

You could also use https://www.cryptodatadownload.com/data/ to download daily or even hourly data from various exchanges in .csv format.

There's also https://coinmetrics.io/data-downloads/ which will give you more data than you will probably ever need on a bunch of different coins. Be sure to check their "data dictionary" (link at top of the list) to figure out what you are actually looking at.

thanks ! got a lot of coins to work with. thank you so much.

I will publish my work in a few weeks


Title: Re: How can I get full Historical Data prices ? ALTS + Bitcoin
Post by: spore1998 on February 04, 2020, 03:00:33 PM
Alternative to coinmarketcap - coingecko: https://www.coingecko.com/en/api

They provide free public api, so you don't need to register any accounts and get api keys. The link I included has the official API docs, it seems you will be most interested in these endpoints:
Code:
/coins/{id}/market_chart
/coins/{id}/market_chart/range
.

Coingecko supports thousands of coins and tokens, so you can include much more than top 100 coins into your research, if you want to.

thanks a lot for the help. I asked for help in reddit, facebook, etc
but nothing like the bitcoin forum !

Thanks your taking your time helping me out