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:
Remember, you must update these tables and column name by Jun 3rd, 2024 or your queries will break.
Last updated