with deposit as (

select

'deposit' as event_name,

block_number,

block_timestamp,

tx_hash,

ORIGIN_FUNCTION_SIGNATURE,

origin_from_address,

origin_to_address,

event_index,

tx_status,

contract_address,

concat('0x', substr(topics[1],27,40)) as token_address,

concat('0x', substr(topics[2],27,40)) as user,

REGEXP_SUBSTR_ALL(SUBSTR(data, 3, len(data)), '.{64}') as segmented_data,

livequery.utils.udf_hex_to_int(SUBSTR(segmented_data[1], 3, 64)) :: float as raw_amount

from blast.core.fact_event_logs

where contract_address = '0xd2499b3c8611e36ca89a70fda2a72c49ee19eaa8'

and topics[0] = '0x2b627736bca15cd5381dcf80b0bf11fd197d01a037c52b927a881a10fb73ba61'

and block_timestamp::date >= '2024-02-29'

,

borrow as (

select

'borrow' as event_name,

block_number,

block_timestamp,

tx_hash,

ORIGIN_FUNCTION_SIGNATURE,

origin_from_address,

origin_to_address,

event_index,

tx_status,

contract_address,