MBAL: 10 Millions Crypto Address Label Dataset
A dataset of 10 millions annotated crypto addresses with categories and entities
@kaggle.yidongchaintoolai_mbal_10m_crypto_address_label_dataset
A dataset of 10 millions annotated crypto addresses with categories and entities
@kaggle.yidongchaintoolai_mbal_10m_crypto_address_label_dataset
CREATE TABLE dataset_10m_ads (
"chain" VARCHAR,
"address" VARCHAR,
"categories" VARCHAR,
"entity" VARCHAR,
"source" VARCHAR
);
CREATE TABLE exp1_bitcoin_sample_test_dd (
"address" VARCHAR,
"category" VARCHAR,
"active_days_1y" BIGINT,
"active_days_180d" BIGINT,
"active_days_30d" BIGINT,
"day_r_1y" BIGINT,
"day_r_180d" BIGINT,
"day_r_30d" BIGINT,
"day_s_1y" BIGINT,
"day_s_180d" BIGINT,
"day_s_30d" BIGINT,
"amt_1y" BIGINT,
"amt_180d" BIGINT,
"amt_30d" BIGINT,
"amt_r_1y" BIGINT,
"amt_r_180d" BIGINT,
"amt_r_30d" BIGINT,
"amt_s_1y" BIGINT,
"amt_s_180d" BIGINT,
"amt_s_30d" BIGINT,
"cnt_1y" BIGINT,
"cnt_180d" BIGINT,
"cnt_30d" BIGINT,
"cnt_r_1y" BIGINT,
"cnt_r_180d" BIGINT,
"cnt_r_30d" BIGINT,
"cnt_s_1y" BIGINT,
"cnt_s_180d" BIGINT,
"cnt_s_30d" BIGINT,
"opns_1y" DOUBLE,
"opns_180d" DOUBLE,
"opns_30d" DOUBLE,
"opns_r_1y" DOUBLE,
"opns_r_180d" DOUBLE,
"opns_r_30d" DOUBLE,
"opns_s_1y" DOUBLE,
"opns_s_180d" DOUBLE,
"opns_s_30d" DOUBLE,
"max_amt_1y" BIGINT,
"max_amt_180d" DOUBLE,
"max_amt_30d" DOUBLE,
"max_amt_r_1y" BIGINT,
"max_amt_r_180d" DOUBLE,
"max_amt_r_30d" DOUBLE,
"max_amt_s_1y" BIGINT,
"max_amt_s_180d" DOUBLE,
"max_amt_s_30d" DOUBLE,
"max_cnt_1y" BIGINT,
"max_cnt_180d" DOUBLE,
"max_cnt_30d" DOUBLE,
"max_cnt_r_1y" BIGINT,
"max_cnt_r_180d" DOUBLE,
"max_cnt_r_30d" DOUBLE,
"max_cnt_s_1y" BIGINT,
"max_cnt_s_180d" DOUBLE,
"max_cnt_s_30d" DOUBLE,
"max_opns_1y" DOUBLE,
"max_opns_180d" DOUBLE,
"max_opns_30d" DOUBLE,
"max_opns_r_1y" DOUBLE,
"max_opns_r_180d" DOUBLE,
"max_opns_r_30d" DOUBLE,
"max_opns_s_1y" DOUBLE,
"max_opns_s_180d" DOUBLE,
"max_opns_s_30d" DOUBLE,
"min_amt_1y" BIGINT,
"min_amt_180d" DOUBLE,
"min_amt_30d" DOUBLE,
"min_amt_r_1y" BIGINT,
"min_amt_r_180d" DOUBLE,
"min_amt_r_30d" DOUBLE,
"min_amt_s_1y" BIGINT,
"min_amt_s_180d" DOUBLE,
"min_amt_s_30d" DOUBLE,
"min_cnt_1y" BIGINT,
"min_cnt_180d" DOUBLE,
"min_cnt_30d" DOUBLE,
"min_cnt_r_1y" BIGINT,
"min_cnt_r_180d" DOUBLE,
"min_cnt_r_30d" DOUBLE,
"min_cnt_s_1y" BIGINT,
"min_cnt_s_180d" DOUBLE,
"min_cnt_s_30d" DOUBLE,
"min_opns_1y" DOUBLE,
"min_opns_180d" DOUBLE,
"min_opns_30d" DOUBLE,
"min_opns_r_1y" DOUBLE,
"min_opns_r_180d" DOUBLE,
"min_opns_r_30d" DOUBLE,
"min_opns_s_1y" DOUBLE,
"min_opns_s_180d" DOUBLE,
"min_opns_s_30d" DOUBLE,
"mean_amt_1y" DOUBLE,
"mean_amt_180d" DOUBLE,
"mean_amt_30d" DOUBLE,
"mean_amt_r_1y" DOUBLE,
"mean_amt_r_180d" DOUBLE,
"mean_amt_r_30d" DOUBLE,
"mean_amt_s_1y" DOUBLE,
"mean_amt_s_180d" DOUBLE
);
CREATE TABLE exp1_bitcoin_sample_train_babd_dd (
"address" VARCHAR,
"category" VARCHAR,
"active_days_1y" BIGINT,
"active_days_180d" BIGINT,
"active_days_30d" BIGINT,
"day_r_1y" BIGINT,
"day_r_180d" BIGINT,
"day_r_30d" BIGINT,
"day_s_1y" BIGINT,
"day_s_180d" BIGINT,
"day_s_30d" BIGINT,
"amt_1y" BIGINT,
"amt_180d" BIGINT,
"amt_30d" BIGINT,
"amt_r_1y" BIGINT,
"amt_r_180d" BIGINT,
"amt_r_30d" BIGINT,
"amt_s_1y" BIGINT,
"amt_s_180d" BIGINT,
"amt_s_30d" BIGINT,
"cnt_1y" BIGINT,
"cnt_180d" BIGINT,
"cnt_30d" BIGINT,
"cnt_r_1y" BIGINT,
"cnt_r_180d" BIGINT,
"cnt_r_30d" BIGINT,
"cnt_s_1y" BIGINT,
"cnt_s_180d" BIGINT,
"cnt_s_30d" BIGINT,
"opns_1y" DOUBLE,
"opns_180d" DOUBLE,
"opns_30d" DOUBLE,
"opns_r_1y" DOUBLE,
"opns_r_180d" DOUBLE,
"opns_r_30d" DOUBLE,
"opns_s_1y" DOUBLE,
"opns_s_180d" DOUBLE,
"opns_s_30d" DOUBLE,
"max_amt_1y" BIGINT,
"max_amt_180d" DOUBLE,
"max_amt_30d" DOUBLE,
"max_amt_r_1y" BIGINT,
"max_amt_r_180d" DOUBLE,
"max_amt_r_30d" DOUBLE,
"max_amt_s_1y" BIGINT,
"max_amt_s_180d" DOUBLE,
"max_amt_s_30d" DOUBLE,
"max_cnt_1y" BIGINT,
"max_cnt_180d" DOUBLE,
"max_cnt_30d" DOUBLE,
"max_cnt_r_1y" BIGINT,
"max_cnt_r_180d" DOUBLE,
"max_cnt_r_30d" DOUBLE,
"max_cnt_s_1y" BIGINT,
"max_cnt_s_180d" DOUBLE,
"max_cnt_s_30d" DOUBLE,
"max_opns_1y" DOUBLE,
"max_opns_180d" DOUBLE,
"max_opns_30d" DOUBLE,
"max_opns_r_1y" DOUBLE,
"max_opns_r_180d" DOUBLE,
"max_opns_r_30d" DOUBLE,
"max_opns_s_1y" DOUBLE,
"max_opns_s_180d" DOUBLE,
"max_opns_s_30d" DOUBLE,
"min_amt_1y" BIGINT,
"min_amt_180d" DOUBLE,
"min_amt_30d" DOUBLE,
"min_amt_r_1y" BIGINT,
"min_amt_r_180d" DOUBLE,
"min_amt_r_30d" DOUBLE,
"min_amt_s_1y" BIGINT,
"min_amt_s_180d" DOUBLE,
"min_amt_s_30d" DOUBLE,
"min_cnt_1y" BIGINT,
"min_cnt_180d" DOUBLE,
"min_cnt_30d" DOUBLE,
"min_cnt_r_1y" BIGINT,
"min_cnt_r_180d" DOUBLE,
"min_cnt_r_30d" DOUBLE,
"min_cnt_s_1y" BIGINT,
"min_cnt_s_180d" DOUBLE,
"min_cnt_s_30d" DOUBLE,
"min_opns_1y" DOUBLE,
"min_opns_180d" DOUBLE,
"min_opns_30d" DOUBLE,
"min_opns_r_1y" DOUBLE,
"min_opns_r_180d" DOUBLE,
"min_opns_r_30d" DOUBLE,
"min_opns_s_1y" DOUBLE,
"min_opns_s_180d" DOUBLE,
"min_opns_s_30d" DOUBLE,
"mean_amt_1y" DOUBLE,
"mean_amt_180d" DOUBLE,
"mean_amt_30d" DOUBLE,
"mean_amt_r_1y" DOUBLE,
"mean_amt_r_180d" DOUBLE,
"mean_amt_r_30d" DOUBLE,
"mean_amt_s_1y" DOUBLE,
"mean_amt_s_180d" DOUBLE
);
CREATE TABLE exp1_bitcoin_sample_train_mbal_dd (
"address" VARCHAR,
"category" VARCHAR,
"active_days_1y" BIGINT,
"active_days_180d" BIGINT,
"active_days_30d" BIGINT,
"day_r_1y" BIGINT,
"day_r_180d" BIGINT,
"day_r_30d" BIGINT,
"day_s_1y" BIGINT,
"day_s_180d" BIGINT,
"day_s_30d" BIGINT,
"amt_1y" BIGINT,
"amt_180d" BIGINT,
"amt_30d" BIGINT,
"amt_r_1y" BIGINT,
"amt_r_180d" BIGINT,
"amt_r_30d" BIGINT,
"amt_s_1y" BIGINT,
"amt_s_180d" BIGINT,
"amt_s_30d" BIGINT,
"cnt_1y" BIGINT,
"cnt_180d" BIGINT,
"cnt_30d" BIGINT,
"cnt_r_1y" BIGINT,
"cnt_r_180d" BIGINT,
"cnt_r_30d" BIGINT,
"cnt_s_1y" BIGINT,
"cnt_s_180d" BIGINT,
"cnt_s_30d" BIGINT,
"opns_1y" DOUBLE,
"opns_180d" DOUBLE,
"opns_30d" DOUBLE,
"opns_r_1y" DOUBLE,
"opns_r_180d" DOUBLE,
"opns_r_30d" DOUBLE,
"opns_s_1y" DOUBLE,
"opns_s_180d" DOUBLE,
"opns_s_30d" DOUBLE,
"max_amt_1y" BIGINT,
"max_amt_180d" DOUBLE,
"max_amt_30d" DOUBLE,
"max_amt_r_1y" BIGINT,
"max_amt_r_180d" DOUBLE,
"max_amt_r_30d" DOUBLE,
"max_amt_s_1y" BIGINT,
"max_amt_s_180d" DOUBLE,
"max_amt_s_30d" DOUBLE,
"max_cnt_1y" BIGINT,
"max_cnt_180d" DOUBLE,
"max_cnt_30d" DOUBLE,
"max_cnt_r_1y" BIGINT,
"max_cnt_r_180d" DOUBLE,
"max_cnt_r_30d" DOUBLE,
"max_cnt_s_1y" BIGINT,
"max_cnt_s_180d" DOUBLE,
"max_cnt_s_30d" DOUBLE,
"max_opns_1y" DOUBLE,
"max_opns_180d" DOUBLE,
"max_opns_30d" DOUBLE,
"max_opns_r_1y" DOUBLE,
"max_opns_r_180d" DOUBLE,
"max_opns_r_30d" DOUBLE,
"max_opns_s_1y" DOUBLE,
"max_opns_s_180d" DOUBLE,
"max_opns_s_30d" DOUBLE,
"min_amt_1y" BIGINT,
"min_amt_180d" DOUBLE,
"min_amt_30d" DOUBLE,
"min_amt_r_1y" BIGINT,
"min_amt_r_180d" DOUBLE,
"min_amt_r_30d" DOUBLE,
"min_amt_s_1y" BIGINT,
"min_amt_s_180d" DOUBLE,
"min_amt_s_30d" DOUBLE,
"min_cnt_1y" BIGINT,
"min_cnt_180d" DOUBLE,
"min_cnt_30d" DOUBLE,
"min_cnt_r_1y" BIGINT,
"min_cnt_r_180d" DOUBLE,
"min_cnt_r_30d" DOUBLE,
"min_cnt_s_1y" BIGINT,
"min_cnt_s_180d" DOUBLE,
"min_cnt_s_30d" DOUBLE,
"min_opns_1y" DOUBLE,
"min_opns_180d" DOUBLE,
"min_opns_30d" DOUBLE,
"min_opns_r_1y" DOUBLE,
"min_opns_r_180d" DOUBLE,
"min_opns_r_30d" DOUBLE,
"min_opns_s_1y" DOUBLE,
"min_opns_s_180d" DOUBLE,
"min_opns_s_30d" DOUBLE,
"mean_amt_1y" DOUBLE,
"mean_amt_180d" DOUBLE,
"mean_amt_30d" DOUBLE,
"mean_amt_r_1y" DOUBLE,
"mean_amt_r_180d" DOUBLE,
"mean_amt_r_30d" DOUBLE,
"mean_amt_s_1y" DOUBLE,
"mean_amt_s_180d" DOUBLE
);
CREATE TABLE exp2_ethereum_sample_test_mbal_dd (
"address" VARCHAR,
"category" VARCHAR,
"active_days_1y" BIGINT,
"opns_1y" BIGINT,
"calls_1y" BIGINT,
"cnt_1y" BIGINT,
"amt_1y" DOUBLE,
"day_ns_1y" DOUBLE,
"opn_ns_1y" DOUBLE,
"amt_ns_1y" DOUBLE,
"cnt_ns_1y" DOUBLE,
"max_amt_ns_1y" DOUBLE,
"min_amt_ns_1y" DOUBLE,
"mean_amt_ns_1y" DOUBLE,
"var_amt_ns_1y" DOUBLE,
"max_cnt_ns_1y" DOUBLE,
"min_cnt_ns_1y" DOUBLE,
"mean_cnt_ns_1y" DOUBLE,
"var_cnt_ns_1y" DOUBLE,
"max_opn_ns_1y" DOUBLE,
"min_opn_ns_1y" DOUBLE,
"mean_opn_ns_1y" DOUBLE,
"var_opn_ns_1y" DOUBLE,
"day_cs_1y" DOUBLE,
"opn_cs_1y" DOUBLE,
"cal_cs_1y" DOUBLE,
"cnt_cs_1y" DOUBLE,
"max_cnt_cs_1y" DOUBLE,
"min_cnt_cs_1y" DOUBLE,
"mean_cnt_cs_1y" DOUBLE,
"var_cnt_cs_1y" DOUBLE,
"max_opn_cs_1y" DOUBLE,
"min_opn_cs_1y" DOUBLE,
"mean_opn_cs_1y" DOUBLE,
"var_opn_cs_1y" DOUBLE,
"max_cal_cs_1y" DOUBLE,
"min_cal_cs_1y" DOUBLE,
"mean_cal_cs_1y" DOUBLE,
"var_cal_cs_1y" DOUBLE,
"day_nr_1y" DOUBLE,
"opn_nr_1y" DOUBLE,
"amt_nr_1y" DOUBLE,
"cnt_nr_1y" DOUBLE,
"max_amt_nr_1y" DOUBLE,
"min_amt_nr_1y" DOUBLE,
"mean_amt_nr_1y" DOUBLE,
"var_amt_nr_1y" DOUBLE,
"max_cnt_nr_1y" DOUBLE,
"min_cnt_nr_1y" DOUBLE,
"mean_cnt_nr_1y" DOUBLE,
"var_cnt_nr_1y" DOUBLE,
"max_opn_nr_1y" DOUBLE,
"min_opn_nr_1y" DOUBLE,
"mean_opn_nr_1y" DOUBLE,
"var_opn_nr_1y" DOUBLE,
"day_cr_1y" DOUBLE,
"opn_cr_1y" DOUBLE,
"cal_cr_1y" DOUBLE,
"cnt_cr_1y" DOUBLE,
"max_cnt_cr_1y" DOUBLE,
"min_cnt_cr_1y" DOUBLE,
"mean_cnt_cr_1y" DOUBLE,
"var_cnt_cr_1y" DOUBLE,
"max_opn_cr_1y" DOUBLE,
"min_opn_cr_1y" DOUBLE,
"mean_opn_cr_1y" DOUBLE,
"var_opn_cr_1y" DOUBLE,
"max_cal_cr_1y" DOUBLE,
"min_cal_cr_1y" DOUBLE,
"mean_cal_cr_1y" DOUBLE,
"var_cal_cr_1y" DOUBLE,
"active_days_180d" DOUBLE,
"opns_180d" DOUBLE,
"calls_180d" DOUBLE,
"cnt_180d" DOUBLE,
"amt_180d" DOUBLE,
"day_ns_180d" DOUBLE,
"opn_ns_180d" DOUBLE,
"amt_ns_180d" DOUBLE,
"cnt_ns_180d" DOUBLE,
"max_amt_ns_180d" DOUBLE,
"min_amt_ns_180d" DOUBLE,
"mean_amt_ns_180d" DOUBLE,
"var_amt_ns_180d" DOUBLE,
"max_cnt_ns_180d" DOUBLE,
"min_cnt_ns_180d" DOUBLE,
"mean_cnt_ns_180d" DOUBLE,
"var_cnt_ns_180d" DOUBLE,
"max_opn_ns_180d" DOUBLE,
"min_opn_ns_180d" DOUBLE,
"mean_opn_ns_180d" DOUBLE,
"var_opn_ns_180d" DOUBLE,
"day_cs_180d" DOUBLE,
"opn_cs_180d" DOUBLE,
"cal_cs_180d" DOUBLE,
"cnt_cs_180d" DOUBLE,
"max_cnt_cs_180d" DOUBLE,
"min_cnt_cs_180d" DOUBLE,
"mean_cnt_cs_180d" DOUBLE,
"var_cnt_cs_180d" DOUBLE
);
CREATE TABLE exp2_ethereum_sample_train_mbal_dd (
"address" VARCHAR,
"category" VARCHAR,
"active_days_1y" BIGINT,
"opns_1y" BIGINT,
"calls_1y" BIGINT,
"cnt_1y" BIGINT,
"amt_1y" DOUBLE,
"day_ns_1y" DOUBLE,
"opn_ns_1y" DOUBLE,
"amt_ns_1y" DOUBLE,
"cnt_ns_1y" DOUBLE,
"max_amt_ns_1y" DOUBLE,
"min_amt_ns_1y" DOUBLE,
"mean_amt_ns_1y" DOUBLE,
"var_amt_ns_1y" DOUBLE,
"max_cnt_ns_1y" DOUBLE,
"min_cnt_ns_1y" DOUBLE,
"mean_cnt_ns_1y" DOUBLE,
"var_cnt_ns_1y" DOUBLE,
"max_opn_ns_1y" DOUBLE,
"min_opn_ns_1y" DOUBLE,
"mean_opn_ns_1y" DOUBLE,
"var_opn_ns_1y" DOUBLE,
"day_cs_1y" DOUBLE,
"opn_cs_1y" DOUBLE,
"cal_cs_1y" DOUBLE,
"cnt_cs_1y" DOUBLE,
"max_cnt_cs_1y" DOUBLE,
"min_cnt_cs_1y" DOUBLE,
"mean_cnt_cs_1y" DOUBLE,
"var_cnt_cs_1y" DOUBLE,
"max_opn_cs_1y" DOUBLE,
"min_opn_cs_1y" DOUBLE,
"mean_opn_cs_1y" DOUBLE,
"var_opn_cs_1y" DOUBLE,
"max_cal_cs_1y" DOUBLE,
"min_cal_cs_1y" DOUBLE,
"mean_cal_cs_1y" DOUBLE,
"var_cal_cs_1y" DOUBLE,
"day_nr_1y" DOUBLE,
"opn_nr_1y" DOUBLE,
"amt_nr_1y" DOUBLE,
"cnt_nr_1y" DOUBLE,
"max_amt_nr_1y" DOUBLE,
"min_amt_nr_1y" DOUBLE,
"mean_amt_nr_1y" DOUBLE,
"var_amt_nr_1y" DOUBLE,
"max_cnt_nr_1y" DOUBLE,
"min_cnt_nr_1y" DOUBLE,
"mean_cnt_nr_1y" DOUBLE,
"var_cnt_nr_1y" DOUBLE,
"max_opn_nr_1y" DOUBLE,
"min_opn_nr_1y" DOUBLE,
"mean_opn_nr_1y" DOUBLE,
"var_opn_nr_1y" DOUBLE,
"day_cr_1y" DOUBLE,
"opn_cr_1y" DOUBLE,
"cal_cr_1y" DOUBLE,
"cnt_cr_1y" DOUBLE,
"max_cnt_cr_1y" DOUBLE,
"min_cnt_cr_1y" DOUBLE,
"mean_cnt_cr_1y" DOUBLE,
"var_cnt_cr_1y" DOUBLE,
"max_opn_cr_1y" DOUBLE,
"min_opn_cr_1y" DOUBLE,
"mean_opn_cr_1y" DOUBLE,
"var_opn_cr_1y" DOUBLE,
"max_cal_cr_1y" DOUBLE,
"min_cal_cr_1y" DOUBLE,
"mean_cal_cr_1y" DOUBLE,
"var_cal_cr_1y" DOUBLE,
"active_days_180d" DOUBLE,
"opns_180d" DOUBLE,
"calls_180d" DOUBLE,
"cnt_180d" DOUBLE,
"amt_180d" DOUBLE,
"day_ns_180d" DOUBLE,
"opn_ns_180d" DOUBLE,
"amt_ns_180d" DOUBLE,
"cnt_ns_180d" DOUBLE,
"max_amt_ns_180d" DOUBLE,
"min_amt_ns_180d" DOUBLE,
"mean_amt_ns_180d" DOUBLE,
"var_amt_ns_180d" DOUBLE,
"max_cnt_ns_180d" DOUBLE,
"min_cnt_ns_180d" DOUBLE,
"mean_cnt_ns_180d" DOUBLE,
"var_cnt_ns_180d" DOUBLE,
"max_opn_ns_180d" DOUBLE,
"min_opn_ns_180d" DOUBLE,
"mean_opn_ns_180d" DOUBLE,
"var_opn_ns_180d" DOUBLE,
"day_cs_180d" DOUBLE,
"opn_cs_180d" DOUBLE,
"cal_cs_180d" DOUBLE,
"cnt_cs_180d" DOUBLE,
"max_cnt_cs_180d" DOUBLE,
"min_cnt_cs_180d" DOUBLE,
"mean_cnt_cs_180d" DOUBLE,
"var_cnt_cs_180d" DOUBLE
);
Anyone who has the link will be able to view this.