Skip to main content

Coretime Dashboards

Overview

Coretime is a parachain on Polkadot that focuses on time-stamping and data certification, providing a decentralized and secure mechanism for verifying data integrity.

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

Please also visit our dashboards for Coretime on Dune Analytics.

Key Tables

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

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

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

Useful Queries

Some useful queries for Coretime are provided:

TitleQueryDescription
Kusama Coretime Core Statisticsquery_3765036This query provides detailed statistics on Coretime sales activities on the Kusama network, including sale start time, lead-in length, start and regular prices, region details, cores sold, and more.

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:

Kusama Coretime Core Statistics
WITH
core_sta as (
SELECT
block_time,
get_href (
'https://nodle.subscan.io/extrinsic/' || cast(extrinsic_id as VARCHAR),
extrinsic_id
) as extrinsics_url,
extrinsic_id,
CAST(JSON_EXTRACT_SCALAR(data, '$[0]') AS BIGINT) as sale_start,
CAST(JSON_EXTRACT_SCALAR(data, '$[1]') AS BIGINT) as leadin_length,
CAST(JSON_EXTRACT_SCALAR(data, '$[2]') AS BIGINT) / pow(10, 12) as start_price,
CAST(JSON_EXTRACT_SCALAR(data, '$[3]') AS BIGINT) / pow(10, 12) as regular_price,
CAST(JSON_EXTRACT_SCALAR(data, '$[4]') AS BIGINT) as region_begin,
CAST(JSON_EXTRACT_SCALAR(data, '$[5]') AS BIGINT) as region_end,
CAST(JSON_EXTRACT_SCALAR(data, '$[6]') AS BIGINT) as ideal_cores_sold,
CAST(JSON_EXTRACT_SCALAR(data, '$[7]') AS BIGINT) as cores_offered,
CAST(
ROW_NUMBER() OVER (
ORDER BY
block_time ASC
) AS BIGINT
) AS sale_round
FROM
coretime_kusama.events
WHERE
section = 'broker'
AND method = 'SaleInitialized'
)
SELECT
*,
get_href (
'https://dune.com/substrate/kusama-coretime-sales-history?sale_round=' || cast(sale_round as VARCHAR),
cast(sale_round as VARCHAR)
) as sale_round_url
FROM
core_sta
ORDER BY
block_time DESC

Query result:

DuneSQL Referece

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