SELECT
date_trunc('day', block_time) AS date,
SUM(eth_balance * eth_price_usd) AS balance_in_usd
FROM
ethereum.erc20_balances
JOIN
ethereum_prices ON ethereum_balances.block_time = ethereum_prices.block_time
WHERE
address = '0xa669e7a0d4b3e4fa48af2de86bd4cd7126be4e13'
AND date_trunc('day', ethereum_balances.block_time) BETWEEN '2022-12-11' AND '2023-12-11'
GROUP BY
date
ORDER BY
date;