alirs
OP-ETH-07
Updated 2022-10-14
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 CEX as (
select address
from ethereum.core.dim_labels
where label_type = 'cex'),
base as (
select block_timestamp::date as date,
-- case when date>='2022-08-15' and date<'2022-09-15'then '1 month Before the merge'
-- when date >= '2022-09-15' and date<='2022-10-14' then '1 month after the merge'
-- else null
-- end as Time_period,
count (distinct tx_hash) as tx_count,
count (distinct eth_to_address) as User_Count,sum(amount) as Volume
from ethereum.core.ez_eth_transfers
where eth_from_address in (select address from cex)
group by --Time_Period,
Date)
select Date,
--Time_period,
sum (tx_count) over(order by date) as tx_Count_Growth,
sum (user_count) over(order by date) as user_count_Growth,
sum (volume)over(order by date) as Volume_Growth
from base
where date>='2022-08-15' and date<'2022-09-15'
order by date
Run a query to Download Data