The Season 1 Boost NFTs are being discontinued, and we want to reward users who managed to acquire them with a new NFT, the Collector. The rank each address receives will be determined by the combination of NFTs held at 2pm CET on Wednesday August 3rd 2022. We should create a query in Dune to gather this data, determine the correct ranks and then generate a .csv for minting the NFTs.
Deadline
We need to mint the NFTs on Wednesday August 3rd 2022
Description
Create a query in Dune analytics which does the following:
Find every address holding a HOPR Boost NFT from Season 1. The following types are included:
Wildhorn_v1
Wildhorn_v2
Puzzlehunt_v1
Puzzehunt_v2
DAO_v2.0
Surveyor
For each NFT type held by the address, ignore all but the single NFT with the highest rank. These are the eligible NFTs in that address.
Assign a score to the address based on the eligible NFTs held, using the following system:
Bronze 1 point
Silver 2 points
Gold 3 points
Diamond 4 points
Based on the address' score, assign a Collector NFT rank using the following system:
<4 points No NFT
4-7 points Bronze
8-11 points Silver
12-15 points Gold
16+ points Diamond
Finally, using the query output a .csv file in accordance with the NFT minting guidelines
Job Story
The Season 1 Boost NFTs are being discontinued, and we want to reward users who managed to acquire them with a new NFT, the Collector. The rank each address receives will be determined by the combination of NFTs held at 2pm CET on Wednesday August 3rd 2022. We should create a query in Dune to gather this data, determine the correct ranks and then generate a .csv for minting the NFTs.
Deadline
We need to mint the NFTs on Wednesday August 3rd 2022
Description
Create a query in Dune analytics which does the following:
For each NFT type held by the address, ignore all but the single NFT with the highest rank. These are the eligible NFTs in that address.
Assign a score to the address based on the eligible NFTs held, using the following system:
Finally, using the query output a .csv file in accordance with the NFT minting guidelines