Hacks, Scandals and Scams - 4. CEL token flows

    Overview

    Celsius Network listed a $1.19 billion deficit on its balance sheet in a bankruptcy court filing a day after the cryptocurrency lender filed for Chapter 11. Currently Celsius owns a large portion of the CEL tokens.

    In this dashboard we wanna see some data about Celsius wallets behavior with CEL token at last 90 days

    Goals of this case to find out :

    • What are the top addresses swapping and transferring CEL?
    • How have the CEL swap volumes changed over the past 90 days?
    • How are Celsius wallets interacting with the CEL token?

    Need to know

    • Time frame of this case is last 90 days

    • CEL address : 0xaaAEBE6Fe48E54f431b0C390CfaF0b017d09D42d

    • For identify Celsius should use crosschain.address_labels table of Flipside database

    Analyze

    • I used Flipside database and crosschain.address_labels to identify Celsius wallets then used ethereum.core.ez_token_transfers and

    ethereum.core.ez_dex_swaps tables to get wallets with most CEL token transferred or swapped

    • Then used ethereum.core.ez_dex_swaps table to get swaps volume of CEL token and also used ethereum.core.fact_hourly_token_prices to show CEL price over last 90 days

    In below you can see top 200 wallets with most CEL transferred or swapped at last 90 days

    Loading...
    Loading...

    In below you can see CEL price and CEL swaps volume over last 90 days

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

    In below you can see how much volume of assets swapped by Celsius wallets at last 90 days

    Loading...
    Loading...

    Results and conclusion

    • Between of top 200 wallets with most CEL swap or transfer there were just 6 wallets belongs to Celsius and their behavior were just transfer and not any swap
    • There were some downtrend in CEL price and top spikes in CEL swaps volume at around 13 Jun that was because of liquidation alerts and fear in market that after Celsius repay their loans every things getting better and price goes up
    • At last days Celsius wallets swapped some assets but there were no swaps for CEL token by them

    Base of all charts and data its obvious still they didn’t try to sell their CEL tokens and prefer to save their platform