Ethereum

    Recreating the ETH Burn Dashboard: Skill-building Bounty 10 (Easy)

    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

    This week, we’ll be recreating the EIP 1559 ETH Burn dashboard here https://bi.etherscan.io/public/dashboards/ORfoxXZXVdCGQ4ShYL2Ndk7ji6n0hLy9RwSrvt4w?org_slug=default


    We’ll only recreate 4 metrics in our dashboard: Total burnt fees in USD, total burnt fees in ETH, highest daily burn and a cumulative chart of burnt fees. 


    Hint: Use the ethereum.core.fact_blocks table and look at the columns ‘gas_used’ and ‘block_header_json’


    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