Hey! I couldn't find any socials linked to your gh account so just going to post this here.
Some of the Dune queries here look like they might be missing some data, mainly because of using ethereum.transactions over ethereum.traces.
I made some dune tables you can use to query for staking data without needing to write the whole code, staking_ethereum.flows should contain all the info you need (including tags), this is the main table I use for my staking dashboard: https://dune.com/hildobby/eth2-staking. You can also dig through the code for it here: https://github.com/duneanalytics/spellbook/tree/main/models/staking/ethereum (see staking_ethereum_deposits.sql & staking_ethereum_flows.sql for in/outflows and other tables for entity tagging).
Also, Rated's 6.5% estimation is for home stakers which isn't the same as solo stakers. Solo stakers can use aws and thus not be home stakers while tagged entities could stake with their own infra and thus be considered home stakers.
Feel free to DM me on Twitter (@hildobby_) or Telegram (@hildobby) if you need help here :)
Hey! I couldn't find any socials linked to your gh account so just going to post this here.
Some of the Dune queries here look like they might be missing some data, mainly because of using
ethereum.transactionsoverethereum.traces.I made some dune tables you can use to query for staking data without needing to write the whole code,
staking_ethereum.flowsshould contain all the info you need (including tags), this is the main table I use for my staking dashboard: https://dune.com/hildobby/eth2-staking. You can also dig through the code for it here: https://github.com/duneanalytics/spellbook/tree/main/models/staking/ethereum (see staking_ethereum_deposits.sql & staking_ethereum_flows.sql for in/outflows and other tables for entity tagging).Also, Rated's 6.5% estimation is for home stakers which isn't the same as solo stakers. Solo stakers can use aws and thus not be home stakers while tagged entities could stake with their own infra and thus be considered home stakers.
Feel free to DM me on Twitter (@hildobby_) or Telegram (@hildobby) if you need help here :)