damidezlending agg
    Updated 2025-03-24
    SELECT
    COUNT(DISTINCT tx_hash) AS tx_count,
    COUNT(DISTINCT Depositor) AS depositors,
    SUM(Amount_USD) AS amountUSD,
    AVG(amount_usd) AS avg_amount
    FROM avalanche.defi.ez_lending_deposits
    WHERE contract_address = '0x794a61358d6845594f94dc1db02a252b5b4814ad'
    AND origin_to_address = '0x794a61358d6845594f94dc1db02a252b5b4814ad'
    AND token_symbol IN ('USDC', 'AUSD', 'USDt', 'DAI.e', 'FRAX')
    AND platform = 'Aave V3'
    AND event_name = 'Supply'
    AND block_timestamp >= '2024-01-01'


    Last run: 11 days ago
    TX_COUNT
    DEPOSITORS
    AMOUNTUSD
    AVG_AMOUNT
    1
    49426118412057682229.0441631.575062518
    1
    45B
    2s