keshanCopy of Untitled Query
    Updated 2022-02-03
    /*select date_trunc('day', block_timestamp) as day, sum(deposit_amount), sum(deposit_amount_usd)
    from anchor.deposits
    group by 1
    order by 1 desc

    select date_trunc('day', block_timestamp) as day, liquidated_currency, sum(liquidated_amount)
    from anchor.liquidations
    group by 1, 2
    order by 1 desc

    select date_trunc('day', block_timestamp) as day, sum(amount), sum(amount_usd)
    from anchor.borrows
    group by 1
    order by 1 desc

    select date_trunc('day', block_timestamp) as day, currency, sum(amount)
    from anchor.collateral
    group by 1, 2
    order by 1 desc

    select date_trunc('day', block_timestamp) as day, sum(amount), sum(amount_usd)
    from anchor.repay
    group by 1
    order by 1 desc*/

    Run a query to Download Data