PREVIEW / stock_1hour / 2012-07-17

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-17.parquet
  size:    918 KB
  rows:    43,537
  symbols: 3,490

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
2012-07-17 04:00:00	AAPL	Stock	21.7682	21.8029	21.7682	21.8	8400.0
2012-07-17 05:00:00	AAPL	Stock	21.8	21.8	21.8	21.8	2800.0
2012-07-17 06:00:00	AAPL	Stock	21.7964	21.8036	21.7857	21.7911	34300.0
2012-07-17 07:00:00	AAPL	Stock	21.7718	21.8036	21.7525	21.8036	454384.0
2012-07-17 08:00:00	AAPL	Stock	21.7979	21.8343	21.7575	21.8279	2188340.0
2012-07-17 09:00:00	AAPL	Stock	21.8268	21.8393	21.6989	21.7404	48056092.0
2012-07-17 10:00:00	AAPL	Stock	21.7396	21.7396	21.5411	21.595	68532016.0
2012-07-17 11:00:00	AAPL	Stock	21.59	21.7414	21.5864	21.74	37423260.0
2012-07-17 12:00:00	AAPL	Stock	21.7336	21.7789	21.7018	21.7071	29251964.0
2012-07-17 13:00:00	AAPL	Stock	21.7071	21.7725	21.6829	21.6889	26006400.0
2012-07-17 14:00:00	AAPL	Stock	21.6857	21.7571	21.6821	21.7172	23056012.0
2012-07-17 15:00:00	AAPL	Stock	21.7132	21.7261	21.6132	21.6754	51263660.0
2012-07-17 16:00:00	AAPL	Stock	21.6746	21.7054	21.6457	21.6839	5238352.0
2012-07-17 17:00:00	AAPL	Stock	21.6839	21.6875	21.6764	21.6868	117572.0
2012-07-17 18:00:00	AAPL	Stock	21.6843	21.6857	21.6796	21.6821	43260.0
2012-07-17 19:00:00	AAPL	Stock	21.6825	21.6929	21.6821	21.6929	156352.0
2012-07-17 07:00:00	MSFT	Stock	29.5	29.5	29.5	29.5	200.0
2012-07-17 08:00:00	MSFT	Stock	29.5	29.61	29.5	29.59	23295.0
2012-07-17 09:00:00	MSFT	Stock	29.6	29.86	29.44	29.63	2590799.0
2012-07-17 10:00:00	MSFT	Stock	29.63	29.63	29.2	29.215	7026550.0
2012-07-17 11:00:00	MSFT	Stock	29.225	29.38	29.2	29.33	4789809.0
2012-07-17 12:00:00	MSFT	Stock	29.33	29.68	29.33	29.54	4027780.0
2012-07-17 13:00:00	MSFT	Stock	29.54	29.68	29.52	29.565	2615558.0
2012-07-17 14:00:00	MSFT	Stock	29.56	29.74	29.55	29.71	3669643.0
2012-07-17 15:00:00	MSFT	Stock	29.705	29.72	29.53	29.66	6735582.0
2012-07-17 16:00:00	MSFT	Stock	29.66	29.8	29.321	29.71	1448216.0
2012-07-17 17:00:00	MSFT	Stock	29.72	29.74	29.66	29.74	9703.0
2012-07-17 18:00:00	MSFT	Stock	29.73	29.73	29.68	29.7	11650.0
2012-07-17 19:00:00	MSFT	Stock	29.71	29.71	29.71	29.71	500.0
2012-07-17 07:00:00	NVDA	Stock	0.3193	0.3193	0.3193	0.3193	16000.0
2012-07-17 08:00:00	NVDA	Stock	0.3175	0.3188	0.3163	0.3163	104000.0
2012-07-17 09:00:00	NVDA	Stock	0.3163	0.3178	0.3083	0.31	48015640.0
2012-07-17 10:00:00	NVDA	Stock	0.3098	0.3098	0.304	0.305	71460680.0
2012-07-17 11:00:00	NVDA	Stock	0.3052	0.3068	0.3045	0.3062	89794640.0
2012-07-17 12:00:00	NVDA	Stock	0.3062	0.3068	0.3051	0.3055	61768080.0
2012-07-17 13:00:00	NVDA	Stock	0.3055	0.3068	0.3045	0.3062	44014080.0
2012-07-17 14:00:00	NVDA	Stock	0.306	0.311	0.3059	0.3105	55467560.0
2012-07-17 15:00:00	NVDA	Stock	0.3105	0.3105	0.3073	0.3091	68242160.0
2012-07-17 16:00:00	NVDA	Stock	0.309	0.3113	0.3075	0.3095	2093440.0
2012-07-17 17:00:00	NVDA	Stock	0.3095	0.3095	0.3093	0.3093	1133640.0
2012-07-17 18:00:00	NVDA	Stock	0.3105	0.3105	0.3105	0.3105	47200.0
2012-07-17 19:00:00	NVDA	Stock	0.3088	0.3088	0.3088	0.3088	4000.0
2012-07-17 08:00:00	AMZN	Stock	10.813	10.8825	10.7995	10.85	130040.0
2012-07-17 09:00:00	AMZN	Stock	10.7995	10.895	10.7651	10.828	6607160.0
2012-07-17 10:00:00	AMZN	Stock	10.819	10.8375	10.698	10.726	7725540.0
2012-07-17 11:00:00	AMZN	Stock	10.734	10.831	10.7235	10.83	4474900.0
2012-07-17 12:00:00	AMZN	Stock	10.8245	10.8845	10.82	10.82	4015120.0
2012-07-17 13:00:00	AMZN	Stock	10.82	10.897	10.82	10.853	4338460.0
2012-07-17 14:00:00	AMZN	Stock	10.8564	10.883	10.847	10.8586	3247980.0
2012-07-17 15:00:00	AMZN	Stock	10.8585	10.8675	10.812	10.846	7981020.0

> showing 50 of 43,537 rows — these rows as CSV

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