SELECT
DISTINCT user_address,
balance,
MAX(block_timestamp) AS latest_timestamp
FROM ethereum.core.fact_token_balances
WHERE contract_address = LOWER('0xb47e3cd837dDF8e4c57F05d70Ab865de6e193BBB')
AND block_timestamp <= '2024-09-01'
AND balance > 0
GROUP BY 1,2