Actions for API Users
Pricing data updates and actions required for users leveraging the Flipside API.
There are two key actions API Users need to take during Flipside’s pricing updates period. They are outlined below in Action #1 and Action #2 sections.
Action #1: Replace old tables and column with optimized tables
Leverage our new pricing tables and deprecate the old ones by June 3rd, 2024. You need to change these table and column names in your queries so they don’t break. This affects 2 tables and 3 columns for 19 databases.
The following chains are affected:
Aptos | Ethereum |
Arbitrum | Flow |
Avalanche | Gnosis |
Aurora | Near |
Axelar | Optimism |
Base | Osmosis |
Bitcoin | Polygon |
Blast | SEI |
BSC | Solana |
Crosschain |
The table and column names that need to be deprecated for those 19 chains:
| Type | Current name | New name |
|---|---|---|
TABLE NAME CHANGE | fact_hourly_token_prices | fact_prices_ohlc_hourly |
TABLE NAME CHANGE | ez_hourly_token_prices | ez_prices_hourly |
COLUMN NAME CHANGE
- in | id | asset_id |
COLUMN NAME CHANGE
- in | id | asset_id |
COLUMN DEPRECATION
- in | decimals | No replacement, column is being deprecated |
Remember, you must update these tables and column names by June 3rd, 2024 or your queries will break
Action #2: Monitor data pipeline for refreshed data on June 3rd, 2024
Any table that includes the amount_usd column will be refreshed on June 3rd, 2024 to include historical pricing. This will cause the modified_timestamp column to update.
If you are incrementally loading data utilizing the modified_timestamp column, you could see larger than normal data loading on June 3rd. Please make necessary preparations and keep an eye on your data pipelines on this day.
The following chains are affected:
Aptos | Crosschain |
Arbitrum | Ethereum |
Avalanche | Gnosis |
Base | Optimism |
Blast | Polygon |
BSC |
We will send you an email as we get closer to remind you.
Bonus: How to get improved token prices
To pull pricing data from 15,000+ tokens from CoinGecko, CoinMarketCap, and various other sources into your queries, analysts use the Crosschain data set and query select * from crosschain.price.ez_prices_hourly to select any token from the available list.
Last updated