from arbitrum.core.fact_transactions

where block_timestamp <= {{time_period}}),

arbi_new as (select distinct(from_address) as new_user

from arbitrum.core.fact_transactions

where from_address not in (select arbi_old_users from arbi_old)),

distribution as (select new_user,

balance

from flipside_prod_db.ethereum.erc20_balances a

join arbi_new b on a.user_address = b.new_user

where balance_date = current_date

and symbol = 'ETH')

when balance < 0.1 then 'Less than 0.1 ETH'

when balance >= 0.1 and balance < 0.5 then '0.1 to 0.5 ETH'

when balance >= 0.5 and balance < 1 then '0.5 to 1 ETH'

else 'More than 1 ETH'

end as eth_category,

count(distinct(new_user)) as user_count

from distribution

group by 1