zora_v1_base

Tables

1155_Purchased_event

ERC-1155 token purchase events from Zora protocol on Base, recording mints and secondary sales with buyer, seller, token ID, quantity, and payment amounts in wei. Used for tracking NFT collection activity, creator earnings, and individual token trading patterns.

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
0x0df054cf07ba32849323f2f8354e72ec255e6d30	false	777000000000000	0xff8b0f870ff56870dc5abd6cb3e6e89c8ba2e062	0xe47ed204b63adfb80c90082c088fc2a430f9a558	67	2	1	10145522	2024-02-04T20:59:51.000Z	0x07a239b08e2067dacf1a831205df777aadb0876b80fc9dcb4b5f9d65fff0be25
0x0fec31ada79d6bdad8048df3a576ebb3abea47fe	false	777000000000000	0xff8b0f870ff56870dc5abd6cb3e6e89c8ba2e062	0x435a8953ff41c8288c348909cac9c8594e2da4a8	130	15	1	10119546	2024-02-04T06:33:59.000Z	0x76440c6efe94d719930857d0ad636a7aeaf994e44521565db3180f7dfebd0b5f
0x0fec31ada79d6bdad8048df3a576ebb3abea47fe	false	777000000000000	0xff8b0f870ff56870dc5abd6cb3e6e89c8ba2e062	0xea788f83c9d38d89ecafee20be0389ffe4d6ff8e	67	16	1	10131731	2024-02-04T13:20:09.000Z	0xd0de96fc2d242aa8d58de387f549926be0ae22246eebe247dd8b4576a6533a84

Example Query

Query with partition filter

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

1155V2_ApprovalForAll_event

ERC-1155 approval events from Zora V2 NFT contracts on Base, recording when accounts grant or revoke operator permissions to manage their entire token collection. Used for analyzing delegation patterns and marketplace integrations.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_approved`	`BOOL`	Boolean flag indicating whether approval was granted or revoked for the operation.

Sample Data

address	removed	log_index	in_account	in_approved	in_operator	block_number	block_timestamp	transaction_hash
0x7b99dd120231cdb80252c4eac3e09d999a8254e1	false	11	0xf624924a226349001daf19e2582c95668fc92d70	true	0x1e0049783f008a0085193e00003d00cd54003c71	10232434	2024-02-06T21:16:55.000Z	0xf8344f56162c499c2697376ef7503ae46e7b513dc0e732af086752599d96f686
0x2f8c28dbc9ae9aa3ba224952784a54d0ea1977df	false	5	0xd7d8cd5b871fed2bcd9cea31cfaeec93702c0498	true	0x1e0049783f008a0085193e00003d00cd54003c71	10021169	2024-02-01T23:54:45.000Z	0x1b53fd4f15e96908f6b0aca1bfb173d556f9e3b6fc35740170a2245c7b4542eb
0x0fd9aaa8dabc306184fa3ab71d0f47454bf13370	false	2	0xd7d8cd5b871fed2bcd9cea31cfaeec93702c0498	true	0x1e0049783f008a0085193e00003d00cd54003c71	10021165	2024-02-01T23:54:37.000Z	0x10eafb60cad780466ae135668ece385dfcc53a082738312d45e45f8c64934a8b

Example Query

Query with partition filter

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

1155V2_ConfigUpdated_event

Configuration change events from Zora’s ERC-1155 V2 contracts on Base, capturing updates to contract settings like ownership, funds recipients, and transfer hooks. Useful for tracking administrative actions and permission changes 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_updater`	`STRING`	Address of the account that initiated the configuration update on the ERC-1155 contract. Typically the Zora contract address or the contract owner making changes to ownership or payment settings.
`in_updateType`	`INT64`	Type of configuration change applied to the ERC-1155 contract, where 0 indicates owner/transfer hook updates and 1 indicates funds recipient updates. Numeric identifier that categorizes the specific contract setting being modified.
`in_newConfig`	`STRUCT<owner STRING, __gap1 STRING, fundsRecipient STRING, __gap2 STRING, transferHook STRING, __gap3 STRING>`	New configuration parameters applied after the update. Struct containing protocol-specific settings such as risk parameters, fees, or contract roles.

Sample Data

