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

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

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

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

{
  "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
}

{
  "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
}

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