WITH CREATE_VAULT_EVENT AS ( SELECT BLOCK_TIMESTAMP, TX_HASH, EVENT_DATA:vault_address AS VAULT_ADDRESS, ACCOUNT_ADDRESS, iff(EVENT_RESOURCE ILIKE 'DepositEvent<%', 'Deposit Collateral', 'Borrow') AS EVENT_TYPE, iff(EVENT_RESOURCE ILIKE 'DepositEvent<%', EVENT_DATA:amount, 0) AS RAW_DEPOSIT_AMOUNT, iff(EVENT_RESOURCE ILIKE 'BorrowEvent<%', EVENT_DATA:amount, 0) AS RAW_BORROW_AMOUNT, iff(EVENT_RESOURCE ILIKE 'BorrowEvent<%', EVENT_DATA:fee, 0) AS RAW_BORROW_FEE_AMOUNT, iff(EVENT_RESOURCE ILIKE 'DepositEvent<%',REPLACE(SPLIT(EVENT_TYPE, '<')[1], '>', ''), NULL) AS COLLATERAL_ASSET_TYPE, iff(EVENT_RESOURCE ILIKE 'BorrowEvent<%','0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_coin::MOD', NULL) AS BORROW_ASSET_TYPE, iff(EVENT_RESOURCE ILIKE 'BorrowEvent<%','Move Dollar', NULL) AS BORROW_ASSET_NAME, iff(EVENT_RESOURCE ILIKE 'BorrowEvent<%','MOD', NULL) AS BORROW_ASSET_SYMBOL, iff(EVENT_RESOURCE ILIKE 'BorrowEvent<%',8, 0) AS BORROW_ASSET_DECIMAL FROM aptos.core.fact_events WHERE PAYLOAD_FUNCTION ILIKE '%::open_vault' AND SUCCESS = TRUE AND EVENT_ADDRESS = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01' AND EVENT_MODULE = 'vault' ), CREATE_VAULT_EVENT_DEPOSIT AS ( SELECT DEPOSIT.BLOCK_TIMESTAMP, DEPOSIT.TX_HASH, DEPOSIT.VAULT_ADDRESS, DEPOSIT.ACCOUNT_ADDRESS, DEPOSIT.EVENT_TYPE, DEPOSIT.COLLATERAL_ASSET_TYPE, DEPOSIT.RAW_DEPOSIT_AMOUNT FROM CREATE_VAULT_EVENT DEPOSIT WHERE DEPOSIT.EVENT_TYPE = 'Deposit Collateral' ), DEPOSIT_COLLATERAL_EVENT AS ( SELECT BLOCK_TIMESTAMP, TX_HASH, EVENT_DATA:vault_address AS VAULT_ADDRESS, ACCOUNT_ADDRESS, 'Deposit Collateral' AS EVENT_TYPE, REPLACE(SPLIT(EVENT_TYPE, '<')[1], '>', '') AS COLLATERAL_ASSET_TYPE, EVENT_DATA:amount AS RAW_DEPOSIT_AMOUNT FROM aptos.core.fact_events WHERE ((PAYLOAD_FUNCTION ILIKE '%::deposit_collateral') OR (EVENT_TYPE ILIKE '%::vault::DepositEvent<%' AND ACCOUNT_ADDRESS = '0x46071dacabc07979c25c709ce902d9d86c54cc6dfcd8892ab01aa4858177cbf8')) AND SUCCESS = TRUE AND EVENT_ADDRESS = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01' AND EVENT_MODULE = 'vault' ), ALL_DEPOSIT_COLLATERAL AS ( SELECT * FROM CREATE_VAULT_EVENT_DEPOSIT UNION ALL SELECT * FROM DEPOSIT_COLLATERAL_EVENT ), DEPOSIT_COLLATERAL_DETAILS AS ( SELECT DEPOSIT.BLOCK_TIMESTAMP, DEPOSIT.TX_HASH, DEPOSIT.VAULT_ADDRESS, DEPOSIT.ACCOUNT_ADDRESS, DEPOSIT.EVENT_TYPE, DEPOSIT.COLLATERAL_ASSET_TYPE, CASE WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0x84d7aeef42d38a5ffc3ccef853e1b82e4958659d16a7de736a29c55fbbeb0114::staked_aptos_coin::StakedAptosCoin' THEN 'Tortuga Staked Aptos' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0x159df6b7689437016108a019fd5bef736bac692b6d4a1f10c941f6fbb9a74ca6::oft::CakeOFT' THEN 'PancakeSwap Token' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xd916a950d4c1279df4aa0d6f32011842dc5c633a45c11ac5019232c159d115bb::coin::T' THEN 'wTBT Pool' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' THEN 'USD Coin (LayerZero)' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xcc8a89c8dce9693d354449f1f73e60e14e347417854f029db5bc8e7454008abb::coin::T' THEN 'Wrapped Ether (Wormhole)' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::WETH' THEN 'Wrapped Ether (LayerZero)' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT' THEN 'USD Tether (LayerZero)' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0x1::aptos_coin::AptosCoin' THEN 'Aptos Coin' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T' THEN 'USD Coin (Wormhole)' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xfaf4e633ae9eb31366c9ca24214231760926576c7b625313b3688b5e900731f6::staking::StakedThalaAPT' THEN 'Staked Thala APT' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xcfea864b32833f157f042618bd845145256b1bf4c0da34a7013b76e42daa53cc::usdy::USDY' THEN 'Ondo US Dollar Yield' END AS COLLATERAL_ASSET_NAME, CASE WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0x84d7aeef42d38a5ffc3ccef853e1b82e4958659d16a7de736a29c55fbbeb0114::staked_aptos_coin::StakedAptosCoin' THEN 'tAPT' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0x159df6b7689437016108a019fd5bef736bac692b6d4a1f10c941f6fbb9a74ca6::oft::CakeOFT' THEN 'CAKE' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xd916a950d4c1279df4aa0d6f32011842dc5c633a45c11ac5019232c159d115bb::coin::T' THEN 'wTBT' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' THEN 'zUSDC' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xcc8a89c8dce9693d354449f1f73e60e14e347417854f029db5bc8e7454008abb::coin::T' THEN 'whWETH' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::WETH' THEN 'zWETH' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT' THEN 'zUSDT' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0x1::aptos_coin::AptosCoin' THEN 'APT' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T' THEN 'whUSDC' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xfaf4e633ae9eb31366c9ca24214231760926576c7b625313b3688b5e900731f6::staking::StakedThalaAPT' THEN 'sthAPT' WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xcfea864b32833f157f042618bd845145256b1bf4c0da34a7013b76e42daa53cc::usdy::USDY' THEN 'USDY' END AS COLLATERAL_ASSET_SYMBOL, CASE WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0x84d7aeef42d38a5ffc3ccef853e1b82e4958659d16a7de736a29c55fbbeb0114::staked_aptos_coin::StakedAptosCoin' THEN 8 WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0x159df6b7689437016108a019fd5bef736bac692b6d4a1f10c941f6fbb9a74ca6::oft::CakeOFT' THEN 8 WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xd916a950d4c1279df4aa0d6f32011842dc5c633a45c11ac5019232c159d115bb::coin::T' THEN 8 WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' THEN 6 WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xcc8a89c8dce9693d354449f1f73e60e14e347417854f029db5bc8e7454008abb::coin::T' THEN 8 WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::WETH' THEN 6 WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT' THEN 6 WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0x1::aptos_coin::AptosCoin' THEN 8 WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T' THEN 6 WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xfaf4e633ae9eb31366c9ca24214231760926576c7b625313b3688b5e900731f6::staking::StakedThalaAPT' THEN 8 WHEN DEPOSIT.COLLATERAL_ASSET_TYPE IS NOT NULL AND DEPOSIT.COLLATERAL_ASSET_TYPE = '0xcfea864b32833f157f042618bd845145256b1bf4c0da34a7013b76e42daa53cc::usdy::USDY' THEN 6 END AS COLLATERAL_ASSET_DECIMAL, DEPOSIT.RAW_DEPOSIT_AMOUNT * POW(10, -(COLLATERAL_ASSET_DECIMAL)) AS DEPOSIT_AMOUNT FROM ALL_DEPOSIT_COLLATERAL DEPOSIT ), CREATE_VAULT_EVENT_BORROW AS ( SELECT BORROW.BLOCK_TIMESTAMP, BORROW.TX_HASH, BORROW.VAULT_ADDRESS, BORROW.ACCOUNT_ADDRESS, BORROW.EVENT_TYPE, BORROW.BORROW_ASSET_TYPE, BORROW.BORROW_ASSET_NAME, BORROW.BORROW_ASSET_SYMBOL, BORROW.BORROW_ASSET_DECIMAL, BORROW.RAW_BORROW_AMOUNT, BORROW.RAW_BORROW_FEE_AMOUNT FROM CREATE_VAULT_EVENT BORROW WHERE BORROW.EVENT_TYPE = 'Borrow' ), BORROW_EVENT AS ( SELECT BLOCK_TIMESTAMP, TX_HASH, EVENT_DATA:vault_address AS VAULT_ADDRESS, ACCOUNT_ADDRESS, 'Borrow' AS EVENT_TYPE, '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_coin::MOD' AS BORROW_ASSET_TYPE, 'Move Dollar' AS BORROW_ASSET_NAME, 'MOD' AS BORROW_ASSET_SYMBOL, 8 AS BORROW_ASSET_DECIMAL, EVENT_DATA:amount AS RAW_BORROW_AMOUNT, EVENT_DATA:fee AS RAW_BORROW_FEE_AMOUNT, FROM aptos.core.fact_events WHERE PAYLOAD_FUNCTION ILIKE '%::borrow' AND SUCCESS = TRUE AND EVENT_ADDRESS = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01' AND EVENT_MODULE = 'vault' ), ALL_BORROW AS ( SELECT * FROM CREATE_VAULT_EVENT_BORROW UNION ALL SELECT * FROM BORROW_EVENT ), BORROW_DETAILS AS ( SELECT BORROW.BLOCK_TIMESTAMP, BORROW.TX_HASH, BORROW.VAULT_ADDRESS, BORROW.ACCOUNT_ADDRESS, BORROW.EVENT_TYPE, BORROW.BORROW_ASSET_TYPE, BORROW.BORROW_ASSET_NAME, BORROW.BORROW_ASSET_SYMBOL, BORROW.BORROW_ASSET_DECIMAL, BORROW.RAW_BORROW_AMOUNT * POW(10, -(BORROW.BORROW_ASSET_DECIMAL)) AS BORROW_AMOUNT, BORROW.RAW_BORROW_FEE_AMOUNT * POW(10, -(BORROW.BORROW_ASSET_DECIMAL)) AS BORROW_FEE_AMOUNT FROM ALL_BORROW BORROW ), CLOSE_VAULT_EVENT AS ( SELECT BLOCK_TIMESTAMP, TX_HASH, EVENT_DATA:vault_address AS VAULT_ADDRESS, ACCOUNT_ADDRESS, iff(EVENT_RESOURCE ILIKE 'WithdrawEvent<%', 'Withdraw Collateral', 'Repay') AS EVENT_TYPE, iff(EVENT_RESOURCE ILIKE 'WithdrawEvent<%', EVENT_DATA:amount, 0) AS RAW_WITHDRAW_AMOUNT, iff(EVENT_RESOURCE ILIKE 'RepayEvent<%', EVENT_DATA:amount, 0) AS RAW_REPAY_AMOUNT, iff(EVENT_RESOURCE ILIKE 'RepayEvent<%', EVENT_DATA:interest_paid, 0) AS RAW_REPAY_INTEREST_PAID, iff(EVENT_RESOURCE ILIKE 'WithdrawEvent<%',REPLACE(SPLIT(EVENT_TYPE, '<')[1], '>', ''), NULL) AS WITHDRAW_ASSET_TYPE, iff(EVENT_RESOURCE ILIKE 'RepayEvent<%','0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_coin::MOD', NULL) AS REPAY_ASSET_TYPE, iff(EVENT_RESOURCE ILIKE 'RepayEvent<%','Move Dollar', NULL) AS REPAY_ASSET_NAME, iff(EVENT_RESOURCE ILIKE 'RepayEvent<%','MOD', NULL) AS REPAY_ASSET_SYMBOL, iff(EVENT_RESOURCE ILIKE 'RepayEvent<%',8, 0) AS REPAY_ASSET_DECIMAL FROM aptos.core.fact_events WHERE PAYLOAD_FUNCTION ILIKE '%::close_vault' AND SUCCESS = TRUE AND EVENT_ADDRESS = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01' AND EVENT_MODULE = 'vault' ), CLOSE_VAULT_EVENT_WITHDRAW AS ( SELECT WITHDRAW.BLOCK_TIMESTAMP, WITHDRAW.TX_HASH, WITHDRAW.VAULT_ADDRESS, WITHDRAW.ACCOUNT_ADDRESS, WITHDRAW.EVENT_TYPE, WITHDRAW.WITHDRAW_ASSET_TYPE, WITHDRAW.RAW_WITHDRAW_AMOUNT FROM CLOSE_VAULT_EVENT WITHDRAW WHERE WITHDRAW.EVENT_TYPE = 'Withdraw Collateral' ), WITHDRAW_COLLATERAL_EVENT AS ( SELECT BLOCK_TIMESTAMP, TX_HASH, EVENT_DATA:vault_address AS VAULT_ADDRESS, ACCOUNT_ADDRESS, 'Withdraw Collateral' AS EVENT_TYPE, REPLACE(SPLIT(EVENT_TYPE, '<')[1], '>', '') AS WITHDRAW_ASSET_TYPE, EVENT_DATA:amount AS RAW_WITHDRAW_AMOUNT FROM aptos.core.fact_events WHERE PAYLOAD_FUNCTION ILIKE '%::withdraw_collateral' AND SUCCESS = TRUE AND EVENT_ADDRESS = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01' AND EVENT_MODULE = 'vault' ), LIQUIDATE_EVENT AS ( SELECT BLOCK_TIMESTAMP, TX_HASH, EVENT_DATA:vault_address AS VAULT_ADDRESS, ACCOUNT_ADDRESS, iff(EVENT_RESOURCE ILIKE 'WithdrawEvent<%', 'Withdraw Collateral', 'Repay') AS EVENT_TYPE, iff(EVENT_RESOURCE ILIKE 'WithdrawEvent<%', EVENT_DATA:amount, 0) AS RAW_WITHDRAW_AMOUNT, iff(EVENT_RESOURCE ILIKE 'RepayEvent<%', EVENT_DATA:amount, 0) AS RAW_REPAY_AMOUNT, iff(EVENT_RESOURCE ILIKE 'RepayEvent<%', EVENT_DATA:interest_paid, 0) AS RAW_REPAY_INTEREST_PAID, iff(EVENT_RESOURCE ILIKE 'WithdrawEvent<%',REPLACE(SPLIT(EVENT_TYPE, '<')[1], '>', ''), NULL) AS WITHDRAW_ASSET_TYPE, iff(EVENT_RESOURCE ILIKE 'RepayEvent<%','0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_coin::MOD', NULL) AS REPAY_ASSET_TYPE, iff(EVENT_RESOURCE ILIKE 'RepayEvent<%','Move Dollar', NULL) AS REPAY_ASSET_NAME, iff(EVENT_RESOURCE ILIKE 'RepayEvent<%','MOD', NULL) AS REPAY_ASSET_SYMBOL, iff(EVENT_RESOURCE ILIKE 'RepayEvent<%',8, 0) AS REPAY_ASSET_DECIMAL FROM aptos.core.fact_events WHERE PAYLOAD_FUNCTION ILIKE '%::liquidate' AND SUCCESS = TRUE AND EVENT_ADDRESS = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01' AND EVENT_MODULE = 'vault' AND EVENT_RESOURCE NOT LIKE 'LiquidationEvent<%' ), LIQUIDATE_EVENT_WITHDRAW AS ( SELECT WITHDRAW.BLOCK_TIMESTAMP, WITHDRAW.TX_HASH, WITHDRAW.VAULT_ADDRESS, WITHDRAW.ACCOUNT_ADDRESS, WITHDRAW.EVENT_TYPE, WITHDRAW.WITHDRAW_ASSET_TYPE, WITHDRAW.RAW_WITHDRAW_AMOUNT FROM LIQUIDATE_EVENT WITHDRAW WHERE WITHDRAW.EVENT_TYPE = 'Withdraw Collateral' ), ALL_WITHDRAW_COLLATERAL AS ( SELECT * FROM CLOSE_VAULT_EVENT_WITHDRAW UNION ALL SELECT * FROM WITHDRAW_COLLATERAL_EVENT -- UNION ALL -- SELECT * FROM LIQUIDATE_EVENT_WITHDRAW ), WITHDRAW_COLLATERAL_DETAILS AS ( SELECT WITHDRAW.BLOCK_TIMESTAMP, WITHDRAW.TX_HASH, WITHDRAW.VAULT_ADDRESS, WITHDRAW.ACCOUNT_ADDRESS, WITHDRAW.EVENT_TYPE, WITHDRAW.WITHDRAW_ASSET_TYPE, CASE WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0x84d7aeef42d38a5ffc3ccef853e1b82e4958659d16a7de736a29c55fbbeb0114::staked_aptos_coin::StakedAptosCoin' THEN 'Tortuga Staked Aptos' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0x159df6b7689437016108a019fd5bef736bac692b6d4a1f10c941f6fbb9a74ca6::oft::CakeOFT' THEN 'PancakeSwap Token' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xd916a950d4c1279df4aa0d6f32011842dc5c633a45c11ac5019232c159d115bb::coin::T' THEN 'wTBT Pool' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' THEN 'USD Coin (LayerZero)' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xcc8a89c8dce9693d354449f1f73e60e14e347417854f029db5bc8e7454008abb::coin::T' THEN 'Wrapped Ether (Wormhole)' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::WETH' THEN 'Wrapped Ether (LayerZero)' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT' THEN 'USD Tether (LayerZero)' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0x1::aptos_coin::AptosCoin' THEN 'Aptos Coin' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T' THEN 'USD Coin (Wormhole)' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xfaf4e633ae9eb31366c9ca24214231760926576c7b625313b3688b5e900731f6::staking::StakedThalaAPT' THEN 'Staked Thala APT' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xcfea864b32833f157f042618bd845145256b1bf4c0da34a7013b76e42daa53cc::usdy::USDY' THEN 'Ondo US Dollar Yield' END AS WITHDRAW_ASSET_NAME, CASE WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0x84d7aeef42d38a5ffc3ccef853e1b82e4958659d16a7de736a29c55fbbeb0114::staked_aptos_coin::StakedAptosCoin' THEN 'tAPT' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0x159df6b7689437016108a019fd5bef736bac692b6d4a1f10c941f6fbb9a74ca6::oft::CakeOFT' THEN 'CAKE' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xd916a950d4c1279df4aa0d6f32011842dc5c633a45c11ac5019232c159d115bb::coin::T' THEN 'wTBT' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' THEN 'zUSDC' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xcc8a89c8dce9693d354449f1f73e60e14e347417854f029db5bc8e7454008abb::coin::T' THEN 'whWETH' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::WETH' THEN 'zWETH' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT' THEN 'zUSDT' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0x1::aptos_coin::AptosCoin' THEN 'APT' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T' THEN 'whUSDC' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xfaf4e633ae9eb31366c9ca24214231760926576c7b625313b3688b5e900731f6::staking::StakedThalaAPT' THEN 'sthAPT' WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xcfea864b32833f157f042618bd845145256b1bf4c0da34a7013b76e42daa53cc::usdy::USDY' THEN 'USDY' END AS WITHDRAW_ASSET_SYMBOL, CASE WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0x84d7aeef42d38a5ffc3ccef853e1b82e4958659d16a7de736a29c55fbbeb0114::staked_aptos_coin::StakedAptosCoin' THEN 8 WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0x159df6b7689437016108a019fd5bef736bac692b6d4a1f10c941f6fbb9a74ca6::oft::CakeOFT' THEN 8 WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xd916a950d4c1279df4aa0d6f32011842dc5c633a45c11ac5019232c159d115bb::coin::T' THEN 8 WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' THEN 6 WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xcc8a89c8dce9693d354449f1f73e60e14e347417854f029db5bc8e7454008abb::coin::T' THEN 8 WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::WETH' THEN 6 WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT' THEN 6 WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0x1::aptos_coin::AptosCoin' THEN 8 WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T' THEN 6 WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xfaf4e633ae9eb31366c9ca24214231760926576c7b625313b3688b5e900731f6::staking::StakedThalaAPT' THEN 8 WHEN WITHDRAW.WITHDRAW_ASSET_TYPE IS NOT NULL AND WITHDRAW.WITHDRAW_ASSET_TYPE = '0xcfea864b32833f157f042618bd845145256b1bf4c0da34a7013b76e42daa53cc::usdy::USDY' THEN 6 END AS WITHDRAW_ASSET_DECIMAL, WITHDRAW.RAW_WITHDRAW_AMOUNT * POW(10, -(WITHDRAW_ASSET_DECIMAL)) AS WITHDRAW_AMOUNT FROM ALL_WITHDRAW_COLLATERAL WITHDRAW ), CLOSE_VAULT_EVENT_REPAY AS ( SELECT REPAY.BLOCK_TIMESTAMP, REPAY.TX_HASH, REPAY.VAULT_ADDRESS, REPAY.ACCOUNT_ADDRESS, REPAY.EVENT_TYPE, REPAY.REPAY_ASSET_TYPE, REPAY.REPAY_ASSET_NAME, REPAY.REPAY_ASSET_SYMBOL, REPAY.REPAY_ASSET_DECIMAL, REPAY.RAW_REPAY_AMOUNT, REPAY.RAW_REPAY_INTEREST_PAID FROM CLOSE_VAULT_EVENT REPAY WHERE REPAY.EVENT_TYPE = 'Repay' ), REPAY_EVENT AS ( SELECT BLOCK_TIMESTAMP, TX_HASH, EVENT_DATA:vault_address AS VAULT_ADDRESS, ACCOUNT_ADDRESS, 'Repay' AS EVENT_TYPE, '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_coin::MOD' AS REPAY_ASSET_TYPE, 'Move Dollar' AS REPAY_ASSET_NAME, 'MOD' AS REPAY_ASSET_SYMBOL, 8 AS REPAY_ASSET_DECIMAL, EVENT_DATA:amount AS RAW_REPAY_AMOUNT, EVENT_DATA:interest_paid AS RAW_REPAY_INTEREST_PAID, FROM aptos.core.fact_events WHERE PAYLOAD_FUNCTION ILIKE '%::repay' AND SUCCESS = TRUE AND EVENT_ADDRESS = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01' AND EVENT_MODULE = 'vault' ), LIQUIDATE_EVENT_REPAY AS ( SELECT REPAY.BLOCK_TIMESTAMP, REPAY.TX_HASH, REPAY.VAULT_ADDRESS, REPAY.ACCOUNT_ADDRESS, REPAY.EVENT_TYPE, REPAY.REPAY_ASSET_TYPE, REPAY.REPAY_ASSET_NAME, REPAY.REPAY_ASSET_SYMBOL, REPAY.REPAY_ASSET_DECIMAL, REPAY.RAW_REPAY_AMOUNT, REPAY.RAW_REPAY_INTEREST_PAID FROM LIQUIDATE_EVENT REPAY WHERE REPAY.EVENT_TYPE = 'Repay' ), ALL_REPAY AS ( SELECT * FROM CLOSE_VAULT_EVENT_REPAY UNION ALL SELECT * FROM REPAY_EVENT -- UNION ALL -- SELECT * FROM LIQUIDATE_EVENT_REPAY ), REPAY_DETAILS AS ( SELECT REPAY.BLOCK_TIMESTAMP, REPAY.TX_HASH, REPAY.VAULT_ADDRESS, REPAY.ACCOUNT_ADDRESS, REPAY.EVENT_TYPE, REPAY.REPAY_ASSET_TYPE, REPAY.REPAY_ASSET_NAME, REPAY.REPAY_ASSET_SYMBOL, REPAY.REPAY_ASSET_DECIMAL, REPAY.RAW_REPAY_AMOUNT * POW(10, -(REPAY.REPAY_ASSET_DECIMAL)) AS REPAY_AMOUNT, REPAY.RAW_REPAY_INTEREST_PAID * POW(10, -(REPAY.REPAY_ASSET_DECIMAL)) AS REPAY_INTEREST_PAID FROM ALL_REPAY REPAY ), PSM_MOD_MINT_EVENT AS ( SELECT BLOCK_TIMESTAMP, TX_HASH, 'PSM Mint' AS EVENT_TYPE, REPLACE(SPLIT(EVENT_TYPE, '<')[1], '>', '') AS ASSET_IN_TYPE, EVENT_DATA:coin_amount_in AS RAW_AMOUNT_IN, EVENT_DATA:coin_fee_amount AS RAW_FEE_AMOUNT_IN, EVENT_DATA:mod_minted AS RAW_MOD_MINTED, '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_coin::MOD' AS MINT_ASSET_TYPE, 'Move Dollar' AS MINT_ASSET_NAME, 'MOD' AS MINT_ASSET_SYMBOL, 8 AS MINT_ASSET_DECIMAL FROM aptos.core.fact_events WHERE PAYLOAD_FUNCTION ILIKE '%::mint' AND SUCCESS = TRUE AND EVENT_ADDRESS = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01' AND EVENT_MODULE = 'psm' ), PSM_MOD_MINT_EVENT_WITH_ACCOUNT_ADDRESS AS ( SELECT PSM.*, ACCOUNT.ACCOUNT_ADDRESS AS ACCOUNT_ADDRESS FROM PSM_MOD_MINT_EVENT PSM JOIN aptos.core.fact_events ACCOUNT ON (PSM.TX_HASH = ACCOUNT.TX_HASH AND ACCOUNT.EVENT_RESOURCE = 'DepositEvent' AND ACCOUNT.EVENT_MODULE = 'coin' AND ACCOUNT.ACCOUNT_ADDRESS != '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01') ), PSM_MOD_MINT_EVENT_DETAILS AS ( SELECT PSM.BLOCK_TIMESTAMP, PSM.TX_HASH, PSM.ACCOUNT_ADDRESS, PSM.EVENT_TYPE, PSM.ASSET_IN_TYPE, CASE WHEN PSM.ASSET_IN_TYPE IS NOT NULL AND PSM.ASSET_IN_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' THEN 'USD Coin (LayerZero)' WHEN PSM.ASSET_IN_TYPE IS NOT NULL AND PSM.ASSET_IN_TYPE = '0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T' THEN 'USD Coin (Wormhole)' END AS PSM_ASSET_IN_NAME, CASE WHEN PSM.ASSET_IN_TYPE IS NOT NULL AND PSM.ASSET_IN_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' THEN 'zUSDC' WHEN PSM.ASSET_IN_TYPE IS NOT NULL AND PSM.ASSET_IN_TYPE = '0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T' THEN 'whUSDC' END AS PSM_ASSET_IN_SYMBOL, CASE WHEN PSM.ASSET_IN_TYPE IS NOT NULL AND PSM.ASSET_IN_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' THEN 6 WHEN PSM.ASSET_IN_TYPE IS NOT NULL AND PSM.ASSET_IN_TYPE = '0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T' THEN 6 END AS PSM_ASSET_IN_DECIMAL, PSM.RAW_AMOUNT_IN * POW(10, -(PSM_ASSET_IN_DECIMAL)) AS AMOUNT_IN, PSM.RAW_FEE_AMOUNT_IN * POW(10, -(PSM_ASSET_IN_DECIMAL)) AS FEE_AMOUNT_IN, PSM.RAW_MOD_MINTED * POW(10, -(MINT_ASSET_DECIMAL)) AS MOD_MINTED_AMOUNT FROM PSM_MOD_MINT_EVENT_WITH_ACCOUNT_ADDRESS PSM ), PSM_MOD_REDEEM_EVENT AS ( SELECT BLOCK_TIMESTAMP, TX_HASH, 'PSM Redeem' AS EVENT_TYPE, REPLACE(SPLIT(EVENT_TYPE, '<')[1], '>', '') AS ASSET_REDEEM_TYPE, EVENT_DATA:coin_amount_out AS RAW_AMOUNT_REDEEM, EVENT_DATA:coin_fee_amount AS RAW_FEE_AMOUNT_REDEEM, EVENT_DATA:mod_burned AS RAW_MOD_BURNED, '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_coin::MOD' AS MINT_ASSET_TYPE, 'Move Dollar' AS MINT_ASSET_NAME, 'MOD' AS MINT_ASSET_SYMBOL, 8 AS MINT_ASSET_DECIMAL FROM aptos.core.fact_events WHERE PAYLOAD_FUNCTION ILIKE '%::redeem' AND SUCCESS = TRUE AND EVENT_ADDRESS = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01' AND EVENT_MODULE = 'psm' ), PSM_MOD_REDEEM_EVENT_WITH_ACCOUNT_ADDRESS AS ( SELECT PSM.*, ACCOUNT.ACCOUNT_ADDRESS AS ACCOUNT_ADDRESS FROM PSM_MOD_REDEEM_EVENT PSM JOIN aptos.core.fact_events ACCOUNT ON (PSM.TX_HASH = ACCOUNT.TX_HASH AND ACCOUNT.EVENT_RESOURCE = 'DepositEvent' AND ACCOUNT.EVENT_MODULE = 'coin' AND ACCOUNT.ACCOUNT_ADDRESS != '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01') ), PSM_MOD_REDEEM_EVENT_DETAILS AS ( SELECT PSM.BLOCK_TIMESTAMP, PSM.TX_HASH, PSM.ACCOUNT_ADDRESS, PSM.EVENT_TYPE, PSM.ASSET_REDEEM_TYPE, CASE WHEN PSM.ASSET_REDEEM_TYPE IS NOT NULL AND PSM.ASSET_REDEEM_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' THEN 'USD Coin (LayerZero)' WHEN PSM.ASSET_REDEEM_TYPE IS NOT NULL AND PSM.ASSET_REDEEM_TYPE = '0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T' THEN 'USD Coin (Wormhole)' END AS PSM_ASSET_REDEEM_NAME, CASE WHEN PSM.ASSET_REDEEM_TYPE IS NOT NULL AND PSM.ASSET_REDEEM_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' THEN 'zUSDC' WHEN PSM.ASSET_REDEEM_TYPE IS NOT NULL AND PSM.ASSET_REDEEM_TYPE = '0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T' THEN 'whUSDC' END AS PSM_ASSET_REDEEM_SYMBOL, CASE WHEN PSM.ASSET_REDEEM_TYPE IS NOT NULL AND PSM.ASSET_REDEEM_TYPE = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' THEN 6 WHEN PSM.ASSET_REDEEM_TYPE IS NOT NULL AND PSM.ASSET_REDEEM_TYPE = '0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T' THEN 6 END AS PSM_ASSET_REDEEM_DECIMAL, PSM.RAW_AMOUNT_REDEEM * POW(10, -(PSM_ASSET_REDEEM_DECIMAL)) AS AMOUNT_REDEEM, PSM.RAW_FEE_AMOUNT_REDEEM * POW(10, -(PSM_ASSET_REDEEM_DECIMAL)) AS FEE_AMOUNT_REDEEM, PSM.RAW_MOD_BURNED * POW(10, -(MINT_ASSET_DECIMAL)) AS MOD_BURNED_AMOUNT FROM PSM_MOD_REDEEM_EVENT_WITH_ACCOUNT_ADDRESS PSM ), DEPOSIT_EVENT_FINAL_RESULT_1 AS ( SELECT BLOCK_TIMESTAMP, TX_HASH, ACCOUNT_ADDRESS, EVENT_TYPE, COLLATERAL_ASSET_TYPE AS TOKEN_ADDRESS, COLLATERAL_ASSET_SYMBOL AS TOKEN_SYMBOL, DEPOSIT_AMOUNT AS AMOUNT FROM DEPOSIT_COLLATERAL_DETAILS ), WITHDRAW_EVENT_FINAL_RESULT_1 AS ( SELECT BLOCK_TIMESTAMP, TX_HASH, ACCOUNT_ADDRESS, EVENT_TYPE, WITHDRAW_ASSET_TYPE AS TOKEN_ADDRESS, WITHDRAW_ASSET_SYMBOL AS TOKEN_SYMBOL, WITHDRAW_AMOUNT AS AMOUNT FROM WITHDRAW_COLLATERAL_DETAILS ), BORROW_EVENT_FINAL_RESULT_1 AS ( SELECT BLOCK_TIMESTAMP, TX_HASH, ACCOUNT_ADDRESS, EVENT_TYPE, BORROW_ASSET_TYPE AS TOKEN_ADDRESS, BORROW_ASSET_SYMBOL AS TOKEN_SYMBOL, BORROW_AMOUNT AS AMOUNT FROM BORROW_DETAILS ), REPAY_EVENT_FINAL_RESULT_1 AS ( SELECT BLOCK_TIMESTAMP, TX_HASH, ACCOUNT_ADDRESS, EVENT_TYPE, REPAY_ASSET_TYPE AS TOKEN_ADDRESS, REPAY_ASSET_SYMBOL AS TOKEN_SYMBOL, REPAY_AMOUNT AS AMOUNT FROM REPAY_DETAILS ), PSM_MINT_EVENT_FINAL_RESULT_1 AS ( SELECT BLOCK_TIMESTAMP, TX_HASH, ACCOUNT_ADDRESS, EVENT_TYPE, ASSET_IN_TYPE AS TOKEN_ADDRESS, PSM_ASSET_IN_SYMBOL AS TOKEN_SYMBOL, AMOUNT_IN AS AMOUNT FROM PSM_MOD_MINT_EVENT_DETAILS ), PSM_REDEEM_EVENT_FINAL_RESULT_1 AS ( SELECT BLOCK_TIMESTAMP, TX_HASH, ACCOUNT_ADDRESS, EVENT_TYPE, ASSET_REDEEM_TYPE AS TOKEN_ADDRESS, PSM_ASSET_REDEEM_SYMBOL AS TOKEN_SYMBOL, AMOUNT_REDEEM AS AMOUNT FROM PSM_MOD_REDEEM_EVENT_DETAILS ), VAULT_EVENT_FINAL_RESULT_1 AS ( SELECT * FROM DEPOSIT_EVENT_FINAL_RESULT_1 UNION ALL SELECT * FROM WITHDRAW_EVENT_FINAL_RESULT_1 UNION ALL SELECT * FROM BORROW_EVENT_FINAL_RESULT_1 UNION ALL SELECT * FROM REPAY_EVENT_FINAL_RESULT_1 UNION ALL SELECT * FROM PSM_MINT_EVENT_FINAL_RESULT_1 UNION ALL SELECT * FROM PSM_REDEEM_EVENT_FINAL_RESULT_1 ), TOTAL_MOD_SUPPLY AS ( SELECT SUM(CASE WHEN EVENT_TYPE = 'Borrow' THEN AMOUNT ELSE 0 END) AS TOTAL_BORROWED, -1 * SUM(CASE WHEN EVENT_TYPE = 'Repay' THEN AMOUNT ELSE 0 END) AS TOTAL_REPAIED, SUM(CASE WHEN EVENT_TYPE = 'PSM Mint' THEN AMOUNT ELSE 0 END) AS TOTAL_MINTED, -1 * SUM(CASE WHEN EVENT_TYPE = 'PSM Redeem' THEN AMOUNT ELSE 0 END) AS TOTAL_REDEEMED, TOTAL_BORROWED + TOTAL_REPAIED + TOTAL_MINTED + TOTAL_REDEEMED AS "MOD in Circulation" FROM VAULT_EVENT_FINAL_RESULT_1 WHERE EVENT_TYPE IN ('Borrow', 'Repay', 'PSM Mint', 'PSM Redeem') ) SELECT ROUND(TOTAL_BORROWED, 2) AS "Total MOD Borrowed", -1 * ROUND(TOTAL_REPAIED, 2) AS "Total MOD Repayed", ROUND(TOTAL_MINTED, 2) AS "Total PSM Minted", -1 * ROUND(TOTAL_REDEEMED, 2) AS "Total PSM Redeem", ROUND("MOD in Circulation", 2) AS "Total MOD in Circulation" FROM TOTAL_MOD_SUPPLY

Query	Creator	Created
2024-08-03 04:11 AM aptos	Zanyar_98	Aug 3, 2024
Daily Borrows - Isolated Pools aptos	Zanyar_98	Nov 6, 2024
MOD Supply aptos	Zanyar_98	Jul 29, 2024
Liquid staking generated fees aptos	Zanyar_98	Jul 27, 2024
Liquid staking generated fees based on action aptos	Zanyar_98	Jul 27, 2024
Restaking generated fees aptos	Zanyar_98	Jul 27, 2024

Zanyar_98