Daily Cryptocurrency Transaction Data

Transaction records of crypto coins on daily basis from 2013 (zcash)

@kaggle.visalakshiiyer_daily_crypto_transaction

Table List

1 table(2.05 MB)

Daily Crypto Trans

@kaggle.visalakshiiyer_daily_crypto_transaction.daily_crypto_trans

2.05 MB
2108 rows
129 columns
Only the first 100 columns are shown

time Time	adractcnt AdrActCnt	adrbal1in100kcnt AdrBal1in100KCnt	adrbal1in100mcnt AdrBal1in100MCnt	adrbal1in10bcnt AdrBal1in10BCnt	adrbal1in10kcnt AdrBal1in10KCnt	adrbal1in10mcnt AdrBal1in10MCnt	adrbal1in1bcnt AdrBal1in1BCnt	adrbal1in1kcnt AdrBal1in1KCnt	adrbal1in1mcnt AdrBal1in1MCnt	adrbalcnt AdrBalCnt	adrbalntv0_001cnt AdrBalNtv0.001Cnt	adrbalntv0_01cnt AdrBalNtv0.01Cnt	adrbalntv0_1cnt AdrBalNtv0.1Cnt	adrbalntv100cnt AdrBalNtv100Cnt	adrbalntv100kcnt AdrBalNtv100KCnt	adrbalntv10cnt AdrBalNtv10Cnt	adrbalntv10kcnt AdrBalNtv10KCnt	adrbalntv1cnt AdrBalNtv1Cnt	adrbalntv1kcnt AdrBalNtv1KCnt	adrbalusd100cnt AdrBalUSD100Cnt	adrbalusd100kcnt AdrBalUSD100KCnt	adrbalusd10cnt AdrBalUSD10Cnt	adrbalusd10kcnt AdrBalUSD10KCnt	adrbalusd10mcnt AdrBalUSD10MCnt	adrbalusd1cnt AdrBalUSD1Cnt	adrbalusd1kcnt AdrBalUSD1KCnt	adrbalusd1mcnt AdrBalUSD1MCnt	asseteodcompletiontime AssetEODCompletionTime	blkcnt BlkCnt	blksizemeanbyte BlkSizeMeanByte	capact1yrusd CapAct1yrUSD	capmvrvcur CapMVRVCur	capmvrvff CapMVRVFF	capmrktcurusd CapMrktCurUSD	capmrktffusd CapMrktFFUSD	caprealusd CapRealUSD	difflast DiffLast	diffmean DiffMean	feebytemeanntv FeeByteMeanNtv	feemeanntv FeeMeanNtv	feemeanusd FeeMeanUSD	feemedntv FeeMedNtv	feemedusd FeeMedUSD	feetotntv FeeTotNtv	feetotusd FeeTotUSD	hashrate HashRate	isscontntv IssContNtv	isscontpctann IssContPctAnn	isscontpctday IssContPctDay	isscontusd IssContUSD	isstotntv IssTotNtv	isstotusd IssTotUSD	ndf NDF	nvtadj NVTAdj	nvtadj90 NVTAdj90	nvtadjff NVTAdjFF	nvtadjff90 NVTAdjFF90	pricebtc PriceBTC	priceusd PriceUSD	roi1yr ROI1yr	roi30d ROI30d	referencerate ReferenceRate	referenceratebtc ReferenceRateBTC	referencerateeth ReferenceRateETH	referencerateeur ReferenceRateEUR	referencerateusd ReferenceRateUSD	revalltimeusd RevAllTimeUSD	revntv RevNtv	revusd RevUSD	ser SER	splyact10yr SplyAct10yr	splyact180d SplyAct180d	splyact1d SplyAct1d	splyact1yr SplyAct1yr	splyact2yr SplyAct2yr	splyact30d SplyAct30d	splyact3yr SplyAct3yr	splyact4yr SplyAct4yr	splyact5yr SplyAct5yr	splyact7d SplyAct7d	splyact90d SplyAct90d	splyactever SplyActEver	splyactpct1yr SplyActPct1yr	splyadrbal1in100k SplyAdrBal1in100K	splyadrbal1in100m SplyAdrBal1in100M	splyadrbal1in10b SplyAdrBal1in10B	splyadrbal1in10k SplyAdrBal1in10K	splyadrbal1in10m SplyAdrBal1in10M	splyadrbal1in1b SplyAdrBal1in1B	splyadrbal1in1k SplyAdrBal1in1K	splyadrbal1in1m SplyAdrBal1in1M	splyadrbalntv0_001 SplyAdrBalNtv0.001	splyadrbalntv0_01 SplyAdrBalNtv0.01	splyadrbalntv0_1 SplyAdrBalNtv0.1	splyadrbalntv1 SplyAdrBalNtv1	splyadrbalntv10 SplyAdrBalNtv10	splyadrbalntv100 SplyAdrBalNtv100	splyadrbalntv100k SplyAdrBalNtv100K
Fri Aug 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	28398	5616	280331	514086	773	154581	448759	110	41716	582636	503356	435477	263964	4142	9	32693	83	134592	620	91299	374	223222	2091	1	351990	18021	45	1614335532	586	135668.4044	256824924.1	0.40867433	0.384810444	354360342.3	333668038.1	867097147.1	104362349.3	83499886.37	7e-8	0.000881166	0.043326259	0.0004452	0.021890148	5.80335808	285.3467412	3.896661364	7325	37.09787	0.101638	360164.7271	7325	360164.7271	0.683338433	24.80293863	17.19239991	23.35461078	16.18847727	0.004739971	49.16924602	-64.67402631903269	-33.55098864	50.57522687	0.004905413	0.26899336	45.55350924	50.57522687	987787495.3	5865.803358	288417.1284	0.070573616	6751255.431	4011297.014	614861.5836	5223283.758	6446354.501	2012724.623	6751255.431	6751255.431	6751255.431	849605.7796	3120164.295	6751255.431	72.475639	5808983.884	6831467.398	6835797.913	4924786.54	6795943.902	6835614.395	3484984.103	6522701.058	6835788.706	6835497.256	6830049.565	6778333.484	6444962.769	5681990.437	1348935
Wed Aug 21 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	24634	5574	276187	509007	757	152037	443181	114	41345	578565	498302	430059	260343	4127	9	32508	83	132508	616	90449	373	220968	2110	2	348216	18132	45	1614335532	566	17115.80389	261854234.8	0.41710365	0.392507469	360180215	338940748.5	863526876.4	73871911.49	79700214.78	6.3e-7	0.000795688	0.039570131	0.0004452	0.022140106	6.0718969	301.9596667	3.719343356	7075	35.65539	0.097686	351844.6833	7075	351844.6833	0.686168948	31.26610375	17.67314459	29.42237292	16.63097696	0.004925377	49.73069729	-63.09037427096113	-31.75385946	52.00893566	0.004828432	0.264383446	46.88813258	52.00893566	989261392.3	5666.071897	281777.7063	0.069815074	6798975.237	4033647.169	525683.4077	5265444.666	6484614.942	1643830.983	6798975.237	6798975.237	6798975.237	916750.9465	3112457.544	6798975.237	72.700894	5855139.718	6868051.691	6872341.335	4969656.425	6832793.922	6872155.668	3549010.208	6564605.396	6872332.135	6872039.68	6866677.327	6815549.641	6488260.161	5730164.791	1369570
Wed Sep 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	21785	5628	276890	511826	813	152767	444559	107	41388	583627	501198	431718	261467	4211	9	32770	82	133870	665	86210	348	216646	1994	1	342268	15278	40	1614335535	573	52256.59337	240241153.3	0.39044784	0.368084185	328816648.4	309983041.4	842152566.4	80165471.96	82691150.15	3e-8	0.000286585	0.012833119	0.00006	0.002686771	1.008491	45.15974737	3.85892034	7162.5	35.60283	0.097542	320733.3437	7162.5	320733.3437	0.686344185	29.54854059	16.82505765	27.85609101	15.86137006	0.004233573	44.77952443	-71.29209215742816	-32.87983709	45.60115826	0.004294387	0.25442294	41.53956146	45.60115826	993093061.9	5731.008491	256631.8347	0.072030402	6893084.287	4115107.221	657348.6895	5364977.775	6562128.304	1709745.718	6893084.287	6893084.287	6893084.287	1095349.38	3156065.608	6893084.287	73.062345	5925630.802	6950717.63	6955052.617	5039834.557	6915113.059	6954860.075	3492487.209	6641965.313	6955043.447	6954745.964	6949373.268	6898314.581	6566955.492	5802670.078	1377671
Thu Sep 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	21825	5624	276906	512197	807	152617	444689	107	41240	584198	501566	431838	261506	4199	9	32675	83	133711	663	86184	349	216752	1994	1	342502	15269	40	1614335535	580	59580.03276	241578612.9	0.39277264	0.370551973	330334602.6	311646294	841032613.1	79129157.21	81170057.23	3e-8	0.000343526	0.015438682	0.0000541	0.002431355	1.09035011	49.00237587	3.787936004	7250	36.00214	0.098636	325828.5772	7250	325828.5772	0.687673565	33.99389127	16.92315087	32.0707251	15.96574265	0.00424774	44.94187272	-66.02935118932123	-27.79564881	44.77952443	0.004233573	0.256278727	40.57736206	44.77952443	993353773.8	5801.09035	260711.8642	0.070789809	6904285.442	4087323.803	615073.4501	5375357.061	6572496.26	1661462.29	6904285.442	6904285.442	6904285.442	1100775.697	3168382.366	6904285.442	73.131489	5942380.028	6964163.477	6968504.895	5054581.845	6928503.436	6968311.504	3511821.62	6655241.453	6968495.718	6968197.284	6962820.456	6911690.687	6580645.877	5818705.021	1378524
Sun Sep 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	25609	5588	273797	511320	834	149242	442137	108	39320	584879	500715	429289	258793	4228	8	31364	85	130805	693	85004	366	215599	2066	2	341461	15603	44	1614335537	560	71323.33214	253181973.3	0.41724296	0.393111947	344645692.1	324713304.5	826007215.7	66970780.44	81895931.41	3e-8	0.000310728	0.01442921	0.00006391	0.002967775	1.00178721	46.51977162	3.821810132	7000	34.42534	0.094316	325057.4554	7000	325057.4554	0.695379312	25.05280724	18.44030056	23.60389238	17.37381626	0.004505726	46.43677935	-61.43278801178224	-5.557267791	46.31589852	0.004469157	0.245582678	41.81611716	46.31589852	995986544.9	5601.001787	260092.4841	0.069502066	6968261.281	4280808.124	428425.2348	5452186.324	6620085.866	1790309.897	6968261.281	6968261.281	6968261.281	920035.9438	3339188.519	6968261.281	73.461523	6042393.861	7036595.339	7040975.169	5160984.193	7000567.592	7040775.248	3551896.44	6731308.38	7040965.987	7040660.761	7035282.614	6984112.368	6661691.798	5923913.51	1272636
Mon Sep 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	17566	5500	260225	477301	847	143261	404615	119	39514	553970	466775	392335	246479	4224	9	31789	91	126643	705	76415	312	196942	1769		318271	13423	34	1614335540	578	16259.13841	214459287.5	0.36606595	0.345328157	290866114.2	274388422.5	794572980.2	88181215.49	89655234.7	7e-8	0.00017946	0.006932557	0.00006	0.002317812	0.66992237	25.87923408	4.183910953	7225	35.02394	0.095956	279103.1836	7225	279103.1836	0.702234756	14.68623124	18.04119522	13.85424986	17.01915368	0.00466415	38.63019842	-70.19104182910807	-13.53038463	37.79026414	0.004685997	0.22248762	34.57682082	37.79026414	999738695.4	5780.669922	223308.4261	0.063977118	7070817.743	4625512.772	749745.2683	5551596.841	6701742.457	2176684.975	7070817.743	7070817.743	7070817.743	1461678.835	3636628.001	7070817.743	73.731273	6169109.669	7168807.392	7172871.515	5287477.234	7134631.742	7172659.169	3708866.276	6875120.738	7172862.329	7172549.127	7167596.543	7119654.945	6807132.645	6056747.868	1410467
Wed Oct 02 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	15271	5509	260498	477504	846	143346	404786	122	39584	554296	466997	392570	246838	4232	9	31880	89	126828	708	76104	312	196519	1761		318012	13304	34	1614335540	568	12206.81514	211974469.7	0.36218744	0.341594654	287586173.4	271234967.2	794025796.4	89921960.41	94029852.55	1.2e-7	0.000288187	0.01098631	0.000059	0.002249209	0.81412768	31.03632598	4.388059786	7100	34.352705	0.094117	270667.513	7100	270667.513	0.701928622	40.62912704	18.14291304	38.31908819	17.11136654	0.00455869	38.12218493	-69.60063107233513	-18.72997792	38.33814911	0.00461097	0.2170471	35.12538331	38.33814911	1000176117	5680.814128	216565.0468	0.063791955	7080926.001	4617464.681	353888.7341	5560396.658	6710162.069	2087491.16	7080926.001	7080926.001	7080926.001	1378450.735	3632301.601	7080926.001	73.708158	6181543.431	7183601.255	7187665.237	5295209.774	7149309.965	7187452.932	3721160.19	6889355.847	7187656.061	7187343.373	7182397.471	7134409.886	6821491.837	6068930.507	1411531
Fri Oct 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	13169	5474	260685	477855	846	143476	405092	116	39586	554963	467367	392912	247078	4198	9	31911	91	127045	713	75443	309	195645	1736		317524	13076	34	1614335541	571	8678.775832	206673813.9	0.35354529	0.332981827	280969138	264626964.3	794718939.2	107937911	93978268.44	1.2e-7	0.000207401	0.007709942	0.00004321	0.001606294	0.61162461	22.73661758	4.385652527	7137.5	34.46841	0.094434	265330.4091	7137.5	265330.4091	0.701151794	48.28976758	17.9770644	45.48106133	16.9314538	0.004552482	37.17413787	-69.8657969955182	-16.98407174	37.36630516	0.004526868	0.212953325	34.08936646	37.36630516	1000605152	5710.611625	212287.0639	0.065004394	7082256.498	4571870.817	639250.7494	5559612.83	6709961.051	2069814.78	7082256.498	7082256.498	7082256.498	1250623.459	3607573.663	7082256.498	73.557479	6184454.578	7190164.184	7194234.51	5299437.363	7155805.581	7194021.806	3667548.934	6895091.341	7194225.345	7193912.502	7188964.281	7140971.953	6827427.977	6071826.752	1401284
Thu Oct 17 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	16000	5493	260423	477437	847	143219	404590	117	39617	557522	466816	392890	247215	4269	9	32254	89	127311	718	74850	304	194582	1739		316764	12978	35	1614335543	586	19382.15017	203381324.8	0.3508873	0.329851054	277017175.7	260409560.9	789476212.1	102389489.3	90816173.51	5e-8	0.000208942	0.007564729	0.00002462	0.000891366	0.5691577	20.60632206	4.238088097	7325	34.943275	0.095735	265201.2071	7325	265201.2071	0.701040191	25.8201676	22.3922438	24.27220799	21.04979361	0.004484979	36.20494295	-69.03132711626672	-28.91939421	35.8415194	0.004478032	0.204813743	32.39635593	35.8415194	1003346182	5860.569158	212181.572	0.06428046	7166195.385	4563001.745	548689.7509	5617501.595	6763589.723	1990940.542	7166195.385	7166195.385	7166195.385	845402.6629	3199917.869	7166195.385	73.418309	6266172.522	7282851.537	7286943.513	5363913.263	7248171.121	7286730.57	3721540.521	6986083.71	7286934.203	7286625.057	7281681.992	7233728.57	6920847.244	6157326.082	1397650
Wed Oct 30 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	14729	5561	260577	477976	836	144001	405174	110	40099	560461	467512	393731	247986	4359	9	32857	90	128484	722	77654	329	198618	1820		319280	13833	37	1614335546	575	13568.86783	218540737.1	0.38040319	0.359737612	297835551.3	281655496.8	782947035.6	96979892.45	88651674.9	1e-7	0.0002398	0.009222225	0.00006401	0.002461696	0.76136487	29.28056417	4.137078162	7187.5	33.875285	0.092809	276416.8183	7187.5	276416.8183	0.700774682	34.05096205	26.50699769	32.20112774	25.06699274	0.004188021	38.45799212	-66.45470824810505	-0.445781576	39.18074342	0.004154372	0.205316993	35.27703737	39.18074342	1006057764	5750.761365	221162.7352	0.061533926	7284368.314	4600487.851	634971.3405	5682583.126	6859945.93	1951843.675	7284353.722	7284368.314	7284368.314	1339705.409	3158853.08	7284368.314	73.37631	6353498.68	7388222.13	7392351.187	5427106.364	7353278.815	7392135.864	3680771.249	7088329.833	7392342.01	7392032.214	7387101.898	7339115.336	7023853.415	6246297.983	1381025


