Try Quests to earn cryptoMethodology
The required data for this analysis were selected from the ez_nft_mints, ez_nft_sales, and ez_nft_transfers tables of the Core schema of the Ethereum database. Transactions were filtered using the following NFT contract addresses attributed to different NFT collections of Nike. The price_usd column was used to measure the volumes and prices. Also, the creator_fee_usd was used to directly calculate the royalties earned by each collection.
Some of the RTFKT NFTs were airdropped to the holders of their previous collections, where they had to burn their tokens to be able to mint the new ones. With that being said, the minting prices for these collections were extracted from the eth_value column of the fact_transactions table.
In the final section of the dashboard, the net profits of CloneX NFT holders were measured by dividing the latest price of the NFT, either the mint price or the last sale price, by the average floor price of the collection.
Also, the consumer airdrop value was calculated based on the total volume of airdrops from their original holders, in addition to the remaining supply they held multiplied by the floor price of each collection they hold. The Nike airdrop value was calculated based on the royalties collected from all airdropped items.
NFT Contract Addresses
- CloneX: 0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b
- CRYPTOKICK: 0xf661d58cfe893993b11d53d11148c4650590c692
- NIKE Hoodie: 0x212590b0dac9502e0591b79db4cedeb6356dcc36
- NIKE Hoodie Forged: 0x1bb6edf7b129967d512086fbdf489ed659580916
- Mint Vial: 0x348fc118bcc65a92dc033a951af153d14d945312
- MNLTH: 0x86825dfca7a6224cfbd2da48e85df2fc3aa7c4b1
- MNLTH2: 0x6d4bbc0387dd4759eee30f6a482ac6dc2df3facf
- RTFKT Creators: 0x9930929903f9c6c83d9e7c70d058d03c376a8337
- RTFKT Pod X: 0xb7be4001bff2c5f4a61dd2435e4c9a19d8d12343
- RTFKT Capsule Space Drip: 0xd3f69f10532457d35188895feaa4c20b730ede88
- RTFKT Capsule Space Drip 1.2: 0xc541fc1aa62384ab7994268883f80ef92aac6399
- RTFKT BONUS ITEMS: 0x0972290a80333d19c6703073c3e57134a4ca0127
- RTFKT PUNK PROJECT GEN 1: 0xae3d8d68b4f6c3ee784b2b0669885a315ba77c08
- SKIN VIAL EVOX: 0x9a06ef3a841316a9e2c1c93b9c21a7342abe484f
