Table Details
| Property | Value |
|---|---|
| Table Name | flynet.snapshots.token_supply |
| Table Status | Beta 🌱 |
| Unique Key | block_number, address |
| Clustering Key(s) | block_timestamp::date |
| Search Optimization | address |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR(42) | The contract address of the token whose supply is being tracked. |
| raw_total_supply | VARCHAR(16777216) | The unnormalized total token supply at this block, stored as a string to preserve precision. |
| block_number | NUMBER(38,0) | The block number at which this supply snapshot was recorded. |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block at which this supply snapshot was recorded. |
| block_hash | VARCHAR(66) | The hash of the block at which this supply snapshot was recorded. |
| _metadata | VARIANT | Internal metadata from the supply ingestion pipeline. |
| _error | VARIANT | Error information if the supply fetch encountered an issue. |
| _source | VARCHAR(16777216) | The data source or ingestion pipeline that produced this record. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |