WITH alltx AS (

-- Honey borrow

SELECT

block_timestamp,

'Honey borrow' AS type,

tx_hash,

'0x' || SUBSTR(DATA, 27, 40) AS address,

utils.udf_hex_to_int(SUBSTR(DATA, 67, 64)) / POW(10, 18) AS amount

FROM

berachain.testnet.fact_event_logs

WHERE

contract_address = lower('0x30A3039675E5b5cbEA49d9a5eacbc11f9199B86D')

AND ORIGIN_FUNCTION_SIGNATURE = '0xa415bcad' -- borrow

AND address = origin_from_address

AND '0x' || SUBSTR(PARSE_JSON(TOPICS)[1]::string, -40) = lower('0x0E4aaF1351de4c0264C5c7056Ef3777b41BD8e03') -- HONEY

UNION ALL

-- Honey repay

SELECT

block_timestamp,

'Honey repay' AS type,

tx_hash,

'0x' || SUBSTR(PARSE_JSON(TOPICS)[3]::string, -40) AS address,

utils.udf_hex_to_int(SUBSTR(DATA, 3, 64)) / POW(10, 18) AS amount

FROM

berachain.testnet.fact_event_logs

WHERE

contract_address = lower('0x30A3039675E5b5cbEA49d9a5eacbc11f9199B86D')

AND ORIGIN_FUNCTION_SIGNATURE = '0x573ade81' -- repay

AND origin_to_address = '0x30a3039675e5b5cbea49d9a5eacbc11f9199b86d'

AND '0x' || SUBSTR(PARSE_JSON(TOPICS)[1]::string, -40) = lower('0x0E4aaF1351de4c0264C5c7056Ef3777b41BD8e03') -- HONEY

AND address IS NOT NULL