This table is currently in Beta.
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| protocol | VARCHAR(16777216) | Protocol associated with this record (e.g. etherfi). |
| chain | VARCHAR(16777216) | Slug identifying the blockchain this record belongs to. |
| user_address | VARCHAR(16777216) | Address of the EtherFi Cash card user. |
| created_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) when the user’s card account was created. |
| creation_tx_hash | VARCHAR(16777216) | Transaction hash of the card account creation. |
| first_topup_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the user’s first card top-up. |
| last_topup_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the user’s most recent card top-up. |
| first_topup_amount_raw | NUMBER(38,0) | First top-up amount in the token’s smallest indivisible unit. |
| first_topup_amount_usd | FLOAT | USD value of the user’s first top-up. |
| first_topup_token | VARCHAR(16777216) | Contract address of the token used for the first top-up. |
| total_topup_amount_raw | NUMBER(38,0) | Total top-up amount across all top-ups in the token’s smallest indivisible unit. |
| total_topup_amount_usd | FLOAT | Total USD value of all the user’s top-ups. |
| total_topups | NUMBER(38,0) | Total number of top-ups made by the user. |
| unique_tokens_used | NUMBER(38,0) | Number of distinct tokens the user has topped up with. |
| unique_source_chains | NUMBER(38,0) | Number of distinct source chains the user has topped up from. |