with final_table as (

with blend_table as (SELECT

date_trunc('hour',block_timestamp) as date,

tx_hash,

origin_function_signature,

origin_from_address,

origin_to_address,

'0x' || SUBSTR(INPUT, 35, 40) AS token_address, case

when '0x' || SUBSTR(INPUT, 35, 40)='0x7ec27d448c6437b4dc3561b3b33512680a179c3f' then 'tBTC'

when '0x' || SUBSTR(INPUT, 35, 40)='0xd68308efbe8330a7bf58276edef51d91316e90b4' then 'USDT'

when '0x' || SUBSTR(INPUT, 35, 40)='0x5eaa741552d6af40c7bf46467eaf79eea08eea9f' then 'WBTC'

when '0x' || SUBSTR(INPUT, 35, 40)='0xf08085ed33c0619113ee706fdb4b1b2c96137bee' then 'USDC'

when '0x' || SUBSTR(INPUT, 35, 40)='0x637e22a1ebbca50ea2d34027c238317fd10003eb' then 'MUSD'

end as symbol,

(

TO_NUMBER(SUBSTR(INPUT, 75, 8), 'XXXXXXXX') * POW(16, 56) +

TO_NUMBER(SUBSTR(INPUT, 83, 8), 'XXXXXXXX') * POW(16, 48) +

TO_NUMBER(SUBSTR(INPUT, 91, 8), 'XXXXXXXX') * POW(16, 40) +

TO_NUMBER(SUBSTR(INPUT, 99, 8), 'XXXXXXXX') * POW(16, 32) +

TO_NUMBER(SUBSTR(INPUT, 107, 8), 'XXXXXXXX') * POW(16, 24) +

TO_NUMBER(SUBSTR(INPUT, 115, 8), 'XXXXXXXX') * POW(16, 16) +

TO_NUMBER(SUBSTR(INPUT, 123, 8), 'XXXXXXXX') * POW(16, 8) +

TO_NUMBER(SUBSTR(INPUT, 131, 8), 'XXXXXXXX') * POW(16, 0)

) AS raw_amount, case

when '0x' || SUBSTR(INPUT, 35, 40)='0x7ec27d448c6437b4dc3561b3b33512680a179c3f' then 18

when '0x' || SUBSTR(INPUT, 35, 40)='0xd68308efbe8330a7bf58276edef51d91316e90b4' then 6

when '0x' || SUBSTR(INPUT, 35, 40)='0x5eaa741552d6af40c7bf46467eaf79eea08eea9f' then 18

when '0x' || SUBSTR(INPUT, 35, 40)='0xf08085ed33c0619113ee706fdb4b1b2c96137bee' then 6

when '0x' || SUBSTR(INPUT, 35, 40)='0x637e22a1ebbca50ea2d34027c238317fd10003eb' then 18

end as decimal, case

when origin_function_signature='0x617ba037' then 'Supply'

when origin_function_signature='0xa415bcad' then 'Borrow'

when origin_function_signature='0x573ade81' then 'Repay'

when origin_function_signature='0x69328dec' then 'Withdraw'

end as action_type