Pi Mainnet Export

A verifiable snapshot of 18 million live addresses from an archive the standard SDK could not read.

PRODUCT SYSTEM● LIVE

01 / FREEZERoot HASCheckpoint 28087871

02 / RESOLVELive BucketListCAP-20 · no hot archive

03 / FILTERACCOUNT > 0G-address · exact balance

04 / WRITEExternal mergeDeduplicate · atomic rename

Client / marketPi Network Mainnet

Year2026

DurationOne research and implementation sprint

Full scopeArchive research, Go pipeline, CAP-20 resolver, external sort, integrity verification

01 / PROBLEM

The challenge

The client needed every public G-address with a positive native balance from one frozen ledger state. Pi’s archive does not publish the per-checkpoint HAS files expected by the standard Stellar SDK, while a full node was excessive for a one-time export.

02 / RESPONSE

The solution

We built a custom live BucketList reader on the official Stellar Go SDK. It freezes the root HAS once, excludes hot-archive buckets, resolves CAP-20 tombstones from newest to oldest and streams account records through a chunked external merge sort. Every bucket is verified against its content-addressed SHA-256 hash.

03 / SYSTEM

Product architecture

The core operating flow connecting the product idea, code and a measurable outcome.

PRODUCT SYSTEM● LIVE

01 / FREEZERoot HASCheckpoint 28087871

02 / RESOLVELive BucketListCAP-20 · no hot archive

03 / FILTERACCOUNT > 0G-address · exact balance

04 / WRITEExternal mergeDeduplicate · atomic rename

04 / MODULES

Inside the system

01Single frozen checkpoint for the entire run↗

02Official CAP-20 live-state resolution↗

03External merge sort at ≈200 MB RAM↗

04Atomic outputs with complete provenance metadata↗

05 / OUTPUT

18,178,808 reproducible addresses in 8 minutes 26 seconds

Verified outcomes

OUTPUT_0118.18M

addresses with native balance above zero

OUTPUT_028m26s

cached-bucket end-to-end runtime

OUTPUT_0321/21

bucket files verified with SHA-256

Project principle

“Verifiability matters more than a plausible-looking number.”

Engineering principle — WeMAIde

Next case / 06WeMAIde↗