SELECT

symbol,

to_address AS address,

date_trunc('day', block_timestamp) AS day,

SUM(amount) AS in_amount

FROM base.core.ez_token_transfers

WHERE contract_address = LOWER('0x55cD6469F597452B5A7536e2CD98fDE4c1247ee4')

GROUP BY symbol, address, day

),

daily_out AS (

SELECT

symbol,

from_address AS address,

date_trunc('day', block_timestamp) AS day,

SUM(amount) AS out_amount

FROM base.core.ez_token_transfers

WHERE contract_address = LOWER('0x55cD6469F597452B5A7536e2CD98fDE4c1247ee4')

GROUP BY symbol, address, day

),

daily_balances AS (

SELECT

a.symbol,

a.day,

a.address,

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

FROM daily_in a

LEFT JOIN daily_out b ON a.address = b.address

AND a.symbol = b.symbol

AND a.day = b.day

),

filtered_daily_balances AS (

SELECT