search

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

missing contract internal txn in ethereumetl export_blocks_and_transactions #438

Open cisan86 opened 1 year ago

cisan86 commented 1 year ago

when i use the command to export the block 9484688 and transaction info like this 

ethereumetl export_blocks_and_transactions --start-block 9484688 --end-block 9484688 \
--provider-uri file://$HOME/Library/Ethereum/geth.ipc \
--blocks-output blocks.csv --transactions-output transactions.csv

image

interesting i find that in etherscan there was 79 txn and 37 contract internal txns , but this command does not export the 37 contract internal transactions in this block

sfsf9797 commented 1 year ago

Hi, you would need to export log as well for internal transaction. You can check out other cli command

cisan86 commented 1 year ago

I want to express my heartfelt gratitude for your constant support and encouragement！

Another question is i already run the command _ethereumetl export_blocks_and_transactions_ for about 4days to download the whole mainnet transactions , but it doesn't seem to want to end. the transaction.csv is over 900 gb , how long do I have to wait ? How big is the whole file ?