zora_v1_optimism

Tables

1155_Purchased_event

ERC-1155 NFT purchase events from Zora protocol on Optimism, tracking mints with buyer address, token ID, quantity, and payment value in wei. Used for analyzing Zora NFT sales activity and creator revenue.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_minter`	`STRING`	Address authorized to mint tokens in the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; 66-character hex string for Aptos.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.
`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	in_value	in_minter	in_sender	log_index	in_tokenId	in_quantity	block_number	block_timestamp	transaction_hash
0x9f775588d77821055ef4ecf8d126a5fce0c57b56	false	777000000000000	0x3678862f04290e565cca2ef163baeb92bb76790c	0xb7831d978dd131019703c894439a1a3a5902bcec	3	1	1	111777763	2023-11-05T03:18:23.000Z	0x9f5d851a91f617f500758eaea592dd6e2b985072d711baef61849b2237f30c4e
0x9f775588d77821055ef4ecf8d126a5fce0c57b56	false	777000000000000	0x3678862f04290e565cca2ef163baeb92bb76790c	0x4f5695d12c30eae448c5f38023b12572e483453c	20	1	1	111805944	2023-11-05T18:57:45.000Z	0x38eb72c8cf9120a9427b1ffc2162aa4c62c5a903154d7684dce2a6518715b4f5
0x9f775588d77821055ef4ecf8d126a5fce0c57b56	false	777000000000000	0x3678862f04290e565cca2ef163baeb92bb76790c	0xd180dd68759a1570a66439548319b94240f309c0	6	1	1	111806257	2023-11-05T19:08:11.000Z	0xcb45e314f69c6d64f642a1c1bb0fa3d55e80ff33d6823d79d05c69bc8bb72ef3

Example Query

Query with partition filter

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

721Drop_MintFeePayout_event

Mint fee payment events from Zora’s ERC-721 drop contracts on Optimism, recording fee amounts and recipient addresses for each successful NFT mint transaction. Useful for analyzing protocol revenue distribution and tracking platform fees across Zora NFT collections.

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_mintFeeAmount`	`STRING`	Fee amount paid for minting an NFT from the Zora 721Drop contract, denominated in wei. Typically represents a platform or protocol fee (e.g., 0.000777 ETH in samples).
`in_mintFeeRecipient`	`STRING`	Wallet address that receives the minting fee from the ERC-721 NFT drop on Optimism. Hex-encoded, 0x-prefixed 40-character string identifying the fee beneficiary for each mint transaction.
`in_success`	`BOOL`	Boolean flag indicating whether the operation completed successfully.

Sample Data

address	removed	log_index	in_success	block_number	block_timestamp	in_mintFeeAmount	transaction_hash	in_mintFeeRecipient
0x31eb3dd0e75dac10d07e8c6cfa54bcb7ae1774ce	false	5	true	108319391	2023-08-17T01:59:19.000Z	777000000000000	0x076c2080b9ccdd382a97925790845830e16923714fbb992761f3122828a4568e	0x7a810dcd0f8d83b20212326813db6ef7e9fd030c
0x31eb3dd0e75dac10d07e8c6cfa54bcb7ae1774ce	false	7	true	108330680	2023-08-17T08:15:37.000Z	777000000000000	0x332f464899debff807cef60b683b70ae02634c9b5b03c000e6f23b38898dee33	0x7a810dcd0f8d83b20212326813db6ef7e9fd030c
0x31eb3dd0e75dac10d07e8c6cfa54bcb7ae1774ce	false	7	true	108347258	2023-08-17T17:28:13.000Z	777000000000000	0x79e9219e2155d409a81a70d42dacaa2207b60bba1d6e5f7839a38f44eea89ca9	0x7a810dcd0f8d83b20212326813db6ef7e9fd030c

Example Query

Query with partition filter

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

721Drop_Sale_event

NFT (ERC-721) sale events from Zora v1 drop contracts on Optimism, capturing mints and secondary purchases with buyer address, token ID, quantity, and price per token. Useful for tracking collection mint progress and analyzing pricing patterns across Zora drops.

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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_quantity`	`STRING`	Number of tokens or units being purchased, minted, transferred, or involved in the transaction. Numeric string representation in smallest denomination.
`in_pricePerToken`	`STRING`	Price paid per NFT token in the sale denominated in wei (smallest unit of ETH). Sample values show both free mints (0) and paid mints (e.g., 2560000000000000 wei = 0.00256 ETH).
`in_firstPurchasedTokenId`	`STRING`	Token ID of the first NFT in the purchase sequence, useful for tracking multi-token mints. Represented as a numeric string identifier (e.g., ‘16344’, ‘86’) assigned by the ERC-721 contract.

