zora_v1_ethereum

Tables

1155_Purchased_event

ERC-1155 token purchase events from Zora v1 protocol on Ethereum, capturing minter addresses, token IDs, quantities, and payment values in wei. Used for analyzing NFT minting activity and revenue from Zora’s multi-edition smart 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_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
0xf45c1b57c8147be09db86892ef611c683e4c1799	false	30777000000000000	0x8a1dbe9b1ceb1d17f92bebf10216fcfab5c3fba7	0x1d14d9e297dfbce003f5a8ebcf8cba7faee70b91	345	1	1	17138236	2023-04-27T14:54:35.000Z	0xc51f8bd2d412c241ddce109a86b8a4c669bd2b59d60830b3fe750313b4682815
0xf45c1b57c8147be09db86892ef611c683e4c1799	false	30777000000000000	0x8a1dbe9b1ceb1d17f92bebf10216fcfab5c3fba7	0xc7a0d765c3af6e2710ba05a56c5e2ca190c2e11e	327	1	1	17138317	2023-04-27T15:10:47.000Z	0x5f7c767f9e3c8fb675d675b1b107064d9b097816ccd41acc825813f22e077024
0xf45c1b57c8147be09db86892ef611c683e4c1799	false	30777000000000000	0x8a1dbe9b1ceb1d17f92bebf10216fcfab5c3fba7	0xd26cc622697e8f6e580645094d62742eec9bd4fc	208	1	1	17138956	2023-04-27T17:19:47.000Z	0x51765f96d5f3e579f980c2cf21f1096eddefd8fcb3d5d6e0bc118ffa1eaff48d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zora_v1_ethereum.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 Ethereum, recording fee amounts paid to recipients and transaction success status. Used for analyzing protocol revenue distribution and fee collection patterns across NFT mints.

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`	Amount of minting fee paid for the NFT creation, denominated in wei (smallest ETH unit). Values typically range from 777000000000000 wei (0.000777 ETH) to higher amounts based on the mint configuration.
`in_mintFeeRecipient`	`STRING`	Contract address receiving the mint fee payment from the ERC-721 drop transaction. Consistently appears as the same Ethereum address (0xd1d1…) across samples, indicating Zora’s platform fee collector.
`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
0x08e96b4bfa2c761cde42277dea9762db83e18257	false	98	true	17307326	2023-05-21T11:03:35.000Z	777000000000000	0xef7c4a8c5c8815c0ca29b9a48c9843d9fde98fe25e1fafd92e4cd8c3cbf0a3ad	0xd1d1d4e36117ab794ec5d4c78cbd3a8904e691d0
0x0f12eac28aad37a04a15e9f798daddfc297217c3	false	350	true	17304205	2023-05-21T00:31:11.000Z	777000000000000	0x924128873d8a37674dedecd81b85bbe8f7f99ba76c4e8bfc21123189a8d7fd8e	0xd1d1d4e36117ab794ec5d4c78cbd3a8904e691d0
0x0f12eac28aad37a04a15e9f798daddfc297217c3	false	135	true	17307639	2023-05-21T12:07:11.000Z	1554000000000000	0x99e93edcd92ea00538a16a119951cbbf88fa18faff40f8d5b84e9208391f24a0	0xd1d1d4e36117ab794ec5d4c78cbd3a8904e691d0

Example Query

Query with partition filter

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

721Drop_Sale_event

