princefarzamAlgos to/from CEXs
    Updated 2022-03-12
    With TO_binance AS (SELECT
    date_trunc('day',block_timestamp) AS DAY,
    sum(AMOUNT) AS ALGOS_TO_binance
    FROM algorand.payment_transaction
    WHERE receiver='SP745JJR4KPRQEXJZHVIEN736LYTL2T2DFMG3OIIFJBV66K73PHNMDCZVM'
    AND DAY >= '2022-02-10' --Appointed new CEO staci warden
    GROUP BY 1
    ORDER BY 1 ASC),
    From_binance AS(
    SELECT
    date_trunc('day',block_timestamp) AS DAY,
    sum(AMOUNT) AS ALGOS_FROM_binance
    FROM algorand.payment_transaction
    WHERE sender='SP745JJR4KPRQEXJZHVIEN736LYTL2T2DFMG3OIIFJBV66K73PHNMDCZVM'
    AND DAY >= '2022-02-10'
    GROUP BY 1
    ORDER BY 1 ASC
    ),
    To_coinbase AS(
    SELECT
    date_trunc('day',block_timestamp) AS DAY,
    sum(AMOUNT) AS ALGOS_TO_coinbase
    FROM algorand.payment_transaction
    WHERE receiver='UXVAPU4KERSMNUILDVZUKKF4KMWQ7RFSSYPXYSEGSYNYILC4FEHISKRBNM'
    AND DAY >= '2022-02-10'
    GROUP BY 1
    ORDER BY 1 ASC),
    From_coinbase AS(
    SELECT
    date_trunc('day',block_timestamp) AS DAY,
    sum(AMOUNT) AS ALGOS_FROM_coinbase
    FROM algorand.payment_transaction
    WHERE sender='UXVAPU4KERSMNUILDVZUKKF4KMWQ7RFSSYPXYSEGSYNYILC4FEHISKRBNM'
    AND DAY >= '2022-02-10'
    GROUP BY 1
    ORDER BY 1 ASC)