[CONTRIBUTION] Add ChimpX AI-powered DeFi aggregator to dex.trades on BNB Chain

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

Read the proposed model, schema, and seed paths under dbt_subprojects/dex, then inspect the ChimpXVolumeRegistry contract and its VolumeRegistered event from block 82131810. Confirm with Dune maintainers whether the aggregated action volume belongs in dex.trades, dex_aggregator.trades, or a custom volume spell, and consider the work done when the agreed model and schema represent the event correctly.