Name: Concordium Blockchain Network Analysis
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Concordium Blockchain Network Analysis

Exploring the Relationship Between Block Height, Staking, and Market Trends

By [source]

About this dataset

This dataset provides a comprehensive view of the Concordium blockchain network and its transaction analysis, staking activity, and related metrics. It includes information to track daily transactions and staking activities using columns such as date, account, block height/slot time/hash ID, credential creation date & count, total balance / locked & unlocked balance / staked amount & restake earnings. Furthermore, other metrics provide insights into the open & closed pools in the Concordium blockchain network (including newly closed pools), delegators count/average stake per pool/average delegated stake per pool and total supply of tokens in circulation (staked & unstaked). Additionally existing on exchanges such as Kucoin/Mexc/Ascendex etc., pricing information measured by CCD USD value + EUR value + Total Volume traded is provided along with GTU (Gas Token Units) + NRG (Network Resource Group) numerator & denominator values. Thus this dataset is perfect for those wanting to gain insights into open vs closed pools activity in their respective blockchain networks combined with external market dynamics playing a role

More Datasets

For more datasets, click here.

Featured Notebooks

🚨 Your notebook can be here! 🚨!

How to use the dataset

Welcome to the Concordium Blockchain Network! This dataset provides a comprehensive look at the various elements of this blockchain network - transaction analysis, staking activity, and more. In this guide, we will take you through how to use these data points to understand and master how the Concordium Blockchain Network works.

Research Ideas

Predicting the price of CCD tokens using the market volume of trades and the total balance of accounts in Concordium blockchain.

Analyzing the performance of delegator pools by tracking key metrics such as pool metadata, staking activity and commissions across different networks over time.

Identifying trends in user behavior by analyzing nonces, credential creation dates, and total balances for specific accounts on Concordium Blockchain network

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: blocks_at_end_of_day.csv

Column name	Description
date	Date of the block. (Date)
blockHeight	Height of the block in the blockchain. (Integer)
blockHash	Hash of the block. (String)
blockSlotTime	Time of the block slot. (Time)

File: blocks_at_height.csv

Column name	Description
height	The block height of the transaction. (Integer)

File: ccd-accounts-df.csv

Column name	Description
account	The account address associated with the transaction. (String)
nonce	The number of transactions associated with the account address. (Integer)
credential_creation_date	The date the account was created. (Date)
credential_count	The number of credentials associated with the account. (Integer)
total_balance	The total balance of the account. (Integer)
unlocked_balance	The amount of tokens that can be unlocked from the account. (Integer)
staked_amount	The amount of tokens that are staked in the account. (Integer)
restake_earnings	The amount of earnings from restaking tokens. (Integer)
pool_status	The status of the pool associated with the account. (String)
pool_metadata_url	The URL of the pool associated with the account. (String)
pool_transaction_commission	The transaction commission rate of the pool. (Integer)
pool_finalization_commission	The finalization commission rate of the pool. (Integer)
pool_baking_commission	The baking commission rate of the pool. (Integer)
delegation_target	The delegation target of the pool. (Integer)
baker_lp	The liquidity pool of the baker. (Integer)
baker_bpy	The baking power of the baker. (Integer)

File: network-ccd-classified-pools.csv

Column name	Description
date	Date of the block. (Date)
open_pool_count	The number of open pools in the Concordium Blockchain Network. (Numeric)
closed_pool_count	The number of closed pools in the Concordium Blockchain Network. (Numeric)
closed_new_pool_count	The number of newly closed pools in the Concordium Blockchain Network. (Numeric)
delegator_count	The total number of delegators in the Concordium Blockchain Network. (Numeric)
delegator_avg_stake	The average stake of delegators in the Concordium Blockchain Network. (Numeric)
delegator_avg_count_per_pool	The average number of delegators per pool in the Concordium Blockchain Network. (Numeric)
pool_total_delegated	The total amount of tokens delegated to pools in the Concordium Blockchain Network. (Numeric)

File: network-ccd-classified.csv

