strawbettyALGO Volume from CEX to Wallet
Updated 2022-03-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select
date_trunc('day', block_timestamp) as block_date
, case when (block_timestamp >= '2022-02-10' and block_timestamp < '2022-02-17') then 'the week after announcement'
when (block_timestamp >= '2022-01-26' and block_timestamp < '2022-02-10') then '2 Weeks before announcement'
when (block_timestamp >= '2022-02-17' and block_timestamp < '2022-03-01') then '2 Weeks after the announcement week'
end as period_label
, lar.label_type
, sum(amount) as amount
from algorand.payment_transaction tx
join algorand.labels la
on tx.receiver = la.address
and la.label_type = 'cex'
left join algorand.labels lar
on tx.sender = lar.address
and lar.label_type != 'cex'
where
block_timestamp >= '2022-01-26'
and block_timestamp < '2022-03-01'
group by
1,2,3
Run a query to Download Data