Skip to main content

Pendulum Dashboards

Overview​

Pendulum is a parachain on Polkadot that focuses on bridging fiat currencies and decentralized finance (DeFi). It aims to create a fully functional fiat-optimized blockchain that facilitates open financial applications and connects them with the traditional financial sector.

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

  • Pendulum on Polkadot: Explore comprehensive data visualizations tracking the integration of fiat and DeFi on the Pendulum parachain.

Please also visit our dashboards for Pendulum on Dune Analytics.

Key Tables​

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

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

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

Useful Queries​

Some useful queries for Pendulum are provided:

TitleQueryDescription
Pendulum Spacewalk Transactionsquery_3821151Find all Spacewalk transactions on the Pendulum parachain

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:

Pendulum Spacewalk Transactions by Month
SELECT
  DATE_TRUNC('month', block_time) AS month,
  SUM(amount) AS amount,
  COUNT(*) AS count,
  token_name
FROM
  query_3821151 -- Pendulum Spacewalk Transactions
GROUP BY
  DATE_TRUNC('month', block_time),
  token_name;

Query result:

DuneSQL Referece

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