fidamAggregate 2
Updated 2025-01-21
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
COUNT(DISTINCT SENDER_ID) AS users,
COUNT(DISTINCT TX_HASH) AS transactions,
SUM(AMOUNT_USD) AS Total_burrowed_amount,
COUNT(DISTINCT SYMBOL) AS token
FROM near.defi.ez_lending
WHERE ACTIONS ILIKE 'borrow%'
AND BLOCK_TIMESTAMP BETWEEN CURRENT_DATE - INTERVAL '7 days' AND CURRENT_DATE
--GROUP BY DATE_TRUNC('week', BLOCK_TIMESTAMP)
--ORDER BY week DESC;
QueryRunArchived: QueryRun has been archived