Skip to main content

Polimec Dashboards

Overview​

Polimec offers a decentralized, transparent, and compliant method for fundraising, ensuring that stakeholder incentives are aligned both during and after the fundraising process.

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

  • Polimec: A comprehensive analysis of Polimec, including: Staking, Funding, Asset Analysis.

Key Tables​

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

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

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

Useful Queries​

Some useful queries for Polimec are provided:

TitleQueryDescription
Polimec Latest Collator Infoquery_3776548Find the latest collator information on Polimec
Plimec All Evaluationsquery_3802921Get all evaluation information for all projects on Polimec
Polimec All Funding Participationsquery_3850228Get all funding participation information for all projects on Polimec

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:

Polimec Latest Reward Distribution
WITH latest_round AS (
  SELECT
    MAX(CAST(JSON_EXTRACT_SCALAR(data, '$[0]') AS BIGINT)) AS start_block
  FROM
    polimec.events
  WHERE
    section = 'parachainStaking'
    AND method = 'NewRound'
),
summed AS (
  SELECT
    MAX(block_time) AS latest_time,
    JSON_EXTRACT_SCALAR(JSON_PARSE(data), '$[0]') AS delegator,
    SUM(
      CAST(JSON_EXTRACT_SCALAR(data, '$[1]') AS BIGINT) / POW(10, 10)
    ) AS reward
  FROM
    polimec.events
  WHERE
    section = 'parachainStaking'
    AND method = 'Rewarded'
    AND CAST(block_number AS BIGINT) >= (
      SELECT
        start_block
      FROM
        latest_round
    )
  GROUP BY
    JSON_EXTRACT_SCALAR(JSON_PARSE(data), '$[0]')
)
SELECT
  latest_time,
  delegator,
  get_href(
    'https://explorer.polimec.org/polimec/account/' || delegator,
    CONCAT(
      SUBSTR(delegator, 1, 4),
      '...',
      SUBSTR(delegator, LENGTH(delegator) - 3)
    )
  ) AS delegator_url,
  reward
FROM
  summed
ORDER BY
  reward DESC;

Query result:

DuneSQL Referece

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