# Sui NFT Collection Analytics

> A Data Pipeline Framework Using Sentio and TypeScript

**Published by:** [Defi, Data, Degen](https://paragraph.com/@evandekim/)
**Published on:** 2025-02-16
**Categories:** sui, analytics, data, pipeline, sql, typescript, sentio, rootlet
**URL:** https://paragraph.com/@evandekim/sui-nft-collection-analytics

## Content

IntroThis article presents a framework for building data pipelines on the Sui blockchain using Sentio, illustrated through a complete implementation to analyze Rootlets NFT holders. Sentio is used for efficient data backfilling, custom processing with TypeScript, and real-time analysis via its SQL Studio. The article culminates in demonstrating a user-friendly Sentio dashboard that queries Rootlet ownership by wallet address. This approach provides a reusable and adaptable foundation for developing data-driven applications and insights across the Sui ecosystem.Sentio Processor PipelineSentio processors, written in TypeScript, provide a flexible way to construct Sui data pipelines. They manage the essential ETL (Extract, Transform, Load) steps for interacting with Sui blockchain data. Processors define how data is extracted, transformed (including handling Sui-specific features like object ownership), and loaded into Sentio's database. They serve as the central logic for data processing, ensuring only relevant and correctly structured data is stored for analysis. The complete processor code for this article is available here.Defining EntitiesEntities in Sentio are analogous to custom tables, structuring data for optimized analysis. Entities are defined in a store.graphql file, located at src/schema/store.graphql. This file uses a GraphQL-like syntax to describe the structure of our custom tables. For the Rootlets project, there are two main entities:RootletStaticFields: This entity captures the static fields of a Rootlet object, such as its description, image URL, and inherent traits (theme, accessories, etc.). This is information that doesn't change over time.RootletOwner: This entity tracks changes in Rootlet ownership. Every time a Rootlet is transferred or modified, a new entry is created in this entity, recording the sender, transaction digest, and timestamp. This is crucial for tracking who owns which Rootlets over time.Generating BindingsAfter defining entities in src/schema/store.graphql, the command yarn sentio build generates TypeScript code. This generated code facilitates interaction with these entities within the processor, enabling the creation and updating of records during data processing.SQL Query AnalyticsSentio provides a built-in SQL Studio, a web-based interface where you can write and execute SQL queries against your data. As the backfilling process populates your entities (which now appear as tables), you can start writing SQL queries to analyze the data in real-time.Rootlet Holder Count GrowthA unique holder count growth over time can be constructed using the RootletOwner table. This query is crucial for taking arbitrary historical snapshots of Rootlet ownership. Sui NFT objects are stored either in kiosks or as wrapped objects, resulting in the true owner often being a nested object value. Instead of recursive searching for the true owner, the sender address is used. Sui's consensus mechanism performs a runtime validation check, ensuring that the object mutator is already the object's owner. Therefore, if the object is mutated, it is assumed that the mutation was performed by the owner. This principle allows the storage of ownership history in a table, tracking the transaction sender each time the object is mutated. Here is what the chart looks like in the Sentio dashboard:The full query is available in the Appendix.Rootlet Holder Count GrowthA second query categorizes Rootlet owners qualitatively (see Appendix for the query). This query joins the theme value, a static object value stored in RootletStaticFields, to the latest owner from RootletOwner. This dashboard integration demonstrates the flexibility of the Sentio data pipeline. Not only can queries provide aggregate statistics, but they also enable detailed, address-specific analysis, such as determining the exact Rootlet holdings of an address Moreover, this level of data granularity enables targeted airdrops, for example, rewarding holders based on specific Rootlet attributes or ownership history.ConclusionThis article presented a comprehensive guide to building a Sui data pipeline for the Rootlets NFT collection using Sentio. The process began with defining custom entities to structure the data, followed by utilizing Sentio's TypeScript processors to handle data extraction, transformation, and the specific challenges of Sui object ownership. The integrated SQL Studio was then used to perform real-time analysis, generating queries for key metrics like holder count growth and thematic categorization. The culminating dashboard, parameterized by wallet address, demonstrates the power of this pipeline for in-depth analysis. This approach not only provides valuable insights into the Rootlets collection but also establishes a reusable framework for developing more sophisticated data pipelines and analytical tools within the Sui ecosystem.SQL Query AppendixRootlet Holder Count GrowthWITH OrderedEvents AS ( SELECT ro1.objectID, ro1.sender, toDate(ro1.timestamp / 1000) AS start_date, ifNull(argMin(toDate(ro2.timestamp / 1000), ro2.timestamp), toDate('2106-02-07')) AS end_date FROM RootletOwner ro1 LEFT JOIN RootletOwner ro2 ON ro1.objectID = ro2.objectID AND ro1.timestamp < ro2.timestamp GROUP BY ro1.objectID, ro1.sender, ro1.timestamp ), -- Convert dates to integers for range function DateRanges AS ( SELECT objectID, sender, toUInt32(start_date) AS start_date_int, toUInt32(end_date) AS end_date_int FROM OrderedEvents ), -- Expand date ranges into individual dates ExpandedDates AS ( SELECT objectID, sender, toDate(start_date_int + number) AS day FROM DateRanges ARRAY JOIN range(0, end_date_int - start_date_int) AS number ), -- Get all distinct dates AllDates AS ( SELECT DISTINCT toDate(timestamp / 1000) AS day FROM RootletOwner ) -- Join expanded dates with all dates and count distinct senders SELECT ad.day, count(DISTINCT ed.sender) AS unique_holder_count FROM AllDates ad LEFT JOIN ExpandedDates ed ON ad.day = ed.day GROUP BY ad.day ORDER BY ad.day;Rootlet Holder Count Per ThemeWITH LatestOwners AS ( SELECT objectID, argMax(sender, timestamp) AS latest_sender FROM RootletOwner GROUP BY objectID ) SELECT lo.latest_sender, s.theme, COUNT() AS theme_count FROM LatestOwners AS lo INNER JOIN RootletStaticFields AS s ON lo.objectID = s.id GROUP BY lo.latest_sender, s.theme ORDER BY theme_count DESC

## Publication Information

- [Defi, Data, Degen](https://paragraph.com/@evandekim/): Publication homepage
- [All Posts](https://paragraph.com/@evandekim/): More posts from this publication
- [RSS Feed](https://api.paragraph.com/blogs/rss/@evandekim): Subscribe to updates

## Optional

- [Collect as NFT](https://paragraph.com/@evandekim/sui-nft-collection-analytics): Support the author by collecting this post
- [View Collectors](https://paragraph.com/@evandekim/sui-nft-collection-analytics/collectors): See who has collected this post