How to find historical coin prices for specific times?

16 replies 373 views
darkhashFull Member
Posts: 57 · Reputation: 464
#1Nov 29, 2021, 05:46 AM
Can this actually be done? Like, if you wanna find out the exact price of a coin like Dash or Maker from way back, say on January 3, 2022, at 8 AM West Coast time? Or maybe 5 PM? How do you figure that out? Coinmarketcap lets you look back and click through the graph, but when you hover, you can only see daily prices. It's not like you can get the price at a specific time. Like, what was BTC or Dash at 8 AM that day? And by the way, what time zone does Coinmarketcap use? If you're scrolling through and it says 5 PM, what does that convert to for the West Coast? Is there a way to do this for altcoins? How does that work? I know you can look up historical data and see highs, lows, and close prices for coins from years ago, but what if I want the price at 8 AM or 5 PM West Coast time? Is it even possible to track that for older dates? I get that if it's recent, you can check, but what about the past?
5 Reply Quote Share
stack_2017Senior Member
Posts: 201 · Reputation: 1389
#2Nov 29, 2021, 09:28 AM
Check CryptoDataDownload. They have multiple other exchanges out there, but just to give you an idea: - Gemini: https://www.cryptodatadownload.com/data/gemini/ - Bitfinex: https://www.cryptodatadownload.com/data/bitfinex/ If the data you're looking for is very old, you might have a difficult time finding it, especially the hourly one.
2 Reply Quote Share
darkhashFull Member
Posts: 57 · Reputation: 464
#3Nov 29, 2021, 03:09 PM
The issue with gemini and bitfinex is it only shows the data of coins that their exchange supports only though right?  The website does seem to show coinbase and binance. So if binance supported a coin say all the way back in 2019, you could find the exact price of that coin on say January 3, 2019 at say 8am USA West Coast time?  So you could check what it was at 5pm USA West Coast time as well?  Yea I am talking about hourly.  Like you want to know what the price was at say 8am or 5pm.  I assume no site would show what it was like at say 8:27am right?  You just have to round it from 8am or 8:30am?
5 Reply Quote Share
stack_2017Senior Member
Posts: 201 · Reputation: 1389
#4Nov 29, 2021, 05:06 PM
Yes, you can only see the data found on those exchanges. This is different than CMC which takes the data from multiple exchanges. So I checked the Binance ones: - https://www.cryptodatadownload.com/data/binance/ And it looks like it has the data by the minute  (you need to create a free account in order to see it apparently) The CSV files have the Unix timestamp, so I would imagine you could use that to convert the time to whatever timezone you want using Excel.
0 Reply Quote Share
darkhashFull Member
Posts: 57 · Reputation: 464
#5Nov 29, 2021, 05:33 PM
So I tried a coin such as waves and then downloaded the CSV.  It shows the high, low and close in excel chart format. So I have to create a free account on that site in order to view the chart hour by hour?  So I could check the price of the coin on any day and check the price at 8am or 5pm?
0 Reply Quote Share
darkhashFull Member
Posts: 57 · Reputation: 464
#6Nov 29, 2021, 05:48 PM
Can someone who has an account post a screenshot of how it looks?  Example you want to know the price of dash on January 3, 2022 at say 8am and 5pm USA West coast time. Also it only gives hour by hour right?  You can't know the exact price at say 8:27am USA West Coast time?
4 Reply Quote Share
alt_bearFull Member
Posts: 55 · Reputation: 444
#7Nov 29, 2021, 09:43 PM
CoinMarketCap is not an exchange, right? So, where does the price come from? You will get the most precise data from the source itself. Find the exchange with the highest volume for each particular coin and check the price there for any specific date and time. Many large exchanges also offer an API that allows you to automate the process with a little bit of scripting. Here's an example: How do I get all the prices history with binance API for a crypto using Python? Here is an excerpt from an example of the DASH-USDT trading pair on January 1, 2022. You can view the entire CSV on pastebin. https://pastebin.com/XksE5JN0 No. It gives you a price per minute. The timestamp is in UNIX format.
4 Reply Quote Share
coin_sigmaLegendary
Posts: 1275 · Reputation: 5553
#8Nov 30, 2021, 02:16 AM
It seems you are looking for an advanced tool Coinmarketcap also does that but it is not free you will need to buy API subscriptions. Check the API guide here Historical data documentation. Or learn how to use sheets to pull historical data to any crypto check this guide below. - Pull historical Crypto Data into Google sheets.
5 Reply Quote Share
darkhashFull Member
Posts: 57 · Reputation: 464
#9Nov 30, 2021, 04:41 AM
So i created a free account on cryptodatadownload.  I then went to binance and entered the coin.  It gives me option to download CSV but when I do that, you can only look at the high, low, closing etc of the coin on previous dates.  Where is the chart for this?  Where am I suppose to click on? I am trying to look for the price at say January 3, 2022 at say 8am USA West Coast time.
6 Reply Quote Share
bit2016Full Member
Posts: 65 · Reputation: 270
#10Nov 30, 2021, 07:26 AM
The time zone that CoinMarketCap uses is Coordinated Universal Time (UTC) if I'm not mistaken. To convert UTC to your local time, you can use a time zone converter.
0 Reply Quote Share
stack_2017Senior Member
Posts: 201 · Reputation: 1389
#11Dec 1, 2021, 10:57 AM
You can use the closing column if you want to know the price. There's no chart, I would imagine you can make one with the data on that CSV but you would need some technical knowledge for that. Same thing with the time, and as I mentioned above, you probably need to convert the Unix timestamp on the first column to USA West coast time, that way it's easier for you to browse or... You can just look what's the equivalent of that in GMT+1 (I think) and then look for it on the CSV file.
6 Reply Quote Share
maxi2017Senior Member
Posts: 262 · Reputation: 1550
#12Dec 1, 2021, 02:40 PM
Okay, I just looked at your trust feedback, and I gotta ask: What is wrong with you? Do you have some kind of mental disability or something? By the way, it is totally fine if you do; just thinking it might help us handle things differently.
0 Reply Quote Share
the_defiFull Member
Posts: 129 · Reputation: 383
#13Dec 1, 2021, 04:33 PM
Well, that is quite easy as you can visit the cart of that crypto coin on the exchange where it is listed, or simply for a general solution you can use the tracker, CMC, and coin gecko will work for you to analyze the market price on that time, but that will help you with the price only for the detailed you need to check that coin on the exchange where it was listed on that time. Quite curious why you need the price of a particular time, any sort of transaction record matching, or any other utility of that data, Anyway that is up to you. Well I had gone through what you wrote this is funny and weird, my suggestion never to ask your queries in that way from next time to get efficient feedbacks. Yes its UTC and converter can be taken into count.
4 Reply Quote Share
darkhashFull Member
Posts: 57 · Reputation: 464
#14Dec 1, 2021, 04:48 PM
Does anyone know the answer to this as the top sites?  I want to check historical prices that go back until the coin was created.  Coinmarketcap and coingecko seem to be the main ones but some coins aren't available? Like some coins, there is only a physical graph and not the regular high and low and open and close.  How do you find this?
4 Reply Quote Share
orbit100Hero Member
Posts: 423 · Reputation: 2314
#15Dec 2, 2021, 05:43 AM
I mean if those websites don't have the data, there is a low chance other websites will have it. It's not surprising that some data are out of date or not collected because they're not popular. Why not share the name of those coins here, maybe someone collects data on their own and doesn't publish it. I don't think you need to bump this topic if you're trying to ask a different question tbh.
4 Reply Quote Share
mark_bossFull Member
Posts: 44 · Reputation: 308
#16Dec 3, 2021, 01:16 PM
Checking the historical background of these coins, it can become evident and resourceful if we can pin down the namely involved data implemented in the space. We know the market have been really a big mess with whole coupling down of buy and sell trigger order, what really matters is OP getting his answers which he will get at desirable time. Suggestions have been made but OP have final decision, either ti look into it or allow it. You can go into deep research about seeking answers to your concerning questions and thoughts. As far I'm concerned, the market is been named and label to become one with volatility. Coinmarket cap and coin gecko is simply the main background for crypto projects, we scout the market if we find anything presentable.
4 Reply Quote Share
p1x3l365Senior Member
Posts: 511 · Reputation: 1890
#17Dec 3, 2021, 03:01 PM
You can create a free account and use this https://koinly.io/crypto-portfolio-tracker/. It is helpful for tax report too, but if you only want to track your portfolio from now (not from the past), you can do it anonymously with https://blockchair.com/markets Some more recommended Cryptocurrency Portfolio Trackers. https://coinledger.io/tools/best-crypto-portfolio-tracker
2 Reply Quote Share

Related topics