address	removed	log_index	in_updater	block_number	in_newConfig	in_updateType	block_timestamp	transaction_hash
0xbc36f724e77f084fb2afd5afe4d7af2c81cad52b	false	39	0x777777c338d93e2c7adf08d102d45ca7cc4ed021	10550014	{“owner”:“0xec0a80a45b8fe551522bb69814aaa51a6666cb7f”,“__gap1”:“0”,“__gap2”:“0”,“__gap3”:“0”,“transferHook”:“0x0000000000000000000000000000000000000000”,“fundsRecipient”:“0x0000000000000000000000000000000000000000”}	0	2024-02-14T05:42:55.000Z	0x021d3d6eeaee42c82e7dd1ebef321c0f48b31f5c0710afc959de64c77921bf22
0xbc36f724e77f084fb2afd5afe4d7af2c81cad52b	false	40	0x777777c338d93e2c7adf08d102d45ca7cc4ed021	10550014	{“owner”:“0xec0a80a45b8fe551522bb69814aaa51a6666cb7f”,“__gap1”:“0”,“__gap2”:“0”,“__gap3”:“0”,“transferHook”:“0x0000000000000000000000000000000000000000”,“fundsRecipient”:“0xec0a80a45b8fe551522bb69814aaa51a6666cb7f”}	1	2024-02-14T05:42:55.000Z	0x021d3d6eeaee42c82e7dd1ebef321c0f48b31f5c0710afc959de64c77921bf22
0xd7cbde25fc0dbd29ec15201406a25a85869c263c	false	52	0x777777c338d93e2c7adf08d102d45ca7cc4ed021	10571468	{“owner”:“0x84705e94c98184b2d47026664cfab2c38cca1bf9”,“__gap1”:“0”,“__gap2”:“0”,“__gap3”:“0”,“transferHook”:“0x0000000000000000000000000000000000000000”,“fundsRecipient”:“0x84705e94c98184b2d47026664cfab2c38cca1bf9”}	1	2024-02-14T17:38:03.000Z	0x02b735c331d7aefa1998b776b2c6fef90023b2d44de8925181964a52c0f5c0a1

Example Query

Query with partition filter

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

1155V2_ContractMetadataUpdated_event

