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.