Skip to main content

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.

Here you will find a variety of dashboards that help visualize data from 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.balances
  • frequency.blocks
  • frequency.calls
  • frequency.events
  • frequency.extrinsics
  • frequency.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

TitleQueryDescription
Frequency Schema List (Off-chain Payload)query_3781175Provides a list of schemas used in the off-chain payload of Frequency.
Frequency Schema Listquery_3760992Lists the schemas used in Frequency.
Frequency MSA Countquery_3820268Displays 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:

Frequency Extrinsics by Day
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 Referece

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