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 ez_asset_metadata	id	asset_id
COLUMN NAME CHANGE - in dim_asset_metadata table	id	asset_id
COLUMN DEPRECATION - in dim_asset_metadata table	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.