| Asset Type | Description |
|---|---|
| Fungible | Fungible assets models contains erc20 tokens and native (gas) token. |
| Native | Native tokens are the gas tokens of the blockchain, such as ETH, BNB, POL, AVAX, etc. |
| ERC20 | ERC20 tokens are the tokens that follow the ERC20 standard, such as USDC, USDT, etc. |
| ERC721 | ERC721 tokens are the tokens that follow the ERC721 standard, such as Pudgy Penguins, etc. |
| ERC1155 | ERC1155 tokens are the tokens that follow the ERC1155 standard, such as OpenSea Collection StoreFront, etc. |
| Table | Use Case | Question |
|---|---|---|
| Balances | Tracks all changes in asset balance for a given address, from wallet creation to the present. | What is the USDC balance of a particular wallet over time? |
| Balances Latest | Checking the current balances of assets for a given address. | What is the current distribution of ETH holdings of OpenSea NFT buyers in the last 7 days? |
| Transfers | Account for the inflow or outflows of assets from one address to another. | What is the total inflow of USDC into a wallet in the last 30 days? (not accounting for outflows) |
| Credit Debit | Accounting for inflows and outflows of assets. | What is the net balance change of USDC into a wallet in the last 14 days? |
| Schema | Description | Tables |
|---|---|---|
| Assets | Token transfers, balances & credit debit data related to fungible and/or non-fungible assets. | balances_latest, credit_debit, erc1155_balances, erc1155_balances_latest, erc1155_credit_debit, erc1155_token_transfers, erc20_balances, erc20_balances_latest, erc20_credit_debit, erc20_token_transfers, erc721_balances, erc721_balances_latest, erc721_credit_debit, erc721_token_transfers, fungible_balances, fungible_balances_daily, fungible_balances_latest, fungible_credit_debit, fungible_pnl, fungible_pnl_5min, fungible_token_transfers, native_balances, native_balances_latest, native_credit_debit, native_token_transfers, stablecoin_list, stablecoin_transfers |