Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| date | TIMESTAMP_NTZ(9) | Calendar date (UTC) this daily record aggregates. |
| project | VARCHAR(16777216) | Project or application associated with this record. |
| protocol | VARCHAR(16777216) | Protocol (and version, if applicable) associated with this record. |
| receipt_token_address | VARCHAR(16777216) | Contract address of the interest-bearing receipt token (e.g. aToken, cToken). |
| underlying_token_address | VARCHAR(16777216) | Contract address of the underlying asset the receipt token wraps. |
| underlying_token_symbol | VARCHAR(16777216) | Ticker symbol of the underlying asset. |
| underlying_token_decimals | NUMBER(38,0) | Decimal precision of the underlying asset. |
| exchange_rate | FLOAT | Conversion rate between the receipt token and its underlying asset on this date. |
| underlying_price_usd | FLOAT | USD price of one unit of the underlying asset. |
| receipt_token_price_usd | FLOAT | USD price of one unit of the receipt token (exchange rate x underlying price). |
| ctoken_type | VARCHAR(16777216) | Receipt token model (e.g. aToken-style rebasing vs cToken-style exchange rate). |
| last_activity_block_number | NUMBER(38,0) | Block number of the most recent activity reflected in this record. |
| last_activity_block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent activity reflected in 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. |