date_trunc('day',BLOCK_TIMESTAMP) AS "DATE", --to group number of unique address had lending activity on Sushi

COUNT (DISTINCT TX_HASH) AS "Distinct Transactions" --count total number of individual transactions

FROM ethereum.sushi.ez_lending

WHERE "DATE"::DATE >= CURRENT_DATE - 90 --last three month

GROUP BY "DATE"

ORDER BY "DATE" DESC