Stellar Community Fund

By Stellar DeFi Dune Dashboards

Stellar DeFi Dune Dashboards

SCF #35

$25.0K

Build

Awarded

Verifiable Dune dashboards to help Stellar community track real DeFi on-chain data with transparent smart contract queries.

Products & Services

Check our video here!
Problem we are solving:
Currently, most DeFi stats on Stellar come from project-provided reports, which are not always transparent or easy to verify. Platforms like DeFi Llama and DappRadar often rely on these reports instead of pulling data directly from the blockchain.

On the other hand, there are many ecosystem stats very useful that can only be calculated using an external tool like Dune Dashboards, like Percentage of Swaps being aggregated, average slippage of swaps and more.

How DeFi Dune Dashboards Solves this:
The Stellar DeFi Dune Dashboards will change this by providing fully verifiable, on-chain data from smart contract activity from all DeFi protocols on the ecosystem. These dashboards will track important stats like Weekly and Monthly Active Users, Average Slippage on Trades, Volume Analisis, Percentage of Aggregated Trades, and Liquidity Provider Activity.

For AMMs and aggregators, we will show key insights, including trade volume, slippage, price impact, and how often trades go through aggregators instead of single AMMs. We will also track arbitrage profits and how many trades are related to arbitrage.

This project will make Stellar DeFi data more transparent and accessible for everyone, helping users, developers, and investors understand how healthy and active the ecosystem really is. We will also maintain and update the dashboards for one year to ensure they stay reliable.

Extra Comments:

It's important to understand that Dune dashboards need regular maintenance. Over time, some queries can become too large because they are analyzing more and more data. When this happens, we need to export the results into Materialized Views to keep the dashboards fast and reliable.

Most importantly, this submission includes the ongoing maintenance of all queries and dashboards, so they stay up-to-date and useful over time.

Soroban

Yes

Requested Budget

$25.0K

Success Criteria

At least 10 new stars every month on our Dashboards

Support of the community
Our dashboards will be shared more than 1,000 times on tweeter after 6 months

Go-To-Market Plan

Engage with projects in the community to share our dashboards on social media, specifically the projects that we are tracking. They will be interested in sharing insight information.

Provide information to SDF and SCF teams for better decision making.

Traction Evidence

At PaltaLabs we have been supporting the “Soroban AMMs on Stellar” dashboard, which means that we have coded new queries to get info from protocols (Soroswap AMM and Aggregator, Blend Backstop, Phoenix Pools, Aquarius AMM), and also we are paying the dashboards to be updated 4 times a day: https://dune.com/paltalabs/soroban-amms-on-stellar

The other Dashboard that we have written and we have been supporting is the Soroswap Dashboard available here:
https://dune.com/paltalabs/soroswap

You can see all more queries here:
https://dune.com/discover/content/relevant?q=author:paltalabs&resource-type=queries

In total we have 26 stats (people following our dashboard or queries. Source: https://dune.com/paltalabs

Note to the reviewer: The reviewer might find out dated dashboards and queries. Some dashboards have been updated some days ago due lack of payment for Dune Credits. Also, some other queries need to be transformed to a materialized view due to the amount of information. All these things we can fix and support with this submission

Tranche 1 (Deliverable Roadmap) - MVP

For all deliverables, how to measure completion:The query will be available and verifiable on our dashboard and will run every 6 hours.
**
Tranche 1:** Weekly & Monthly Active User. 1 month of development. Total Tranche Budget: USD 8,333

Deliverable 1: Weekly & Monthly Active Users

Brief description: Tracks how many unique users interact with selected DeFi protocol on Soroban. We will include:
1. Unique wallets per time period
2. Per-protocol breakdown
3. Action-based segmentation (Swappers, LPs, Aggregators, Lender, Borrowers, Liquidators, etc…)
4. New vs. returning users
5. Weekly/monthly growth rate
Protocols: Blend, FxDAO, Soroswap, Aquarius, Phoenix, Etherfuse.
Estimated date of completion: 1 month after acceptance
Budget: USD 8,333

Tranche 2 (Deliverable Roadmap) - Testnet

Tranche 2: User overlap & LP Acticity. 1 month of development. Total Tranche Budget: USD 8,333

Deliverable 2: Protocol Overlap in Users

Brief description: Tracks unique users and their overlaps between different selected protocols. How many users interact with more than one protocol.
Objective: Identify what protocols are bringing new addresses into the ecosystem, revealing user journeys and protocol synergies
Protocols: Blend, FxDAO, Soroswap, Aquarius, Phoenix, Etherfuse.
Estimated date of completion: 1.5 month after acceptance
Budget: USD 3,333

Deliverable 3: Liquidity Provider Activity

Brief description: Shows how LPs are moving capital between protocols, including:
1. Query to calculate the value per transaction, considering price of tokens on SDEX and Soroban DEXEs
2. Active LP wallets (unique addresses interacting as LPs)
3. Top LPs (addresses providing the most liquidity)
Protocols: Blend, FxDAO, Soroswap, Aquarius, Phoenix, Etherfuse.
Estimated date of completion: 2 month after acceptance
Budget: USD 5,000

Tranche 3 (Deliverable Roadmap) - Mainnet

Tranche 3: Liquidity Flows and Migrations. 1 month of development. Total Tranche Budget: USD 8,333

Deliverable 4: Liquidity Flows and Migrations

Brief description: Shows how LPs are moving capital including:
1. Liquidity inflows and outflows per protocol or pool
2. Liquidity migration (how liquidity is added or removed)
Protocols: Blend, FxDAO, Soroswap, Aquarius, Phoenix, Etherfuse.
Estimated date of completion: 3 month after acceptance
Budget: USD 8,333

Team

We are PaltaLabs 🥑, a hacker hub focused on Stellar. We build DeFi products like the Soroswap.Finance AMM and AMM Aggregator, DeFindex DeFi Investment Vaults, and developer tools like the @soroban-react library and Create Soroban Dapp. Check us out at paltalabs.io.

We manage a team of five full-time developers who are highly active in the community—building dev tools, answering questions, and collaborating with other projects.