PapasotGard collateral
Updated 2022-04-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
SELECT
date_trunc('day',block_timestamp) as date,
SUM(amount) as Algo_collateral,
sum(Algo_collateral) over (order by date asc rows between unbounded preceding and current row) as cum_collateral
FROM
algorand.payment_transaction
WHERE
receiver = 'C2A7GRY3ZJ2U5BJ3Z22V63BIDNBO6SJT37ALKQQ537Z4BTKFVGVDG55GGU'
OR
receiver = 'GD5UA5BJZKIC67IHBJXPSN452GBJHZL4I5IEBL2I672NASKW4F6PSDCDZ4'
OR
receiver = 'T27WUFS76IBQDLLD2UHF5LOVOABPBFU7LLWVXOXUE4P7EPSB6OIRKA572I'
OR
receiver = 'G5KCQCONM6BSDMKZR7TBDWTHCCPEWLB753ATAHQR5SA7TIHCXURY4KRLT4'
OR
receiver = 'ICBQRLQYNB2APVLLPDYUQV236OVAKZXUM4MMX6X5XOC37LFUARQMLKYLDU'
OR
receiver = 'JG2QOVUALZ6J5BCHGAOBCUIEAWWCD2BEQ62HQONVADS4KGL44LJIFWVHOA'
GROUP BY 1
order by 1
Run a query to Download Data