SELECT
DATE_TRUNC('day', block_timestamp) AS date,
COUNT(DISTINCT DEPOSITOR) AS Depositor,
COUNT(DISTINCT Tx_hash) AS Deposits,
SUM(amount_usd) AS Volume_deposited
FROM
avalanche.defi.ez_lending_deposits
WHERE
PLATFORM = 'Benqi'
AND block_timestamp >= '2024-01-01'
GROUP BY 1