Artemis Analytics Data Analytics Bounty

About Artemis Analytics

Artemis Analytics is a leading blockchain data platform that provides comprehensive analytics and insights across multiple blockchain ecosystems. We empower users with real-time data visualization, custom dashboards, and deep metrics to make data-driven decisions with confidence. Our platform serves fundamental investors, traders, developers, and projects by delivering actionable intelligence on network activity, token metrics, and ecosystem trends.

Bounty Overview

Artemis is launching a data engineering bounty focused on developing SQL queries for MarginFi's key performance metrics. This bounty challenges data engineers to create robust, efficient, and accurate queries that can be implemented on the Artemis platform.

The winning submission will be implemented on the Artemis platform, providing valuable insights to the MarginFi community and enabling data-driven decision-making across the ecosystem. Your work will directly contribute to increasing transparency and understanding of one of Solana's leading lending protocols.

Objective

Develop SQL queries to extract and calculate the following MarginFi metrics:

• Total Value Locked (TVL)

• Borrows (volume and outstanding)

• Deposits (volume and outstanding)

• Protocol Fees

• Revenue

Requirements

Technical Skills

• Strong proficiency in SQL

• Ability to optimize queries for performance

• Understanding of blockchain data structures

• Familiarity with DeFi protocols and metrics

Specific Requirements

• All queries must be developed using Flipside's dataset via Flipside Studio (link)

• Queries can use either decoded or raw instructions data (preference for decoded data)

• Code must be open-source and fully reproducible

• Solution must include clear documentation explaining the approach and methodology

• Queries should handle edge cases and potential data inconsistencies

Submission Guidelines

1. Submit a Google Doc with the following:

   • Queries you create on Flipside’s platform

   • Screenshots of the query outputs

   • A “README” with:

     1. Explanation of each metric calculation

     2. Data sources used

     3. Any assumptions made

     4. Instructions for running/testing the queries

   • Include a brief write-up on any challenges encountered and how they were resolved

2. Submissions to be sent directly to isaiah@artemisanalytics.xyz or on Telegram @isaiahwash

Judging Criteria

Submissions will be evaluated based on:

1. Data Quality - Accuracy and comprehensiveness of the metrics

2. Code Quality - Cleanliness, efficiency, and readability of SQL

3. Documentation - Clarity and completeness of documentation

4. Reproducibility - Ease of implementing the solution

Winner Selection

The bounty will be awarded to the submission with the cleanest, most accurate data. In the case of a tie, the earlier submission will be selected as the winner.

Prizes

• 1st Place: $2000

Contact / Resources

• Sign-up for Flipside Studio: https://flipsidecrypto.xyz/studio

• MarginFi docs: https://docs.marginfi.com/

For questions or clarifications about this bounty, please reach out to:

• Telegram: @isaiahwash , @x0wes

• Email: isaiah@artemisanalytics.xyz, wes@artemisanalytics.xyz

Happy querying!