flipside

    fee
    adambalafee
    Updated 2022-07-14
    select borrow.BLOCK_TIMESTAMP::date as date,
    COUNT(DISTINCT borrow.TX_HASH)as TX_num,
    SUM(fee.TX_FEE) AS FEE,
    ACTION,
    SUM(borrow.AMOUNT_USD)
    from flipside_prod_db.crosschain.ez_borrowing as borrow inner join ethereum.core.fact_transactions as fee
    on fee.tx_hash=borrow.tx_hash
    where borrow.BLOCKCHAIN='ethereum'
    and borrow.PLATFORM='sushi'
    GROUP BY 1,4
    Run a query to Download Data