[shubik22]

The article mentions high gas fees impacting refunds, and I was wondering what the extent of that impact was. The article doesn’t answer that question, but it does link to a tweet which links to a page of stats about ConstitutionDAO that does: https://dune.xyz/ilemi/ConstitutionDAO-Funding-Tracker

55.78% of funds returned! Truly an incredible accomplishment, and not in a positive way.

(edit: On second thought, does the 44% of original funds remaining include people who haven’t tried getting refunds? Curious if there’s an estimate of ETH lost purely to transaction fees.)

[hanklazard]

Yea, if you don’t request a refund, you don’t get it so yes, that % includes people who haven’t requested a refund.

Also, this token became a “meme coin” in the weeks that followed the auction loss, returning something like 10x or more on Uniswap. More sophisticated users traded their tokens there, rather than going through the official refund process.

[ShamelessC]

Another reason people wouldn't request a refund would be that they would actually lose money by doing so if their original spend was under 200$ because of "gas fees".

[X6S1x6Okd1st]

I might have the query wrong, but I am seeing 0.8% of redeemed fees were lost to transaction fees. I'm sure someone could also generate something that looks better into the effects of redeemtion size & whether people are just not redeeming because too much would be lost in txn fees.

Anyway here's the query:

``` WITH burnt as ( SELECT SUM(gas_used * (gas_price + priority_fee_per_gas))/1e18 as eth_burnt FROM ethereum."transactions" WHERE SUBSTRING("data",1,4) = '\x3015a5b5' --redeem AND "to" = '\xd569d3cce55b71a8a3f3c418c329a66e5f714431' AND SUBSTRING("data", 37,32) = '\x0000000000000000000000000000000000000000000000000000000000000024' --constitutiondao projectid ), ), returned as ( SELECT SUM(bytea2numeric(SUBSTRING("data", 101,32))/1e18) as returned FROM ethereum."transactions" WHERE SUBSTRING("data",1,4) = '\x3015a5b5' --redeem AND "to" = '\xd569d3cce55b71a8a3f3c418c329a66e5f714431' AND SUBSTRING("data", 37,32) = '\x0000000000000000000000000000000000000000000000000000000000000024' --constitutiondao projectid AND "success" )

SELECT (SELECT * FROM burnt)/(SELECT * FROM returned)*100 ```

To be used on dune analytics: https://dune.xyz/home

[jfk13]

> not in a positive way

Presumably it's positive for the people collecting the fees, so that's OK then.

[oefrha]

Which is negative for those of us who want to buy a frigging graphics card at a reasonable price.

[X6S1x6Okd1st]

Post eip-1559 most fees are burnt instead of paid to miners.

Here's hoping that eth's merge happens soon