Column name	Description
date	Date of the block. (Date)
total_supply	Total amount of CCD tokens in circulation. (Numeric)
staked	Amount of CCD tokens staked in the network. (Numeric)
unstaked	Amount of CCD tokens not staked in the network. (Numeric)
bitfinex	Trading volume of CCD tokens on Bitfinex. (Numeric)
bitglobal	Trading volume of CCD tokens on BitGlobal. (Numeric)
mexc	Trading volume of CCD tokens on MEXC. (Numeric)
ascendex	Trading volume of CCD tokens on Ascendex. (Numeric)
kucoin	Trading volume of CCD tokens on Kucoin. (Numeric)
delegated	Amount of CCD tokens delegated to pools. (Numeric)

File: network-ccd-coingecko.csv

Column name	Description
date	Date of the block. (Date)
ccd_usd	The price of CCD tokens in US Dollars. (Numeric)
ccd_eur	The price of CCD tokens in Euros. (Numeric)
vol_usd	The trading volume of CCD tokens in US Dollars. (Numeric)
vol_eur	The trading volume of CCD tokens in Euros. (Numeric)
vol_ccd	The trading volume of CCD tokens in CCD. (Numeric)
label	A label associated with the transaction. (String)

File: network-first-entry-bakers.csv

Column name	Description
date	Date of the block. (Date)
account	The account address associated with the transaction. (String)

File: network-first-entry.csv

Column name	Description
date	Date of the block. (Date)
account	The account address associated with the transaction. (String)

File: network-microccd.csv

Column name	Description
date	Date of the block. (Date)
GTU_denominator	Denominator of the Gas Token Unit (GTU) ratio. (Integer)
GTU_numerator	Numerator of the Gas Token Unit (GTU) ratio. (Integer)
NRG_denominator	Denominator of the Energy Token Unit (NRG) ratio. (Integer)
NRG_numerator	Numerator of the Energy Token Unit (NRG) ratio. (Integer)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit .

Tables

Blocks At End Of Day

@kaggle.thedevastator_concordium_blockchain_network_transaction_analys.blocks_at_end_of_day

56.68 kB
564 rows
4 columns

CREATE TABLE blocks_at_end_of_day (
  "date" TIMESTAMP,
  "blockheight" BIGINT,
  "blockhash" VARCHAR,
  "blockslottime" VARCHAR
);

Blocks At Height

@kaggle.thedevastator_concordium_blockchain_network_transaction_analys.blocks_at_height

3.89 MB
53,232 rows
2 columns

CREATE TABLE blocks_at_height (
  "height" BIGINT,
  "block" VARCHAR
);

Ccd Accounts Df

@kaggle.thedevastator_concordium_blockchain_network_transaction_analys.ccd_accounts_df

4.87 MB
86,414 rows
19 columns

CREATE TABLE ccd_accounts_df (
  "account" VARCHAR,
  "nonce" BIGINT,
  "credential_creation_date" TIMESTAMP,
  "credential_valid_to_date" TIMESTAMP,
  "credential_count" BIGINT,
  "total_balance" DOUBLE,
  "unlocked_balance" DOUBLE,
  "locked_balance" DOUBLE,
  "baker_id" DOUBLE,
  "staked_amount" DOUBLE,
  "restake_earnings" VARCHAR,
  "pool_status" VARCHAR,
  "pool_metadata_url" VARCHAR,
  "pool_transaction_commission" DOUBLE,
  "pool_finalization_commission" DOUBLE,
  "pool_baking_commission" DOUBLE,
  "delegation_target" VARCHAR,
  "baker_lp" DOUBLE,
  "baker_bpy" DOUBLE
);

Network Activity

@kaggle.thedevastator_concordium_blockchain_network_transaction_analys.network_activity

11.65 kB
564 rows
2 columns

CREATE TABLE network_activity (
  "date" TIMESTAMP,
  "network_activity" DOUBLE
);

Network Ccd Classified

@kaggle.thedevastator_concordium_blockchain_network_transaction_analys.network_ccd_classified

41.87 kB
563 rows
10 columns