Sample Data

in_to	address	removed	log_index	in_quantity	block_number	block_timestamp	transaction_hash	in_firstPurchasedTokenId
0xd2275771391cae5afbc05b4160889c4c89af4d12	0x31eb3dd0e75dac10d07e8c6cfa54bcb7ae1774ce	false	11	1	113685761	2023-12-19T07:18:19.000Z	0xa0e36c31209540a02be66b2814e210c6fe437dd1c77845e19ea049422fc28a60	16344
0x983e82aa3e9ebdcf8cd3900469ee6a78d72afcf8	0x3b5f256ebded2412016edb7c7f646d61e7796d8a	false	7	1	113674983	2023-12-19T01:19:03.000Z	0x5eda503112abe5646e05b598279e2199f16c86fac38ce9ba92b33f3763d5cf75	86
0xf6418efa0724e6af3dffb809a77934b53bc0f9b1	0x3ef0d6baa5d41a32797b02d472dea5ea780b5fff	false	13	1	113698253	2023-12-19T14:14:43.000Z	0xb3a225387db351e333e7f6d4f224ddc094db027745615fd8b0e274473c9abf3f	110

Example Query

Query with partition filter

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

Factory1155_SetupNewContract_event

ERC-1155 contract deployment events from Zora’s factory on Optimism, capturing new NFT collection creation with metadata URIs, creator addresses, admin roles, and royalty configurations (basis points, recipient address, mint schedule).

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_newContract`	`STRING`	Address of the newly deployed ERC-1155 contract created by the factory. Hex-encoded, 0x-prefixed, 42-character string.
`in_creator`	`STRING`	Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
`in_defaultAdmin`	`STRING`	Address designated as the default administrator for the newly created contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_contractURI`	`STRING`	URI pointing to off-chain contract-level metadata. IPFS URI format with either CIDv0 (Qm-prefixed) or CIDv1 (bafkrei-prefixed) content identifiers.
`in_name`	`STRING`	Name or label identifier for the entity being created, registered, or updated in the event.
`in_defaultRoyaltyConfiguration`	`STRUCT<royaltyMintSchedule STRING, royaltyBPS STRING, royaltyRecipient STRING>`	Default royalty settings for the newly created ERC-1155 contract. Contains three fields: royaltyMintSchedule (mint schedule integer), royaltyBPS (royalty percentage in basis points), and royaltyRecipient (address receiving royalty payments, hex-encoded with 0x prefix).

Sample Data

