CryptoLionbtc1v2
Updated 2023-03-27
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
date_trunc('day',block_timestamp) as day,
ctoken_symbol,
count(tx_id) as transactions,
sum(loan_amount_usd) as value
FROM compound.borrows
WHERE block_timestamp >= getdate() - interval '3 months'
AND (ctoken_symbol = 'cWBTC'
OR ctoken_symbol = 'cWBTC2')
GROUP BY day,ctoken_symbol
ORDER BY day
Run a query to Download Data