ERC721 Token Transfers

ERC721 Token Transfers table records all the transfer events of ERC721 tokens. Each row represents a single token transfer, including the token address, token ID, sender (from_address), recipient (to_address) and the transaction and block details associated with the transfer.

ETL data class

Column Name	Data Type	Note
token_address	str
token_id	int
from_address	str
to_address	str
transaction_hash	str
log_index	int
block_timestamp	timestamp
block_number	int
block_hash	str

Examples

{
  "token_address": "0x5dac7efe0b4cd2cabdd350efc0c69bcaa81e76c6",
  "token_id": 7228,
  "from_address": "0x0000000000000000000000000000000000000000",
  "to_address": "0xfbabacd8ef4deefa572cdc1a685781c2b551490e",
  "transaction_hash": "0xde75fa94443a7e3035a0ad4ed1bfb762aa9ec1cdf283cf86878246f0911e5a0d",
  "log_index": 3,
  "block_timestamp": "2023-10-29T03:34:19.000Z",
  "block_number": 435530,
  "block_hash": "0x68189ad6461faff3837f22571813eb507de3bdca2d1c9b596f233bd1fc8ff810"
}

0x5dac7efe0b4cd2cabdd350efc0c69bcaa81e76c6,7228,0x0000000000000000000000000000000000000000,0xfbabacd8ef4deefa572cdc1a685781c2b551490e,0xde75fa94443a7e3035a0ad4ed1bfb762aa9ec1cdf283cf86878246f0911e5a0d,3,2023-10-29T03:34:19.000Z,435530,0x68189ad6461faff3837f22571813eb507de3bdca2d1c9b596f233bd1fc8ff810,

Model in the Database

Column Name	Data Type	Note
token_address	bytea
token_id	numeric(78)
from_address	bytea
to_address	bytea
transaction_hash	bytea
log_index	bigint
block_timestamp	timestamp
block_number	bigint
block_hash	bytea

Examples

{
  "token_address": "\\x5dac7efe0b4cd2cabdd350efc0c69bcaa81e76c6",
  "token_id": 7228,
  "from_address": "\\x0000000000000000000000000000000000000000",
  "to_address": "\\xfbabacd8ef4deefa572cdc1a685781c2b551490e",
  "transaction_hash": "\\xde75fa94443a7e3035a0ad4ed1bfb762aa9ec1cdf283cf86878246f0911e5a0d",
  "log_index": 3,
  "block_timestamp": "2023-10-29 03:34:19.000000",
  "block_number": 435530,
  "block_hash": "\\x68189ad6461faff3837f22571813eb507de3bdca2d1c9b596f233bd1fc8ff810",
  "token_uri": null
}

\\x5dac7efe0b4cd2cabdd350efc0c69bcaa81e76c6,7228,\\x0000000000000000000000000000000000000000,\\xfbabacd8ef4deefa572cdc1a685781c2b551490e,\\xde75fa94443a7e3035a0ad4ed1bfb762aa9ec1cdf283cf86878246f0911e5a0d,3,2023-10-29 03:34:19.000000,435530,\\x68189ad6461faff3837f22571813eb507de3bdca2d1c9b596f233bd1fc8ff810,