blockchain-etl / ethereum-etl

Python scripts for ETL (extract, transform and load) jobs for Ethereum blocks, transactions, ERC20 / ERC721 tokens, transfers, receipts, logs, contracts, internal transactions. Data is available in Google BigQuery https://goo.gl/oY5BCQ
https://t.me/BlockchainETL
MIT License
2.87k stars 812 forks source link

Please help me with the BigQuery request ! #436

Open agoora opened 1 year ago

agoora commented 1 year ago

Hello,

I want to know if someone can help me, with a BigQuery request, to extract all ethereum addresses with balance, nonce, date and public key, if balance > 5 ethers, from "bigquery-public-data.crypto_ethereum"

Eg : Date : from 01/01/2017 until 12/2017 Format : address, nonce, balance, date,publickey

Thank you.