PREVIEW / stock_1hour / 2015-06-04

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-04.parquet
  size:    1.0 MB
  rows:    48,619
  symbols: 3,493

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
2015-06-04 04:00:00	AAPL	Stock	32.515	32.515	32.27	32.325	73320.0
2015-06-04 05:00:00	AAPL	Stock	32.325	32.355	32.3	32.355	38992.0
2015-06-04 06:00:00	AAPL	Stock	32.3375	32.365	32.2875	32.3125	27528.0
2015-06-04 07:00:00	AAPL	Stock	32.355	32.415	32.345	32.3925	99488.0
2015-06-04 08:00:00	AAPL	Stock	32.395	32.4725	32.3325	32.4175	860372.0
2015-06-04 09:00:00	AAPL	Stock	32.4102	32.6125	32.3375	32.565	22356776.0
2015-06-04 10:00:00	AAPL	Stock	32.5625	32.645	32.4522	32.46	21652136.0
2015-06-04 11:00:00	AAPL	Stock	32.46	32.5025	32.385	32.405	17110592.0
2015-06-04 12:00:00	AAPL	Stock	32.4062	32.4725	32.3825	32.4182	10000672.0
2015-06-04 13:00:00	AAPL	Stock	32.4175	32.42	32.2925	32.31	20256016.0
2015-06-04 14:00:00	AAPL	Stock	32.3075	32.3525	32.2275	32.3	19312944.0
2015-06-04 15:00:00	AAPL	Stock	32.2975	32.3725	32.2675	32.365	26521204.0
2015-06-04 16:00:00	AAPL	Stock	32.34	32.4405	32.3375	32.355	7211040.0
2015-06-04 17:00:00	AAPL	Stock	32.3625	32.37	32.3375	32.3425	158068.0
2015-06-04 18:00:00	AAPL	Stock	32.3425	32.355	32.3375	32.35	96692.0
2015-06-04 19:00:00	AAPL	Stock	32.3525	32.355	32.335	32.335	111452.0
2015-06-04 04:00:00	MSFT	Stock	46.71	46.71	46.6	46.6	329.0
2015-06-04 05:00:00	MSFT	Stock	46.54	46.54	46.54	46.54	300.0
2015-06-04 06:00:00	MSFT	Stock	46.52	46.52	46.5	46.5	2985.0
2015-06-04 07:00:00	MSFT	Stock	46.53	46.61	46.5	46.55	12925.0
2015-06-04 08:00:00	MSFT	Stock	46.66	46.69	46.54	46.64	30517.0
2015-06-04 09:00:00	MSFT	Stock	46.6	47.08	46.5	47.015	3298443.0
2015-06-04 10:00:00	MSFT	Stock	47.015	47.16	46.71	46.736	2917613.0
2015-06-04 11:00:00	MSFT	Stock	46.74	46.82	46.44	46.54	3602441.0
2015-06-04 12:00:00	MSFT	Stock	46.53	46.61	46.48	46.5	2162113.0
2015-06-04 13:00:00	MSFT	Stock	46.5	46.5	46.28	46.33	3109209.0
2015-06-04 14:00:00	MSFT	Stock	46.335	46.54	46.29	46.404	2710001.0
2015-06-04 15:00:00	MSFT	Stock	46.406	46.46	46.2	46.39	5640421.0
2015-06-04 16:00:00	MSFT	Stock	46.36	46.565	46.36	46.49	2229718.0
2015-06-04 17:00:00	MSFT	Stock	46.449	46.449	46.4	46.44	950.0
2015-06-04 18:00:00	MSFT	Stock	46.48	46.48	46.44	46.44	300.0
2015-06-04 19:00:00	MSFT	Stock	46.45	46.46	46.4	46.45	1904.0
2015-06-04 09:00:00	NVDA	Stock	0.543	0.549	0.5392	0.5478	30441160.0
2015-06-04 10:00:00	NVDA	Stock	0.5478	0.551	0.5475	0.5503	32650800.0
2015-06-04 11:00:00	NVDA	Stock	0.5502	0.554	0.5485	0.553	55090600.0
2015-06-04 12:00:00	NVDA	Stock	0.5528	0.554	0.5525	0.5528	39533000.0
2015-06-04 13:00:00	NVDA	Stock	0.5528	0.553	0.5498	0.55	36753680.0
2015-06-04 14:00:00	NVDA	Stock	0.55	0.5512	0.5492	0.5511	20475280.0
2015-06-04 15:00:00	NVDA	Stock	0.551	0.5525	0.5498	0.5522	81677360.0
2015-06-04 16:00:00	NVDA	Stock	0.5522	0.5545	0.5503	0.5545	3188040.0
2015-06-04 17:00:00	NVDA	Stock	0.5525	0.5525	0.5525	0.5525	56000.0
2015-06-04 18:00:00	NVDA	Stock	0.555	0.555	0.555	0.555	18000.0
2015-06-04 06:00:00	AMZN	Stock	21.725	21.725	21.6875	21.715	6040.0
2015-06-04 07:00:00	AMZN	Stock	21.7	21.7415	21.7	21.7415	42120.0
2015-06-04 08:00:00	AMZN	Stock	21.7465	21.76	21.73	21.735	84300.0
2015-06-04 09:00:00	AMZN	Stock	21.735	21.8378	21.7095	21.75	8407040.0
2015-06-04 10:00:00	AMZN	Stock	21.7425	21.8095	21.641	21.6615	8466200.0
2015-06-04 11:00:00	AMZN	Stock	21.655	21.667	21.578	21.624	6637540.0
2015-06-04 12:00:00	AMZN	Stock	21.6225	21.6345	21.582	21.597	3504020.0
2015-06-04 13:00:00	AMZN	Stock	21.59	21.605	21.4855	21.508	6305540.0

> showing 50 of 48,619 rows — these rows as CSV

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