velo_lock as (

select

block_timestamp,

tx_hash,

from_address as locker,

ethereum.public.udf_hex_to_int(substr(input_data,11,64))/pow(10,18) as amount,

ethereum.public.udf_hex_to_int(substr(input_data,75)) as duration,

case

when duration < 704800 then '1 week'

when duration < 2729743 then '1 month'

when duration < 31656926 then '1 year'

when duration < 126327704 then '4 years'

else 'sus' end as time_lock,

case time_lock

when '1 week' then amount/(4*52)

when '1 month' then amount/(4*12)

when '1 year' then amount/(4)

when '4 years' then amount

end as ve_velo

from optimism.core.fact_transactions

where to_address = '0x9c7305eb78a432ced5c4d14cac27e8ed569a2e26'

and origin_function_signature = '0x65fc3873'

select

block_timestamp,

locker,

amount as velo_locked,

time_lock as duration_locked,

ve_velo,

tx_hash

from velo_lock

order by block_timestamp desc

limit 100