Velodrome Locks
Analyze new locks created on Velodrome Finance.
Introduction
what is Velodrome?
Velodrome is an innovative new AMM that will serve as the central trading and liquidity marketplace on optimism. It is designed in such a way that it provides deep liquidity and low slippage to token pairs, critical for the growth of the Optimism ecosystem
what is the difference between stable and Variable pools?
Stable pools are designed for assets with low volatility and Variable is for assets with high price volatility
why users vote?
Users by voting decide which liquidity pools receive emissions. The emission is $VELO reward
Method
-
with help of optimism.core.fact_event_logs and sample query that provided with the questions, I sorted wallets base on their locked value to find the most locked wallets
\
-
with help of DATED IFF function, I'd got the duration for the lock transactions then sorted it base on most common ones
\
-
ID got the pools address from INPUT_DATA column in optimism.core.fact_transactions table for transaction that had contact with '0x09236cff45047dbee6b921e00704bed6d6b8cf7e' address and then named them with help of Velodrome site
\n