Silver 🥈
Decoded, transformed, and filtered data. These tables transform the bronze tables into easier to use tables by joining and flattening tables and filtering out information for specific use cases.
When to use​
These tables are best used for a more curated experience while still needing to search and filter for specific use cases such as information on a specific contract.
One example is getting relevant Stellar events to calculate circulating supply by using the token_transfers_raw table. In theory you can get the same information from the bronze history_contract_events table but the token_transfers_raw table has already processed, filtered, and flattened the events relevant to SEP-41 events and classic operations.
Slowly Changing Dimensions (SCD Type 2)​
Some silver tables are modeled as SCD Type 2 tables. This means they track the full history of changes to a record over time by keeping multiple versions with valid_from / valid_to ranges.
These tables are especially useful for answering historical questions such as:
- What was the state of a contract at a given point in time?
- How did an account, trustline, or balance evolve across different periods?
- Which liquidity pools were active at a given date, and how did their properties change over time?
NOTE: Daily Snapshot Frequency: Snapshots run on a daily basis, meaning they capture inter-day changes, but not multiple changes that occur within the same day.