Querying

• off-chain:
  • subgraph index:
    • TheGraph
    • Satsuma
    • Messari Standard Subgraphs
  • Dune Analytics
  • CryptoStats collection
• query oracle (query on-chain, executed off-chain):
  • Tableland
• on-chain:
  • sqlidity — sqlite3 in solidity
  • MUD

DeFi and Wallet analytics

• impersonator.xyz (extension)
• DeBank
• Zapper

Block Explorer/Scanner

• Etherscan — Rich block explorer for many EVM chains
  • Blockscan for cross-chain search
• TxStreet — Fun block visualizer
• Open source block explorers for EVM-based chains:
  • Blockscout (Github)
  • Otterscan (Twitter) — Designed to be run locally with an archive node companion.
  • Ethernal

Transaction Explorer

Transaction decoder:

• Ethereum Transaction Viewer by samczsun
• Phalcon
• Tenderly
• Bloxy
• Blockchair
• Debaub
• EthTx
• Fire — Chrome extension that simulates transactions before you sign them
• mopsus — Simulates transactions

Fund Flow Explorer:

• How to od transaction analysis article by Arkham
• Nansen
• Breadcrumbs
• Orbit
• MetaDock — Chrome extension that makes Etherscan pages more detailed
• Ethtective
• Bridge explorers:
  • Socketscan

Learn

Web3 Analytics 101: Live Course

Dune

Dune course
https://www.youtube.com/playlist?app=desktop&list=PL_7kfUeJgSzz5Fltb2nivE_8xuAe2XTJl

Dune snippets
https://github.com/sambacha/dune-snippets

Use ChatGPT for queries
https://twitter.com/0xAnyaa/status/1601494765375483910