Follow [How to Query Balances for all Ethereum Addresses in BigQuery](https://medium.com/google-cloud/how-to-query-balances-for-all-ethereum-addresses-in-bigquery-fb594e4034a7) to create a query for balances from traces. Or use Transfer events only with a double entry book described in [Plotting Ethereum Address Growth Chart in BigQuery](https://medium.com/google-cloud/plotting-ethereum-address-growth-chart-55cc0e7207b2).
Follow How to Query Balances for all Ethereum Addresses in BigQuery to create a query for balances from traces.
Or use Transfer events only with a double entry book described in Plotting Ethereum Address Growth Chart in BigQuery.