| app_list | ARRAY | Array of applications that the wallets have interacted with. |
| entity_list | ARRAY | Array of entity labels assigned to this wallet (e.g. exchange, protocol, whale). |
| interaction_list | ARRAY | Array of notable protocols or contracts this wallet has interacted with. |
| wallet_address | VARCHAR(42) | Address of the created wallet |
| latest_ens_name | VARCHAR(16777216) | Latest ENS name registered by the user. |
| total_days_active | NUMBER(18,0) | Number of distinct calendar days on which this wallet sent at least one transaction. |
| total_txn_count | NUMBER(18,0) | Total distinct number of transactions performed by the wallet at the time of analysis. |
| total_to_address | NUMBER(18,0) | Total distinct number of addresses that the wallet has interacted with from raw transactions. |
| first_txn_date | TIMESTAMP_NTZ(9) | Blocktime stamp of the wallet’s first transaction. |
| first_txn_hash | VARCHAR(66) | Transaction hash of the wallet’s first transaction. |
| first_funding_date | TIMESTAMP_NTZ(9) | Date (UTC) when this wallet received its first funding transaction. |
| first_funding_address | VARCHAR(42) | Address that funded the wallet’s first gas token. |
| first_funding_txn_hash | VARCHAR(66) | Transaction that funded the wallet’s first gas token. |
| tokens_held_symbols | ARRAY | Array of ERC20 token symbols held by the wallet at the time of update. |
| tokens_held_addresses | ARRAY | Array of ERC20 token addresses held by the wallet at the time of update. |
| total_usd_balance | FLOAT | Total USD balance held by the wallet at the time of update. |
| stablecoin_usd_balance | FLOAT | Total stablecoin USD balance held by the wallet at the time of update. Currently includes USDC, USDT, BUSD, TUSD and USDP. |
| native_token_usd_balance | FLOAT | Total ETH USD balance held by the wallet at the time of update. |
| native_token_balance | FLOAT | Total ETH balance held by the wallet at the time of update. |
| list_dex_trade_project_used | ARRAY | List of DEX projects the wallet has traded on. |
| total_dex_trade_volume_usd | FLOAT | Total USD volume traded by the wallet. |
| avg_dex_trade_volume_usd | FLOAT | Average USD volume per trade performed. |
| first_dex_trade_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of the first DEX trade performed. |
| first_dex_trade_txn_hash | VARCHAR(66) | Transaction hash of the first DEX trade performed. |
| first_dex_trade_project | VARCHAR(16777216) | First DEX project interacted by the wallet. |
| total_nft_trade_txn_count | NUMBER(18,0) | Total number of NFT trades performed. |
| total_nft_trade_volume_usd | FLOAT | Total USD volume of NFT trades performed. |
| avg_nft_trade_volume_usd | FLOAT | Average USD volume of NFT per trade. |
| list_nft_trade_marketplace_used | ARRAY | List of NFT marketplaces that the wallet has bought NFT from. |
| list_nft_trade_aggregator_used | ARRAY | List of NFT aggregators that the wallet has bought NFT from. |
| total_nft_trade_marketplace_count | NUMBER(18,0) | Total number of NFT marketplaces that the wallet has bought NFT from. |
| total_nft_trade_aggregator_count | NUMBER(18,0) | Total number of NFT aggregators that the wallet has bought NFT from. |
| total_nft_trade_collection_count | NUMBER(18,0) | Total number of NFT collections that the wallet has traded (distinct collection address). |
| opensea_nft_trade_user | NUMBER(1,0) | Flag for OpenSea User. Where 1 = User and 0 = not user. |
| opensea_nft_trade_first_txn_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of first NFT trade on OpenSea. |
| opensea_nft_trade_last_txn_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of last NFT trade on OpenSea. |
| opensea_nft_trade_total_txn_count | NUMBER(18,0) | Total NFT trade transaction performed on OpenSea. |
| opensea_nft_trade_total_volume_usd | FLOAT | Total USD volume traded on OpenSea. |
| opensea_nft_trade_avg_volume_usd | FLOAT | Average USD volume traded on OpenSea per trade. |
| looksrare_nft_trade_user | NUMBER(1,0) | Flag for LooksRare User. Where 1 = User and 0 = not user. |
| looksrare_nft_trade_first_txn_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of first NFT trade on LooksRare. |
| looksrare_nft_trade_last_txn_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of last NFT trade on LooksRare. |
| looksrare_nft_trade_total_txn_count | NUMBER(18,0) | Total NFT trade transaction performed on LooksRare. |
| looksrare_nft_trade_total_volume_usd | FLOAT | Total USD volume traded on LooksRare. |
| looksrare_nft_trade_avg_volume_usd | FLOAT | Average USD volume traded on LooksRare per trade. |
| x2y2_nft_trade_user | NUMBER(1,0) | Flag for X2Y2 User. Where 1 = User and 0 = not user. |
| x2y2_nft_trade_first_txn_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of first NFT trade on X2Y2. |
| x2y2_nft_trade_last_txn_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of last NFT trade on X2Y2. |
| x2y2_nft_trade_total_txn_count | NUMBER(18,0) | Total NFT trade transaction performed on X2Y2. |
| x2y2_nft_trade_total_volume_usd | FLOAT | Total USD volume traded on X2Y2. |
| x2y2_nft_trade_avg_volume_usd | FLOAT | Average USD volume traded on X2Y2 per trade. |
| blur_nft_trade_user | NUMBER(1,0) | Flag for Blur User. Where 1 = User and 0 = not user. |
| blur_nft_trade_first_txn_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of first NFT trade on Blur. |
| blur_nft_trade_last_txn_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of last NFT trade on Blur. |
| blur_nft_trade_total_txn_count | NUMBER(18,0) | Total NFT trade transaction performed on Blur. |
| blur_nft_trade_total_volume_usd | FLOAT | Total USD volume traded on Blur. |
| blur_nft_trade_avg_volume_usd | FLOAT | Average USD volume traded on Blur per trade. |
| rarible_nft_trade_user | NUMBER(1,0) | Flag for Rarible User. Where 1 = User and 0 = not user. |
| rarible_nft_trade_first_txn_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of first NFT trade on Rarible. |
| rarible_nft_trade_last_txn_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of last NFT trade on Rarible. |
| rarible_nft_trade_total_txn_count | NUMBER(18,0) | Total NFT trade transaction performed on Rarible. |
| rarible_nft_trade_total_volume_usd | FLOAT | Total USD volume traded on Rarible. |
| rarible_nft_trade_avg_volume_usd | FLOAT | Average USD volume traded on Rarible per trade. |
| magiceden_nft_trade_user | NUMBER(1,0) | Flag for Magic Eden User. Where 1 = User and 0 = not user. |
| magiceden_nft_trade_first_txn_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of first NFT trade on Magic Eden. |
| magiceden_nft_trade_last_txn_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of last NFT trade on Magic Eden. |
| magiceden_nft_trade_total_txn_count | NUMBER(18,0) | Total NFT trade transaction performed on Magic Eden. |
| magiceden_nft_trade_total_volume_usd | FLOAT | Total USD volume traded on Magic Eden. |
| magiceden_nft_trade_avg_volume_usd | FLOAT | Average USD volume traded on Magic Eden per trade. |
| first_nft_trade_token_address | VARCHAR(42) | Token address of first NFT traded. |
| first_nft_trade_token_id | VARCHAR(16777216) | Token ID of first NFT traded. |
| first_nft_trade_token_name | VARCHAR(16777216) | Token name of first NFT traded. |
| first_nft_trade_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of first NFT traded. |
| first_nft_trade_txn_hash | VARCHAR(66) | Transaction hash of first NFT traded. |
| total_collections_minted | NUMBER(18,0) | Total number of unique NFT collections minted. |
| total_nft_mint_txn | NUMBER(18,0) | Total number of NFT minting transactions. |
| total_mint_volume_usd | FLOAT | Total USD volume spent on minting NFTs. |
| avg_mint_price_usd | FLOAT | Average USD mint price of mints. |
| first_nft_mint_token_address | VARCHAR(68) | Token address of the first NFT minted. |
| first_nft_mint_token_name | VARCHAR(16777216) | Token ID of first NFT minted. |
| first_nft_mint_token_id | VARCHAR(16777216) | Token name of first NFT minted. |
| first_nft_mint_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of first NFT minted. |
| first_nft_mint_txn_hash | VARCHAR(66) | Transaction hash of first NFT minted. |
| first_nft_token_address | VARCHAR(42) | Token address of the first NFT acquired (which can be a mint or NFT bought). |
| first_nft_token_name | VARCHAR(16777216) | Token ID of first NFT acquired. |
| first_nft_token_id | VARCHAR(16777216) | Token name of first NFT acquired. |
| first_nft_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of first NFT acquired. |
| first_nft_txn_hash | VARCHAR(66) | Transaction hash of first NFT acquired. |
| blue_chip_collections_held | ARRAY | List of Bluechip NFT held by the wallet at the time of analysis. Bluechips NFT collections include CryptoPunks, BoredApeYachtClub, MutantApeYachtClub, Fidenza / Art Blocks, Otherdeed, Azuki, CloneX, Moonbirds, Sandbox LANDs, Chromie Squiggle / Art Blocks |
| blue_chip_collections_count | NUMBER(18,0) | Number of Bluechip NFT collections held by the wallet at the time of analysis. |
| blue_chip_nfts_count | NUMBER(18,0) | Number of Bluechip NFTs held by the wallet at the time of analysis. |
| blue_chip_collection_address_list | ARRAY | List of Bluechip NFT addresses held by the wallet at the time of analysis. |
| blue_chip_collection_name_list | ARRAY | List of Bluechip NFT names held by the wallet at the time of analysis. |
| _updated_at | TIMESTAMP_LTZ(9) | Timestamp of when the entry was last updated in the database. |
| updated_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent update to this row. Alias for _updated_at used in models that omit the underscore prefix. |