Metadata update events from Zora’s ERC-1155 V2 protocol on Base, capturing contract name and IPFS URI changes. Tracks collection metadata modifications by updater address for analyzing NFT collection management and rebranding 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_updater`	`STRING`	Address of the account that triggered the metadata update for this ERC-1155 contract. Typically the contract owner or an authorized administrator with update permissions.
`in_uri`	`STRING`	URL pointing to metadata or asset information stored on external storage systems (IPFS, AWS S3, Arweave) or web servers.
`in_name`	`STRING`	Name or label identifier for the entity being created, registered, or updated in the event.

Sample Data

in_uri	address	in_name	removed	log_index	in_updater	block_number	block_timestamp	transaction_hash
ipfs://bafkreic5lff4hi2wbcwi5etbox5dctv4divqnvhlwfkxlvpymxhc4vngpu	0x805f00c9013efd48b742bc66040b5b4f8058eb12	Cars V2	false	10	0x53fbed245a104c1fa40f6daf42c3daeb5f7db8e3	9382861	2024-01-18T05:17:49.000Z	0x13f2a58a1ce9b617a733c2825b280f56c7a008bc9ff841b25affeae58ef0d8ff
ipfs://bafkreifbvjnqq4iqb3pcz5daiblqyaealfrlzmdtewwwwrbt7xqbsknl5y	0x2e99ac8c179c14fb0f5bbf8dc8f38dccdd527219	Cars	false	27	0x53fbed245a104c1fa40f6daf42c3daeb5f7db8e3	9383598	2024-01-18T05:42:23.000Z	0x5742d6bfed8a48995406d21cb6ff1e85be8ddf843cb46f08a2dbcb5fcb798c46
ipfs://bafkreidahdh2lhwldckenzcthdoahlpmoptipgmxswn4qy3s72hstsr7sq	0xe20f1c5bea7eb3c4dd6fe2eeeec597d1a74c5b8b	Prop 488 Appreciation	false	15	0x2ee0485f71764bcd2062a84d9455688c581b90f8	10154908	2024-02-05T02:12:43.000Z	0xbd57db4c72e07a3394753ef7cd737a7920cc64152d3e316c9a6f581f6a1657fa

Example Query

Query with partition filter

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

1155V2_Purchased_event

Purchase events from Zora’s ERC-1155 V2 NFT contracts on Base, tracking mints with quantity, price paid, and minter addresses. Used for analyzing Zora NFT collection minting activity and collector behavior.

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
0xd5fbb9bc5199e8270c3b3332e31c674ade79383c	false	777000000000000	0x04e2516a2c207e84a1839755675dfd8ef6302f0a	0x75a6085bbc25665b6891ea94475e6120897ba90b	18	1	1	9576852	2024-01-22T17:04:11.000Z	0x39dd096169dbf075092b8b63cde38cd4db3ea8506e55c513688c53cc53136dce
0x27835916b7c1372be4edffacb764adc3aaee63a1	false	777000000000000	0x04e2516a2c207e84a1839755675dfd8ef6302f0a	0x81f91aca8c05b3eefebc00171139afefac17c9a6	18	1	1	9552378	2024-01-22T03:28:23.000Z	0x55bb9c31fcd51fba231c0ffcdd5d859af4c4022a7a4912af83b44f0588c2c785
0xd5fbb9bc5199e8270c3b3332e31c674ade79383c	false	777000000000000	0x04e2516a2c207e84a1839755675dfd8ef6302f0a	0x81f91aca8c05b3eefebc00171139afefac17c9a6	8	1	1	9550679	2024-01-22T02:31:45.000Z	0x65592897bfcaed82b927a9f27cc0c7c892f6ea786c975da50f84eca02b7744b3

Example Query

Query with partition filter

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

721Drop_MintFeePayout_event

Mint fee payment records from Zora’s ERC-721 Drop contracts on Base, tracking protocol fees paid to recipients during NFT minting. Used for analyzing Zora’s fee structure and revenue distribution across 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 in the Zora 721Drop contract, denominated in wei. Sample values show a standard fee of 0.000777 ETH (777000000000000 wei) per mint.
`in_mintFeeRecipient`	`STRING`	Address receiving the mint fee payout from the ERC-721 drop contract. Typically a protocol fee collector or treasury address, as shown by the recurring recipient address in samples.
`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
0x58e52a43ca6a3dc1737cec05a496163e4334a6b4	false	3	true	4566984	2023-09-28T17:48:35.000Z	777000000000000	0xa7b98ce15009c7d50dd2dbcca7ba678573908f3dbb30c2cb7c885d6533eedc99	0x7bf90111ad7c22bec9e9dff8a01a44713cc1b1b6
0xf0e6db22b365293f796f1d1317274ff50cf0c9f8	false	24	true	4557935	2023-09-28T12:46:57.000Z	777000000000000	0xb0aa46cc7103a0fba3a3d579aa8ebb34c8495e685c675784d032573aef0600cb	0x7bf90111ad7c22bec9e9dff8a01a44713cc1b1b6
0x5c5a727d36629cc529471c5824eed1a1ce818c19	false	4	true	4558259	2023-09-28T12:57:45.000Z	777000000000000	0x35a6d1fcad5be18dd642c982ebf0dc6e0829d5db156c05c862d5fc83b9980115	0x7bf90111ad7c22bec9e9dff8a01a44713cc1b1b6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zora_v1_base.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’s drop contracts on Base, capturing mints and secondary sales with buyer address, token ID, price per token, and quantity. Used for tracking collection mint performance, pricing trends, and collector behavior across Zora’s creator economy.

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 per token in wei (smallest unit) paid for each NFT in this sale transaction. String-formatted to preserve precision; zero values indicate free mints or gasless claims.
`in_firstPurchasedTokenId`	`STRING`	Token ID of the first NFT minted in this sale transaction from the ERC-721 drop contract. Subsequent tokens in multi-quantity purchases increment sequentially from this value.

Sample Data

in_to	address	removed	log_index	in_quantity	block_number	block_timestamp	in_pricePerToken	transaction_hash
0x2a0b0bb27870bfea2fdb96dc7e1dd94d207db448	0x8d69f58605ba00e6746c7ac8297632983102329e	false	32	1	8597345	2023-12-31T00:53:57.000Z	100000000000000	0xc99706cd47c63bad014a51d116609d5d828694dca97c550dbb2fce74284feea1
0x070e818729717b8ef1fa6acc28e3e4d9e1eab35a	0xc34fca9d38d38f72fb1dba0fa7b3d95cb340c00c	false	9	1	8612943	2023-12-31T09:33:53.000Z	100000000000000	0xd929c40801ebae998473164e7a9917f5610aeec3d9f10704841839b6c7425c08
0xbd3805ee5d0591a01eb32dfaae6424dd07dc539f	0x5af678835e94c1f8f95742d022d2f07d1e9da425	false	35	1	8610312	2023-12-31T08:06:11.000Z	0	0xb0305608336160caa254b21c1707f0bd92a2648a4b84eeb096bfb6fcd364d407

