Osmosis critical bug, volume analysis

    What was the total dollar amount of assets that was improperly removed from pools due to the bug, and what is the list of addresses that had joined a pool since the upgrade? What is the dollar value deposited of those addresses joining pools? What is the cumulative value of funds that joined and exited?

    Loading...
    Loading...
    Loading...
    Loading...

    Method

    We are going to analyze transactions with msg_type 'pool_joined' and 'pool_exited' between blocks with id 4707300 and 4713064.

    • first we find all transactions with msg_type 'pool_joined'
    • we cluster them based on currency the used to deposit
    • we find the average price for currencies at the time of bug appearance
    • then we can have the USD volume for pool_joined deposits
    • we can repeat this steps for 'pool_exited' transactions

    To find addressed that have executed 'pool_joined' transactions, we can use the above method with grouping the transactions based on tx_from column.

    Loading...