transpose-defi-sdk

The Transpose DeFi SDK is a simple Python package for performing multi-chain DeFi analysis using the real-time Transpose SQL API. At the moment, the only supported functionality is the ability to download or chart OHLC prices for any token on Ethereum, Goerli, and Polygon.

The underlying price data is sourced for every token on the supported networks, regardless of centralized listing status, volume, or liquidity. This data is derived from DEX data across over 24 different DEXs, including Uniswap, Sushiswap, Balancer, and Curve, and nearly 200k DEX pools. The token prices are normalized to accurate USD prices using Chainlink price feeds. The full list of supported DEXs can be found in the docs.

Retrieving an API key

To use the SDK, you will need an API key for Transpose. You can sign up for a free API key by visting the Transpose App. If you have any questions on getting started, feature requests, or contributing to the SDK, please reach out to us on Discord.

Installation

To install the package, run the following command in your Python environment:

pip install transpose-defi-sdk

The SDK requires Python 3.6 or higher and has only 4 dependencies:

• pandas
• pip-chill
• web3
• plotly

Getting Started

Charting OHLC prices

OHLC stands for open-high-low-close and is a common way to represent price data over fixed time intervals. To start charting data, simply import and instantiate the Chart class from the SDK and call its ohlc method.

from transpose.chart import Chart

# initialize Chart with your API key
chart = Chart(api_key='YOUR API KEY')

# chart OHLC data for a token
chart.ohlc(
    chain='ethereum', 
    token_address='0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2', # token address for WETH
    from_timestamp='2021-01-01', 
    to_timestamp='2021-02-01', 
    timeframe='hour'
)

The above code will generate a chart of hourly OHLC prices for Wrapped Ether (WETH) during the month of January 2021. The address for WETH can be replaced with any token address on the supported chains.

By default, Plotly will automatically render the chart in your browser. If you would like to save the chart as a HTML file, you can pass the save_as parameter to the ohlc method:

chart.ohlc(
    chain='ethereum', 
    token_address='0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2', 
    from_timestamp='2021-01-01', 
    to_timestamp='2021-02-01', 
    timeframe='hour',
    save_as='test.html'
)

Downloading OHLC data

To return the data directly as a Pandas DataFrame from the ohlc method rather than charting, you may pass the optional return_df parameter:

price_df = chart.ohlc(
    chain='ethereum', 
    token_address='0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2', 
    from_timestamp='2021-01-01', 
    to_timestamp='2021-02-01', 
    timeframe='hour',
    return_df=True
)

The price_df DataFrame will contain a timestamp index and four columns for the OHLC prices: open, high, low, and close.

Charting Options

The ohlc method accepts a number of optional parameters to customize the chart. The following parameters are available:

• chain: The blockchain network to query (ethereum, goerli, or polygon).
• token_address: The address of the token to chart (must be a valid 42-character hex addres).
• from_timestamp: The start date for the chart (supports common string formats and Unix timestamps).
• to_timestamp: The end date for the chart (supports common string formats and Unix timestamps).
• timeframe: The time interval to chart (day, hour, or minute).
• save_as: The path to save the chart as a HTML file.
• return_df: Whether to return the data as a Pandas DataFrame rather than charting.