alirs OP-ETH-07
    Updated 2022-10-14
    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