(SELECT
BALANCE,
DATE_TRUNC('day', balances.BLOCK_TIMESTAMP) AS DATE,
balances.CONTRACT_ADDRESS,
labels.NAME as NAME,
labels.SYMBOL as SYMBOL
FROM
ethereum.core.fact_token_balances as balances
JOIN ethereum.core.dim_contracts as labels ON labels.ADDRESS = balances.CONTRACT_ADDRESS
)