Cryptocurrency Top1000 Project Timeseries Dataset

id Id	symbol Symbol	name Name	image Image	current_price Current Price	market_cap Market Cap	market_cap_rank Market Cap Rank	fully_diluted_valuation Fully Diluted Valuation	total_volume Total Volume	high_24h High 24h	low_24h Low 24h	price_change_24h Price Change 24h	price_change_percentage_24h Price Change Percentage 24h	market_cap_change_24h Market Cap Change 24h	market_cap_change_percentage_24h Market Cap Change Percentage 24h	circulating_supply Circulating Supply	total_supply Total Supply	max_supply Max Supply	ath Ath	ath_change_percentage Ath Change Percentage	ath_date Ath Date	atl Atl	atl_change_percentage Atl Change Percentage	atl_date Atl Date	roi Roi	last_updated Last Updated
bitcoin	btc	Bitcoin	https://assets.coingecko.com/coins/images/1/large/bitcoin.png?1547033579	28586	556294419808	1	600328146295	16473552159	29222	28429	-607.5996972451903	-2.08124	-11872626569.99927	-2.08964	19459662	21000000	21000000	69045	-58.62655	2021-11-10T14:24:11.849Z	67.81	42027.4529	2013-07-06T00:00:00.000Z	nan	2023-08-17T02:32:13.805Z
ethereum	eth	Ethereum	https://assets.coingecko.com/coins/images/279/large/ethereum.png?1595348880	1798.6	216071794229	2	216071794229	7616252903	1829.85	1787.88	-29.90543616223113	-1.63551	-3626401487.025299	-1.65063	120135902.440721	120135902.440721		4878.26	-63.17383	2021-11-10T14:24:19.604Z	0.432979	414810.85074	2015-10-20T00:00:00.000Z	{'times': 83.12447399341853, 'currency': 'btc', 'percentage': 8312.447399341854}	2023-08-17T02:32:13.157Z
tether	usdt	Tether	https://assets.coingecko.com/coins/images/325/large/Tether.png?1668148663	0.998599	82900948179	3	82900948179	18979502175	1.002	0.995827	-0.0005147535693847	-0.05152	-207343464.4985352	-0.24949	83017245694.1072	83017245694.1072		1.32	-24.49958	2018-07-24T00:00:00.000Z	0.572521	74.48138	2015-03-02T00:00:00.000Z	nan	2023-08-17T02:30:00.464Z
binancecoin	bnb	BNB	https://assets.coingecko.com/coins/images/825/large/bnb-icon2_2x.png?1644979850	230.66	35487352098	4	46130560394	577909351	236.73	228.85	-5.688189443925893	-2.40671	-882142206.6813126	-2.4255	153856150	153856150	200000000	686.31	-66.4282	2021-05-10T07:24:17.097Z	0.0398177	578550.92585	2017-10-19T00:00:00.000Z	nan	2023-08-17T02:32:21.035Z
ripple	xrp	XRP	https://assets.coingecko.com/coins/images/44/large/xrp-symbol-white-128.png?1605778731	0.593143	31383228514	5	59390838083	1716778172	0.61355	0.580462	-0.0134068225284987	-2.21034	-618747425.4098473	-1.93347	52841868422	99988501123	100000000000	3.4	-82.60014	2018-01-07T00:00:00.000Z	0.00268621	21913.40838	2014-05-22T00:00:00.000Z	nan	2023-08-17T02:32:12.517Z
usd-coin	usdc	USD Coin	https://assets.coingecko.com/coins/images/6319/large/USD_Coin_icon.png?1547042389	1	26058362535	6	26058261139	4557414149	1.002	0.996835	0.00021251	0.02125	28365175	0.10897	26055949558.266	26055848171.7565		1.17	-14.76487	2019-05-08T00:40:28.300Z	0.877647	13.89067	2023-03-11T08:02:13.981Z	nan	2023-08-17T02:32:13.093Z
staked-ether	steth	Lido Staked Ether	https://assets.coingecko.com/coins/images/13442/large/steth_logo.png?1608607546	1797.4	14642383962	7	14642383962	18921345	1828.76	1784.18	-30.30610473294428	-1.65815	-215957050.4887981	-1.45344	8146569.23971302	8146569.23971302	8146569.23971302	4829.57	-62.82452	2021-11-10T14:40:47.256Z	482.9	271.80161	2020-12-22T04:08:21.854Z	nan	2023-08-17T02:32:21.699Z
cardano	ada	Cardano	https://assets.coingecko.com/coins/images/975/large/cardano.png?1547034860	0.277036	9705654674	8	12462668020	260377928	0.281727	0.268847	-0.0044843798745332	-1.59291	-157729884.4284668	-1.59915	35045020830.3234	45000000000	45000000000	3.09	-91.06142	2021-09-02T06:00:10.474Z	0.01925275	1333.1769	2020-03-13T02:22:55.044Z	nan	2023-08-17T02:32:14.422Z
dogecoin	doge	Dogecoin	https://assets.coingecko.com/coins/images/5/large/dogecoin.png?1547792256	0.068226	9593403484	9	9593372102	572537979	0.071112	0.066808	-0.0028377762102989	-3.99325	-402494540.4598064	-4.0266	140621116383.705	140620656383.705		0.731578	-90.7237	2021-05-08T05:08:23.458Z	0.0000869	77990.31429	2015-05-06T00:00:00.000Z	nan	2023-08-17T02:32:20.761Z
solana	sol	Solana	https://assets.coingecko.com/coins/images/4128/large/solana.png?1640133422	23.27	9481071135	10	12921542787	492172589	23.92	22.52	-0.6422396425299084	-2.68526	-237709735.2371826	-2.44588	407307791.445989	555110807.609593		259.96	-91.07497	2021-11-06T21:54:35.825Z	0.500801	4532.86377	2020-05-11T19:35:23.449Z	nan	2023-08-17T02:32:17.592Z


CREATE TABLE top_1000_cryptocurrency (
  "id" VARCHAR,
  "symbol" VARCHAR,
  "name" VARCHAR,
  "image" VARCHAR,
  "current_price" DOUBLE,
  "market_cap" BIGINT,
  "market_cap_rank" BIGINT,
  "fully_diluted_valuation" DOUBLE,
  "total_volume" DOUBLE,
  "high_24h" DOUBLE,
  "low_24h" DOUBLE,
  "price_change_24h" DOUBLE,
  "price_change_percentage_24h" DOUBLE,
  "market_cap_change_24h" DOUBLE,
  "market_cap_change_percentage_24h" DOUBLE,
  "circulating_supply" DOUBLE,
  "total_supply" DOUBLE,
  "max_supply" DOUBLE,
  "ath" DOUBLE,
  "ath_change_percentage" DOUBLE,
  "ath_date" VARCHAR,
  "atl" DOUBLE,
  "atl_change_percentage" DOUBLE,
  "atl_date" VARCHAR,
  "roi" VARCHAR,
  "last_updated" VARCHAR
);