Example Query

Query with partition filter

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

Creator1155Factory_SetupNewContract_event

ERC-1155 contract deployment events from Zora’s Creator1155Factory on Base, capturing new multi-edition NFT collection deployments with creator addresses, contract metadata URIs, and royalty configurations. Used for tracking Zora collection launches and analyzing creator activity patterns.

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
0x9b24fd165a371042e5ca81e8d066d25cad11ede7	Junion Stands with Crypto	false	38	0x03851f30cc29d86ee87a492f037b16642838a357	4740940	ipfs://bafkreiaholpzgo62o7euvtte6zxki6ix57fcik4tektuqcvc6qcmqfnm7y	0xcee494271061e5f401b98338ef415b1583f3642b	2023-10-02T18:27:07.000Z	0x03851f30cc29d86ee87a492f037b16642838a357	0xce1a1f8ee847e856a881d75105fbda14e26b2e1b3d1825ca8c838c1ac49930f9	{“royaltyBPS”:“0”,“royaltyRecipient”:“0x0000000000000000000000000000000000000000”,“royaltyMintSchedule”:“0”}
0x9b24fd165a371042e5ca81e8d066d25cad11ede7	We Stand With Crypto	false	7	0x1c189052c717e20753bd746145fc1746a2d97f5f	4738624	ipfs://bafkreibp5wu5cxswvs4fevoyyoyaqk5yjv77injgko5ccnx5voaccyve4a	0x9ec7f353af709a099fa82d2c12ad3e24cdea0c7b	2023-10-02T17:09:55.000Z	0x1c189052c717e20753bd746145fc1746a2d97f5f	0x5ee397b049461a2f8510ba3fedf17f0ede8842ab93ab8e47a5cc257256abaf38	{“royaltyBPS”:“0”,“royaltyRecipient”:“0x0000000000000000000000000000000000000000”,“royaltyMintSchedule”:“0”}
0x9b24fd165a371042e5ca81e8d066d25cad11ede7	We Stand With Crypto	false	1	0x1c189052c717e20753bd746145fc1746a2d97f5f	4738648	ipfs://bafkreibp5wu5cxswvs4fevoyyoyaqk5yjv77injgko5ccnx5voaccyve4a	0x3ba8272a422f47aae49390fb31b39195348f9438	2023-10-02T17:10:43.000Z	0x1c189052c717e20753bd746145fc1746a2d97f5f	0xa49123d38e3553cb674c3cab1466763ec7f19e081709a35ac0d7a2b5f4c17568	{“royaltyBPS”:“0”,“royaltyRecipient”:“0x0000000000000000000000000000000000000000”,“royaltyMintSchedule”:“0”}

Example Query

Query with partition filter

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

Factory1155_SetupNewContract_event

