split(split(EVENT_TYPE, '<')[1],'>')[0] as token_add,

case

when token_add ilike '0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T' then 'whUSDC'

when token_add ilike '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' then 'zUSDC'

when token_add ilike '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT' then 'zUSDT'

end as "Asset",

round(EVENT_DATA:amount/1e6, 2) AS RAW_AMOUNT,

round(EVENT_DATA:vault_collateral/1e6, 2) AS "Available Borrow",

round(EVENT_DATA:vault_liability/1e6, 2) AS "Total Borrowed",

"Available Borrow" + "Total Borrowed" AS "Total Supply",

FROM aptos.core.fact_events

where payload_function IN (

,'0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::vault_scripts::repay'

,'0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::vault_scripts::liquidate'

AND SUCCESS = TRUE

AND EVENT_MODULE = 'vault'

AND token_add IN (

,'0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC'

,'0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT'

QUALIFY ROW_NUMBER() OVER (PARTITION BY "Asset" ORDER BY BLOCK_TIMESTAMP DESC) = 1

,

aptin_Tb AS (

SELECT

CASE

when EVENT_DATA:coin_name ilike '0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::t' then 'whUSDC'

when EVENT_DATA:coin_name ilike '0xa2eda21a58856fda86451436513b867c97eecb4ba099da5775520e0f7492e852::coin::t' then 'whUSDT'