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.
Featured Dashboards on Dune
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:
Title | Query | Description |
---|---|---|
Pendulum Spacewalk Transactions | query_3821151 | Find 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:
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:
For more information on DuneSQL, please refer to the DuneSQL Cheatsheet and DuneSQL Official Documentation.