base_table as (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

from ethereum.core.ez_balance_deltas

where user_address in ('0x57a8865cfb1ecef7253c27da6b4bc3daee5be518', '0xde21f729137c5af1b01d73af1dc21effa2b8a0d6')),

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.date_day, a.user_address, a.contract_address, a.symbol

from all_days c

left join address_ranges a

on c.date_day 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, true as daily_activity

from base_table),

balance_tmp as (select d.date_day as day,

d.user_address,

d.contract_address,

d.symbol,

b.current_bal,

b.daily_activity

from all_dates d

left join eth_balances b

on d.date_day = b.balance_date and d.user_address = b.user_address and

d.contract_address = b.contract_address),

final_balance AS (select b.day

, b.CONTRACT_ADDRESS

, b.symbol