Bỏ qua tới nội dung
TakoAPI
Quay lại kỹ năng

dune-analytics-api

bởi lz-web3

Browser & Automation
500Lượt tải do clawskills.sh công bố
2Sao
0Lượt xem
0 lượt thíchĐăng nhập để thích kỹ năng này
—Chưa có đánh giá
Đánh giá của bạn

Tóm tắt

Dune Analytics API for blockchain data queries.

Mô tả

Kỹ năng này làm gì

Queries, analyzes, and uploads blockchain data via the Dune Analytics API. Covers EVM and Solana chains, DEX trade analysis, wallet tracking, SQL optimization for DuneSQL (Trino), and CSV/NDJSON data uploads. Includes scripts for common operations and reference docs to avoid known table pitfalls.

Bundles scripts, reference docs, and anti-pattern guidance together so common mistakes like inflated volume from dex.trades or missing Solana deduplication are caught before they reach production.

Khi nào nên dùng

  • Tracking a wallet's trading volume across EVM chains
  • Analyzing DEX activity for a specific token or protocol
  • Uploading a CSV of wallet addresses to query against on-chain data
  • Finding and inspecting decoded event tables by contract address
  • Running parameterized Dune queries and monitoring credit usage

Quy trình ví dụ

ĐẦU VÀO

User asks: Show me the last 7 days of trading volume for a specific wallet on Ethereum

AGENT
  1. 1

    Read wallet-analysis.md and common-tables.md references to select correct tables

  2. 2

    Identify dex_aggregator.trades as the correct table for user-level wallet volume

  3. 3

    Write DuneSQL query filtering by wallet address and date range

  4. 4

    Execute query via dune_query.py or DuneClient with is_private=True

  5. 5

    Return results with credits consumed and data freshness note

ĐẦU RA

Table of daily trading volume in USD for the wallet over the past 7 days

Yêu cầu

  • DUNE_API_KEY environment variable
  • Dune Analytics account (free tier supports saved query execution; Plus plan required for direct SQL execution via run_sql)

Cài đặt

clawhub install lz-web3/dune-analytics-api

Chạy lệnh CLI, hoặc dán prompt vào Claude Code, Cursor, Codex hay coding agent bạn đang dùng.

Liên kết