Lock Time (Base & ETH)

freemartianLock Time (Base & ETH)

Updated 4 hours ago

with

prices AS(

SELECT

hour,

price,

symbol,

ROW_NUMBER() OVER (ORDER BY hour DESC) AS row_num

FROM base.price.ez_prices_hourly

WHERE symbol ilike 'PRIME'

AND hour::date = current_date

qualify row_num = 1

base_deposit_temp AS (

SELECT

block_timestamp,

tx_hash,

origin_from_address as user,

regexp_substr_all(SUBSTR(data, 3, len(data)), '.{64}') AS temp_data,

ethereum.public.udf_hex_to_int(temp_data[0] :: STRING) AS depositIndex,

ethereum.public.udf_hex_to_int(temp_data[1] :: STRING)/pow(10,18) AS amount,

to_timestamp(ethereum.public.udf_hex_to_int(temp_data[3] :: STRING)) AS createdTimestamp,

to_timestamp(ethereum.public.udf_hex_to_int(temp_data[2] :: STRING)) AS endTimestamp,

DATEDIFF(DAY, createdTimestamp, endTimestamp) AS difference_in_days,

from base.core.fact_event_logs

-- where tx_hash in ('0xf7977ba798badd22d56d0f5576124e5f4f911bb66168ea8f0b8f3770850d7b3d')

WHERE origin_function_signature = '0xf104489f'

AND block_timestamp::date >= '2024-06-01'

AND origin_to_address = '0xfa980ced6895ac314e7de34ef1bfae90a5add21b'

AND contract_address IN ('0x75a44a70ccb0e886e25084be14bd45af57915451','0xfa980ced6895ac314e7de34ef1bfae90a5add21b')

AND ARRAY_SIZE(temp_data) = 4

base_deposits AS(

SELECT

block_timestamp,

Last run: about 4 hours agoAuto-refreshes every 1 hour

936B

598s

flipside