Acala Dashboards

Overview

Acala is a decentralized finance hub and stablecoin platform powering cross-blockchain liquidity and applications. It serves as a critical infrastructure layer for the Polkadot ecosystem.

Featured Dashboards on Dune

Here you will find a variety of dashboards that help visualize data from the Acala parachain:

• Acala on Polkadot: This dashboard provides a comprehensive view of financial activities and token dynamics within the Acala network.

Key Tables

Data from the Acala parachain is organized into several key tables:

• acala.balances
• acala.blocks
• acala.calls
• acala.events
• acala.extrinsics
• acala.transfers

Start building your own queries using granular data on Dune here.

Useful Queries

Some useful queries for Acala are provided:

Title	Query	Description
Acala Asset Exchange Rate by Date	query_3672976	Retrieves historical exchange rates for Acala assets, date-wise breakdown
Acala Assets Most Frequently Subject to Swapping	query_3673478	This query identifies which Acala assets are swapped the most frequently on the platform.

These descriptions aim to provide more context and details about what each query does and the insights they offer.

Getting Started with Queries

To get started with querying data from Unique, you are welcome to use the mentioned materialized queries. You can use the following DuneSQL queries as examples:

Acala List of Assets

WITH
    decimals_for_each_symbol AS (
            SELECT
                symbol,
                MAX(decimals) AS decimals
            FROM
                acala.transfers
            WHERE
                symbol IS NOT NULL
            GROUP BY
                symbol
        )
SELECT
    b.asset,
    b.symbol,
    d.decimals
FROM
    acala.balances b
LEFT JOIN decimals_for_each_symbol d ON b.symbol = d.symbol
GROUP BY
    b.asset,
    b.symbol,
    d.decimals
ORDER BY
    SUM(b.free + b.reserved + b.misc_frozen + b.frozen) DESC

Query result:

DuneSQL Referece

For more information on DuneSQL, please refer to the DuneSQL Cheatsheet and DuneSQL Official Documentation.