Uniswap - CEX to DEX and DEX to CEX

    Examine the flow of UNI tokens between Centralized Exchanges (CEX) and Decentralized Exchanges (DEX). Identify the volume of UNI tokens being transferred from CEX to DEX and vice versa. Determine which exchanges have the highest volume in terms of USD and analyze whether more UNI tokens are flowing into or out of these exchanges.

    db_img

    What Is Uniswap (UNI)?

    • Uniswap is a popular decentralized trading protocol, known for its role in facilitating automated trading of decentralized finance (DeFi) tokens.

    • An example of an automated market maker (AMM), Uniswap launched in November 2018, but has gained considerable popularity this year thanks to the DeFi phenomenon and associated surge in token trading.

    • Uniswap aims to keep token trading automated and completely open to anyone who holds tokens, while improving the efficiency of trading versus that on traditional exchanges.

    • Uniswap creates more efficiency by solving liquidity issues with automated solutions, avoiding the problems which plagued the first decentralized exchanges.

    • In September 2020, Uniswap went a step further by creating and awarding its own governance token, UNI, to past users of the protocol. This added both profitability potential and the ability for users to shape its future — an attractive aspect of decentralized entities. link

    Methodology

    • This dashboard will investigate the Uniswap (UNI) token and the transfer flow of this token to/from Cex/Dex since the start.
    • Additionally, I discuss Dex and Cex transfer in a separate tab to illustrate the performance of each transfer type and then compare them together to illustrate which one has better performance.
    • Also, I used the Flipside database, specifically the Ethereum schema.
    • In addition, I try to answer the following questions:
    • -Total number of transfer transactions
    • -Total number of users
    • -Total transfer volume
    • -Average transactions per day
    • -Grouping transactions by their volume
    • -Grouping Users by their transactions number
    • And etc.

    Summary

    • It seems that users who wanted to transfer their UNI tokens tended to use Cex instead of Dexs, since Cexs has the highest number of transfer transactions, users, and volume.
    • Perhaps, the Ethereum fee is the biggest factor in encouraging users to use Cexs instead of Dexs.
    • Also, Binance and Coinbase have the most Transactions and Volume while Uniswap is the most popular Dex as it has the most Transactions and Volume.
    • In conclusion, according to the statistics, Cexs perform better than Dexs and trend of weekly transfer transactions, Users and volume in Dex/Cex sector is Downward.