# Tokens

Tokens are digital assets that can be created and managed on blockchain platforms like Ethereum. They represent a wide range of assets, from cryptocurrencies to digital collectibles. Currently, tokens are primarily categorized into three main types:

1. ERC20: The most common type of token, used for cryptocurrencies and utility tokens.
2. ERC721: Non-fungible tokens (NFTs) that represent unique digital assets.
3. ERC1155: Multi-token standard that can represent both fungible and non-fungible tokens.

ERC721 and ERC1155 are commonly used for NFTs (Non-Fungible Tokens), which represent unique digital assets such as art, collectibles, or in-game items.

## ETL data class

| Column Name   | Data Type | Note                      |
| ------------- | --------- | ------------------------- |
| address       | str       |                           |
| token\_type   | str       | ERC20, ERC721, or ERC1155 |
| name          | str       |                           |
| symbol        | str       |                           |
| decimals      | int       |                           |
| block\_number | int       |                           |
| total\_supply | int       |                           |

Examples

```json

{
  "address": "0x0DC808ADCE2099A9F62AA87D9670745ABA741746",
  "token_type": "ERC20",
  "name": "Wrapped Ether",
  "symbol": "WETH",
  "decimals": 18,
  "block_number": 19025325,
  "total_supply": 5133665930482359665722
}

```

```json
  {
  "address": "0xd5cb4a5009e9d9cdd58ef093182729d78c5d5a6e",
  "token_type": "ERC721",
  "name": "Manta Fest",
  "symbol": "Manta",
  "decimals": null,
  "block_number": 1153515,
  "total_supply": 115591
}

```

```csv
0x0DC808ADCE2099A9F62AA87D9670745ABA741746,ERC20,Wrapped Ether,WETH,18,19025325,5133665930482359665722
0xd5cb4a5009e9d9cdd58ef093182729d78c5d5a6e,ERC721,Manta Fest,Manta,,1153515,115591
```

## Model in the Database

| Column Name            | Data Type      | Note                      |
| ---------------------- | -------------- | ------------------------- |
| address                | bytea          | primary key               |
| name                   | varchar        |                           |
| symbol                 | varchar        |                           |
| total\_supply          | numeric(100)   |                           |
| decimals               | numeric(100)   |                           |
| token\_type            | varchar        | ERC20, ERC721, or ERC1155 |
| holder\_count          | integer        |                           |
| transfer\_count        | integer        |                           |
| icon\_url              | varchar        |                           |
| urls                   | jsonb          |                           |
| volume\_24h            | numeric(38, 2) |                           |
| price                  | numeric(38, 6) |                           |
| previous\_price        | numeric(38, 6) |                           |
| market\_cap            | numeric(38, 2) |                           |
| on\_chain\_market\_cap | numeric(38, 2) |                           |
| is\_verified           | boolean        |                           |
| cmc\_id                | integer        | CoinMarketCap ID          |
| cmc\_slug              | varchar        | CoinMarketCap slug        |
| gecko\_id              | varchar        | CoinGecko ID              |
| description            | varchar        |                           |
| create\_time           | timestamp      | default now()             |
| update\_time           | timestamp      | default now()             |
| block\_number          | bigint         |                           |

Examples

```json
{
  "address": "E'\\\\x0DC808ADCE2099A9F62AA87D9670745ABA741746'",
  "name": "Wrapped Ether",
  "symbol": "WETH",
  "total_supply": 5133665930482359665722,
  "decimals": 18,
  "token_type": "ERC20",
  "holder_count": 32961,
  "transfer_count": 1161654,
  "icon_url": "https://s2.coinmarketcap.com/static/img/coins/64x64/2396.png",
  "urls": {
    "website": [
      "https://weth.io/"
    ],
    "explorer": [
      "https://etherscan.io/token/0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"
    ]
  },
  "volume_24h": 1487479300.00,
  "price": 2274.550500,
  "previous_price": 2274.550500,
  "market_cap": 0.00,
  "on_chain_market_cap": 11676782.41,
  "is_verified": true,
  "cmc_id": 2396,
  "cmc_slug": "weth",
  "gecko_id": "weth",
  "description": "WETH (WETH) is a cryptocurrency and operates on the Ethereum platform. WETH is a wrapped version of Ether, allowing for easier integration with DeFi protocols.",
  "create_time": "2024-01-04 15:41:00.000000",
  "update_time": "2024-01-04 15:41:00.000000",
  "block_number": 19025325
}
```

```json
{
  "address": "E'\\\\xD5CB4A5009E9D9CDD58EF093182729D78C5D5A6E'",
  "name": "Manta Fest",
  "symbol": "Manta",
  "total_supply": 115591,
  "decimals": null,
  "token_type": "ERC721",
  "holder_count": 53660,
  "transfer_count": 116398,
  "icon_url": null,
  "urls": null,
  "volume_24h": null,
  "price": null,
  "previous_price": null,
  "market_cap": null,
  "on_chain_market_cap": null,
  "is_verified": null,
  "cmc_id": null,
  "cmc_slug": null,
  "gecko_id": null,
  "description": null,
  "create_time": "2024-01-20 05:58:29.000000",
  "update_time": "2024-01-20 05:58:29.000000",
  "block_number": 1153515
}
```

```csv
0xD5CB4A5009E9D9CDD58EF093182729D78C5D5A6E,Manta Fest,Manta,115591,,ERC721,53660,116398,,,,,,,,,,,,,,2024-01-20 05:58:29.000000,2024-01-20 05:58:29.000000,1153515
0x0DC808ADCE2099A9F62AA87D9670745ABA741746,Wrapped Ether,WETH,5133665930482359665722,18,ERC20,32961,1161654,https://s2.coinmarketcap.com/static/img/coins/64x64/2396.png,"{""website"": [""https://weth.io/""], ""explorer"": [""https://etherscan.io/token/0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2""]}",1487479300.00,2274.550500,2274.550500,0.00,11676782.41,true,2396,weth,weth,"WETH (WETH) is a cryptocurrency and operates on the Ethereum platform. WETH is a wrapped version of Ether, allowing for easier integration with DeFi protocols.",2024-01-04 15:41:00.000000,2024-01-04 15:41:00.000000,19025325
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.thehemera.com/hemera-indexer/data-class/generated-tables/tokens.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.