mo115Untitled Query
Updated 2022-07-13
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
COLLATERAL_SYMBOL,
Symbol,
count(distinct tx_hash) as TXcount,
count(distinct BORROWER) as BorrowersUsers,
sum(amount) as BorrowedAmount,
sum(AMOUNT_USD) as BorrowedAmountUSD
from polygon.sushi.EZ_BORROWING
where COLLATERAL_SYMBOL in ('USDC','USDT','USDN','DAI','UST','FEI','FRAX','BUSD','TUSD','sUSD') and
action = 'Borrow' and block_timestamp::date<=CURRENT_DATE and block_timestamp::date>='2022-01-01'
group by 1,2
Run a query to Download Data