In light of the exorbitant pricing tiers for the new pro api and in addition to them taking down both v1 and v2 free apis. The highest tier provides 5 years of historical data. this tier has a "inquire for pricing". the tier below is 699usd a month... and only provides 1 years of historical data. i.e. https://ift.tt/2L2CbmI thought this was highly unfair, decided i would get the data and share it freely to everyone. id prefer not to go into detail about how i got it, they might take it down.I have all price data, of all cryptocurrencies listed on cmcfrom: 2013-04-28to: 2018-08-04.link to download:https://ift.tt/2vS93tN using sql server, so i tried to provide a db agnostic as possible way to share this data, so i dumped it into a csv file. this is the table structure. Table name is CmcHistoricalPriceDataIdCoinIdSymbolDateOpenHighLowCloseVolumeMarketCap8355611BTC2013-04-28135.3135.979132.1134.2101500519936The CoinId looks odd, but its used as a foreign key to other tables im using, mainly the coins provided via the free v2 api https://ift.tt/2L2UDM7. full api here https://ift.tt/2vSY8jk Id field is just a primary key that increments by one for each new listing. i added non clustered index for faster retrieval, but eh, surprisingly it only ended up being 835561 rows. so not really any needed, the index uses the coinid and date.i did some spot checks on https://ift.tt/1VC8V82, looks to be accurate.this data is useful for back testing, and general market analysis, if you use the R programming language you can do some interesting stuff with this data.As for their highest pricing tier with 5 years of historical data, there might be a richer data set, but i think the data provided in my table is enough to do most analysis. the only other data that would be useful would be exchange data, looking for arbitrage opportunities etc.Only disappointing aspect of this data is that it doesnt go back past 2013, not sure how to go about getting that data.Hope you guys like it.edit: If anyone who knows R can quickly show me how to build a set of the % difference of marketcap changes between the peak of mcap and the bottom historically, id really appreciate that, hope that question makes sense.another edit: here is the table, the types are not correct e.g. decimal, but it does the job. just run it if ur using sql server, or u can prob run it thru an online converter for ur db of choice. if you can suggest a better decimal type for this kinda data id like that too.sql table script:/****** Object: Table [dbo].[CmcHistoricalPriceData] Script Date: 2018-08-18 1:24:11 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CmcHistoricalPriceData]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [CoinId] [bigint] NOT NULL, [Symbol] [nvarchar](50) NOT NULL, [Date] [datetime] NOT NULL, [Open] [decimal](30, 12) NULL, [High] [decimal](30, 12) NULL, [Low] [decimal](30, 12) NULL, [Close] [decimal](30, 12) NULL, [Volume] [decimal](30, 12) NULL, [MarketCap] [bigint] NULL, CONSTRAINT [PK_CmcHistoricalPriceData] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_CmcHistoricalPriceData] UNIQUE NONCLUSTERED ( [CoinId] ASC, [Date] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CmcHistoricalPriceData] WITH CHECK ADD CONSTRAINT [FK_CmcHistoricalPriceData_CmcCoinListing] FOREIGN KEY([CoinId]) REFERENCES [dbo].[CmcCoinListing] ([CoinId]) GO ALTER TABLE [dbo].[CmcHistoricalPriceData] CHECK CONSTRAINT [FK_CmcHistoricalPriceData_CmcCoinListing] GO
Submitted August 18, 2018 at 10:18AM
No comments:
Post a Comment