arbitrum

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
0x204636753b992df51dcdd983abd175f79e29e9e5	[“0”,“1”,“2”,“3”,“4”,“5”,“6”,“7”]	0xb75db4ef3615e954b29c690b76af994ad41d04d5	0x0000000000000000000000000000000000000000	false	[“0”,“1”,“0”,“0”,“0”,“1”,“0”,“0”]	1	0x204636753b992df51dcdd983abd175f79e29e9e5	9039590	2022-04-01T15:01:20.000Z	0x3c6713637d1b44ca752a0f66ea6e610f4fd9ec285d2b9144e44eea47ec4cf98c
0x204636753b992df51dcdd983abd175f79e29e9e5	[“0”,“1”,“2”,“3”,“4”,“5”,“6”,“7”]	0xb75db4ef3615e954b29c690b76af994ad41d04d5	0x0000000000000000000000000000000000000000	false	[“0”,“0”,“0”,“1”,“0”,“0”,“1”,“0”]	1	0x204636753b992df51dcdd983abd175f79e29e9e5	9036876	2022-04-01T14:14:49.000Z	0x47b176ceb793159bc3e1d8e07da4db362be328866627d1ed994ecfd300888376
0x204636753b992df51dcdd983abd175f79e29e9e5	[“0”,“1”,“2”,“3”,“4”,“5”,“6”,“7”]	0xb75db4ef3615e954b29c690b76af994ad41d04d5	0x0000000000000000000000000000000000000000	false	[“0”,“0”,“0”,“0”,“0”,“0”,“2”,“0”]	1	0x204636753b992df51dcdd983abd175f79e29e9e5	9037181	2022-04-01T14:19:49.000Z	0xea481235674ef685a6851a02f8752ad72e24d211b36dc3dae2bbe1f23a09f045

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.arbitrum.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
59429887388664532463289593558592718497307830835221633233702214901411118622667	0x0000000000000000000000000000000000000000	0x007f7735baf391e207e3aa380bb53c4bd9a5fed6	0x73afef607da2dbd27bd9c83e9e9297ae9ca1fd2b	false	324616581019673433576	0	0x73afef607da2dbd27bd9c83e9e9297ae9ca1fd2b	149566470	2023-11-12T04:02:56.000Z	0x54dcf50ab3fbd4acff6f6d02d7a1e0bebf0309cd3212ddd46fbabb1a8dea59b9
1	0x19e02b992c0295d27eecff941d5dbfaf85409d86	0x051e96707627de9b200d2f3b91450e3383bb359d	0x86aff5275f1cd92eb580e97ab143451201c51f82	false	1	0	0x86aff5275f1cd92eb580e97ab143451201c51f82	149818124	2023-11-12T22:50:42.000Z	0xc0c3b97cd5617e9f9b93db9577c53f9d56406d2bc1623ed62f82c4c733c59c70
7237005577332262213976460295956684772459197514154395736821835213215016956933	0x0000000000000000000000000000000000000000	0x06a2e5ff1c358368fd9a061ca01d0df6512012f3	0x22deaf5120d862592a748295750e56c999f07cb8	false	50000000000000000	4	0x22deaf5120d862592a748295750e56c999f07cb8	149784331	2023-11-12T20:12:49.000Z	0x6d8cb27b036e4918f10998d1439bd6812b33401d6d8741ba8e98ba0a49933b5b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.arbitrum.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
0x57c4417d12a76f7c75ba5db7fb56eb672231f1a3	0x000000000000012def132e61759048be5b5c6033	0x0000000000000000000000000000000000000000	false	3185325000000000000000	12	292254428	2025-01-05T13:31:29.000Z	0xf04d75a6ff33fa3318f8dac2f0810c9513722578450bbbcfc1f49a22d6607f9d
0xdb5f61954c9db2626590fb83495861b1ed6909f6	0x000000000000012def132e61759048be5b5c6033	0x0000000000000000000000000000000000000000	false	2517357700000000000000	6	292269231	2025-01-05T14:33:22.000Z	0x720cfe89a509a01d3e4503a7a4aa8c0bf41730f1973e852bfaef20865147fdd6
0xf08c358b1355172c7531660d60166b9061c419d1	0x000000000000012def132e61759048be5b5c6033	0x0000000000000000000000000000000000000000	false	1012959767765000000000	2	292067502	2025-01-05T00:30:04.000Z	0x1ca1a749f530c5b4c560ea16768ab3e52ba18f56f74c463673a42ef028a08455

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.arbitrum.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	block_number	block_timestamp	transaction_hash
0x000000000026839b3f4181f2cf69336af6153b99	false	226338516	2024-06-27T18:13:40.000Z	0xceb5417ebafec73f9e7ae195dcc38d4a6d4b026052425b9399387e253c981056
0x000000000026839b3f4181f2cf69336af6153b99	false	226342362	2024-06-27T18:29:46.000Z	0x558bfdaff25d18833df8cb6c06dc0b86038f41efb9b132c642223eea3609dc6f
0x0000206329b97db379d5e1bf586bbdb969c63274	false	226403509	2024-06-27T22:45:11.000Z	0xd851be42aa2684530f855b63bde26889963274f0057b5529121b0f56a7dcd14a

Example Query

Query with partition filter

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