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

IntroPrevious research looked at transaction faliure rates on Solana and identified higher than average failure rates with the Pyth pull ...

IntroThis is the start of a series of posts that examines how to analyze Solana data in SQL using different platforms. We start off the s...

TLDR:Pyth contract has a 26.5% tx failure rate (292,165 txs) across 1.1m transactions, resulting in 1.45 SOL in lost fees. The failure rate....

In this article, we'll explore how to build a Solana data pipeline in Python to analyze Jito fees. We'll use Solana-py to examine block and tran...

defi, data, degen, mev, math

IntroThis post goes over a simple solution to create an embedded streaming OLAP data pipeline that leverages historical blockchain data from Hypersyn...

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

IntroductionIn today's blockchain ecosystem, querying transaction data across multiple chains has become an essential task for developers seeking to analyze trends, monitor transactions, and build cross-chain applications. Hypermanager enters as a solution to the challenges inherent in cross-chain querying. Built on Hypersync—a client that operates atop Envio's Hyperindex—Hypermanager enables seamless, efficient orchestration of cross-chain log queries across EVM networks. Hypersync provides ...