Ethereum

    Etherscan 'Internal transactions’: Skill-building Bounty 11 (Hard)

    Solve bounties that help you level up as an analyst. Join us on our live call on Tuesday, September 20 as we walk through solving this bounty together with you

    Payout
    0
    Level
    Beginner
    Difficulty
    Medium
    Ended

    We’ve all seen Etherscan transactions with entries in the ‘internal transactions’ tab, but what do those mean and how do we query those? 


    https://etherscan.io/tx/0xe91b076db193dac2ed4bbb931151ad26bb7fb54b56641043f9e0aa30b26be5a2/advanced 

    The sample transaction above is one with internal transactions with the following details: 

    • A transaction to settle an NFT auction in the SuperRare platform 
    • NFT contract address: 0x233FFf5F31Dc468936194fdD44BB237F31095D90, TokenId: 4 
    • Distribute the NFT to the winning bidder 
    • Distribute the funds to the seller 


    Using a combination of fact_transactions, event_logs and the traces table, create a raw table that shows all ‘settle auction’ transactions with this NFT contract address for all TokenIds. The table would have the following:

    • tokenId
    • Winning bidder address 
    • How much ETH was sent to the Superrare Treasury address 
    • How much ETH did the seller receive 


    Don’t forget to join us for a walkthrough for this bounty in our live SQL sessions on discord on September 20. You can also catch the previous live SQL session recordings on our Youtube channel https://www.youtube.com/watch?v=FF_upt0F8gw&t=2s