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. |
| recipient_address | VARCHAR(16777216) | Address that received the cashback. |
| cashback_category | VARCHAR(16777216) | Category of spend the cashback was earned on. |
| cashback_token_address | VARCHAR(16777216) | Contract address of the token the cashback was paid in. |
| cashback_amount_raw | NUMBER(38,0) | Cashback amount in the token’s smallest indivisible unit. |
| cashback_amount | FLOAT | Decimal-adjusted cashback amount. |
| cashback_amount_usd | FLOAT | USD value of the cashback at the record’s timestamp. |
| cashback_usd_cents | NUMBER(38,0) | Cashback value in USD cents as reported by the protocol. |
| cashback_usd | FLOAT | Cashback value in USD as reported by the protocol. |
| payment_amount_raw | NUMBER(38,0) | Underlying card payment amount in the token’s smallest indivisible unit. |
| cashback_type | NUMBER(38,0) | Type of cashback issued (e.g. base, boosted). |
| event_flag | NUMBER(38,0) | Flag identifying the on-chain event variant that produced this record. |
| contract_address | VARCHAR(16777216) | Address of the smart contract that emitted this event. |
| topic0 | VARCHAR(16777216) | Keccak hash of the event signature (first log topic). |
| transaction_hash | VARCHAR(16777216) | Hash of the transaction that produced this record. |
| transaction_index | NUMBER(38,0) | Zero-based position of the transaction within its block. |
| log_index | NUMBER(38,0) | Zero-based position of this event log within its transaction. |
| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_hash | VARCHAR(16777216) | Cryptographic hash of the block header that contains this record. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. |