mo115Untitled Query
    Updated 2022-07-13
    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