Convert Unix UTC Field to Any Timezone

July 24, 2022, 12:14 a.m.by CryptoDataDownload

Timezone Conversion

CryptoDataDownload uses a column called "Unix" in all of its OHLCV CSV files. This field represents the server time of the exchange for the time interval specified. Most computers use "epoch" or UTC timezone as the internal computer clock. Therefore, the unix timestamp is universal UTC time. Because we have the original unix timestamp, you are able to convert it into a human readable date for the time zone local to you (or any you specify). This code example is shorter than most; and shows how you can use a built in pandas function to convert the epoch / unix timestamps.

# CryptoDataDownload
# No Express Warranty
import ssl
import pandas as pd
from datetime import datetime

# change the ssl state so we do not see an error for https:// content
ssl._create_default_https_context = ssl._create_unverified_context

def main():
    """In our main sample function, we will first load the data into a dataframe and store that into a local
    variable called df. Our next step is to create a new column and convert the unix timezone into a new time column

"""

df = load_data_sets()
    df['newdate'] = pd.to_datetime(df['unix'], unit='ms', origin='unix')

# newdate column is now a series of datetime64 objects ... you can now use any of the datetime functions to convert to local dates
    # https://pandas.pydata.org/docs/reference/api/pandas.to_datetime.html
    # https://docs.python.org/3/library/datetime.html#module-datetime

print("All done! Thank you!")

def load_data_sets():
    """This function will load the BTC timeseries for the Gemini exchange and put into Pandas
    dataframe, then return the dataframe

"""
    # read the two data sets into dataframes and then return the dataframe
    btc_df = pd.read_csv("https://www.cryptodatadownload.com/cdd/Gemini_BTCUSD_d.csv", skiprows=1)

return btc_df

if __name__ == "__main__":
    main()

Notice: Information contained herein is not and should not be construed as an offer, solicitation, or recommendation to buy or sell securities. The information has been obtained from sources we believe to be reliable; however no guarantee is made or implied with respect to its accuracy, timeliness, or completeness. Author does not own the any crypto currency discussed. The information and content are subject to change without notice. CryptoDataDownload and its affiliates do not provide investment, tax, legal or accounting advice.

This material has been prepared for informational purposes only and is the opinion of the author, and is not intended to provide, and should not be relied on for, investment, tax, legal, accounting advice. You should consult your own investment, tax, legal and accounting advisors before engaging in any transaction. All content published by CryptoDataDownload is not an endorsement whatsoever. CryptoDataDownload was not compensated to submit this article. Please also visit our Privacy policy; disclaimer; and terms and conditions page for further information.

About

CryptoDataDownload - Free market data and risk analytics tools for cryptocurrency research and analysis. Premium content & analytical offerings also available. Trusted by academics worldwide.

Navigation

Contacts

E-mail

support@cryptodatadownload.com
Have feedback or questions? Our team is here to help. Contact us for any inquiries or to report any inaccuracies.

Convert Unix UTC Field to Any Timezone

Timezone Conversion

Latest Posts

Follow Us

Notify me of new content

About

Navigation

Contacts