Concordium Blockchain Network Analysis
Exploring the Relationship Between Block Height, Staking, and Market Trends
@kaggle.thedevastator_concordium_blockchain_network_transaction_analys
Exploring the Relationship Between Block Height, Staking, and Market Trends
@kaggle.thedevastator_concordium_blockchain_network_transaction_analys
CREATE TABLE blocks_at_end_of_day (
"date" TIMESTAMP,
"blockheight" BIGINT,
"blockhash" VARCHAR,
"blockslottime" VARCHAR
);
CREATE TABLE blocks_at_height (
"height" BIGINT,
"block" VARCHAR
);
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
);
CREATE TABLE network_activity (
"date" TIMESTAMP,
"network_activity" DOUBLE
);
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
);
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
);
CREATE TABLE network_ccd_coingecko (
"date" TIMESTAMP,
"ccd_usd" DOUBLE,
"ccd_eur" DOUBLE,
"vol_usd" BIGINT,
"vol_eur" BIGINT,
"vol_ccd" BIGINT,
"label" VARCHAR
);
CREATE TABLE network_first_entry (
"date" TIMESTAMP,
"account" VARCHAR
);
CREATE TABLE network_first_entry_bakers (
"date" TIMESTAMP,
"account" VARCHAR,
"baker_id" BIGINT
);
CREATE TABLE network_microccd (
"date" TIMESTAMP,
"gtu_denominator" BIGINT,
"gtu_numerator" DOUBLE,
"nrg_denominator" BIGINT,
"nrg_numerator" BIGINT
);
CREATE TABLE network_release_amounts (
"date" TIMESTAMP,
"blockhash" VARCHAR,
"totalamountreleased" DOUBLE,
"blockheight" DOUBLE,
"totalamount" DOUBLE
);
CREATE TABLE network_stake_per_day (
"date" TIMESTAMP,
"account" VARCHAR,
"staked_amount" DOUBLE
);
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
);
CREATE TABLE network_summary (
"date" TIMESTAMP,
"total_amount" DOUBLE,
"total_encrypted_amount" DOUBLE,
"account_count" BIGINT,
"baker_count" BIGINT
);
CREATE TABLE network_transactions (
"date" TIMESTAMP,
"accounttransaction" BIGINT,
"bakingrewards" BIGINT,
"blockreward" BIGINT,
"finalizationrewards" BIGINT,
"mint" BIGINT
);
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
);
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
);
Anyone who has the link will be able to view this.