Content
@
0 reply
0 recast
0 reaction
ilemi
@ilemi
Anyone have a query of all zora nft mints? Last like 12 months? I want the minter, nft, mint time, mint value, and creator of the mint token :)
6 replies
0 recast
11 reactions
Blockboy
@0xblockboy.eth
Hey here is a query, does this solve it? I added parameter filters because without them the data is waaaay to big at least on my plan: https://dune.com/queries/3924845/6598471/ let me know how to officially submit, thank you!
1 reply
0 recast
0 reaction
ilemi
@ilemi
this is close! I think you need to get creator data by joining on this table zora_ethereum.ZoraNFTCreatorV1_evt_CreatedDrop. you'll likely need to union across the different decoded tables first before the join. do that and then I'll pay you out
1 reply
0 recast
0 reaction
Blockboy
@0xblockboy.eth
how about now? https://dune.com/queries/3924845/6598471/ happy to keep working on it to make sure its what your looking for if needed
1 reply
0 recast
0 reaction
ilemi
@ilemi
looking like it's almost there! now UNION ALL the other chains you can find for the same creator table in the CTE, then I think you're done
1 reply
0 recast
0 reaction
Blockboy
@0xblockboy.eth
https://dune.com/queries/3924845?category=decoded_project&namespace=zora&blockchain=arbitrum hey how about now, sorry for the delay, busy work weekend, hope this is helpful :)
2 replies
0 recast
1 reaction
ilemi
@ilemi
bounty paid out! https://basescan.org/tx/0x703d9acbcbe227b6841d5562bc4d7c951663fc561dce75904b72756fb182d76f
0 reply
0 recast
1 reaction
ilemi
@ilemi
Great work! @bytecast answered, ill pay you out the bounty
0 reply
0 recast
1 reaction
