ERC20 Token Transfers

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

ETL data class

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

Examples

{
  "token_address": "0x80137510979822322193fc997d400d5a6c747bf7",
  "wallet_address": "0xcaab1bd9025a576cee4757506d81b32e4724f9ef",
  "balance_of": 9834981273804,
  "transaction_hash": null,
  "block_timestamp": "2023-11-16T01:06:59.000Z",
  "block_number": 590166,
  "block_hash": null
}

0xf417f5a458ec102b90352f697d6e2ac3a3d2851f,0xdc5aabac622b5f472ba377c62522e97836a37a4f,0xbad4ccc91ef0dfffbcab1402c519601fbaf244ef,10872268,0x83c246999b005ba42738cdbf3b585d5c212ab9726b2cdf4dc9b67f2e93df4390,10,2023-10-29T03:34:19.000Z,435530,0x68189ad6461faff3837f22571813eb507de3bdca2d1c9b596f233bd1fc8ff810

Model in the Database

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

Examples

{
  "token_address": "\\xf417f5a458ec102b90352f697d6e2ac3a3d2851f",
  "from_address": "\\xdc5aabac622b5f472ba377c62522e97836a37a4f",
  "to_address": "\\xbad4ccc91ef0dfffbcab1402c519601fbaf244ef",
  "value": 10872268,
  "transaction_hash": "\\x83c246999b005ba42738cdbf3b585d5c212ab9726b2cdf4dc9b67f2e93df4390",
  "log_index": 10,
  "block_timestamp": "2023-10-29 03:34:19.000000",
  "block_number": 435530,
  "block_hash": "\\x68189ad6461faff3837f22571813eb507de3bdca2d1c9b596f233bd1fc8ff810"
}

\\xf417f5a458ec102b90352f697d6e2ac3a3d2851f,\\xdc5aabac622b5f472ba377c62522e97836a37a4f,\\xbad4ccc91ef0dfffbcab1402c519601fbaf244ef,10872268,\\x83c246999b005ba42738cdbf3b585d5c212ab9726b2cdf4dc9b67f2e93df4390,10,2023-10-29 03:34:19.000000,435530,\\x68189ad6461faff3837f22571813eb507de3bdca2d1c9b596f233bd1fc8ff810