Question:

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 4 weeks? Which pools are wallets voting for with their locked tokens most often? 

Overview of essay:

Velodrome is an AMM designed as the central trading and liquidity marketplace on Optimism Network. Velodrome wants to encourage liquidity on veNFTs in ways that are value-additive to the flywheel and ecosystem. Through integrated features and partnerships with key OP protocols, aim o Velodrome is to develop instruments for healthy deployment of veVELO NFT.

The new locks on Velodrome finance have been studied in this essay.

Approach:

The following steps have been used:

1. First we should determine the Velodrome Locks by decoding

   topics[0]::STRING= '0xff04ccafc360e16b67d682d17bd9503c4c6b9a131f6be6325762dc9ffc7de624'

2. The time difference between lock time and locked_date

   DATEDIFF((year,month,week,day), block_timestamp,locked_date)

3. Find out accounts (distribution) with most lock

   when count_lock =1 then 'a. 1 lock' when count_lock between 2 and 5 then 'b. 2-5 locks' when count_lock between 5 and 20 then 'c. 5-20 locks' when count_lock>=20 then 'd. over 20 locks'

4. Voted pools

   decode from INPUT_DATA of from optimism.core.fact_transactions where TO_ADDRESS='0x09236cff45047dbee6b921e00704bed6d6b8cf7e' and ORIGIN_FUNCTION_SIGNATURE='0x7ac09bf7'

   \

Key findings:

1. The most popular duration of lock among Velodrome users is 4 year lock and 218 distinct provider lock for that duration as illustrated by table and both pie graphs.
2. The next popular lock durations are 4 weeks (1 month) and 52 weeks (1 year), respectively.
3. The consequences related to the count of lock reveals the domination of 1 lock by most of the providers (about 67.5%). Next, 472 distinct providers locked for 2-5 times.
4. The results related to the popular pools by accounts voting via their locked tokens displayed on Table and scatter plot ,accordingly.
5. According to these illustrations, the pool named VolatileV1 AMM - VELO/USDC and voted by 842 unique voters and over 1400 votes.