address	in_name	removed	log_index	in_creator	block_number	in_contractURI	in_newContract	block_timestamp	in_defaultAdmin	transaction_hash	in_defaultRoyaltyConfiguration
0x78b524931e9d847c40bcbf225c25e154a7b05fda	Starknet AİRDROP	false	45	0xff2aa81a57feb17c692d06310fc76ee0dfb55dc4	113014946	ipfs://bafkreihroa6yihaqq57gcf24pfoqlcvlusssutq55fparn2nrrqvtmqg54	0x0ba80cc462c7042c72b880b21253cf2e0e686cc7	2023-12-03T18:37:49.000Z	0xff2aa81a57feb17c692d06310fc76ee0dfb55dc4	0x687a87f84c7a292f3a2ed2e460cd1d39bcecdda17edac367b4805eca26682a0a	{“royaltyBPS”:“0”,“royaltyRecipient”:“0xff2aa81a57feb17c692d06310fc76ee0dfb55dc4”,“royaltyMintSchedule”:“0”}
0x78b524931e9d847c40bcbf225c25e154a7b05fda	Puppy Dreams and Crypto Hopes	false	1	0x5b4c155a9fe7cb63e9ce8194cf56d51661ef7366	113013033	ipfs://bafkreih3by5sfopddshbcgk3glmw456ft7ijlkr5oja7htokuldurrmqma	0x191046add33f4b553b97f177d5fb74882751aafd	2023-12-03T17:34:03.000Z	0x5b4c155a9fe7cb63e9ce8194cf56d51661ef7366	0xafcf7f2a32a07137e88125d7d0e9325986e7178e21f7304cf9c0f2151ff2ee26	{“royaltyBPS”:“500”,“royaltyRecipient”:“0x5b4c155a9fe7cb63e9ce8194cf56d51661ef7366”,“royaltyMintSchedule”:“0”}
0x78b524931e9d847c40bcbf225c25e154a7b05fda	In Safe Hands: The Trust of Crypto	false	3	0xe80864820ac94f0d027f78cb418de5810d9ccd65	113015172	ipfs://bafkreiejs3wh7cjxpwr3xld43rxx6rocoepveawuir42lvk7l2hb2pfyre	0x4af87839fa252899ea9a88b5dc8b173931eede18	2023-12-03T18:45:21.000Z	0xe80864820ac94f0d027f78cb418de5810d9ccd65	0x8f249fe8182832cf8143f4bc5e111276b84566a87c8c1fc98c23d2b5bc9f919b	{“royaltyBPS”:“500”,“royaltyRecipient”:“0xe80864820ac94f0d027f78cb418de5810d9ccd65”,“royaltyMintSchedule”:“0”}

Example Query

Query with partition filter

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

Factory721_CreatedDrop_event

NFT edition creation events from Zora’s ERC-721 factory contract on Optimism, recording new drop deployments with creator address, edition size, and deployed contract address for tracking Zora protocol NFT launches.

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_creator`	`STRING`	Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
`in_editionContractAddress`	`STRING`	Contract address of the newly created NFT edition. Hex-encoded, 0x-prefixed, 42-character string.
`in_editionSize`	`STRING`	Maximum number of NFTs that can be minted in the edition. String-encoded integer, with 18446744073709551615 representing unlimited supply.

Sample Data

address	removed	log_index	in_creator	block_number	in_editionSize	block_timestamp	transaction_hash	in_editionContractAddress
0x7d1a46c6e614a0091c39e102f2798c27c1fa8892	false	7	0xfe977e8fceb9c976b735eb66475c8babcc67e397	109903860	1000000	2023-09-22T18:14:57.000Z	0xfa0e88c7d5c10e9912235395273d0eb6731f6873b98e74e364f05dd73c06673d	0xc437627a5db1417eccb6f537c684fa7077b6503f
0x7d1a46c6e614a0091c39e102f2798c27c1fa8892	false	8	0x6cb82e6732d3cc70acf54eb795168aae6650fd2e	109876476	18446744073709551615	2023-09-22T03:02:09.000Z	0xb0213c256600c16a56cf7587e093d81d35e7b95fd662a72e59cb92eb92e09eae	0x72c2e184507b8a3d897ad3cfccf8fe4680e619a4
0x7d1a46c6e614a0091c39e102f2798c27c1fa8892	false	8	0xf88eff6d9e3ce72ea8ead9630eafcab8c572c190	109911361	18446744073709551615	2023-09-22T22:24:59.000Z	0x48184d8d6d8285c0dfa2e46c48a652a5eee21f9c36e66f74919fe297d2449174	0x99a5cbb044c365f9f45b38fca994e37e3ddcdad6

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

1155_Purchased_event

721Drop_MintFeePayout_event

721Drop_Sale_event

Factory1155_SetupNewContract_event

Factory721_CreatedDrop_event

​Tables

​1155_Purchased_event

​721Drop_MintFeePayout_event

​721Drop_Sale_event

​Factory1155_SetupNewContract_event

​Factory721_CreatedDrop_event

Tables

1155_Purchased_event

721Drop_MintFeePayout_event

721Drop_Sale_event

Factory1155_SetupNewContract_event

Factory721_CreatedDrop_event