freemartianCEX As Sender
Updated 2022-03-10
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with source as (
SELECT a.block_timestamp as date, a.sender, a.amount as amounts, b.address, b.label_type from algorand.payment_transaction a
INNER JOIN algorand.labels b
ON a.sender = b.address
WHERE date >= '2022-02-05'
AND date <= '2022-02-20'
AND b.label_type = 'cex'
)
SELECT date_trunc(day,date) as time, sum(amounts) from aaaaaa
GROUP by time
order by time
Run a query to Download Data