camppolygon,وثیقه
Updated 2022-07-13
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select --block_timestamp::date as date,
COLLATERAL_SYMBOL,
count(distinct tx_hash) as transaction,
count(distinct BORROWER) as borrrowers,
sum(amount) as amount,
sum(AMOUNT_USD) as amount_usd
from flipside_prod_db.crosschain.ez_borrowing
where COLLATERAL_SYMBOL in ('USDC','USDT','USDN','DAI','UST','FEI','FRAX','BUSD','TUSD','sUSD') and block_timestamp::date<='2022-07-11' and block_timestamp::date>='2022-06-06'
and PLATFORM='sushi' and action = 'Borrow' and BLOCKCHAIN='polygon'
group by 1--,2
order by 1,2 asc
Run a query to Download Data