SELECT

symbol,

to_address AS address,

SUM(amount) AS in_amount

FROM base.core.ez_token_transfers

WHERE contract_address = LOWER('0x55cD6469F597452B5A7536e2CD98fDE4c1247ee4')

AND block_timestamp::date < CURRENT_DATE

GROUP BY symbol, to_address

),

amtout AS (

SELECT

symbol,

from_address AS address,

SUM(amount) AS out_amount

FROM base.core.ez_token_transfers

WHERE contract_address = LOWER('0x55cD6469F597452B5A7536e2CD98fDE4c1247ee4')

AND block_timestamp::date < CURRENT_DATE

GROUP BY symbol, from_address

),

current_balances AS (

SELECT

a.symbol,

a.address,

COALESCE(a.in_amount, 0) - COALESCE(b.out_amount, 0) AS current_balance

FROM amtin a

LEFT JOIN amtout b ON a.address = b.address AND a.symbol = b.symbol

),

filtered_balances AS (

SELECT

symbol,

address,

current_balance