adambalaethereum kashi collateral
    Updated 2022-07-12



    select * from (
    select
    DATE(BLOCK_TIMESTAMP)AS date,COLLATERAL_SYMBOL,
    COUNT(DISTINCT TX_HASH)AS Txs_num,
    SUM(AMOUNT_USD) as deposit_volume
    from flipside_prod_db.crosschain.ez_borrowing
    where BLOCKCHAIN='ethereum'
    and PLATFORM='sushi'
    and ACTION ilike'%borrow%'
    and (COLLATERAL_SYMBOL='USDT'OR COLLATERAL_SYMBOL='USDC' OR COLLATERAL_SYMBOL='DAI'OR COLLATERAL_SYMBOL='sUSD'OR COLLATERAL_SYMBOL='UST'OR COLLATERAL_SYMBOL='TUSD')
    GROUP BY 1,2

    )
    Run a query to Download Data