Intro:

Velodrome Finance, at its core, is a solution for protocols on Optimism to properly incentivize liquidity for their own use cases.

Velodrome allow protocols and other large stakeholders to become veNFT "voters", using their locked voting power to direct future emissions and collecting fees (termed bribes in Solidly) from the pools they voted for.

In this bounty, the new locks created on Velodrome is investigated by considering the fllowing metrics:

• Duration of lock
• Top wallets with most lock
• Top pools wallets voting for them with their tokens

Method:

• Used table-→ optimism.core.fact_event_logs
• New locks-→ '0xff04ccafc360e16b67d682d17bd9503c4c6b9a131f6be6325762dc9ffc7de624'
• Decode of new locks-→ sample query
• Lock date-→ DATEDIFF(day, block_timestamp,locked_date)
• Top wallets-→ distinct provider
• Pool address-→ CONCAT('0x', SUBSTR(INPUT_DATA :: STRING, 291, 40))

Outcomes:

• The lock duration is considers by days. As shown in the first donut chart, most of the locks has lock duration about 1456 days which equal to 4 years.
• Based on the bar chart related to the top wallets, the top ranked wallet with most lock in the past 4 weeks has more than 1200 locks.
• Now wants to track the liquidity pools voted by wallets. As shown in the related bar chart, the VolatileV1 AMM - VELO/USDC pool has usage about 967 time and stands in the first rank.
• The second liquidity pool with most usage is VolatileV1 AMM - OP/USDC with 611 time voted by wallets.
• The voting activity on liquidity pools by wallets shown in the time based bar chart. As shown in the chart, the start point of it from June 15, 2022.
• According to the daily voting, the high usage of VolatileV1 AMM - VELO/USDC and VolatileV1 AMM - OP/USDC can be obviously seen over time.