0xHaM-dTotal Deposited Collateral [Tokens Breakdown] copy
    Updated 2024-12-13
    WITH token_map AS (
    SELECT
    COLUMN1 AS TOKEN_CONTRACT, COLUMN2 AS asset, COLUMN3 AS borrow_pow, COLUMN4 AS tvl_pow
    FROM
    (VALUES
    ('0xdd89c0e695df0692205912fb69fc290418bed0dbe6e4573d744a6d5e6bab6c13::coin::T', 'SOL', 26, 8),
    ('0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::WBTC', 'zWBTC', 24, 6),
    ('0xcfea864b32833f157f042618bd845145256b1bf4c0da34a7013b76e42daa53cc::usdy::USDY', 'USDY', 24, 6),
    ('0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC', 'zUSDC', 24, 6),
    ('0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT', 'zUSDT', 24, 6),
    ('0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::WETH', 'zWETH', 24, 6),
    ('0x9770fa9c725cbd97eb50b2be5f7416efdfd1f1554beb0750d4dae4c64e860da3::fa_to_coin_wrapper::WrappedUSDT', 'USDt', 24, 6),
    ('0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T', 'whUSDC', 24, 6),
    ('0x84d7aeef42d38a5ffc3ccef853e1b82e4958659d16a7de736a29c55fbbeb0114::staked_aptos_coin::StakedAptosCoin', 'tAPT', 26, 8),
    ('0xcc8a89c8dce9693d354449f1f73e60e14e347417854f029db5bc8e7454008abb::coin::T', 'whWETH', 26, 8),
    ('0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::amapt_token::AmnisApt', 'amAPT', 26, 8),
    ('0x159df6b7689437016108a019fd5bef736bac692b6d4a1f10c941f6fbb9a74ca6::oft::CakeOFT', 'CAKE', 26, 8),
    ('0x1::aptos_coin::AptosCoin', 'APT', 26, 8),
    ('0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::stapt_token::StakedApt', 'stAPT', 26, 8),
    ('0xa2eda21a58856fda86451436513b867c97eecb4ba099da5775520e0f7492e852::coin::t','whUSDT', 24, 6),
    ('0x6684d15d691e3e5edbf3474eba252e0dd29b7dfbefa6cc7c2e00811fd454c75a::tether::usdt','USDt', 24, 6),
    ('0x357b0b74bc833e95a115ad22604854d6b0fca151cecd94111770e5d6ffc9dc2b','USDt', 24, 6),
    ('0x4e1854f6d332c9525e258fb6e66f84b6af8aba687bbcb832a24768c4e175feec::abtc::ABTC','aBTC', 28, 10),
    ('0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_coin::MOD','MOD', 26, 8),
    ('0x7fd500c11216f0fe3095d0c4b8aa4d64a4e2e04f83758462f2b127255643615::thl_coin::THL','THL', 26, 8),
    ('0xfaf4e633ae9eb31366c9ca24214231760926576c7b625313b3688b5e900731f6::staking::StakedThalaAPT','sthAPT', 26, 8),
    ('0xaef6a8c3182e076db72d64324617114cacf9a52f28325edc10b483f7f05da0e7','TruAPT', 26, 8)
    )
    )
    ,
    depsitEvent AS (
    SELECT
    BLOCK_TIMESTAMP,
    TX_HASH,
    EVENT_DATA:vault_address as vault_add,
    ACCOUNT_ADDRESS,
    QueryRunArchived: QueryRun has been archived