SShortSingh.
TopTechnologyAI & MLStartupsProgrammingScienceBusinessFinanceCrypto & Web3World
Back to feed
Programming

How Analysts Attribute DEX Trade Origins Using On-Chain Data in Dune SQL

0
·1 views

A technical excerpt from 'The DeFi Data Quick-Start' explains the challenge of tracing the origin of decentralized exchange trades on platforms like Dune Analytics. Every trade recorded in the dex.trades table captures chain, venue, token, and amount data, but omits which frontend or application initiated the transaction. This gap matters significantly because incentive programs and market-share claims depend on knowing whether a trade came from a human using a wallet app or an automated bot. Analysts use a method called attribution, which involves examining call data tags, router addresses, and transaction structure to infer trade origins indirectly. Some protocols like 0x and 1inch embed identifying markers in transaction data, making attribution possible through SQL joins on transaction hashes.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Log in to join the discussion and vote.

Log in

Related stories

0
ProgrammingDEV Community ·

How Unverified Tech Narratives Are Quietly Replacing Engineering Arguments

The author, a core contributor to SolidJS, discovered that Anthropic's documentation had been using a migration away from SolidJS as a canonical example since at least April 2026 — months before any public discussion of Cursor's switch from SolidJS to React emerged. The timing proved painful, coinciding with the release of Solid 2.0 RC, the framework's most significant update to date. The author argues this reflects a broader industry shift where conclusions about technology choices spread without benchmarks, reasoning, or public debate. Compounding the problem, AI agents can now execute large-scale code migrations in days rather than months, removing cost as a natural brake on trend-chasing. With execution barriers gone, the author warns that unverified narratives — embedded in docs or AI-generated case studies — now carry outsized influence over technical decision-making.

0 comments Read more at DEV Community
0
ProgrammingDEV Community ·

Linux Foundation Launches Akrites to Coordinate Open-Source Vulnerability Fixes

The Linux Foundation launched Akrites on June 25, 2026, an initiative designed to coordinate vulnerability discovery, remediation, and disclosure for critical open-source software. The effort brings together a multi-stakeholder coalition of roughly 25 to 30 organizations, including AWS, Google, Microsoft, JPMorganChase, Anthropic, OpenAI, and several open-source foundations. Unlike approaches that measure success by the volume of vulnerabilities reported, Akrites prioritizes ensuring that fixes are implemented upstream and that patches are actually deployed by downstream users. The initiative was formed in response to AI-enabled scanning tools that can rapidly increase the number of potential vulnerabilities requiring assessment, framing this as a coordination challenge rather than purely a discovery problem. Akrites does not introduce a new commercial product or compliance framework, but instead aims to align industry stakeholders around a shared, practical security lifecycle for open-source software.

0 comments Read more at DEV Community
0
ProgrammingDEV Community ·

Team Builds AI Onboarding Tool 'Waypoint' to Guide Devs Through Unfamiliar Codebases

A developer team at InnovaHack Chapter-1 built Waypoint, a platform designed to help developers navigate unfamiliar codebases without reading irrelevant files. Users point it at a GitHub repo or local folder, describe a task, and receive a structured 'Mission Brief' listing exactly which files to touch, potential pitfalls, and a suggested order of steps. Under the hood, Waypoint runs a five-step pipeline combining keyword matching, NVIDIA embedding-based semantic retrieval, LLM-based file selection, source code parsing, and mission generation. The project was selected as one of the Top 50 entries to advance to Round 2 of the hackathon. The team has also shared that circumstances following their placement led them to withdraw from the next round.

0 comments Read more at DEV Community
0
ProgrammingDEV Community ·

Foremerge: Open-Source Tool Prevents Silent Conflicts Between Parallel AI Coding Agents

Developers building GPTree encountered a silent but critical failure when multiple AI coding agents — Claude Code, Codex, and Cursor — worked simultaneously on the same repository, producing clean Git merges that nonetheless broke the codebase at a design level. The core problem was that Git compares file diffs, not agent intentions, leaving three failure modes unresolved: destructive versus additive changes, duplicate work, and contract drift. To address this, the team built and open-sourced Foremerge, a coordination protocol that sits above Git and requires agents to declare their intended changes — including semantic scope and operation type — before executing them. When two agents declare overlapping scopes, deterministic rules compare the declarations and surface a conflict warning while both tasks are still in the planning stage. Foremerge uses advisory leases rather than hard locks, ensuring agents are warned and given shared context without being blocked from proceeding.

0 comments Read more at DEV Community
How Analysts Attribute DEX Trade Origins Using On-Chain Data in Dune SQL · ShortSingh