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:

TypeCurrent nameNew 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.

Last updated