Events

無法將 Ethplorer.io 上特定合約的所有傳輸事件導出到 csv

  • March 26, 2022

我可以使用 Export to csv 功能,但它只給我最近的 1000 個事件。關於如何在 csv 文件中獲取所有(2100+)事件的任何建議?

https://ethplorer.io/address/0x2c2391f793f4f81475d87fffe366458ce5380a13#

請改用etherscan.ion

這是您要查找的地址的連結:https ://etherscan.io/txs?a=0x2c2391f793f4f81475d87fffe366458ce5380a13

你可以在那裡找到所有的交易——截至目前為 4856 筆。您可以抓取所有交易(如果使用 etherscan.io 可以的話),或者查看他們提供的 API

這是有關如何將乙太坊數據導出到 csv 的指南https://medium.com/@medvedev1088/exporting-and-analyzing-ethereum-blockchain-f5353414a94e

它使用https://github.com/medvedev1088/ethereum-etl將數據輸出到blocks.csv, transactions.csv, erc20_transfers.csv.

blocks.csv

Column                  | Type               |
------------------------|---------------------
block_number            | bigint             |
block_hash              | hex_string         |
block_parent_hash       | hex_string         |
block_nonce             | hex_string         |
block_sha3_uncles       | hex_string         |
block_logs_bloom        | hex_string         |
block_transactions_root | hex_string         |
block_state_root        | hex_string         |
block_miner             | hex_string         |
block_difficulty        | bigint             |
block_total_difficulty  | bigint             |
block_size              | bigint             |
block_extra_data        | hex_string         |
block_gas_limit         | bigint             |
block_gas_used          | bigint             |
block_timestamp         | bigint             |
block_transaction_count | bigint             |

transactions.csv

Column              |    Type     |
--------------------|--------------
tx_hash             | hex_string  |
tx_nonce            | bigint      |
tx_block_hash       | hex_string  |
tx_block_number     | bigint      |
tx_index            | bigint      |
tx_from             | hex_string  |
tx_to               | hex_string  |
tx_value            | bigint      |
tx_gas              | bigint      |
tx_gas_price        | bigint      |
tx_input            | hex_string  |

erc20_transfers.csv

Column              |    Type     |
--------------------|--------------
erc20_token         | hex_string  |
erc20_from          | hex_string  |
erc20_to            | hex_string  |
erc20_value         | bigint      |
erc20_tx_hash       | hex_string  |
erc20_block_number  | bigint      |

引用自:https://ethereum.stackexchange.com/questions/51912