Table Columns
Unique Key:unique_id
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR | Address of the account that was credited or debited value amount of ETH |
| counterparty_address | VARCHAR | The address of counter party of this credit or debit transfer |
| raw_amount | NUMERIC | Amount of ETH in wei |
| raw_amount_str | VARCHAR | Amount of ETH in wei in string format |
| amount | FLOAT | Amount of ether |
| amount_str | VARCHAR | Amount of ether in string format |
| usd_amount | FLOAT | The amount of ether moved, in $USD |
| usd_exchange_rate | FLOAT | The exchange rate used to calculate the usd_value |
| transfer_type | VARCHAR | Type of transfers. Includes value_transfer, gas_payment_to_mine, gas_burn |
| transaction_hash | VARCHAR | Transaction hash that this transfer belongs to |
| transaction_index | BIGINT | The position of this transaction in the block. The first transaction has index 0 |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block that the corresponding transaction of this transfer belongs to |
| block_number | BIGINT | The block number that the corresponding transaction of this transfer belongs to |
| block_hash | VARCHAR | The block hash that the corresponding transaction of this transfer belongs to |
| unique_id | VARCHAR | Unique id generated to each transfer |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full refresh |