SELECT

DATE_TRUNC('Day', block_timestamp) AS Day,

COUNT(DISTINCT Origin_from_address) AS Active_users,

COUNT(DISTINCT depositor) AS depositors

FROM avalanche.defi.ez_lending_withdraws

WHERE block_timestamp >= '2024-01-01'

AND platform = 'Benqi'

GROUP BY 1

SELECT

AVG(Active_users) AS Average_users_per_day,

AVG (depositors) as AVG_depositors_per_day

FROM daily_data;