Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_creatorSTRINGAddress of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
in_editionContractAddressSTRINGContract address of the newly created NFT edition. Hex-encoded, 0x-prefixed, 42-character string.
in_editionSizeSTRINGMaximum number of NFTs that can be minted in the edition. String-encoded integer, with 18446744073709551615 representing unlimited supply.
addressremovedlog_indexin_creatorblock_numberin_editionSizeblock_timestamptransaction_hashin_editionContractAddress
0xf74b146ce44cc162b601dec3be331784db111dc1false500xb2d9e2a22c27254987fe82cf2b2d804d4f1becf91669464712023-02-24T00:26:59.000Z0x5079edcf91e5c1c89f362a43025a74fbed32154d2f1ed3885bf3a88774e372320xc54400d7cb571e0336df605f98b1620843d2b258
0xf74b146ce44cc162b601dec3be331784db111dc1false1420x2f85e3ec1148fbc4729a916dfe528bf72434ab051669574372023-02-24T04:08:35.000Z0xb049246edf76325d2b996e1732b13c2561c3dec478da61e1f191520d4e0b474c0x6f14dcd904a9e6adb7661b0959bf6348aa5e6213
0xf74b146ce44cc162b601dec3be331784db111dc1false3410xef58304e292fbaeacfdec25b67b3438031fde31316695156102023-02-24T02:10:23.000Z0xfe1a2fa8d0e99e3e7372db0586f84b92a19e326ac80e1c858a7302a7698ddddd0xbf841edc2ed5cb8a08ce64551a1e544c51993063
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