Insight FAQs
You can include aggregation functions directly in your API requests. Here's an example:
You can find working examples and experiment with different aggregation presets in the Insight Playground. The Playground provides a user-friendly interface to build and test your aggregation queries.
- Calculating total trading volume
- Finding average transaction values
- Counting unique users/wallets
- Analyzing gas usage patterns
- Tracking NFT collection statistics
Yes, you can create custom aggregations using standard SQL aggregation functions like count()
, sum()
, avg()
, min()
, max()
, and countDistinct()
. The presets are just convenient shortcuts for common operations.
You can find the complete list of available aggregation presets in the Insight Playground, where you can also test them with real blockchain data.
More information coming soon.