Skip to content

Instantly share code, notes, and snippets.

@rifkiamil

rifkiamil/sql-eth-01.sql

Created February 19, 2021 12:36
Show Gist options
  • Save rifkiamil/b2be164a845097a68f7814b0f4603803 to your computer and use it in GitHub Desktop.
Save rifkiamil/b2be164a845097a68f7814b0f4603803 to your computer and use it in GitHub Desktop.
Download ZIP
Top 20 balances on Ethereum with correct decimal place
Raw
sql-eth-01.sql
## Below is the query that will give you top 20 balances on Ethereum
SELECT Address as EthAddress,
CAST(eth_balance as NUMERIC)/1000000000000000000 as EthBalance
FROM `bigquery-public-data.crypto_ethereum.balances`
ORDER BY Eth_balance DESC
LIMIT 20
@rifkiamil
Copy link
Author

If you try the following discord group https://discord.com/invite/wukrezR you will find a channel for Ethereum ETL

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment