A collection of example SQL queries and patterns for interacting with Allium's blockchain data schemas. These recipes are designed to help developers and analysts quickly construct queries for common use cases, such as retrieving token balances, tracking wallet activity, and analyzing DEX volumes.
⚠️ Construction Notice This repository is currently under active development. Directory structures, query syntax, and file organizations are subject to change without notice. Please verify all queries against the current schema documentation before using them in production.
This repository provides copy-pasteable SQL snippets organized by use case and blockchain network. It is intended to serve as a companion to the official Allium Documentation.
To run these queries, you will need access to the Allium App. Reach out to hello@allium.so to get set up.
We welcome contributions! If you have a query pattern that you find useful:
- Fork the repository.
- Create a new branch for your recipe.
- Add your
.mdfile with a descriptive comment header explaining what it does. - Submit a Pull Request.
For issues related to the data itself or API connectivity, please contact Allium support or refer to the official documentation. For issues with a specific query in this repo, please open a GitHub Issue.
Last Updated: December 9 2025