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
chart = Chart(api_key='YOUR API KEY')
chart.ohlc(
chain='ethereum',
token_address='0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2',
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.