Baselight

Concordium Blockchain Network Analysis

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

@kaggle.thedevastator_concordium_blockchain_network_transaction_analys

Loading...
Loading...

About this Dataset

Concordium Blockchain Network Analysis


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
Loading...
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
Loading...
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
Loading...
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
Loading...
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
Loading...
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
Loading...
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
Loading...
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
Loading...
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
Loading...
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
Loading...
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
Loading...
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
Loading...
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
Loading...
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
Loading...
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
Loading...
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
Loading...
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
Loading...
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
);

Share link

Anyone who has the link will be able to view this.