EXCEEDS logo
Exceeds
Trojen

PROFILE

Trojen

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.

Overall Statistics

Feature vs Bugs

100%Features

Repository Contributions

1Total
Bugs
0
Commits
1
Features
1
Lines of code
79
Activity Months1

Work History

March 2026

1 Commits • 1 Features

Mar 1, 2026

March 2026: Delivered the PigeonHouse DEX Solana volume/fees/revenue analytics adapter for DefiLlama/dimension-adapters. Replaced the previous API endpoint with Dune SQL on-chain queries to compute daily volume, fees, and treasury revenue, improving data transparency and historical visibility. Implemented Solana data extraction by querying solana.instruction_calls and tokens_solana.transfers, with program ID and buy/sell discriminators, to produce reliable metrics (dailyFees at 2% and dailyRevenue at 0.5%). Added comprehensive docstrings to support CodeRabbit coverage and aligned with maintainer feedback on on-chain data history. Co-authored by noegppgeon-boop and bheluga.

Activity

Loading activity data...

Quality Metrics

Correctness100.0%
Maintainability80.0%
Architecture100.0%
Performance80.0%
AI Usage40.0%

Skills & Technologies

Programming Languages

TypeScript

Technical Skills

Dune AnalyticsSolanaTypeScriptblockchain development

Repositories Contributed To

1 repo

Overview of all repositories you've contributed to across your timeline

DefiLlama/dimension-adapters

Mar 2026 Mar 2026
1 Month active

Languages Used

TypeScript

Technical Skills

Dune AnalyticsSolanaTypeScriptblockchain development