Degen

I wanted to see how much damage overstaking is doing so I finally sat down and figured out how to write a Dune query.

Since this is my first query, I welcome someone checking my figures/calculations, but it looks pretty valid to me.

If you don't want to click through, here's the results as I write:

Lost Allowance Amount:            392,174
Total Overstake Amount: 	   33,989,745
Total Locked Amount:        390,023,685

                        Below Allow. Cap   Above Allow. Cap
% of Stakes     81                           19
# of Stakers    6,736                      47
Staked Amt.    315,298,133           74,725,552

So about 9% of allowances are lost that could have been distributed to smaller stakers because of overstaking. 

Some people may think that's no big deal, but it is to me. Small stakers need all the help they can get and their allowances will continue to go down as more people lock up their DEGEN. They are stuck for 3 months like this...

I wanted to see how much damage overstaking is doing so I finally sat down and figured out how to write a Dune query.

Since this is my first query, I welcome someone checking my figures/calculations, but it looks pretty valid to me.

If you don't want to click through, here's the results as I write:

Lost Allowance Amount:            392,174
Total Overstake Amount: 	   33,989,745
Total Locked Amount:        390,023,685

                        Below Allow. Cap   Above Allow. Cap
% of Stakes     81                           19
# of Stakers    6,736                      47
Staked Amt.    315,298,133           74,725,552

So about 9% of allowances are lost that could have been distributed to smaller stakers because of overstaking. 

Some people may think that's no big deal, but it is to me. Small stakers need all the help they can get and their allowances will continue to go down as more people lock up their DEGEN. They are stuck for 3 months like this... 

https://dune.com/queries/3912382

GenX girl who learned the hard way 🔹 lifelong artist 🔹 software engineer 🔹 curator of conversations 🔹 made /blend-o-rama 🔹 thinks you're cool