Finding holders for a specific token: Skill-building Bounty 13 (Hard)
Solve bounties that help you level up as an analyst. Join us on our live call on Tuesday, September 27 as we walk through solving this bounty together with you
A month ago we looked at how to query the top 10 holders for a specific token using the ethereum.core.ez_current_balances table.
This time, the task is to create a query to show the daily count of existing token holders for a specific token. The query should also be able to show the list of token holders at any specific day.
Hint: Use the ethereum.core.ez_balance_deltas table. You are encouraged to also use Etherscan to cross check your answer. For example, the token holders for sushi tokens can be found here: https://etherscan.io/token/0x6B3595068778DD592e39A122f4f5a5cF09C90fE2#balances
Don’t forget to join us for a walkthrough for this bounty in our live SQL sessions on discord on September 27. You can also catch the previous live SQL session recordings on our Youtube channel https://www.youtube.com/watch?v=FF_upt0F8gw&t=2s