> For the complete documentation index, see [llms.txt](https://docs.thehemera.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.thehemera.com/hemera-indexer/data-class/generated-tables/erc20-token-transfers.md).

# 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

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

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

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

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