CREATE TABLE network_ccd_classified (
  "date" TIMESTAMP,
  "total_supply" DOUBLE,
  "staked" DOUBLE,
  "unstaked" DOUBLE,
  "bitfinex" DOUBLE,
  "bitglobal" DOUBLE,
  "mexc" DOUBLE,
  "ascendex" DOUBLE,
  "kucoin" DOUBLE,
  "delegated" DOUBLE
);

Network Ccd Classified Pools

@kaggle.thedevastator_concordium_blockchain_network_transaction_analys.network_ccd_classified_pools

14.8 kB
184 rows
8 columns

CREATE TABLE network_ccd_classified_pools (
  "date" TIMESTAMP,
  "open_pool_count" BIGINT,
  "closed_pool_count" BIGINT,
  "closed_new_pool_count" BIGINT,
  "delegator_count" BIGINT,
  "delegator_avg_stake" DOUBLE,
  "delegator_avg_count_per_pool" DOUBLE,
  "pool_total_delegated" DOUBLE
);

Network Ccd Coingecko

@kaggle.thedevastator_concordium_blockchain_network_transaction_analys.network_ccd_coingecko

20.06 kB
318 rows
7 columns

CREATE TABLE network_ccd_coingecko (
  "date" TIMESTAMP,
  "ccd_usd" DOUBLE,
  "ccd_eur" DOUBLE,
  "vol_usd" BIGINT,
  "vol_eur" BIGINT,
  "vol_ccd" BIGINT,
  "label" VARCHAR
);

Network First Entry

@kaggle.thedevastator_concordium_blockchain_network_transaction_analys.network_first_entry

4.58 MB
86,414 rows
2 columns

CREATE TABLE network_first_entry (
  "date" TIMESTAMP,
  "account" VARCHAR
);

Network First Entry Bakers

@kaggle.thedevastator_concordium_blockchain_network_transaction_analys.network_first_entry_bakers

28.97 kB
408 rows
3 columns

CREATE TABLE network_first_entry_bakers (
  "date" TIMESTAMP,
  "account" VARCHAR,
  "baker_id" BIGINT
);

Network Microccd

@kaggle.thedevastator_concordium_blockchain_network_transaction_analys.network_microccd

14.19 kB
564 rows
5 columns

CREATE TABLE network_microccd (
  "date" TIMESTAMP,
  "gtu_denominator" BIGINT,
  "gtu_numerator" DOUBLE,
  "nrg_denominator" BIGINT,
  "nrg_numerator" BIGINT
);

Network Release Amounts

@kaggle.thedevastator_concordium_blockchain_network_transaction_analys.network_release_amounts

60.84 kB
564 rows
5 columns

CREATE TABLE network_release_amounts (
  "date" TIMESTAMP,
  "blockhash" VARCHAR,
  "totalamountreleased" DOUBLE,
  "blockheight" DOUBLE,
  "totalamount" DOUBLE
);

Network Stake Per Day

@kaggle.thedevastator_concordium_blockchain_network_transaction_analys.network_stake_per_day

440.94 kB
82,653 rows
3 columns

CREATE TABLE network_stake_per_day (
  "date" TIMESTAMP,
  "account" VARCHAR,
  "staked_amount" DOUBLE
);

Network Stake Per Month

@kaggle.thedevastator_concordium_blockchain_network_transaction_analys.network_stake_per_month

42.51 kB
1,912 rows
6 columns

CREATE TABLE network_stake_per_month (
  "year_month" VARCHAR,
  "account" VARCHAR,
  "monthly_avg_staked_amount" DOUBLE,
  "days_active_in_month" BIGINT,
  "monthly_avg_total_balance" DOUBLE,
  "monthly_avg_total_staked" DOUBLE
);

Network Summary

@kaggle.thedevastator_concordium_blockchain_network_transaction_analys.network_summary

20.43 kB
564 rows
5 columns

CREATE TABLE network_summary (
  "date" TIMESTAMP,
  "total_amount" DOUBLE,
  "total_encrypted_amount" DOUBLE,
  "account_count" BIGINT,
  "baker_count" BIGINT
);

