solana.raw.spl_token_total_supply table contains snapshots of SPL token total supply as returned from the Solana RPC. These snapshots are triggered approximately when a mint or burn event is detected on the blockchain.
Since the RPC does not allow specifying a slot number when querying token supply, the snapshot block will occur after but close to the actual mint/burn event that triggered the snapshot.
Snapshot Triggers
Snapshots are created when:- Mint Events: New tokens are minted to increase the total supply
- Burn Events: Existing tokens are burned to decrease the total supply
Table Columns
| Column Name | Description | Type | Example |
|---|---|---|---|
mint | The mint address of the SPL token | varchar | EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v |
symbol | The ticker symbol of the token | varchar | USDC |
token_name | The full name of the token | varchar | USD Coin |
decimals | Number of decimal places the token uses | number | 6 |
raw_amount_str | Total supply as a string in raw units (before decimal adjustment) | varchar | 1000000000000 |
raw_amount | Total supply as a float in raw units (before decimal adjustment) | float | 1000000000000.0 |
amount_str | Total supply as a string in human-readable units (after decimal adjustment) | varchar | 1000000.0 |
amount | Total supply as a float in human-readable units (after decimal adjustment) | float | 1000000.0 |
snapshot_block_slot | The slot number of the block where the snapshot was taken | number | 276304227 |
snapshot_block_timestamp | The timestamp of the block where the snapshot was taken | timestamp_ntz | 2024-07-08 02:16:54.000 |
snapshot_block_height | The height of the block where the snapshot was taken | number | 255661589 |
snapshot_block_hash | The hash of the block where the snapshot was taken | varchar | 36KR3aiVEZYSJDb8wgWBWpXbYykuz3BJagFRMhFijKxA |
_updated_at | Timestamp when the record was last updated | timestamp_ntz | 2024-07-08 02:16:54.000 |
_created_at | Timestamp when the record was created | timestamp_ntz | 2024-07-08 02:16:54.000 |