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