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.

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.

defi, data, degen, mev, math

defi, data, degen, mev, math

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

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