Network Transactions

@kaggle.thedevastator_concordium_blockchain_network_transaction_analys.network_transactions

15.68 kB
512 rows
6 columns

CREATE TABLE network_transactions (
  "date" TIMESTAMP,
  "accounttransaction" BIGINT,
  "bakingrewards" BIGINT,
  "blockreward" BIGINT,
  "finalizationrewards" BIGINT,
  "mint" BIGINT
);

Network Transactions Ce

@kaggle.thedevastator_concordium_blockchain_network_transaction_analys.network_transactions_ce

33.36 kB
512 rows
31 columns

CREATE TABLE network_transactions_ce (
  "date" TIMESTAMP,
  "transfer" DOUBLE,
  "addbaker" DOUBLE,
  "transfertoencrypted" DOUBLE,
  "encryptedamounttransfer" DOUBLE,
  "transfertopublic" DOUBLE,
  "transferwithschedule" DOUBLE,
  "removebaker" DOUBLE,
  "updatecredentials" DOUBLE,
  "deploymodule" DOUBLE,
  "initcontract" DOUBLE,
  "update" DOUBLE,
  "registerdata" DOUBLE,
  "transferwithmemo" DOUBLE,
  "updatebakerstake" DOUBLE,
  "updatebakerkeys" DOUBLE,
  "updatebakerrestakeearnings" DOUBLE,
  "transferwithscheduleandmemo" DOUBLE,
  "encryptedamounttransferwithmemo" DOUBLE,
  "unnamed_19" DOUBLE  -- Unnamed: 19,
  "unnamed_20" DOUBLE  -- Unnamed: 20,
  "unnamed_21" DOUBLE  -- Unnamed: 21,
  "unnamed_22" DOUBLE  -- Unnamed: 22,
  "configurebaker" DOUBLE,
  "configuredelegation" DOUBLE,
  "unnamed_25" DOUBLE  -- Unnamed: 25,
  "unnamed_26" DOUBLE  -- Unnamed: 26,
  "unnamed_27" DOUBLE  -- Unnamed: 27,
  "unnamed_28" DOUBLE  -- Unnamed: 28,
  "unnamed_29" DOUBLE  -- Unnamed: 29,
  "unnamed_30" DOUBLE  -- Unnamed: 30
);

Network Transactions Mongo

@kaggle.thedevastator_concordium_blockchain_network_transaction_analys.network_transactions_mongo

42.54 kB
564 rows
34 columns

CREATE TABLE network_transactions_mongo (
  "date" TIMESTAMP,
  "initial" DOUBLE,
  "normal" DOUBLE,
  "transfer" DOUBLE,
  "transfertopublic" DOUBLE,
  "removebaker" DOUBLE,
  "addbaker" DOUBLE,
  "encryptedamounttransfer" DOUBLE,
  "transferwithschedule" DOUBLE,
  "transfertoencrypted" DOUBLE,
  "credentialdeploymenttransaction" DOUBLE,
  "accounttransaction" DOUBLE,
  "updatecredentials" DOUBLE,
  "deploymodule" DOUBLE,
  "initcontract" DOUBLE,
  "update" DOUBLE,
  "updatemicrogtupereuro" DOUBLE,
  "updatepoolparameters" DOUBLE,
  "updatetransaction" DOUBLE,
  "registerdata" DOUBLE,
  "updateprotocol" DOUBLE,
  "transferwithmemo" DOUBLE,
  "updatebakerstake" DOUBLE,
  "updateaddidentityprovider" DOUBLE,
  "updatebakerkeys" DOUBLE,
  "updatebakerrestakeearnings" DOUBLE,
  "transferwithscheduleandmemo" DOUBLE,
  "updatelevel2keys" DOUBLE,
  "encryptedamounttransferwithmemo" DOUBLE,
  "unnamed_29" DOUBLE  -- Unnamed: 29,
  "updatelevel1keys" DOUBLE,
  "configuredelegation" DOUBLE,
  "configurebaker" DOUBLE,
  "unnamed_33" DOUBLE  -- Unnamed: 33
);