본문으로 건너뛰기
TakoAPI
스킬로 돌아가기

dune-analytics-api

lz-web3 제작

Browser & Automation
500clawskills.sh가 보고한 다운로드 수
2스타
0조회수
좋아요 0개로그인하면 이 스킬에 좋아요를 누를 수 있습니다
—아직 평가 없음
내 평가

요약

Dune Analytics API for blockchain data queries.

설명

이 스킬이 하는 일

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.

사용 시점

  • 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

예시 워크플로

입력

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

에이전트
  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

출력

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

요구 사항

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

설치

clawhub install lz-web3/dune-analytics-api

CLI 명령을 실행하거나, 프롬프트를 Claude Code, Cursor, Codex 등 사용하는 코딩 에이전트에 붙여넣으세요.

링크