camppolygon,وثیقه
    Updated 2022-07-13
    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