keshanCopy of Untitled Query
Updated 2022-02-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
/*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