zksyncera

Tables

ERC20_Transfer_event

ERC-20 token transfer events decoded from transaction logs, containing sender address, recipient address, and token amount. Primary source for tracking fungible token flows and wallet holdings across EVM-compatible blockchains.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xe3d4db769bddf24bc883df105e194a427c7f391f	0x000000000000000000000000000000000000800a	0x621425a1ef6abe91058e9712575dcc4258f8d091	false	16117929886556217	11	10821761	2023-08-09T21:07:12.000Z	0x67560d72834e764dfba28c879d22462c92c62b3856e3303a098fd29f7d85b712
0x927244310b001538cd0a0ca560a11c0fbf9a2171	0x000000000000000000000000000000000000800a	0x0000000000000000000000000000000000008001	false	847129250000000	34	10793514	2023-08-09T13:09:20.000Z	0x9bef42501979c3b31feaf93498115418e588d364447c53da8746c78258969507
0x0000000000000000000000000000000000008001	0x000000000000000000000000000000000000800a	0x22c593f30abe9bca9ddc075c2d0a9f4f602e204a	false	873982750000000	54	10793514	2023-08-09T13:09:20.000Z	0x457a7c7aea66e6ebc2223da51e3d206fa3e0255645cfe94c0105a100bf6dca08

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zksyncera.ERC20_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ERC721_Transfer_event

Non-fungible token (NFT) transfer events emitted by ERC-721 compliant smart contracts, capturing the movement of unique tokens between addresses. Contains sender, recipient, token ID, and contract address for tracking NFT ownership changes and marketplace activity across chains.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x28a487240e4d45cff4a2980d334cc933b7483842	false	2	9177	2023-03-16T02:51:53.000Z	0xd0175cac5889cce68d59b1d3610b479b522f08bb05727c92a4d5c9209614598c
0x000000000000000000000000000000000000800a	false	4	9177	2023-03-16T02:51:53.000Z	0xd0175cac5889cce68d59b1d3610b479b522f08bb05727c92a4d5c9209614598c
0x000000000000000000000000000000000000800a	false	0	9177	2023-03-16T02:51:53.000Z	0xd0175cac5889cce68d59b1d3610b479b522f08bb05727c92a4d5c9209614598c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zksyncera.ERC721_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

ERC20_Transfer_event

ERC721_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ERC20_Transfer_event

​ERC721_Transfer_event

Tables

ERC20_Transfer_event

ERC721_Transfer_event