gnosis

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
0x6353daf87feb3e4636e38762165870107ad8be53	[“19207734894064092283215989546873475702255108270422835439765274766342808730252”,“10694104156469839210049049189444194429474457301271177140145182239145670261871”]	0xceafdd6bc0bef976fdcd1112955828e00543c0ce	0x0000000000000000000000000000000000000000	false	[“1000000000000000000”,“1000000000000000000”]	10	0x6353daf87feb3e4636e38762165870107ad8be53	18928959	2021-11-06T09:07:10.000Z	0xaf86b41f7345814a32922233c7709cff12fa6d2c58a614a08e1c2db413886f6c
0x9083a2b699c0a4ad06f63580bde2635d26a3eef0	[“19207734894064092283215989546873475702255108270422835439765274766342808730252”,“10694104156469839210049049189444194429474457301271177140145182239145670261871”]	0xceafdd6bc0bef976fdcd1112955828e00543c0ce	0x6353daf87feb3e4636e38762165870107ad8be53	false	[“0”,“0”]	13	0x6353daf87feb3e4636e38762165870107ad8be53	18928959	2021-11-06T09:07:10.000Z	0xaf86b41f7345814a32922233c7709cff12fa6d2c58a614a08e1c2db413886f6c
0x7f2afd483d3ba5af484333613db3b7eff9cfdaa3	[“19207734894064092283215989546873475702255108270422835439765274766342808730252”,“10694104156469839210049049189444194429474457301271177140145182239145670261871”]	0xceafdd6bc0bef976fdcd1112955828e00543c0ce	0x9083a2b699c0a4ad06f63580bde2635d26a3eef0	false	[“0”,“0”]	14	0x9083a2b699c0a4ad06f63580bde2635d26a3eef0	18928959	2021-11-06T09:07:10.000Z	0xaf86b41f7345814a32922233c7709cff12fa6d2c58a614a08e1c2db413886f6c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gnosis.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
530	0x6897abe0fd62b589260784b21f4ca3f78a0d8017	0x13a24ba31a6f81b4b4f8e9759b8bda49bd5904a1	0xf833660d4131f6cb847b06aab075851228bfa383	false	1	5	0x5baa93ec45b95e116275a99e912e484dab3c58eb	20100660	2022-01-14T10:46:10.000Z	0xd2c2a316f75606e86793737e2197c094ffb32ed8a3738481d7063dcb9351d114
986	0xa51154bda978962086c2b683fb17952d2e104134	0x13a24ba31a6f81b4b4f8e9759b8bda49bd5904a1	0xe49d0d8cf01ea366d804cc84738a768f0b8b175e	false	1	18	0x8b90560963cf5625384e6e642c4979e6a1c38b04	20103015	2022-01-14T14:02:25.000Z	0x01f5b59f2d03d218c22f4b7612b4f12d669ac0065284e80ca27fbdff128c56d5
986	0xe49d0d8cf01ea366d804cc84738a768f0b8b175e	0x13a24ba31a6f81b4b4f8e9759b8bda49bd5904a1	0x7663697900dd93a6d4722bc150d8e3a03c7b4866	false	1	6	0x8b90560963cf5625384e6e642c4979e6a1c38b04	20102911	2022-01-14T13:53:45.000Z	0xe456533c626d8b12af83db1292304c2814a7d13ef44f7813f78df399434c4c0e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gnosis.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
0xff951073cf2ccdbef1028267913398441f5b9e31	0x4b78a47532d9e966574d30189b3de734a232a78a	0x25acf48da50e087ad9414e3ff53535964c89492a	false	1000000000000000000	1	8600124	2020-02-26T20:16:50.000Z	0xf900dcc5f11b423af6ed025de59ee5627fd9febeac7d3ded90268cc5339a9b49
0x0b2e52575a59ec9a47989912011a14b59e34b7c1	0x4b78a47532d9e966574d30189b3de734a232a78a	0x25aa798a897db69f9200977fb6db0264e59bf7c7	false	1000000000000000000	1	8585865	2020-02-26T00:27:00.000Z	0xc7c82057b02f92489b739c854a25e5269aa45f2b11597dc527cdcdd390abbab5
0xf4a19207bf4114a6db2bd8e0ed2066cd33cecad8	0x4b78a47532d9e966574d30189b3de734a232a78a	0x25aab37361b64cc507fc8465c47d4d0fe5148661	false	1000000000000000000	1	8601124	2020-02-26T21:40:20.000Z	0x4cc62a5c4174300d4e7b2c733ce1372137a112de6c49a3a9836bfefaa5d13262

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gnosis.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
0x0fd6e8f2320c90e9d4b3a5bd888c4d556d20abd4	false	9221058	2020-04-03T11:28:10.000Z	0x22b06e4a6d222416f37f122eb33a84c63f92fed11dcf1748ddacb959a5d15b09
0x0fd6e8f2320c90e9d4b3a5bd888c4d556d20abd4	false	9217924	2020-04-03T06:53:10.000Z	0x4f5835ba8bab816508eb342fbdfc9cf75bfb63654b143571b37291f04f1ad25d
0x0fd6e8f2320c90e9d4b3a5bd888c4d556d20abd4	false	9219094	2020-04-03T08:35:50.000Z	0x3cf418803383870d10753283c13877e2c5807d1ecedd0bbbfa6bdf25c1c52576

Example Query

Query with partition filter

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