PREVIEW / stock_1hour / 2018-05-10

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-10.parquet
  size:    1.1 MB
  rows:    49,188
  symbols: 2,842

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2018-05-10 04:00:00	AAPL	Stock	46.86	46.86	46.84	46.84	27600.0
2018-05-10 05:00:00	AAPL	Stock	46.805	46.805	46.8	46.8	7600.0
2018-05-10 06:00:00	AAPL	Stock	46.805	46.805	46.8	46.8	4400.0
2018-05-10 07:00:00	AAPL	Stock	46.8325	46.875	46.8075	46.865	109084.0
2018-05-10 08:00:00	AAPL	Stock	46.8625	46.9675	46.8	46.9625	459676.0
2018-05-10 09:00:00	AAPL	Stock	46.9425	47.14	46.9	47.0	14064588.0
2018-05-10 10:00:00	AAPL	Stock	47.0	47.1775	46.9362	47.1675	13758604.0
2018-05-10 11:00:00	AAPL	Stock	47.165	47.4625	47.1488	47.4427	15668032.0
2018-05-10 12:00:00	AAPL	Stock	47.445	47.5	47.3602	47.46	10872320.0
2018-05-10 13:00:00	AAPL	Stock	47.46	47.5925	47.42	47.4712	13478268.0
2018-05-10 14:00:00	AAPL	Stock	47.4725	47.5475	47.3675	47.4925	8157016.0
2018-05-10 15:00:00	AAPL	Stock	47.4948	47.5675	47.4275	47.5075	17869896.0
2018-05-10 16:00:00	AAPL	Stock	47.5075	47.52	47.3825	47.3975	4780576.0
2018-05-10 17:00:00	AAPL	Stock	47.405	47.45	47.405	47.435	81800.0
2018-05-10 18:00:00	AAPL	Stock	47.4375	47.485	47.4375	47.475	45712.0
2018-05-10 19:00:00	AAPL	Stock	47.475	47.5	47.45	47.4625	79124.0
2018-05-10 04:00:00	MSFT	Stock	97.0	97.0	97.0	97.0	187.0
2018-05-10 06:00:00	MSFT	Stock	97.06	97.06	97.05	97.05	300.0
2018-05-10 07:00:00	MSFT	Stock	97.0	97.06	97.0	97.06	2499.0
2018-05-10 08:00:00	MSFT	Stock	97.0	97.24	96.94	97.15	13178.0
2018-05-10 09:00:00	MSFT	Stock	97.11	97.58	97.09	97.24	2146337.0
2018-05-10 10:00:00	MSFT	Stock	97.25	97.78	97.07	97.62	2214523.0
2018-05-10 11:00:00	MSFT	Stock	97.615	97.84	97.54	97.58	1551760.0
2018-05-10 12:00:00	MSFT	Stock	97.586	97.87	97.48	97.67	1643936.0
2018-05-10 13:00:00	MSFT	Stock	97.68	97.8	97.23	97.35	1752314.0
2018-05-10 14:00:00	MSFT	Stock	97.35	97.55	97.05	97.53	2345809.0
2018-05-10 15:00:00	MSFT	Stock	97.53	97.95	97.37	97.9	3289164.0
2018-05-10 16:00:00	MSFT	Stock	97.9	97.92	97.66	97.75	5859981.0
2018-05-10 17:00:00	MSFT	Stock	97.75	97.85	97.75	97.77	2092.0
2018-05-10 18:00:00	MSFT	Stock	97.76	97.79	97.74	97.75	2889.0
2018-05-10 19:00:00	MSFT	Stock	97.7	97.75	97.67	97.75	3936.0
2018-05-10 04:00:00	NVDA	Stock	6.425	6.4458	6.425	6.4373	99960.0
2018-05-10 05:00:00	NVDA	Stock	6.4375	6.4442	6.43	6.43	99480.0
2018-05-10 06:00:00	NVDA	Stock	6.4353	6.4362	6.425	6.425	42760.0
2018-05-10 07:00:00	NVDA	Stock	6.4275	6.4672	6.4275	6.46	3245000.0
2018-05-10 08:00:00	NVDA	Stock	6.4411	6.4688	6.4275	6.4552	7849240.0
2018-05-10 09:00:00	NVDA	Stock	6.4588	6.4983	6.4325	6.4642	126379560.0
2018-05-10 10:00:00	NVDA	Stock	6.463	6.475	6.439	6.4578	121099600.0
2018-05-10 11:00:00	NVDA	Stock	6.4578	6.4748	6.4528	6.4567	60142640.0
2018-05-10 12:00:00	NVDA	Stock	6.457	6.4662	6.43	6.4581	85256920.0
2018-05-10 13:00:00	NVDA	Stock	6.4585	6.473	6.4575	6.4597	58680000.0
2018-05-10 14:00:00	NVDA	Stock	6.4603	6.4798	6.45	6.4795	77621600.0
2018-05-10 15:00:00	NVDA	Stock	6.4782	6.5125	6.4685	6.506	179125880.0
2018-05-10 16:00:00	NVDA	Stock	6.5033	6.615	6.3	6.3895	120328960.0
2018-05-10 17:00:00	NVDA	Stock	6.3895	6.4	6.2568	6.3135	32036640.0
2018-05-10 18:00:00	NVDA	Stock	6.312	6.3225	6.2588	6.2875	13860000.0
2018-05-10 19:00:00	NVDA	Stock	6.2895	6.3225	6.2895	6.3138	5879040.0
2018-05-10 04:00:00	AMZN	Stock	80.55	80.55	80.55	80.55	2600.0
2018-05-10 05:00:00	AMZN	Stock	80.55	80.55	80.55	80.55	25840.0
2018-05-10 07:00:00	AMZN	Stock	80.45	80.6	80.3785	80.4	197060.0

> showing 50 of 49,188 rows — these rows as CSV

> unlock the full archive -- $79 one-time