DevJacobidonations-coins-sent-comparison
    Updated 2022-10-05
    with donations as (
    select date(block_timestamp) as date, sum(amount) as amount from flipside_prod_db.algorand.payment_transaction
    where receiver = '2XBL47CKYWTNAIVUQCTAMFBL75EXXRT3TBG2ZK7SOG7MDBER7Q3XNL77XQ'
    group by date
    ),
    sent as (
    select date(block_timestamp) as date, sum(amount) as amount from flipside_prod_db.algorand.payment_transaction
    where sender = '2XBL47CKYWTNAIVUQCTAMFBL75EXXRT3TBG2ZK7SOG7MDBER7Q3XNL77XQ'
    and amount > 0
    group by date
    ),

    every_date as (
    select distinct(date(block_timestamp)) as date from flipside_prod_db.algorand.payment_transaction
    )

    select every_date.date, donations.amount as donated, sent.amount as sent from every_date full outer join sent on sent.date = every_date.date
    full outer join donations on donations.date = every_date.date
    where donated is not null or sent is not null
    order by every_date.date
    Run a query to Download Data