flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
velodrome locks over time
cypher
velodrome locks over time
Updated 2022-11-13
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with
data
as
(
select
date_trunc
(
'day'
,
block_timestamp
)
as
date
,
datediff
(
day
,
date
::
date
,
unlock_date
)
as
lock_time
,
velo_amount_usd
as
amount_usd
from
optimism
.
velodrome
.
ez_velo_locks
where
velo_action
=
'deposit'
)
select
*
from
data
Results
Run a query to Download Data