Onchain Data, Utilities, References, and other Analytics on Optimism
Onchain Data, Utilities, References, and other Analytics on Optimism. Join the conversation with other numba nerds in the #analytics channel in the Optimism Discord.
A select list of Optimism data dashboards:
See Distributions mapping resources in Select Optimism Data Abstractions
Dune Spellbook: Tables can be used in Dune Analytics
contracts_optimism.contract_mapping
: Near exhaustive mappings of contracts to project names on Optimism - uses decoded contracts in Dune (optimism.contracts
) and known deployer addresses to map contracts.op_token_distributions_optimism.transfer_mapping
: Mappings of token distributions from the OP Foundation & by Grant/Growth Experiment recipients. You can use this table to count how much OP has been deployed, by whom, and to where. Note: These are "best guess" mappings (contribute address mappings in the Dune Spellbook repo).dex.trades
: Aggregation of swaps across many decentralized exchangesnft.trades
: Aggregation of swaps across many NFT marketplaces. Also see nft.wash_trades
by hildobby for filtering out likely wash trades.perpetual.trades
: Aggregation of swaps across many perpetuals exchanges (by rplust)Flipside Crypto - Optimism Models > Gold-Level Tables: Tables can be used in Flipside
optimism.core.ez_dex_swaps
: Aggregation of swaps across many decentralized exchangesoptimism.core.ez_nft_sales
: Aggregation of swaps across many NFT marketplacesoptimism.core.fact_delegations
: Aggregation of OP governance delegation events.For scripts which use APIs from providers with API keys, add the lines like below in a .env file (Replace with your API key - remember to add to gitignore):
DUNE_API_KEY = 'Your API Key'
FLIPSIDE_SHROOMDK_KEY = 'Your API Key'
python -m pip install pipenv
pipenv install
See Pipfile
for all the requirements.
Common packages used for python scripts include
In this repository, we use pre-commit
to ensure consistency of formatting. To install for Mac, run
brew install pre-commit
Once installed, in the command line of the repository, run
pre-commit install
This will install pre-commit
to the Git hook, so that pre-commit
will run and fix files covered in its config before committing.