Afonso_DiazAverage Unlock Time
Updated 2024-10-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
with
main as (
select
tx_hash,
block_timestamp,
unlock_timestamp,
account_address as user,
olas_amount,
olas_amount_usd
from
crosschain.olas.ez_olas_locking
where
block_timestamp between '{{ start_date }}' and '{{ end_date }}'
and event_name = 'Deposit'
)
select
avg(datediff('day', block_timestamp, unlock_timestamp)) as average_unlock_days,
median(datediff('day', block_timestamp, unlock_timestamp)) as median_unlock_days
from
main
QueryRunArchived: QueryRun has been archived