Hot-7.Moonbirds Mint Analysis

    -- Q7. What was the distribution at mint? How many wallets minted? Who minted the most? -- Use the Ethereum_core schema. -- Hint: https://etherscan.io/address/0x23581767a106ae21c074b2276d25e5c3e136a68b

    Methodology

    • Find all Mint transactions using the following filters for contract 0x23581767a106ae21c074b2276d25e5c3e136a68b and from address is 0x0000000000000000000000000000000000000000
      from ethereum_core.fact_transactions t, lateral flatten(input => tx_json:receipt:logs) l
      where
        to_address = '0x23581767a106ae21c074b2276d25e5c3e136a68b' -- Moonbirds'
      -- and   tx_hash = '0x9fcb0e681c05f96d3269b52dae05f357f407b5f99d3d15d93a7c527e9e6730a5'
      and l.value:decoded:inputs:tokenId is not null
      and l.value:decoded:inputs:from = '0x0000000000000000000000000000000000000000'
    

    What was the distribution at mint? How many wallets minted?

    • Given below are all the wallets that minted Moonbirds, in total there were 8698 Wallets.

    Who minted the most?

    • 0x7b557aa52d0055d84b1e3f5487d9018f318372c1 minted the most number of NFTs with 139 NFTs
    • Followed by 0x081a5fba5b0e02dfab0ae5ca276fe9ac387657b7 with 18 NFTs minted.
    Loading...
    Loading...