> ## Documentation Index
> Fetch the complete documentation index at: https://developers.stellar.org/llms.txt
> Use this file to discover all available pages before exploring further.

# 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](https://github.com/stellar/stellar-dbt-public/blob/master/docs/snapshot.md) 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.

> **[Account Signers Current](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/account-signers-current.md)**
>
> Column details are equivalent to the bronze Account Signers table.

> **[Accounts Current](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/accounts-current.md)**
>
> Column details are equivalent to the bronze Accounts table.

> **[Accounts Snapshot](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/accounts-snapshot.md)**
>
> Reference documentation for the Accounts Snapshot table in Hubble's Silver data dictionary.

> **[Claimable Balances Current](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/claimable-balances-current.md)**
>
> Column details are equivalent to the bronze Claimable Balances table.

> **[Config Settings Current](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/config-settings-current.md)**
>
> Column details are equivalent to the bronze Config Settings table.

> **[Config Settings Snapshot](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/config-settings-snapshot.md)**
>
> Reference documentation for the Config Settings Snapshot table in Hubble's Silver data dictionary.

> **[Contract Code Current](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/contract-code-current.md)**
>
> Column details are equivalent to the bronze Contract Code table.

> **[Contract Data Current](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/contract-data-current.md)**
>
> Column details are equivalent to the bronze Contract Data table.

> **[Contract Data Snapshot](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/contract-data-snapshot.md)**
>
> Reference documentation for the Contract Data Snapshot table in Hubble's Silver data dictionary.

> **[Evicted Keys Snapshot](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/evicted-keys-snapshot.md)**
>
> Reference documentation for the Evicted Keys Snapshot table in Hubble's Silver data dictionary.

> **[Liquidity Pools Current](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/liquidity-pools-current.md)**
>
> Column details are equivalent to the bronze Liquidity Pools table.

> **[Liquidity Pools Snapshot](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/liquidity-pools-snapshot.md)**
>
> Reference documentation for the Liquidity Pools Snapshot table in Hubble's Silver data dictionary.

> **[Offers Current](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/offers-current.md)**
>
> Column details are equivalent to the bronze Offers table.

> **[Reflector Prices Data CEX Snapshot](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/reflector-prices-data-cex-snapshot.md)**
>
> Reference documentation for the Reflector Prices Data CEX Snapshot table in Hubble's Silver data dictionary.

> **[Reflector Prices Data FEX Snapshot](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/reflector-prices-data-fex-snapshot.md)**
>
> Reference documentation for the Reflector Prices Data FEX Snapshot table in Hubble's Silver data dictionary.

> **[Reflector Prices Data SDEX Snapshot](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/reflector-prices-data-sdex-snapshot.md)**
>
> Reference documentation for the Reflector Prices Data SDEX Snapshot table in Hubble's Silver data dictionary.

> **[Trustlines Current](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/trustlines-current.md)**
>
> Column details are equivalent to the bronze Trustlines table.

> **[Trustlines Snapshot](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/trustlines-snapshot.md)**
>
> Reference documentation for the Trustlines Snapshot table in Hubble's Silver data dictionary.

> **[TTL Current](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/ttl-current.md)**
>
> Column details are equivalent to the bronze TTL table.

> **[Enriched History Operations](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/enriched-history-operations.md)**
>
> Reference documentation for the Enriched History Operations table in Hubble's Silver data dictionary.

> **[Enriched History Operations Soroban](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/enriched-history-operations-soroban.md)**
>
> Column details are equivalent to the silver Enriched History Operations table.

> **[Token Transfers](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/silver/token-transfers-raw.md)**
>
> Reference documentation for the Token Transfers Raw table in Hubble's Silver data dictionary.
