bsc

Tables

ERC1155_TransferBatch_event

TransferBatch events from ERC-1155 (Multi-Token Standard) contracts containing operator, sender, recipient, and arrays of token IDs with corresponding quantities for batch transfers. Used for tracking multi-token movements including mints, burns, and transfers in gaming assets, collectibles, and semi-fungible tokens.

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_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.
`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_ids`	`ARRAY<STRING>`	Array of token identifiers involved in the batch operation. Numeric strings representing token IDs, which may be sequential integers for fungible positions or large integers for ERC-1155 token types.
`in_values`	`ARRAY<STRING>`	Array of token quantities transferred in the batch operation corresponding to the token IDs in in_ids. Numeric strings representing amounts, with precision and scale determined by the specific token contract implementation.

Sample Data

in_to	in_ids	address	in_from	removed	in_values	log_index	in_operator	block_number	block_timestamp	transaction_hash
0x08b8267ff800ea536748c473e941b424c20f2cd7	[“34005”]	0xb3e968ba01a78ea489292130bcf8bbe6a64be648	0x3bd6a582698eccf6822db08141818a1a8512c68d	false	[“1”]	378	0x3bd6a582698eccf6822db08141818a1a8512c68d	7797620	2021-05-28T08:40:18.000Z	0x36f58e4626b30dc94d3f32845fe65a7bd2268aaaa44f40ec447db5740c5eba73
0x1043506e05f37c45dc922dffa29e10de47e29d4c	[“14006”]	0xb3e968ba01a78ea489292130bcf8bbe6a64be648	0x3bd6a582698eccf6822db08141818a1a8512c68d	false	[“1”]	792	0x3bd6a582698eccf6822db08141818a1a8512c68d	7792019	2021-05-28T04:00:03.000Z	0x750280828fa4597e8f0947fcb8e3036b7d362ca99a606558a7c14da5b9144ecf
0x1681d8fc82928ae37c2f584bb7ce870ef35bd438	[“43895”]	0x060dd632f7dd45cb97a86376863d623d6756e848	0x679e19503f8ded85ffcd21ad33a214b9481df9cd	false	[“1”]	258	0x679e19503f8ded85ffcd21ad33a214b9481df9cd	7805662	2021-05-28T15:22:41.000Z	0x7e0a54863ae413f90bc6b9381240a5e27e1c6a7125ea83915db4aa69b993f1f1

Example Query

Query with partition filter

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

ERC1155_TransferSingle_event

ERC-1155 (Multi Token Standard) single token transfer events emitted when one token ID is transferred between addresses. Contains operator, sender, recipient, token ID, and transfer amount for tracking individual NFT and semi-fungible token movements within multi-token contracts.

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_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.
`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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_id	in_to	address	in_from	removed	in_amount	log_index	in_operator	block_number	block_timestamp	transaction_hash
0	0x00290ad511cb5b737d76f8493a141ea05e14c813	0x4169b51b5907968aca1dd2a9875500d9c40e4950	0x0000000000000000000000000000000000000000	false	100	275	0x00290ad511cb5b737d76f8493a141ea05e14c813	19878258	2022-07-26T04:29:24.000Z	0x433aa8daba3fa0079c24fa7ab811bfdbe7ef2612504f1c7cd8865b423f56564a
0	0x4169b51b5907968aca1dd2a9875500d9c40e4950	0x4169b51b5907968aca1dd2a9875500d9c40e4950	0x00290ad511cb5b737d76f8493a141ea05e14c813	false	100	373	0x00290ad511cb5b737d76f8493a141ea05e14c813	19878282	2022-07-26T04:30:36.000Z	0xad7f03f522fc5b3fc66437ba21535d76f54be72409af314c29e2bf09d74e4c6d
33	0x0037dd60f7a4393587b6dce2c6dddd4508d38e32	0x2e640603e6bb000131991560c5bb7d6c6a9212e1	0x0000000000000000000000000000000000000000	false	1	231	0x0037dd60f7a4393587b6dce2c6dddd4508d38e32	19885413	2022-07-26T10:27:17.000Z	0x0103ad32d44e22bc14f23d24d15852b1c71c4073c023a63fe67f28bd39844e18

Example Query

Query with partition filter

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

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
0x0000000000000000000000000000000000000000	0x009cf7bc57584b7998236eff51b98a168dcea9b0	0xc24e305699657404643158aa60a960b6d4745988	false	0	17	2703104	2020-12-01T01:00:14.000Z	0xe79474f4b152fc88b3999c14d7950cfaf42498d5469f267464766aff117c94bf
0xdfc12c3022e52930e3e6b010d79f35e7b6773c06	0x009cf7bc57584b7998236eff51b98a168dcea9b0	0x0000000000000000000000000000000000000000	false	53565911597326777	6	2703104	2020-12-01T01:00:14.000Z	0xe2908b4eecf8c92d9c99b1e9b1d946865ef306b9c09e5c9729b26b0426285ebb
0xb5c098961105ce5c5a231822d788281190c1b0d8	0x009cf7bc57584b7998236eff51b98a168dcea9b0	0x0000000000000000000000000000000000000000	false	3014857194427015414369	5	2704128	2020-12-01T01:51:26.000Z	0x094c371404c06b9ebceb608e5e41d26c37ad641c9c4a2d89753c1a8e6c68e8dd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bsc.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

in_to	address	in_from	removed	log_index	in_tokenId	block_number	block_timestamp	transaction_hash
0x43c070994f3ae32daed20aded44d6171b35fdfeb	0x8abd9a383fb68c9354ada2c7783f4f12a9f7f8fe	0x630e1bcc7a74952eecb2bb24068a4d7fc5d5b34f	false	233	29690	5095779	2021-02-22T08:43:53.000Z	0x2e714eb8c95c72d869029672c1326a88f9d2629ce72eba9e8c1cf79ef45b664f
0x473df1fa25d31cd21fb33f6f6d333ae753597e7c	0x5e74094cd416f55179dbd0e45b1a8ed030e396a1	0x0000000000000000000000000000000000000000	false	86	796587	5101960	2021-02-22T13:54:39.000Z	0xbd18d20dd657d456e93f2e35e1b2a2779dda9151d145ac46542c89b2fc96384a
0x77297bc8ca478fe348315aeb47a053c8984371bb	0x5e74094cd416f55179dbd0e45b1a8ed030e396a1	0x0000000000000000000000000000000000000000	false	118	785576	5086427	2021-02-22T00:51:46.000Z	0x263510fb7e9c6f4a567a75724da0cd91c288771cc462886025ef8771302110ed

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ERC1155_TransferBatch_event

ERC1155_TransferSingle_event

ERC20_Transfer_event

ERC721_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ERC1155_TransferBatch_event

​ERC1155_TransferSingle_event

​ERC20_Transfer_event

​ERC721_Transfer_event

Tables

ERC1155_TransferBatch_event

ERC1155_TransferSingle_event

ERC20_Transfer_event

ERC721_Transfer_event