shadilAlgorand Foundation New CEO Staci Warden
Updated 2022-03-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
with cexs as (
select address from algorand.labels
where label_type='cex'
),
from_cexs as(
select sum(amount), 'ALGOs being moved from CEXs to wallets' as type
from algorand.payment_transaction
where sender in (select address from cexs)
and amount != 0
and amount is not NULL
and block_timestamp::date >= '2022-02-10'
and block_timestamp::date <= '2022-02-17'
),
to_cexs as(
select sum(amount), 'ALGOs being moved from wallets back to CEXs' as type
from algorand.payment_transaction
where receiver in (select address from cexs)
and amount != 0
and amount is not NULL
and block_timestamp::date >= '2022-02-10'
and block_timestamp::date <= '2022-02-17'
)
select * from from_cexs
UNION all
SELECT * from to_cexs
Run a query to Download Data