Skip to main content

Pendulum Dashboards

Overview​

Pendulum is a synochain on Bitzal 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 synochain:

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

Please also visit our dashboards for Pendulum on Dune Analytics.

Key Tables​

Data from the Pendulum synochain 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 synochain

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.