mz0111KASHI 1
    Updated 2022-12-02
    SELECT
    date_trunc('day', BLOCK_TIMESTAMP) AS date ,
    Count(TX_HASH) AS "deposit number",
    SUM(ASSET_AMOUNT_USD) AS "volume",
    SYMBOL
    FROM crosschain.defi.ez_lending
    WHERE BLOCKCHAIN = 'ethereum'
    AND symbol in ('USDC', 'USDT', 'DAI', 'UST')
    AND date >= CURRENT_DATE - 90
    AND ACTION = 'Deposit'
    group by 1,4
    order by 1
    Run a query to Download Data