Defi, Data, Degen

This article presents an AI-powered, LLM-enabled data pipeline for smart contract analytics on the Sui blockchain. Using Snowflake, it curates structured event and object catalogues from 95k+ Move packages, enabling LLMs to perform on-chain data analysis at scale. The pipeline automates SQL generation for DeFi metrics like trading volume, funding rates, DAUs, and open interest, showcasing a scalable approach to blockchain data pipelines.

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 deve...

Over 50% of transactions to mutate shared liquidity pool objects that pay the maximum gas fee end up below the median block position. Users paying max gas fees have a 0.001-0.002% chance of securing the top block position, compared to 7-10% for those not paying the highest fees.SIP-45 proposes increasing the max gas price to 1 trillion MIST and making tra...

Sentio Referral Code: Reach out to @is_ye in the sentio telegram chat and give the referral code evandekim2025 for a 20% discount for Sentio subscription! IntroSentio is a game-changing development platform that enables end-to-end data observability for web3 data pipelines. The platform provides a fully integrated, hosted experience that combines modern monitoring, alerting, and debugging capabilities. What makes Sentio particularly powerful is its real-time processing architecture: developer...

defi, data, degen, mev, math

How “Latest State” Works on SuiThe latest-state pattern is one of the most important techniques for anyone working with Sui object data. This technique generalizes to every Sui object type and forms the backbone for any analysis rooted in the chain’s actual state. Every asset—whether a coin, NFT, or protocol object—exists as a Move object that evolves through a sequence of versions. Each mutation creates a new version, deleted objects remain visible with object_status = 'Deleted', and there i...

OutlineMental Model of Sui ObjectsQuerying USDC Coin Transfers on DuneTransfer HeuristicsQuery OptimizationsThis post shows how to calculate USDC transfers on the Sui blockchain using Dune’s Trino SQL engine. Sui is object-centric - meaning that every object has their own lifecycle, ownership history, versioning, and special object type data. This means that coins and addresses on Sui are also Move objects. To calculate balance transfers, we must compare the state of multiple coin objects, no...

GaussianMove uses the AAA algorithm to generate near-optimal rational approximations offline, then evaluates them on-chain via Horner's method—achieving CDF error of 3.35×10⁻⁹ and PPF error of 3.11×10⁻¹³ with predictable gas costs. Sui's native sui::random then makes Gaussian sampling operationally simple inside a single transaction. This article describes the constraints, the approximation methods, and several applications once these functions are available as ordinary library calls.