flipside

    Total by Action & Asset
    0xHaM-dTotal by Action & Asset
    Updated 2025-02-11
    with eventTb as (
    SELECT
    EVENT_NAME,
    BLOCK_TIMESTAMP,
    TX_HASH,
    ORIGIN_FROM_ADDRESS,
    PLATFORM,
    TOKEN_SYMBOL,
    AMOUNT,
    AMOUNT_USD
    FROM avalanche.defi.ez_lending_borrows
    WHERE TOKEN_SYMBOL ilike ANY ('%USDC%', '%USDT%', 'AUSD','BUSD')

    UNION ALL

    SELECT
    EVENT_NAME,
    BLOCK_TIMESTAMP,
    TX_HASH,
    ORIGIN_FROM_ADDRESS,
    PLATFORM,
    TOKEN_SYMBOL,
    AMOUNT,
    AMOUNT_USD
    FROM avalanche.defi.ez_lending_deposits
    WHERE TOKEN_SYMBOL ilike ANY ('%USDC%', '%USDT%', 'AUSD','BUSD')

    UNION ALL

    SELECT
    EVENT_NAME,
    BLOCK_TIMESTAMP,
    TX_HASH,
    ORIGIN_FROM_ADDRESS,
    PLATFORM,
    FLASHLOAN_TOKEN_SYMBOL,
    Last run: 2 months ago
    EVENT_NAME
    ASSET
    N_TXS
    N_USERS
    TOTAL_AMT
    1
    		DepositUSDC.e3331314757313558360857.3
    2
    		SupplyUSDC1755824649815529670724.27
    3
    		WithdrawUSDC.e3037394259615313941513.72
    4
    		WithdrawUSDC1949983817415354509006.43
    5
    		DepositUSDT.e189098379691640393337.09
    6
    		WithdrawUSDT.e166248325702388958871.68
    7
    		BorrowUSDC1829902477312446939501.15
    8
    		DepositUSDC84277204783307559614.62
    9
    		BorrowUSDC.e128766196648685406261.36
    10
    		RepayUSDC.e112289193639703666647.09
    11
    		BorrowUSDT.e10418318394921870346.18
    12
    		RepayUSDT.e93928182081331422260.52
    13
    		RepayUSDC1294801663412352635679.17
    14
    		WithdrawUSDt63894143777194127888.02
    15
    		SupplyUSDt42080120775505814067.13
    16
    		BorrowUSDt71745106404813684865.58
    17
    		RepayUSDt5629189514733892375.67
    18
    		DepositUSDt3413950962155041686.23
    19
    		DepositAUSD4561378954083700.49
    20
    		FlashLoanUSDC238172647489482770.81
    37
    2KB
    6s