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.
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
Presumably it's positive for the people collecting the fees, so that's OK then.
Here's hoping that eth's merge happens soon
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.)