zora_v3_ethereum

Tables

ZoraNFTCreator_CreatedDrop_event

NFT edition drop creation events from the Zora v3 protocol on Ethereum, capturing when creators deploy new edition contracts with the creator address, edition size, and deployed contract address. Used for tracking new NFT 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
0xf74b146ce44cc162b601dec3be331784db111dc1	false	50	0xb2d9e2a22c27254987fe82cf2b2d804d4f1becf9	16694647	1	2023-02-24T00:26:59.000Z	0x5079edcf91e5c1c89f362a43025a74fbed32154d2f1ed3885bf3a88774e37232	0xc54400d7cb571e0336df605f98b1620843d2b258
0xf74b146ce44cc162b601dec3be331784db111dc1	false	142	0x2f85e3ec1148fbc4729a916dfe528bf72434ab05	16695743	7	2023-02-24T04:08:35.000Z	0xb049246edf76325d2b996e1732b13c2561c3dec478da61e1f191520d4e0b474c	0x6f14dcd904a9e6adb7661b0959bf6348aa5e6213
0xf74b146ce44cc162b601dec3be331784db111dc1	false	341	0xef58304e292fbaeacfdec25b67b3438031fde313	16695156	10	2023-02-24T02:10:23.000Z	0xfe1a2fa8d0e99e3e7372db0586f84b92a19e326ac80e1c858a7302a7698ddddd	0xbf841edc2ed5cb8a08ce64551a1e544c51993063

Example Query

Query with partition filter

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

zora_v1_ethereum zora_v1_optimism

⌘I

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ZoraNFTCreator_CreatedDrop_event

​Tables

​ZoraNFTCreator_CreatedDrop_event

Tables

ZoraNFTCreator_CreatedDrop_event