[CONTRIBUTION] Add ChimpX AI-powered DeFi aggregator to dex.trades on BNB Chain #9356
Description
Summary
Add ChimpX, an AI-powered DeFi aggregator on BNB Chain, to the dex trades spells.
What is ChimpX?
ChimpX is an AI agent that lets users execute swaps, bridges, lending, borrowing, staking, and perpetuals across DeFi protocols on BNB Chain through natural language. Volume is tracked on-chain via a custom ChimpXVolumeRegistry contract.
- Contract: `0x8327839597934e1490f90D06F2b0A549dFC7edeB` (BNB Chain)
- Deployed block: 82131810
- Event: `VolumeRegistered(address indexed user, uint8 indexed actionType, uint256 volumeUsd, bytes32 txRef, uint256 timestamp)`
- Action types: Swap (0), Bridge (1), Lend (2), Borrow (3), Stake (4), Unstake (5), PerpsLong (6), PerpsShort (7)
Proposed Changes
- New model: `dbt_subprojects/dex/models/projects/chimpx/bnb/chimpx_bnb_trades.sql`
- New schema: `dbt_subprojects/dex/models/projects/chimpx/bnb/chimpx_bnb_schema.yml`
- Seed data: `dbt_subprojects/dex/seeds/chimpx/chimpx_bnb_trades_seed.csv`
Note on token columns
ChimpX's registry records aggregated USD volume across action types rather than individual token pair swaps. The token_bought/sold columns would be NULL. Happy to discuss the best approach — whether this fits dex.trades, dex_aggregator.trades, or a custom volume spell. Open to guidance from the Dune team.
Why it benefits the community
Adds visibility into AI-agent-driven DeFi volume on BNB Chain — a new category of on-chain activity (AI-native DeFi aggregation) not currently tracked by Dune.
Sub-project
dex — volume tracking