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

Fantastic work putting all this together! I only locked a little to share with my supporters. 🎭

I made another query that lets you simulate what things might be under different total daily allowance, allowance cap and staking cap scenarios.

Try it out and see if you can get better outcomes than I did.

Just adding a staking cap of 800k got rid of almost all overstaking and helped push the minimum stake for maximum allowance (MSfMA) down too. It's too late to do that now, of course, but capping staking at 1m would have been a good idea for everyone. Not enough thought went into this beforehand.

Adjusting the allowance cap down makes the MSfMA go up, and that's not great, even though it helps reduce overstaking.

Adjusting the amount of daily allowance doesn't have an affect on overstaking, but can lower the MSfMA which really doesn't mater now that most people who were going to lock have already done it.

Capped staking would have been the real fix for this so that's sad. Not sure how to adjust the allowance algo without some really fancy math now.

https://dune.com/queries/3912919

Glad you found it useful! 💙 
I made another one that lets you play with the caps to see how it affects things, if you are interested in that!

𝔽𝕚𝕣𝕖 𝕕𝕒𝕟𝕔𝕖𝕣, 𝔸𝕣𝕥𝕚𝕤𝕥 & 𝕐𝕠𝕘𝕒 🔥

Will definitely check this out! I’m outta masks Here’s 500 $WILD

Glad you found it useful! 💙 
I made another one that lets you play with the caps to see how it affects things, if you are interested in that!
https://warpcast.com/bluecockatoo/0x5fdf5770