Skip to main content

​
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?
Daily Snapshot FrequencySnapshots run on a daily basis, meaning they capture inter-day changes, but not multiple changes that occur within the same day.

Account Signers Current

Column details are equivalent to the bronze Account Signers table.

Accounts Current

Column details are equivalent to the bronze Accounts table.

Accounts Snapshot

Reference documentation for the Accounts Snapshot table in Hubble’s Silver data dictionary.

Claimable Balances Current

Column details are equivalent to the bronze Claimable Balances table.

Config Settings Current

Column details are equivalent to the bronze Config Settings table.

Config Settings Snapshot

Reference documentation for the Config Settings Snapshot table in Hubble’s Silver data dictionary.

Contract Code Current

Column details are equivalent to the bronze Contract Code table.

Contract Data Current

Column details are equivalent to the bronze Contract Data table.

Contract Data Snapshot

Reference documentation for the Contract Data Snapshot table in Hubble’s Silver data dictionary.

Evicted Keys Snapshot

Reference documentation for the Evicted Keys Snapshot table in Hubble’s Silver data dictionary.

Liquidity Pools Current

Column details are equivalent to the bronze Liquidity Pools table.

Liquidity Pools Snapshot

Reference documentation for the Liquidity Pools Snapshot table in Hubble’s Silver data dictionary.

Offers Current

Column details are equivalent to the bronze Offers table.

Reflector Prices Data CEX Snapshot

Reference documentation for the Reflector Prices Data CEX Snapshot table in Hubble’s Silver data dictionary.

Reflector Prices Data FEX Snapshot

Reference documentation for the Reflector Prices Data FEX Snapshot table in Hubble’s Silver data dictionary.

Reflector Prices Data SDEX Snapshot

Reference documentation for the Reflector Prices Data SDEX Snapshot table in Hubble’s Silver data dictionary.

Trustlines Current

Column details are equivalent to the bronze Trustlines table.

Trustlines Snapshot

Reference documentation for the Trustlines Snapshot table in Hubble’s Silver data dictionary.

TTL Current

Column details are equivalent to the bronze TTL table.

Enriched History Operations

Reference documentation for the Enriched History Operations table in Hubble’s Silver data dictionary.

Enriched History Operations Soroban

Column details are equivalent to the silver Enriched History Operations table.

Token Transfers

Reference documentation for the Token Transfers Raw table in Hubble’s Silver data dictionary.