Data engineer — e-commerce & analytics
Lisbon, Portugal
On-chain analytics — DEX bots, stablecoin flows, and fraud detection across EVM chains. Full profile on dune.com/andrewmatic.
This dashboard identifies tokens with suspicious on-chain trading activity, which is often a red flag for wash trading or artificial volume inflation on Decentralized Exchanges (DEXs). Suspicious two-token swap loops happening many times within a single tx = is a classic signature of artificial volume inflation.
Estimating the activity of trading bots on the Uniswap DEX across all blockchains. How do I distinguish bots from ordinary wallets? Bots typically execute transactions using contract addresses, and their contract code is usually hidden.
Query detects address poisoning attacks on EVM chains (now Ethereum, BNB, Base, Polygon). It finds cases where an attacker sends a zero/near-zero dust transfer to a victim using a look-alike address, and then checks if the victim later accidentally sent real funds to that attacker.
Tracks addresses that behave like stablecoin farmers — wallets and contracts whose DEX activity is overwhelmingly stablecoin-to-stablecoin swaps. The dashboard shows who's farming (top addresses) and what they farm (top stablecoins and pools) across chains.
Finds ETH wallets that were dormant for years and suddenly sent ETH within the last N days. The wallet must have exactly one outbound transaction before the recent window (its very first outbound tx) and then no outbound activity until a recent outbound transfer. Results are ranked by USD value (using the ETH price at the transaction hour) and enriched with Dune labels plus Etherscan links.
This dashboard provides a comprehensive risk analysis of major ERC-20 stablecoins across EVM chains. It focuses on peg stability, real depeg events, and long-term risk metrics, while automatically excluding broken or abandoned tokens.
7-day rolling view of Ethereum stablecoins grouped into Top-10 symbols (by total txs in the window) plus 'others'. Tracks rolling volume, tx count, daily median transfer (rolling median), and active wallets (rolling avg).