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.

Last updated