文档介绍
https://console.cloud.google.com/marketplace/details/ethereum/crypto-ethereum-blockchain?project=aqueous-tesla-294801
如查询
What are the 10 most popular Ethereum collectibles (ERC721 contracts), by number of transactions?
SELECT contracts.address, COUNT(1) AS tx_count
FROM `bigquery-public-data.crypto_ethereum.contracts` AS contracts
JOIN `bigquery-public-data.crypto_ethereum.transactions` AS transactions ON (transactions.to_address = contracts.address)
WHERE contracts.is_erc721 = TRUE
GROUP BY contracts.address
ORDER BY tx_count DESC
LIMIT 10
其它查询方式
https://ethereum-etl.readthedocs.io/en/latest/commands/
kaggle数据格式文章来源：https://www.toymoban.com/news/detail-540225.html
Ethereum Blockchain | KaggleComplete live historical Ethereum blockchain data (BigQuery)https://www.kaggle.com/datasets/bigquery/ethereum-blockchain?utm_medium=partner&utm_source=cloud&utm_campaign=big+data+blog+ethereum&select=contracts文章来源地址https://www.toymoban.com/news/detail-540225.html
到了这里，关于google bigquery如何查询以太坊ethereum数据 sql怎么写的文章就介绍完了。如果您还想了解更多内容，请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章，希望大家以后多多支持TOY模板网！
