PapasotGard collateral
    Updated 2022-04-19
    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