PapasotAlgo inflows to CEX
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
date_trunc('day',a.block_timestamp) as date,
sum(amount) as Algos
from algorand.payment_transaction a
left join algorand.labels b on b.address = a.receiver
where a.block_timestamp >= '2022-02-07' AND
a.block_timestamp < '2022-02-21' AND
a.receiver = b.address AND
label_type = 'cex' AND
asset_id = 0
group by date
order by date
Run a query to Download Data