ERC-1155 contract creation events from Zora’s factory on Base, capturing new NFT collection deployments with creator addresses, contract metadata URIs, admin permissions, and royalty configurations (basis points and recipient addresses). Used for tracking Zora collection launches and analyzing creator activity patterns.

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
0x777777c338d93e2c7adf08d102d45ca7cc4ed021	NAME	false	8	0x1d266998da65e25de8e1770d48e0e55ddee39d24	10371336	ipfs://QmQhexqEE9vA9QrHfdzzJtC9rj4vW6HXbw8VviZFksMQWu/0	0xafe03ba08b8ede425afe02f9557fa6e305af9629	2024-02-10T02:26:59.000Z	0x1d266998da65e25de8e1770d48e0e55ddee39d24	0x2176024415e0ec4c48f388802341465b53f47b90c7c1a1e9d1467062753f44e2	{“royaltyBPS”:“1000”,“royaltyRecipient”:“0x1d266998da65e25de8e1770d48e0e55ddee39d24”,“royaltyMintSchedule”:“0”}
0x777777c338d93e2c7adf08d102d45ca7cc4ed021	bound-redesign	false	5	0xae4705dc0816ee6d8a13f1c72780ec5021915fed	9597524	ipfs://bafybeicrt7sprgwfm54efw35zw6dgc32wjk7bxnyc4wgnlwvr5wzgdc2te	0x511c0d5cf833e57bdf4d8bc9595435be3a30b664	2024-01-23T04:33:15.000Z	0xae4705dc0816ee6d8a13f1c72780ec5021915fed	0xcfc385398e8ceb859949fe23da44371bec7ad5f8a3373beafaa1a728f62abee6	{“royaltyBPS”:“1000”,“royaltyRecipient”:“0xae4705dc0816ee6d8a13f1c72780ec5021915fed”,“royaltyMintSchedule”:“0”}
0x777777c338d93e2c7adf08d102d45ca7cc4ed021	Masterpieces	false	31	0xae4705dc0816ee6d8a13f1c72780ec5021915fed	9624039	ipfs://bafybeif5ohzrnpo6egcofxxqeucpjhuchkofnjg3idifmjjcpisqbnxspe	0x6cd547d0b371a116c4b72ef7caa08bfa6d75dfb1	2024-01-23T19:17:05.000Z	0xae4705dc0816ee6d8a13f1c72780ec5021915fed	0x22dc2e0effd67c277bee4eb9b8fff8113dc24268df49fdc1816337a65f415bf7	{“royaltyBPS”:“1000”,“royaltyRecipient”:“0xae4705dc0816ee6d8a13f1c72780ec5021915fed”,“royaltyMintSchedule”:“0”}

Example Query

Query with partition filter

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

NFTCreator_CreatedDrop_event

NFT edition creation events from Zora v1 protocol on Base, recording when creators deploy new NFT drop contracts with edition size and contract addresses. Used for tracking new collection launches and creator activity on the Zora 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_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
0x58c3ccb2dcb9384e5ab9111cd1a5dea916b0f33c	false	11	0xaf090d3e78530b3c9a4ed035bbe09978b560d7ee	7815667	18446744073709551615	2023-12-12T22:38:01.000Z	0xe6f243a0974ae1f060b39bb40cb6ba2bc25fba7e08dc68f1e8a1d5a73022e72d	0x3e51d9a58a121fd9323d8c5c0aab66bf0422bf29
0x58c3ccb2dcb9384e5ab9111cd1a5dea916b0f33c	false	36	0x16c9a2cb96eeafd2e6441b6556709c4aec3f8875	7796906	18446744073709551615	2023-12-12T12:12:39.000Z	0xadf067a6464c3a38a6185d6f91abb76706a530743ae4c45d05ecc7e329f8493e	0xbf87a54ab1597762f70a2cf649fc4895d8225c98
0x58c3ccb2dcb9384e5ab9111cd1a5dea916b0f33c	false	28	0x92f6bff66885fd9285b1fb5ef8a31a785c527b56	7785291	18446744073709551615	2023-12-12T05:45:29.000Z	0xda58bff706e0ad794ac8cdd3b0f4a0bc7726aff7d618f21ab0f3293e1a9e2d1e	0xdbf5a9153a4cbb0fa094f49c04faca7530f0dcf9

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

1155_Purchased_event

1155V2_ApprovalForAll_event

1155V2_ConfigUpdated_event

1155V2_ContractMetadataUpdated_event

1155V2_Purchased_event

721Drop_MintFeePayout_event

721Drop_Sale_event

Creator1155Factory_SetupNewContract_event

Factory1155_SetupNewContract_event

NFTCreator_CreatedDrop_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​1155_Purchased_event

​1155V2_ApprovalForAll_event

​1155V2_ConfigUpdated_event

​1155V2_ContractMetadataUpdated_event

​1155V2_Purchased_event

​721Drop_MintFeePayout_event

​721Drop_Sale_event

​Creator1155Factory_SetupNewContract_event

​Factory1155_SetupNewContract_event

​NFTCreator_CreatedDrop_event

Tables

1155_Purchased_event

1155V2_ApprovalForAll_event

1155V2_ConfigUpdated_event

1155V2_ContractMetadataUpdated_event

1155V2_Purchased_event

721Drop_MintFeePayout_event

721Drop_Sale_event

Creator1155Factory_SetupNewContract_event

Factory1155_SetupNewContract_event

NFTCreator_CreatedDrop_event