Actions for Data Studio Users

Pricing data updates and actions required for queries and dashboards build in the data studio.

Update #1: 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.

Update #2: Replace old tables and column with optimized tables

Leverage our new pricing tables and deprecate the old ones. The old ones will be deprecated on 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 1 column for 11 databases.

The chains affected:

• Aptos

• Arbitrum

• Avalanche

• Base

• Blast

• BSC

• Crosschain

• Ethereum

• Gnosis

• Optimism

• Polygon

The table and column names that need to be deprecated for those 11 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 name by Jun 3rd, 2024 or your queries will break.