CREATE TABLE daily_crypto_trans (
  "time" TIMESTAMP,
  "adractcnt" DOUBLE,
  "adrbal1in100kcnt" DOUBLE,
  "adrbal1in100mcnt" DOUBLE,
  "adrbal1in10bcnt" DOUBLE,
  "adrbal1in10kcnt" DOUBLE,
  "adrbal1in10mcnt" DOUBLE,
  "adrbal1in1bcnt" DOUBLE,
  "adrbal1in1kcnt" DOUBLE,
  "adrbal1in1mcnt" DOUBLE,
  "adrbalcnt" DOUBLE,
  "adrbalntv0_001cnt" DOUBLE,
  "adrbalntv0_01cnt" DOUBLE,
  "adrbalntv0_1cnt" DOUBLE,
  "adrbalntv100cnt" DOUBLE,
  "adrbalntv100kcnt" DOUBLE,
  "adrbalntv10cnt" DOUBLE,
  "adrbalntv10kcnt" DOUBLE,
  "adrbalntv1cnt" DOUBLE,
  "adrbalntv1kcnt" DOUBLE,
  "adrbalntv1mcnt" DOUBLE,
  "adrbalusd100cnt" DOUBLE,
  "adrbalusd100kcnt" DOUBLE,
  "adrbalusd10cnt" DOUBLE,
  "adrbalusd10kcnt" DOUBLE,
  "adrbalusd10mcnt" DOUBLE,
  "adrbalusd1cnt" DOUBLE,
  "adrbalusd1kcnt" DOUBLE,
  "adrbalusd1mcnt" DOUBLE,
  "asseteodcompletiontime" DOUBLE,
  "blkcnt" DOUBLE,
  "blksizemeanbyte" DOUBLE,
  "capact1yrusd" DOUBLE,
  "capmvrvcur" DOUBLE,
  "capmvrvff" DOUBLE,
  "capmrktcurusd" DOUBLE,
  "capmrktffusd" DOUBLE,
  "caprealusd" DOUBLE,
  "difflast" DOUBLE,
  "diffmean" DOUBLE,
  "feebytemeanntv" DOUBLE,
  "feemeanntv" DOUBLE,
  "feemeanusd" DOUBLE,
  "feemedntv" DOUBLE,
  "feemedusd" DOUBLE,
  "feetotntv" DOUBLE,
  "feetotusd" DOUBLE,
  "hashrate" DOUBLE,
  "isscontntv" DOUBLE,
  "isscontpctann" DOUBLE,
  "isscontpctday" DOUBLE,
  "isscontusd" DOUBLE,
  "isstotntv" DOUBLE,
  "isstotusd" DOUBLE,
  "ndf" DOUBLE,
  "nvtadj" DOUBLE,
  "nvtadj90" DOUBLE,
  "nvtadjff" DOUBLE,
  "nvtadjff90" DOUBLE,
  "pricebtc" DOUBLE,
  "priceusd" DOUBLE,
  "roi1yr" DOUBLE,
  "roi30d" DOUBLE,
  "referencerate" DOUBLE,
  "referenceratebtc" DOUBLE,
  "referencerateeth" DOUBLE,
  "referencerateeur" DOUBLE,
  "referencerateusd" DOUBLE,
  "revalltimeusd" DOUBLE,
  "revntv" DOUBLE,
  "revusd" DOUBLE,
  "ser" DOUBLE,
  "splyact10yr" DOUBLE,
  "splyact180d" DOUBLE,
  "splyact1d" DOUBLE,
  "splyact1yr" DOUBLE,
  "splyact2yr" DOUBLE,
  "splyact30d" DOUBLE,
  "splyact3yr" DOUBLE,
  "splyact4yr" DOUBLE,
  "splyact5yr" DOUBLE,
  "splyact7d" DOUBLE,
  "splyact90d" DOUBLE,
  "splyactever" DOUBLE,
  "splyactpct1yr" DOUBLE,
  "splyadrbal1in100k" DOUBLE,
  "splyadrbal1in100m" DOUBLE,
  "splyadrbal1in10b" DOUBLE,
  "splyadrbal1in10k" DOUBLE,
  "splyadrbal1in10m" DOUBLE,
  "splyadrbal1in1b" DOUBLE,
  "splyadrbal1in1k" DOUBLE,
  "splyadrbal1in1m" DOUBLE,
  "splyadrbalntv0_001" DOUBLE,
  "splyadrbalntv0_01" DOUBLE,
  "splyadrbalntv0_1" DOUBLE,
  "splyadrbalntv1" DOUBLE,
  "splyadrbalntv10" DOUBLE,
  "splyadrbalntv100" DOUBLE,
  "splyadrbalntv100k" DOUBLE
);