xai

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

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x299e90b375ceea4c27bae0ffdc7105f0bf0b5be4	false	1	990642	2024-02-16T07:23:24.000Z	0x11c1c890f6150ec119570cc1f6b074ff527f92572ec080c389cbf55c5de38c29
0x299e90b375ceea4c27bae0ffdc7105f0bf0b5be4	false	1	992578	2024-02-16T08:32:08.000Z	0x34b384dede4e1356cae5f3e672aa0e3b03358a2cc2acffb05bd144e8188ced55
0x299e90b375ceea4c27bae0ffdc7105f0bf0b5be4	false	1	993740	2024-02-16T09:15:03.000Z	0x3914bbd6ae42a8cf84ab492a8f173093a708d363586b86031cc09dc5c9562b3a

Example Query

Query with partition filter

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

worldmobilechain xdc

⌘I

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ERC20_Transfer_event

​Tables

​ERC20_Transfer_event

Tables

ERC20_Transfer_event