# 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
```