with
    balance_change_daily as (
        select 
        date(block_timestamp) as block_date, 
        row_number() over (partition by date(block_timestamp), chain, address, token_address order by block_number desc) as rn,
        *
        from crosschain.assets.fungible_balances_evm
        where address = lower('') and chain in ('ethereum', 'bsc', 'base')
    ),
    changed_balances as (
        select
            *,
            lead(block_date) over (
                partition by chain, token_address, address order by block_date asc
            ) as next_update_day
        from balance_change_daily
        where rn = 1
    ),
    forward_fill as (
        select cast(d.date_timestamp as timestamp) as day, *
        from common.utility.dates d
            left join
                changed_balances b
                on d.date_timestamp >= b.block_date
                and (b.next_update_day is null or d.date_timestamp < b.next_update_day)
            where date_timestamp <= current_date and date_timestamp >= '2015-01-01'
    )
select
    f.day::timestamp_ntz(9) as block_date,
    f.chain::varchar as chain,
    f.address::varchar as address,
    f.token_address::varchar as token_address,
    ft.name::varchar as token_name,
    ft.symbol::varchar as token_symbol,
    ft.decimals::bigint as token_decimals,
    f.raw_balance_str::varchar as raw_balance,
    coalesce(f.balance_str::float, div0(f.raw_balance_str, power(10, ft.decimals)::float)) as balance,
    (f.balance * hp.price)::float as usd_balance,
    hp.price::float as usd_exchange_rate,
    f.block_timestamp::timestamp_ntz(9) as last_activity_block_timestamp,
    f.block_number::bigint as last_activity_block_number,
    f.block_hash::varchar as last_activity_block_hash,
from forward_fill f
left join crosschain.raw.fungible_tokens ft on f.chain = ft.chain and f.token_address = ft.address
left join common.prices.hourly hp on f.block_date = hp.timestamp and f.token_address = hp.address and hp.chain = f.chain
where 1=1 
  and raw_balance_str > '0'  -- [Optional]  Exclude non-zero balances
  and usd_exchange_rate is not null -- [Optional] Exclude fungible balances without prices data