nsa2000amount of ETH transfer from CEX
Updated 2022-09-29
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
30
31
32
33
34
35
36
›
⌄
with
transfer_from_cte as (
select
BLOCK_TIMESTAMP::date date
, ETH_TO_ADDRESS sender
, sum(amount) amount
, count(tx_hash) tx_count
from ethereum.core.ez_eth_transfers a
join ethereum.core.dim_labels b on a.ETH_FROM_ADDRESS = b.address and b.label_type = 'cex'
left join ethereum.core.dim_labels c on a.ETH_TO_ADDRESS = c.address
where 1=1
and c.address is null -- sender is not labeled
group by 1,2
)
select
date
, period
, amount
, sender
, tx_count / sender tx_count_per_sender
from (
select
date
, case
when date < '2022-09-15' then 'Before'
when date > '2022-09-15' then 'After'
else 'The Merge'
end period
, sum(amount) amount
, sum(tx_count) tx_count
, count(distinct sender) sender
from transfer_from_cte
group by 1,2
)
where 1=1
and date between '2022-09-01' and '2022-09-30'
Run a query to Download Data