Analyze new locks created on Velodrome Finance.

Analyze new locks created on Velodrome Finance. What durations are most common? Which wallets have locked the most in the last four weeks? Which pools are wallets voting for with their locked tokens most often?

Info

The velodrome is an AMM designed as the trading and liquidity marketplace on the Optimism network, launching on May 31st, 2022.

Its mission is to be the liquidity base layer of Optimism, allowing users to trade digital assets in a secure way, with very low fees and low slippage.

\n

Methods

• I used the hint from the flipside sample query.
• Table: optimism.core.fact_event_logs
• count_tx: count(DISTINCT tx_hash)
• user: count(DISTINCT ORIGIN_FROM_ADDRESS)
• amount: sum(value)
• origin_function_signature= '0x65fc3873'
• \

Number of transactions

\

• The highest number of transactions on Velodrome Finance over the past month was on July 14th.

  On this day, the number of transactions was 221.

  \

• The lowest number of transactions over the past 30 days was on June 30th.

  On this day, the number of transactions was 10.

• From July 13th till July 17th, the number of transactions increased.

Number of users

\

• The highest number of users on Velodrome Finance over the past month was on July 14th.

  On this day, the number of users was 202.

  \

• The lowest number of users over the past 30 days was on June 30th.

  On this day, the number of users was 10.

• The number of users on Velodrome Finance increased on July 13th and July 14th.

Volume

\

• The highest volume of transactions on Velodrome Finance over the past month was on June 15th.

  On this day, the volume was 23 million, and the average amount of transactions was 447.78k

  \

• The lowest volume of transactions over the past 30 days was on June 30th.

  On this day, the volume of transactions was around 18k, and the average amount of each transaction was 1792.

Withdraw

\

• The highest number of transactions of withdrawal actions on Velodrome Finance over the past month was on July 14th.

  On this day, the number of withdrawal transactions was 47.

  \

• The lowest number of transactions of withdrawal actions on Velodrome Finance over the past month was on June 27th.

  On this day, the number of withdrawal transactions was only 1.

\

• The highest number of users who had withdrawn actions on Velodrome Finance over the past month was on July 14th.

  On this day, the number of users on withdrawal transactions was 44.

  \

• The lowest number of users who had withdrawn actions on Velodrome Finance over the past month was on June 27th.

  On this day, only one user made the withdrawn transaction.

Number of transactions

Number of users

Volume

Duration

The highest duration of locked value on the Velodrome Finance was 80 days.

The average days of locked value are 7.1 days.

Top 20 wallets

Number of transactions

• The first wallet of the top 20 wallets had 121 transactions over the past month. This wallet had 51.3% part of the top 20 wallets based on the number of transactions.

• The second wallet had 15 transactions. This wallet had 6.36% part of the top 20 wallets.

  \

There is a massive difference between the first and the second wallet.

Volume

• The first wallet of the top 20 wallets made transactions that were valued at 23.7 million over the past month. This wallet had 30% part of the top 20 wallets based on the locked volume.

• The second wallet had a 5.11 million locked volume. This wallet had 6.48% part of the top 20 wallets.

  \

Top pools

• The first pool that had the most vote among the top 5 pools was the Velo_USDC pool. This pool had 1487 votes.

  This wallet had 43.2% of the top pools based on the number of votes.

• The second wallet was the OP-USDC pool which had 941 votes and 27.3% part

• The third wallet was the WETH-USDC pool with 406 votes and 11.8% part.

• The VELO-OP pools had 313 votes.

• The USDC-sUSD pool had 294 votes over the past month and took fifth place among the top 5 pools.

\

• The highest volume of withdrawal transactions on Velodrome Finance over the past month was on July 16th.

  On this day, the volume of withdrawal transactions was 4.5 million.

  \

• The lowest volume of withdrawal transactions on Velodrome Finance over the past month was on June 25th.

  On this day, the volume of withdrawal transactions was only 105.

  \