Search code examples
google-bigqueryethereumsmartcontractsmedical

It seems Ethereum dataset does not work with some token

In google-bigquery, could you confirm the queries with Ethereum dataset does return zero when trying to analyze, for example, this contract?

Solution

  • It seems that the token_address data is stored in lowercase.

    Try running:

    SELECT * FROM `bigquery-public-data.ethereum_blockchain.token_transfers`
WHERE token_address='0x41dbecc1cdc5517c6f76f6a6e836adbee2754de3' LIMIT 100

    And you'll get results.