Developed a Solana analytics adapter for the DefiLlama/dimension-adapters repository, delivering daily volume, fee, and revenue metrics for the PigeonHouse DEX. The work involved migrating from a custom API to Dune Analytics on-chain SQL queries, leveraging solana.instruction_calls and tokens_solana.transfers with program ID and buy/sell discriminators to ensure accurate data extraction. Implemented calculations for dailyFees at 2% and dailyRevenue at 0.5% treasury, enhancing transparency and historical data visibility. Added comprehensive docstrings to support CodeRabbit coverage and incorporated maintainer feedback to align with on-chain data history. Utilized TypeScript, Dune Analytics, and blockchain development skills.