Accessing Pre-Regenesis History

This tutorial explains how to access transaction history between 23 June 2021 and the final regenesis using the Etherscan CSV exporting tool. Because of our final regenesis on 11 November 2021, older transactions are not part of the current blockchain and do not appear on Etherscan (opens in a new tab).

Etherscan access

Browse to the Optimism Explorer (opens in a new tab).

Select your address and the type of report you want.

export data

Dune access

If none of the Etherscan CSV files contains the information you need, you can use a query on Dune Analytics (opens in a new tab), similar to this query (opens in a new tab). You have to log on with a Dune account, but their free tier is sufficient.

Browse to the Optimism transactions on Dune (opens in a new tab).

Run the query.

SELECT * FROM optimism.transactions
WHERE "from"='{{addr}}' or "to"='{{addr}}'
LIMIT 100

Make sure to select the data source Optimism (OVM 1.0)
This is how you specify parameters in Dune, {{ followed by the parameter name and then }}.
Addresses are specified as \x<hex address> rather than 0x<hex address>.
The limit is not required, but here to save resources

Pre 23 June 2021 History

Follow these steps:

Clone go-ethereum (the standard version) and checkout version v1.9.10

git clone https://github.com/ethereum/go-ethereum.git
cd go-ethereum
git checkout v1.9.10

Download the following three datadir folders

Build and run the standard geth v1.9.10 with

./build/bin/geth --datadir ./path/to/datadir --rpc

You can then use ERC20 events filters to get the events that you want for each address. Note that you will have to repeat this process for each datadir to get the full event history. If you are non-technical and need help requesting this data please reach out to us in Discord and we will be happy to help.

Oracles Analytics Tools