feyikemiBenqi Borrows
Updated 2024-08-31
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
DATE_TRUNC('day', block_timestamp) AS date,
COUNT(DISTINCT BORROWER) AS Borrowers,
COUNT(DISTINCT Tx_hash) AS Borrows,
SUM(amount_usd) AS Volume_Borrowed
FROM
avalanche.defi.ez_lending_borrows
WHERE
PLATFORM = 'Benqi'
AND block_timestamp >= '2024-01-01'
GROUP BY 1
QueryRunArchived: QueryRun has been archived