PREVIEW / stock_1hour / 2011-04-12

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-12.parquet
  size:    934 KB
  rows:    44,034
  symbols: 3,537

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
2011-04-12 04:00:00	AAPL	Stock	11.7679	11.7764	11.7368	11.7396	25200.0
2011-04-12 05:00:00	AAPL	Stock	11.7364	11.75	11.7321	11.7321	30240.0
2011-04-12 06:00:00	AAPL	Stock	11.7461	11.75	11.7321	11.7393	59612.0
2011-04-12 07:00:00	AAPL	Stock	11.7332	11.7679	11.6961	11.725	1000496.0
2011-04-12 08:00:00	AAPL	Stock	11.73	11.8593	11.725	11.8482	4364332.0
2011-04-12 09:00:00	AAPL	Stock	11.8475	11.9189	11.7929	11.8536	99728916.0
2011-04-12 10:00:00	AAPL	Stock	11.8536	11.8946	11.8211	11.8514	81985260.0
2011-04-12 11:00:00	AAPL	Stock	11.8529	11.8607	11.7936	11.8214	58162860.0
2011-04-12 12:00:00	AAPL	Stock	11.8211	11.8714	11.7989	11.8489	34070708.0
2011-04-12 13:00:00	AAPL	Stock	11.8489	11.8743	11.8161	11.865	35938364.0
2011-04-12 14:00:00	AAPL	Stock	11.8646	11.8854	11.8357	11.8486	33837944.0
2011-04-12 15:00:00	AAPL	Stock	11.8471	11.8771	11.8357	11.8714	57516228.0
2011-04-12 16:00:00	AAPL	Stock	11.8686	11.8786	11.7945	11.8736	10502940.0
2011-04-12 17:00:00	AAPL	Stock	11.8743	11.8907	11.8714	11.8904	734636.0
2011-04-12 18:00:00	AAPL	Stock	11.89	11.9089	11.8714	11.8996	854812.0
2011-04-12 19:00:00	AAPL	Stock	11.9011	11.9082	11.8889	11.9082	319116.0
2011-04-12 05:00:00	MSFT	Stock	25.98	25.98	25.98	25.98	100.0
2011-04-12 07:00:00	MSFT	Stock	25.81	25.85	25.81	25.81	4050.0
2011-04-12 08:00:00	MSFT	Stock	25.88	25.9	25.83	25.87	29830.0
2011-04-12 09:00:00	MSFT	Stock	25.88	25.91	25.71	25.802	5092015.0
2011-04-12 10:00:00	MSFT	Stock	25.802	25.82	25.66	25.66	5169296.0
2011-04-12 11:00:00	MSFT	Stock	25.66	25.69	25.61	25.67	3998147.0
2011-04-12 12:00:00	MSFT	Stock	25.677	25.73	25.65	25.72	3182772.0
2011-04-12 13:00:00	MSFT	Stock	25.722	25.78	25.68	25.73	2996674.0
2011-04-12 14:00:00	MSFT	Stock	25.738	25.75	25.62	25.64	4538128.0
2011-04-12 15:00:00	MSFT	Stock	25.65	25.67	25.55	25.642	9112441.0
2011-04-12 16:00:00	MSFT	Stock	25.64	25.697	25.562	25.604	2623687.0
2011-04-12 17:00:00	MSFT	Stock	25.65	25.68	25.64	25.68	103078.0
2011-04-12 18:00:00	MSFT	Stock	25.64	25.68	25.64	25.65	15607.0
2011-04-12 19:00:00	MSFT	Stock	25.65	25.65	25.65	25.65	1009.0
2011-04-12 08:00:00	NVDA	Stock	0.4275	0.4308	0.427	0.4272	109600.0
2011-04-12 09:00:00	NVDA	Stock	0.43	0.43	0.4213	0.4226	110342640.0
2011-04-12 10:00:00	NVDA	Stock	0.4228	0.4248	0.4208	0.4224	130471680.0
2011-04-12 11:00:00	NVDA	Stock	0.4222	0.4305	0.4218	0.4288	124194600.0
2011-04-12 12:00:00	NVDA	Stock	0.4288	0.4338	0.4278	0.4332	99104520.0
2011-04-12 13:00:00	NVDA	Stock	0.4332	0.4365	0.433	0.4348	128345120.0
2011-04-12 14:00:00	NVDA	Stock	0.4345	0.4372	0.4345	0.4362	84108960.0
2011-04-12 15:00:00	NVDA	Stock	0.4361	0.4365	0.4322	0.4342	151607080.0
2011-04-12 16:00:00	NVDA	Stock	0.4355	0.4355	0.4245	0.4335	4524880.0
2011-04-12 17:00:00	NVDA	Stock	0.435	0.4372	0.435	0.4365	425200.0
2011-04-12 18:00:00	NVDA	Stock	0.4372	0.4372	0.4362	0.4368	454280.0
2011-04-12 19:00:00	NVDA	Stock	0.437	0.4375	0.437	0.4375	47480.0
2011-04-12 07:00:00	AMZN	Stock	9.1505	9.1505	9.1425	9.15	18000.0
2011-04-12 08:00:00	AMZN	Stock	9.16	9.1835	9.1455	9.1655	102200.0
2011-04-12 09:00:00	AMZN	Stock	9.175	9.2295	9.145	9.1575	16607380.0
2011-04-12 10:00:00	AMZN	Stock	9.158	9.197	9.136	9.1525	16723840.0
2011-04-12 11:00:00	AMZN	Stock	9.1525	9.166	9.126	9.137	8817760.0
2011-04-12 12:00:00	AMZN	Stock	9.134	9.141	9.0795	9.084	9005300.0
2011-04-12 13:00:00	AMZN	Stock	9.08	9.0985	9.0455	9.0685	12159720.0
2011-04-12 14:00:00	AMZN	Stock	9.0695	9.0815	9.009	9.0175	15630520.0

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

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