PREVIEW / stock_1hour / 2014-04-08

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-08.parquet
  size:    1.0 MB
  rows:    47,799
  symbols: 3,555

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
2014-04-08 04:00:00	AAPL	Stock	18.7725	18.7839	18.7725	18.7839	19600.0
2014-04-08 05:00:00	AAPL	Stock	18.7557	18.7557	18.7161	18.7161	29316.0
2014-04-08 06:00:00	AAPL	Stock	18.71	18.71	18.6964	18.6964	5600.0
2014-04-08 07:00:00	AAPL	Stock	18.6986	18.7036	18.6857	18.7036	26292.0
2014-04-08 08:00:00	AAPL	Stock	18.6986	18.815	18.6986	18.8007	863324.0
2014-04-08 09:00:00	AAPL	Stock	18.7982	18.8029	18.525	18.5646	41687156.0
2014-04-08 10:00:00	AAPL	Stock	18.5711	18.7807	18.565	18.7454	48014344.0
2014-04-08 11:00:00	AAPL	Stock	18.7461	18.7739	18.6554	18.6894	24045868.0
2014-04-08 12:00:00	AAPL	Stock	18.6921	18.7257	18.644	18.6521	11879784.0
2014-04-08 13:00:00	AAPL	Stock	18.6532	18.6943	18.6164	18.6614	15994552.0
2014-04-08 14:00:00	AAPL	Stock	18.6614	18.69	18.6107	18.6896	12486600.0
2014-04-08 15:00:00	AAPL	Stock	18.6904	18.7421	18.6554	18.6939	27430228.0
2014-04-08 16:00:00	AAPL	Stock	18.7	18.725	18.5427	18.698	17532536.0
2014-04-08 17:00:00	AAPL	Stock	18.6943	18.6964	18.6839	18.6839	221620.0
2014-04-08 18:00:00	AAPL	Stock	18.6914	18.7004	18.6857	18.7	235004.0
2014-04-08 19:00:00	AAPL	Stock	18.705	18.705	18.6964	18.6964	72912.0
2014-04-08 06:00:00	MSFT	Stock	39.63	39.63	39.58	39.58	444.0
2014-04-08 07:00:00	MSFT	Stock	39.66	39.7	39.65	39.65	825.0
2014-04-08 08:00:00	MSFT	Stock	39.7	39.92	39.7	39.85	3639.0
2014-04-08 09:00:00	MSFT	Stock	39.86	39.93	39.43	39.49	5227740.0
2014-04-08 10:00:00	MSFT	Stock	39.49	39.77	39.2	39.736	8427162.0
2014-04-08 11:00:00	MSFT	Stock	39.74	39.86	39.654	39.675	4630211.0
2014-04-08 12:00:00	MSFT	Stock	39.67	39.88	39.665	39.8	3219969.0
2014-04-08 13:00:00	MSFT	Stock	39.799	39.91	39.79	39.84	2608459.0
2014-04-08 14:00:00	MSFT	Stock	39.84	39.85	39.65	39.758	2680166.0
2014-04-08 15:00:00	MSFT	Stock	39.75	39.9	39.71	39.82	5290994.0
2014-04-08 16:00:00	MSFT	Stock	39.82	39.83	39.457	39.828	2240603.0
2014-04-08 17:00:00	MSFT	Stock	39.82	39.82	39.82	39.82	3600.0
2014-04-08 18:00:00	MSFT	Stock	39.8	39.82	39.8	39.82	600.0
2014-04-08 19:00:00	MSFT	Stock	39.82	39.82	39.82	39.82	239.0
2014-04-08 09:00:00	NVDA	Stock	0.4552	0.4659	0.4545	0.4648	57824120.0
2014-04-08 10:00:00	NVDA	Stock	0.4645	0.4698	0.4625	0.4688	96619760.0
2014-04-08 11:00:00	NVDA	Stock	0.4685	0.4692	0.467	0.469	49975720.0
2014-04-08 12:00:00	NVDA	Stock	0.469	0.4723	0.4688	0.4713	36812520.0
2014-04-08 13:00:00	NVDA	Stock	0.4714	0.4728	0.4708	0.4723	52145240.0
2014-04-08 14:00:00	NVDA	Stock	0.4723	0.4728	0.4692	0.47	46636600.0
2014-04-08 15:00:00	NVDA	Stock	0.4699	0.4723	0.469	0.4715	92247320.0
2014-04-08 16:00:00	NVDA	Stock	0.4715	0.4719	0.4708	0.4716	1347840.0
2014-04-08 17:00:00	NVDA	Stock	0.4718	0.4718	0.4713	0.4713	72000.0
2014-04-08 18:00:00	NVDA	Stock	0.4715	0.4715	0.4715	0.4715	710520.0
2014-04-08 06:00:00	AMZN	Stock	15.8735	15.8735	15.8735	15.8735	4800.0
2014-04-08 07:00:00	AMZN	Stock	15.8695	15.874	15.8695	15.874	6720.0
2014-04-08 08:00:00	AMZN	Stock	15.874	16.186	15.874	16.1375	885300.0
2014-04-08 09:00:00	AMZN	Stock	16.1495	16.2065	15.922	16.1357	25218620.0
2014-04-08 10:00:00	AMZN	Stock	16.128	16.336	16.001	16.272	27211040.0
2014-04-08 11:00:00	AMZN	Stock	16.2595	16.4	16.226	16.2945	17427740.0
2014-04-08 12:00:00	AMZN	Stock	16.2945	16.385	16.2545	16.3346	8932940.0
2014-04-08 13:00:00	AMZN	Stock	16.3385	16.3825	16.2336	16.3665	8633180.0
2014-04-08 14:00:00	AMZN	Stock	16.363	16.38	16.232	16.287	10186740.0
2014-04-08 15:00:00	AMZN	Stock	16.29	16.384	16.284	16.368	18534360.0

> showing 50 of 47,799 rows — these rows as CSV

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