2024-11-27 | Release Notes
Introducing expanded Aleo data coverage, Jupiter V4/V5 swap updates on Solana, plus important table deprecation notices and data latency changes.
Highlights
This release brings comprehensive data coverage to the Aleo ecosystem with new core transfer tracking, pricing tables, and network metrics. We've also enhanced Solana's Jupiter swap data organization. Plus, we're rolling out major updates to Flipside Studio to transform how you build and share your analysis. Let's dive into what's new!
🎨 New Studio Features
Query Referencing - Queries in Queries!
Reference results from previous queries directly using $query('query_id')
Streamline your analysis by eliminating complex query rewrites
Build more sophisticated analyses by combining query results
Learn more about query referencing here.
Custom Dashboard Tagging
Create custom tags for your dashboards directly from the sidebar or query editor
Increase visibility of your work with better categorization
Find and get found more easily with improved tag display across boards
Boost your earnings potential through increased dashboard discovery
Ethereum Chainlink tables will be removed on December 9, 2024
DeepNFTValue tables will be removed on December 4, 2024
Please update your queries and dashboards accordingly
📊 Data Latency Updates
We're updating the latency for our non-core tables across multiple blockchains to improve data reliability. Tables in non-core schemas like defi/nft/gov/stats/etc. that are not [db].core.[table] are subject to changes in their latency. See the full list of blockchains and their freshness targets here.
Aleo
1 hour
4 hours
Arbitrum
2 hours
6 hours
Axelar
2 hours
1 hour
Base
2 hours
4 hours
BSC
2 hours
6 hours
Bitcoin
2 hours
6 hours
Blast
1 hour
4 hours
CoreDao
1 hour
4 hours
Eclipse
1 hour
4 hours
Gnosis
2 hours
6 hours
Kaia
1 hour
4 hours
Optimism
2 hours
6 hours
Polygon
2 hours
6 hours
Thorchain
2 hours
4 hours
Check out these updates and the rest of the release notes below.
Aleo
New Tables - Core Transfer Tracking
aleo.core.fact_transfers
Track public and private transfers of native Aleo credits between addresses. Foundation for future expansion to include non-native token transfers.
New Tables - Price Data Integration
aleo.price.dim_asset_metadata
aleo.price.ez_asset_metadata
aleo.price.ez_prices_hourly
aleo.price.fact_prices_ohlc_hourly
These standard pricing tables integrate data from CoinGecko and CoinMarketCap to provide comprehensive price tracking for Aleo assets.
New Table - Network Statistics
aleo.stats.ez_core_metrics_hourly
Core network metrics now available in the stats schema. Aleo metrics integrated into crosschain.stats.ez_core_metrics_hourly
Solana
Updated Tables - Jupiter Swap Data Organization
The Jupiter V4 and V5 swap data is being restructured for better analysis and added to Jupiter-specific tables:
solana.defi.fact_swaps_jupiter_summary
Aggregated view of Jupiter V4/V5 swaps
solana.defi.fact_swaps_jupiter_inner
Detailed routes for individual swaps
Important Note: Jupiter V4 and V5 swaps will be removed from fact_swaps
on December 9th. To query these swaps, use fact_swaps_jupiter_summary
with the following program IDs:
Jupiter V4: 'JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB'
Jupiter V5: 'JUP5pEAZeHdHrLxh5UCwAbpjGwYKKoquCpda2hfP4u8' and 'JUP5cHjnnCx2DppVsufsLrXs8EBZeEZzGtEK9Gdz6ow'
Since these swaps will exist in both fact_swaps
and fact_swaps_jupiter_summary
until December 9th, any union between these tables should exclude the previously mentioned program ID’s from fact_swaps
to avoid duplicates.
⚠️ Deprecated Tables - Action Required
Ethereum Chainlink Tables (Removing December 9, 2024)
The following tables will be deprecated due to low usage:
ethereum.chainlink.dim_oracle_feeds
ethereum.chainlink.ez_oracle_feeds
ethereum.chainlink.fact_oracle_feeds
DeepNFTValue Tables (Removing December 4, 2024)
The following tables will be deprecated due to low usage:
external.deepnftvalue.fact_collections
external.deepnftvalue.fact_tokens
external.deepnftvalue.fact_valuations
Please update any queries or dashboards that reference these tables before their removal dates.
Useful Resources
Request a smart contract ABI to be decoded: https://science.flipsidecrypto.xyz/abi-requestor/
Request a Solana IDL to be decoded: https://science.flipsidecrypto.xyz/idl-requestor
Add labels: https://science.flipsidecrypto.xyz/add-a-label
Last updated