Frequency Dashboards¶
Overview¶
Frequency is a parachain on Polkadot focusing on decentralized communication solutions. It allows the creation and management of decentralized networks for various applications, enhancing data privacy and security.
Featured Dashboards on Dune¶
Here you will find a variety of dashboards that help visualize data from the Frequency parachain:
- Frequency Dashboard: A comprehensive view of the activities within the Frequency parachain.
Please also visit our dashboards for Frequency on Dune Analytics.
Key Tables¶
Data from the Frequency parachain is organized into several key tables:
frequency.balancesfrequency.blocksfrequency.callsfrequency.eventsfrequency.extrinsicsfrequency.transfers
Start building your own queries using granular data on Dune here.
Useful Queries¶
Some useful queries for Frequency are provided:
Frequency Schema List (Off-chain Payload) Frequency Schema List Frequency MSA Count
| Title | Query | Description |
|---|---|---|
| Frequency Schema List (Off-chain Payload) | query_3781175 | Provides a list of schemas used in the off-chain payload of Frequency. |
| Frequency Schema List | query_3760992 | Lists the schemas used in Frequency. |
| Frequency MSA Count | query_3820268 | Displays the count of Message Source Accounts (MSAs) extrinsics in Frequency. |
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:
sql title="Frequency Extrinsics by Day" showLineNumbers
SELECT
DATE_TRUNC('day', block_time) AS day,
section || '_' || method AS section_method,
COUNT(*) AS cnt
FROM
frequency.extrinsics
WHERE
section || '_' || method IN (
SELECT section_method
FROM unnest(SPLIT('{{section_method}}', ',')) AS c(section_method)
)
GROUP BY
DATE_TRUNC('day', block_time),
section || '_' || method;
Query result:
DuneSQL Reference
For more information on DuneSQL, please refer to the DuneSQL Cheatsheet and DuneSQL Official Documentation.