Table Details
| Property | Value |
|---|---|
| Table Name | b3.nfts.wallet_funders |
| Table Status | Production-Ready |
| Unique Key | address, funder_address, funding_token_address |
| Search Optimization | address |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR(16777216) | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies. |
| funder_address | VARCHAR(16777216) | Address that funded this wallet (sent tokens to it before its first NFT trade). |
| funder_address_categories | ARRAY | Comma-separated entity categories for the funder address (e.g. cex, bridge, dex). |
| funding_token_address | VARCHAR(16777216) | Contract address of the token used to fund this wallet. Zero address for native token (ETH/MATIC). |
| funding_transaction_count | NUMBER(38,0) | Number of transactions from the funder address to this wallet. |
| first_funded_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the first funding transaction from this funder to this wallet. |
| first_funding_txn | VARCHAR(16777216) | Transaction hash of the first funding transaction from this funder to this wallet. |
| last_funded_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the most recent funding transaction from this funder. |
| last_funding_txn | VARCHAR(16777216) | Transaction hash of the most recent funding transaction from this funder. |
| total_funding_amount | FLOAT | Total token amount received from this funder (decimal-adjusted). |
| total_funding_amount_usd | FLOAT | USD value of total funding received from this funder. |
| max_funding_amount | FLOAT | Largest single funding transaction amount (decimal-adjusted). |
| max_funding_amount_usd | FLOAT | USD value of the largest single funding transaction. |
| _upstream_created_at | TIMESTAMP_NTZ(9) | Timestamp when the upstream intermediate record feeding this row was first created. |
| _upstream_updated_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent update to the upstream model that feeds 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. |