DevJacobidonations-coins-sent-comparison
Updated 2022-10-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
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