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:
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