Q8.

    Let’s take a closer look at DEXs on Optimism, specifically Velodrome. Make a dashboard that compares Velodrome to any other Optimism DEX based on: -Total number of swaps by day over the last month -Total number of wallets swapping by day -What are the most popular asset pairs to swap from and too

      -Top 10 assets swapping from

      -Top 10 assets to swap to

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    db_img

    Info

    Optimism uses advanced data compression techniques to speed up and cut the costs of Ethereum transactions. They do so by a technique known as called Optimistic Rollups, where multiple transactions are “rolled up” into one transaction and settled on another cheaper blockchain.

    Method

    tables: from optimism.core.fact_token_transfers , from optimism.core.dim_contracts
    
    when platform = '0xdef1abe32c034e558cdd535791643c58a13acc10' then '0xProject'
    when platform = '0xa132dab612db5cb9fc9ac426a0cc215a3423f9c9' then 'Velodrome Finance'
    when platform = '0xe592427a0aece92de3edee1f18e0157c05861564' then 'Uniswap'
    when platform = '0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45' then 'Uniswap' end as platforms
    

    Number of transactions

    The highest number of transactions was on July 29th. On this day, of all the transactions; around 30k transactions happened on Velodrome, almost 20k transactions belonged to Uniswap and only 1932 transactions were in 0xproject.

    The most cumulative transactions belong to Uniswap with almost 322k transactions on August 3rd.

    The cumulative Velodrome on August 3rd is 314.62k.

    The least cumulative belongs to 0xproject which is 32.7k on August 3rd.

    Number of users

    Platforms

    The highest number of users was on July 29th. On this day, of all the users; 4388 users had transactions on Uniswap, 1279 users belonged to Velodrome and 604 users made transactions in 0xproject.

    The most cumulative users belong to Uniswap with almost 54.56 transactions on August 3rd.

    The cumulative Velodrome on August 3rd is 21.15.

    The least cumulative belongs to 0xproject which is 12.26k on August 3rd.

    The totals

    Tokens in

    Number of swaps

    The token that had the most number of swaps; is USDC.

    This token was used to make swaps in, 142.16k transactions on Velodrome, 114.38k on Uniswap, and 15.87k on 0xproject.

    Most of the users used USDC to make swaps.

    Almost 112k users used USDC in Uniswap, 4565 users in 0xproject, and 3965 users in Velodrome.

    Tokens out

    Same as the tokens that were used to make swaps in, USDC used the most to make outage swaps.

    This token used 142.7k in Velodrome, 95.7k in Uniswap, and around 14k in 0xproject to make outage swaps.

    Most of the users used USDC to make outage swaps.

    7952 users used USDC in Uniswap, 4468 users in Velodrome, and only 4565 users in 0xproject

    Top 10 tokens based on the number of swap

    • In total USDC was used to make 252.39 transactions. This token had 40.9% part of the top 10 tokens in, based on the number of swaps.

      \

    • The second token that had a noticeable number of transactions was WETH which had 154k transactions.

      \

    • OP was in third place of the top 10 tokens which had more number of transactions with 153.3k.

    Top 10 tokens based on the number of users

    • In total 13.11k users used USDC to make swaps. USDC had 31.5% part of the top 10 tokens based on the number of users.

    • 7359 users who used WETH which had 17.7% part of the top 10 tokens.

    • The number of users that used OP was 5143 and this number of users caused OP to take 3rd place of the top tokens.

    Top 10 tokens based on the number of swaps

    • In total USDC was used to make 272.4k transactions. This token had 41.4% part of the top 10 tokens in, based on the number of swaps.

      \

    • The second token that had a noticeable number of transactions was WETH which had 142.3k transactions.

      \

    • OP was in third place of the top 10 tokens which had more number of transactions with 168k and 21.6%.

    Top 10 tokens based on the number of users

    • In total 17.8k users used USDC to make swaps. USDC had 30.1% part of the top 10 tokens based on the number of users.

    • 15.2k users used OP. OP had 25.7% part of the top 10 tokens.

    • The number of users that used WBTC was 6299 and this number of users caused WBTC to take 3rd place of the top tokens.

    Pairs

    Top 10 based on number of transactions

    • In total OP/USDC was used to make around 142k transactions. This pair had 26.9% part of the top 10 pairs, based on the number of swaps.

      \

    • The second pair that had a noticeable number of transactions was USDC/OP which had around 140k transactions.

      \

    • WETH/USDC was in third place of the top 10 pairs which had 82.3k number of transactions

    Top 10 based on number of users

    • In total 6639 users used the OP/USDC pair to make swaps. this pair had 40.9% part of the top 10 pairs based on the number of users.

    • 7359 users used USDC/OP which had 21.4% part of the top 10 tokens.

    • The number of users that used VELO/USDC was 3048 and this number of users caused this pair to take 3rd place of the top pairs.

    db_img
    db_img