AndyCoolCEX to Wallet
Updated 2022-05-12
99
1
2
3
4
5
6
7
8
9
10
›
⌄
WITH cex AS ( SELECT address
FROM algorand.labels
WHERE label_type = 'cex'
)
SELECT sum(amount) AS volume, date_trunc('day', block_timestamp) as TIME
FROM algorand.payment_transaction p
INNER JOIN cex c on c.address = p.sender
WHERE block_timestamp >= '2022-04-30'
GROUP BY TIME
Run a query to Download Data