How to check for historical prices for coin years ago at exact time?

[jerry0]

Is this possible to do or not?  For example say you want to find the exact price of a coin such as dash or maker to make it simple and say on January 3, 2022.



But you want to know the price at say 8am West Coast USA time.  Or say at 5pm.  How would you do this?  Coinmarketcap allows you to go back and click on all in the graph but when you move your mouse slowly, you could sort of check daily but you can't even get the price at a certain time?  Say you want to know what the price of btc or dash was at 8am on that day.  Also what time zone does coinmarketcap use?  Example if you scroll through the graph and it show 5pm... what time is it in USA West Coast Time?



Is there a way to do this for altcoins?  And how?  I know coinmarketcap you can check the history and what the high, low and closing price is for each coin for many years ago but what if you want to know the price of that coin at say 8am West Coast USA time?  Or say 5pm West Coast USA time?  Is there a way to do that or not before it is too long ago?  Now if it is recent, obviously you can check this.

[1715183994]

1715183994

[1715183994]

1715183994

[OmegaStarScream]

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.

[jerry0]

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?

[OmegaStarScream]

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?

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.

[jerry0]

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?

[jerry0]

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?   

[FatFork]

Is there a way to do this for altcoins?  And how?  I know coinmarketcap you can check the history and what the high, low and closing price is for each coin for many years ago but what if you want to know the price of that coin at say 8am West Coast USA time?  Or say 5pm West Coast USA time?  Is there a way to do that or not before it is too long ago?  Now if it is recent, obviously you can check this.

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?

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.

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

Also it only gives hour by hour right?  You can't know the exact price at say 8:27am USA West Coast time?  

No. It gives you a price per minute. The timestamp is in UNIX format.

[BitMaxz]

Also it only gives hour by hour right?  You can't know the exact price at say 8:27am USA West Coast time?   

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.

[jerry0]

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.

[Text]

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.

[OmegaStarScream]

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.

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.

[Stalker22]

~
Where is the chart for this?  Where am I suppose to click on?

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.

[Hamza2424]

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.

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.

Yes its UTC and converter can be taken into count.