strawbettyALGO transferred from CEXs to wallets
Updated 2022-05-13
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
26
27
28
29
›
⌄
with
cex_address as (
select distinct address,
label
from algorand.labels
where label_type = 'cex' and label not like '%group%'
),
cex_transfers as (
select
block_timestamp,
tx_id,
sender,
receiver,
amount,
label as cex
from algorand.payment_transaction x join cex_address y on (x.sender = y.address and x.receiver != y.address)
where block_timestamp >= '2022-05-02'
and block_timestamp <'2022-05-10'
)
select
date_trunc('day', block_timestamp) as day,
count(tx_id) as transactions,
count(DISTINCT(receiver)) as wallets,
sum(amount) as volume
from cex_transfers
group by 1
order by 1 asc
Run a query to Download Data