Try Quests to earn cryptoVelodrome Locks
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?
Introduction
According to the documents
> Velodrome Finance, at its core, is a solution for protocols on Optimism to properly incentivize liquidity for their own use cases. Building on top of the groundwork laid out by Solidly, our team has addressed that first iteration's core issues to realize its full potential.
For this analysis, we needed information that we could extract from the optimism data with the help of the
optimism.core.fact_event_logs table In many cases, the data needed to be sorted and cleaned to meet our needs.
Although the SQL codes of this analysis are relatively simple, they are extremely useful, and with the help of these codes, I have been able to provide a detailed analysis of the requirements of the question, and in some places, other interesting things outside of the question have also been mentioned.
The daily transactions and the number of locks over time are shown in the two graphs below The first graph shows the symmetrical distribution of the number of daily transactions for
Velodrome Locks, and the second graph shows the opposite
In the second chart, July and August 2022, January 2023, and the end of May 2026 are important dates.
I could choose many criteria for the top ten wallets, but the number and volume seem to be the most reasonable criteria In both charts, the other share seems high
But in the second graph, which is based on the number of transactions, this account has a significant share
By placing names instead of addresses and categories in SQL codes on the addresses of the pools, we can get the amount of transactions. Apart from the number The amount of the fee seems to be an important factor, which can be seen in the second graph, how much the fee was