SELECT

DATE_TRUNC('day', block_timestamp + INTERVAL '12 hours') AS date_truncated,

SUM(CASE WHEN TO_ADDRESS = LOWER('0xfa1fdcf4682b72e56e3b32ff1aba7afcd5e1c7a8') THEN amount ELSE 0 END) AS in_flow,

SUM(CASE WHEN FROM_ADDRESS = LOWER('0xfa1fdcf4682b72e56e3b32ff1aba7afcd5e1c7a8') THEN amount ELSE 0 END) AS out_flow

FROM

blast.core.ez_token_transfers

WHERE

CONTRACT_ADDRESS = LOWER('0x42e12d42b3d6c4a74a88a61063856756ea2db357')

GROUP BY

DATE_TRUNC('day', block_timestamp + INTERVAL '12 hours')

SELECT

date_truncated,

SUM(in_flow) OVER (ORDER BY date_truncated) - SUM(out_flow) OVER (ORDER BY date_truncated) AS net_flow

FROM

daily_flows;