select block_timestamp :: date as balance_date,

case when symbol = 'ETH' then 'ETH' else contract_address end as contract_address,

user_address,

symbol,

CURRENT_BAL_USD from ethereum.core.ez_balance_deltas

where block_timestamp::date >= '2020-01-01'

and symbol = 'ETH'

and lower(user_address) = lower('0xDcd382bE6cC4f1971C667ffDa85C7a287605afe4') ),

all_days as (

select date_day as balance_date

from ethereum.core.dim_dates

where date_day >= '2020-01-01'),

address_ranges as (

select user_address,

contract_address,

symbol,

min( balance_date::date) as min_block_date,

current_date()::date as max_block_date

from base_table

group by user_address, contract_address, symbol, max_block_date ),

all_dates as (

select c.balance_date,

a.user_address,

a.contract_address,

a.symbol

from all_days c left join address_ranges a on c.balance_date between a.min_block_date and a.max_block_date

where a.user_address is not null ),

eth_balances as (

select user_address,

contract_address,

balance_date,

CURRENT_BAL_USD,

true as daily_activity

from base_table ),

balance_tmp as (