NFT sale events from Zora’s ERC-721 drop contracts on Ethereum, capturing buyer addresses, token IDs, quantities, and prices in wei. Used for analyzing Zora NFT mint pricing, purchase patterns, and collection performance.

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`	Token price in wei (smallest ETH denomination) paid per NFT in this sale transaction. Value is string-encoded to preserve precision; divide by 10^18 to convert to ETH.
`in_firstPurchasedTokenId`	`STRING`	Token ID of the first NFT purchased in this sale transaction. Stored as a string-encoded integer, typically starting from 0 for the initial mint in a sequential drop.

Sample Data

in_to	address	removed	log_index	in_quantity	block_number	block_timestamp	in_pricePerToken	transaction_hash
0xa8a34a672a8041a369859a4f7df48d03d440927b	0x34a156f6f763599f6a890e00241cd63b03b9268c	false	46	1	15364233	2022-08-18T09:34:44.000Z	103000000000000000	0x83d309317f0e6a5dcf6fbc3737b91e866a46535ad997b5c49fed3b9ef32b1c05
0xd2ded238b1ae52ddb6006ebf5d93cdf2de635f41	0x8b8a129aa3fc57091c4229e1af4c806beecf8be1	false	123	1	15364656	2022-08-18T11:09:34.000Z	101000000000000000	0x2405a14fb26e3e1f83a3e33e1cadb08ed0e02049eae07023d0a8ec590c435e00
0x6e5019c712827b5e7d30e1ada52b871582ca4349	0xe179bca1c9b04d3c79d2f29e82570d7590897006	false	169	1	15364063	2022-08-18T08:59:41.000Z	102000000000000000	0x3c972395378d4c0eed4e4361b6dab5c91c5c7466fc50e6eb0e5b62e9269721ea

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zora_v1_ethereum.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 contract on Ethereum, capturing new multi-edition NFT contract creations with creator addresses, collection names, metadata URIs, and royalty configurations. Used for tracking Zora collection launches and analyzing creator activity on the platform.

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
0xa6c5f2de915240270dac655152c3f6a91748cb85	Obscured by Clouds	false	238	0x8b1de9760c745098af64a4327b4c9d113ed424e4	17854906	ipfs://bafkreibiabyuqx6ire7cie2r6bm3jtfsetiizsiok2u4a7bnxhjz4b32vi	0xdd8c0df4c788be1521ee75405a3f01f6869a99ad	2023-08-06T09:04:23.000Z	0x8b1de9760c745098af64a4327b4c9d113ed424e4	0x5f9e87be35671584ebf2962879a4b18d7ac47b53663276458b56879cd5eec807	{“royaltyBPS”:“0”,“royaltyRecipient”:“0x0000000000000000000000000000000000000000”,“royaltyMintSchedule”:“0”}
0xa6c5f2de915240270dac655152c3f6a91748cb85	Hopes and dream.	false	213	0xbc86e704d3cb84fbbf2a4516ccfe4562c9e648d5	17858807	ipfs://bafkreifkyu6bbluy7x3hptjyd3b6z4enwuvq2jjuvh3yvjl2oju3ejr2uq	0x16b3f3b17e729409f87fed6cbca5cf667db13456	2023-08-06T22:11:11.000Z	0xbc86e704d3cb84fbbf2a4516ccfe4562c9e648d5	0xb8d852a8425e2b254af5cc6fd4049c3a00eba4c4f32b308c0f5168feefa34436	{“royaltyBPS”:“0”,“royaltyRecipient”:“0x0000000000000000000000000000000000000000”,“royaltyMintSchedule”:“0”}
0xa6c5f2de915240270dac655152c3f6a91748cb85	zooties	false	113	0xa58b4a80de82b889ff40e487c58208a429c77f88	17853904	ipfs://bafkreigeuystirenyoyzlomxagoz5zunls7tlgja6vnx3gahbgwi2mf5ki	0x740c91fc0c222c2a5a153faa044cbecb202e874c	2023-08-06T05:42:47.000Z	0xa58b4a80de82b889ff40e487c58208a429c77f88	0x6c20e37ee24fbb4997fd8cd67f9a859faed3b88e28bb23da9dbba4af6bbbb702	{“royaltyBPS”:“0”,“royaltyRecipient”:“0x0000000000000000000000000000000000000000”,“royaltyMintSchedule”:“0”}

Example Query

Query with partition filter

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

Factory721_CreatedDrop_event

NFT drop creation events from Zora’s ERC-721 factory contract on Ethereum, capturing when creators deploy new edition contracts with their specified supply limits. Tracks creator addresses, edition contract deployments, and supply caps for analyzing Zora protocol adoption and creator activity.

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
0xf74b146ce44cc162b601dec3be331784db111dc1	false	228	0x7b994e111cd89c9391be815fa6fcd6ef2abfd053	17410309	64	2023-06-04T22:51:59.000Z	0x1f174f8c9b4fac60787740df2ba241cedf1299a40903ef535e3204a6e0fc2d18	0x8f2a4fb6c13bb2daaa2fefe2278baa74a5ae3d8c
0xf74b146ce44cc162b601dec3be331784db111dc1	false	152	0xa75c93e895dc2fb3b034bf4ac59cf85c4c99ae1f	17410337	1000	2023-06-04T22:57:35.000Z	0x6059cc44c288011f320eb99ada8e3750d242170812c757c644a1bafe6ff19fed	0xbd4239f850e84ba2740e5b85dfd6679242071094
0xf74b146ce44cc162b601dec3be331784db111dc1	false	278	0x003e2ebbbeb31f272ff9013a80da84197e842a4c	17405091	9000	2023-06-04T05:10:47.000Z	0x71a142a879e9d88ecb5d914fdf7e99327685b4cc2b4e6af84985266151286ef4	0x60d91297fe21cd4a1234686c12aca9573ee8b0fd

Example Query

Query with partition filter

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