optimism

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	in_operator	block_number	block_timestamp	transaction_hash
0x0000000000000000000000000000000000000000	[“1”]	0x2f05e799c61b600c65238a9df060caba63db8e78	0xef1a36506cc85ba8e197f0580437c382aaf305a3	false	[“1”]	0xef1a36506cc85ba8e197f0580437c382aaf305a3	61493724	2023-01-07T02:55:55.000Z	0x6607f2e3c431b37a85d04f0c3a770cd8ae59e317e402383ba9bc1ef038502ce5
0x0000000000000000000000000000000000000000	[“1”]	0x2f05e799c61b600c65238a9df060caba63db8e78	0x5cd48eefb57b200e99fc6a4ceb489d57641aaaae	false	[“1”]	0x5cd48eefb57b200e99fc6a4ceb489d57641aaaae	61586735	2023-01-07T05:40:27.000Z	0x95de84e682772fadcab882898807c1e45e1ae6a76dbfa87cdf7ce8d9edf43ce0
0x0000000000000000000000000000000000000000	[“1”]	0x2f05e799c61b600c65238a9df060caba63db8e78	0xd3849a7f181d72da2bee4da9ba6c61d4aa4087ff	false	[“1”]	0xd3849a7f181d72da2bee4da9ba6c61d4aa4087ff	61848293	2023-01-07T12:33:27.000Z	0x72b55d27ca00977c444d3e4100e64dcb03f4a3517c6fd4d616973ecae0173167

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.optimism.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	in_operator	block_number	block_timestamp	transaction_hash
5	0xf68d2bfcecd7895bba05a7451dd09a1749026454	0x69712823736db25915fe84043efb0e9dfee17853	0x0000000000000000000000000000000000000000	false	1	0xf68d2bfcecd7895bba05a7451dd09a1749026454	15797526	2022-07-26T04:00:15.000Z	0xe22aa435dcb5db16e0923aa0e3fa28154c2da72c1b242650cda98351b65977c3
5	0xdc7f990ec4d2f2470bdeafcabb9ae2c17cc11312	0x6bada9cc1af5b684fb1662e39760925e6475aee4	0x0000000000000000000000000000000000000000	false	1	0xdc7f990ec4d2f2470bdeafcabb9ae2c17cc11312	15827967	2022-07-26T11:55:55.000Z	0x6e52f6a569838ac223206075415be7cc5014ab965ed1ee29c133c22f2d1f9ab9
0	0x1dfc3a5ade0a66b409276722eb03a64bdf429518	0x6bada9cc1af5b684fb1662e39760925e6475aee4	0x0000000000000000000000000000000000000000	false	1	0x1dfc3a5ade0a66b409276722eb03a64bdf429518	15840108	2022-07-26T13:33:18.000Z	0xdf8442d85365dece4e11f9635e9f3666f8f176de0902aac5317940af4b492abf

Example Query

Query with partition filter

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

address	removed	block_number	block_timestamp	transaction_hash
0xfa14e1157f35e1dad95dc3f822a9d18c40e360e2	false	62481417	2023-01-08T12:51:17.000Z	0x855b61585a8325cb110e63d436c2d4e36f4ad018ac7902679c97f515bc53bffa
0xfa14e1157f35e1dad95dc3f822a9d18c40e360e2	false	62177353	2023-01-08T03:19:10.000Z	0x9a01df961df479f8c70d90784f5512fa2723cadae7600f2e5e8a235545f07963
0xfa14e1157f35e1dad95dc3f822a9d18c40e360e2	false	62232449	2023-01-08T05:15:43.000Z	0x1f8f50e126f2b9be199129db75f8ee81378ace3595127932f12f5e1c39ee2cc8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.optimism.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
0x24b74bf5e15af860fb8874c6a9f2047e417b5683	0x0000000000771a79d0fc7f3b7fe270eb4498f20b	0x0000000000000000000000000000000000000000	false	131	27657	112658176	2023-11-25T12:25:29.000Z	0xab1d3bc179b801fe0225c7cf9c1b0c7171ce957e377960d2c0b15dff8064d929
0xd55a886d1f6f993b94f20842b253c156c157fd1d	0x0000000000771a79d0fc7f3b7fe270eb4498f20b	0x0000000000000000000000000000000000000000	false	152	28432	112674816	2023-11-25T21:40:09.000Z	0x4b08a20964c0a48c53be4d5e5bdcd8420ca52cd1c540e4c1641d1bed04484d28
0x0372233bbd180bdf88ac927bb5258adaf59ecba8	0x0000000000771a79d0fc7f3b7fe270eb4498f20b	0x0000000000000000000000000000000000000000	false	133	27837	112665601	2023-11-25T16:32:59.000Z	0x64519e6d80b0c9300f62cf3da7f86619249914bd0fa7404dca180c247911a6f5

Example Query

Query with partition filter

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