Skip to content

Latest commit

 

History

History
46 lines (30 loc) · 1 KB

README.md

File metadata and controls

46 lines (30 loc) · 1 KB
Raw

Dune-Test

Dashboards, Queries, Smart contracts

Resources

Docs Dune

Querifying Blockchain Data

Go to Dune

Ethereum Tables

  • ethereum.blocks
  • ethereum.contracts
  • ethereum.logs
  • ethereum.traces
  • ethereum.transactions

SQL Queries

What is the question you want to ask?

    1. Select blockchain
    1. Select dataset (e.g. ethereum.transactions or uniswap_v3 mint evt) | Search for all minting events and we can see all the fields
    1. Write the query | SQL Cheat sheet

very simple example

SELECT "evt_block_time","amount", "amount0","amount1" FROM uniswap_v3."Pair_evt_Mint"
ORDER BY "evt_block_time" DESC
LIMIT 15

in the above example we sorting all minting events on uniswap_v3 by block time.

    1. Create visualization (Graph, Chart, Map, etc)
    1. Embed visualization Copy IFrame code and paste into HTML
    1. Create Dashboard

Importance

  • The power of events in a smart contract.