☀️ solarchive beta

Home Playground Learn Community Support RSS

Learn

Learn how to work with SolArchive data through practical, hands-on tutorials. Each tutorial includes working code examples and step-by-step instructions.

How to Download SolArchive Data

Learn how SolArchive organizes blockchain data and build a download script with Python and async/await

● Beginner ⏱ 15 min
PythonDownloadsGetting Started

How to Find All Transactions for a Wallet

Query transaction data to find all transactions involving a specific wallet address

● Beginner ⏱ 10 min
WalletsDuckDBTransactions

How to Find Your First Transaction on Solana

Discover when you first started using Solana by finding your wallet's earliest transaction

● Beginner ⏱ 5 min
WalletsDuckDBFun

How to Extract Token Transfers

Query transaction data to extract token transfer information with human-readable token names using DuckDB

● Beginner ⏱ 10 min
TransactionsDuckDBToken Transfers

How to Track a Token's Daily Volume

Calculate daily trading volume for any SPL token using time-series aggregations in DuckDB

● Beginner ⏱ 10 min
TokensDuckDBAnalytics

How to Load SolArchive to ClickHouse

Load SolArchive parquet files into ClickHouse for blazing-fast analytical queries on Solana blockchain data

● Intermediate ⏱ 25 min
ClickHouseSQLAnalytics

How to Export Data to PostgreSQL

Load SolArchive parquet files into PostgreSQL for integration with your existing data infrastructure

● Intermediate ⏱ 20 min
PostgreSQLSQLExport