PREVIEW / stock_1hour / 2012-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-20.parquet
  size:    941 KB
  rows:    44,647
  symbols: 3,515

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-04-20 04:00:00	AAPL	Stock	21.0	21.0614	21.0	21.0039	102060.0
2012-04-20 05:00:00	AAPL	Stock	20.9821	20.9821	20.9643	20.9821	33600.0
2012-04-20 06:00:00	AAPL	Stock	21.0189	21.0714	21.0189	21.0714	82320.0
2012-04-20 07:00:00	AAPL	Stock	21.0714	21.0718	20.9018	20.9361	1483692.0
2012-04-20 08:00:00	AAPL	Stock	20.9432	21.0711	20.9168	21.0536	5800900.0
2012-04-20 09:00:00	AAPL	Stock	21.0507	21.2186	20.79	21.2171	164790752.0
2012-04-20 10:00:00	AAPL	Stock	21.2207	21.2364	20.9379	20.9682	135653112.0
2012-04-20 11:00:00	AAPL	Stock	20.9679	20.9679	20.7664	20.8761	96730592.0
2012-04-20 12:00:00	AAPL	Stock	20.8761	20.9329	20.7371	20.74	85720656.0
2012-04-20 13:00:00	AAPL	Stock	20.7393	20.7804	20.575	20.6018	122430364.0
2012-04-20 14:00:00	AAPL	Stock	20.6032	20.6132	20.4504	20.4504	140177800.0
2012-04-20 15:00:00	AAPL	Stock	20.4532	20.5282	20.3721	20.443	213818360.0
2012-04-20 16:00:00	AAPL	Stock	20.4446	20.8059	20.4333	20.5389	21624036.0
2012-04-20 17:00:00	AAPL	Stock	20.5357	20.5371	20.4636	20.4886	1329748.0
2012-04-20 18:00:00	AAPL	Stock	20.4943	20.5	20.4679	20.4811	341152.0
2012-04-20 19:00:00	AAPL	Stock	20.4771	20.4986	20.4682	20.4714	372512.0
2012-04-20 06:00:00	MSFT	Stock	32.0	32.0	32.0	32.0	300.0
2012-04-20 07:00:00	MSFT	Stock	32.0	32.18	32.0	32.11	136280.0
2012-04-20 08:00:00	MSFT	Stock	32.11	32.17	31.92	32.03	319789.0
2012-04-20 09:00:00	MSFT	Stock	32.02	32.53	31.97	32.523	17791373.0
2012-04-20 10:00:00	MSFT	Stock	32.53	32.79	32.46	32.7	20850130.0
2012-04-20 11:00:00	MSFT	Stock	32.7	32.785	32.64	32.7	8737186.0
2012-04-20 12:00:00	MSFT	Stock	32.7	32.79	32.635	32.737	7252640.0
2012-04-20 13:00:00	MSFT	Stock	32.74	32.89	32.71	32.79	9943388.0
2012-04-20 14:00:00	MSFT	Stock	32.79	32.79	32.64	32.651	9403709.0
2012-04-20 15:00:00	MSFT	Stock	32.655	32.72	32.41	32.42	17444737.0
2012-04-20 16:00:00	MSFT	Stock	32.43	32.693	32.41	32.42	5450855.0
2012-04-20 17:00:00	MSFT	Stock	32.44	32.45	32.42	32.43	27738.0
2012-04-20 18:00:00	MSFT	Stock	32.43	32.47	32.43	32.43	3650.0
2012-04-20 19:00:00	MSFT	Stock	32.42	32.43	32.41	32.41	6200.0
2012-04-20 08:00:00	NVDA	Stock	0.3448	0.346	0.3445	0.346	53480.0
2012-04-20 09:00:00	NVDA	Stock	0.344	0.345	0.3388	0.3402	65899600.0
2012-04-20 10:00:00	NVDA	Stock	0.34	0.3402	0.337	0.338	84420000.0
2012-04-20 11:00:00	NVDA	Stock	0.338	0.3413	0.3379	0.3405	40696560.0
2012-04-20 12:00:00	NVDA	Stock	0.3404	0.3421	0.3402	0.3411	36454360.0
2012-04-20 13:00:00	NVDA	Stock	0.341	0.3415	0.3395	0.3396	40830400.0
2012-04-20 14:00:00	NVDA	Stock	0.3395	0.3398	0.3348	0.3348	87239400.0
2012-04-20 15:00:00	NVDA	Stock	0.3348	0.3355	0.334	0.3345	130624920.0
2012-04-20 16:00:00	NVDA	Stock	0.3348	0.3378	0.333	0.3348	20789400.0
2012-04-20 17:00:00	NVDA	Stock	0.3418	0.3418	0.3348	0.3348	216280.0
2012-04-20 18:00:00	NVDA	Stock	0.3353	0.3353	0.3353	0.3353	6000.0
2012-04-20 19:00:00	NVDA	Stock	0.335	0.335	0.3348	0.3348	39000.0
2012-04-20 08:00:00	AMZN	Stock	9.5815	9.6235	9.535	9.6075	217400.0
2012-04-20 09:00:00	AMZN	Stock	9.6075	9.6645	9.5775	9.6645	12175600.0
2012-04-20 10:00:00	AMZN	Stock	9.6655	9.674	9.583	9.6104	7619340.0
2012-04-20 11:00:00	AMZN	Stock	9.6099	9.6325	9.59	9.6025	7926040.0
2012-04-20 12:00:00	AMZN	Stock	9.602	9.6145	9.556	9.5613	3567560.0
2012-04-20 13:00:00	AMZN	Stock	9.56	9.571	9.505	9.5245	5383880.0
2012-04-20 14:00:00	AMZN	Stock	9.523	9.551	9.49	9.497	6432600.0
2012-04-20 15:00:00	AMZN	Stock	9.4997	9.517	9.4939	9.4995	13508200.0

> showing 50 of 44,647 rows — these rows as CSV

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