PREVIEW / stock_1hour / 2011-05-18

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-18.parquet
  size:    946 KB
  rows:    45,236
  symbols: 3,559

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-05-18 04:00:00	AAPL	Stock	12.0714	12.0714	12.0714	12.0714	2800.0
2011-05-18 07:00:00	AAPL	Stock	12.0404	12.0404	11.9893	11.9911	278684.0
2011-05-18 08:00:00	AAPL	Stock	12.0	12.0071	11.9714	11.9979	871304.0
2011-05-18 09:00:00	AAPL	Stock	11.9968	12.0857	11.9946	12.0743	65163756.0
2011-05-18 10:00:00	AAPL	Stock	12.0746	12.1411	12.0657	12.1336	73876992.0
2011-05-18 11:00:00	AAPL	Stock	12.1339	12.1495	12.1061	12.1196	47615820.0
2011-05-18 12:00:00	AAPL	Stock	12.1204	12.1429	12.1111	12.1357	21934360.0
2011-05-18 13:00:00	AAPL	Stock	12.1371	12.1768	12.1304	12.1632	28798756.0
2011-05-18 14:00:00	AAPL	Stock	12.1621	12.1804	12.1254	12.14	37640764.0
2011-05-18 15:00:00	AAPL	Stock	12.1404	12.16	12.1329	12.135	48817608.0
2011-05-18 16:00:00	AAPL	Stock	12.1357	12.1556	12.005	12.1479	7279160.0
2011-05-18 17:00:00	AAPL	Stock	12.1432	12.1464	12.1429	12.1457	39256.0
2011-05-18 18:00:00	AAPL	Stock	12.1471	12.1521	12.1382	12.1521	213892.0
2011-05-18 19:00:00	AAPL	Stock	12.1536	12.1679	12.1536	12.1607	497476.0
2011-05-18 06:00:00	MSFT	Stock	24.64	24.64	24.59	24.59	650.0
2011-05-18 07:00:00	MSFT	Stock	24.6	24.6	24.57	24.59	17570.0
2011-05-18 08:00:00	MSFT	Stock	24.6	24.6	24.56	24.57	8359.0
2011-05-18 09:00:00	MSFT	Stock	24.58	24.6	24.3	24.32	6085602.0
2011-05-18 10:00:00	MSFT	Stock	24.31	24.49	24.25	24.45	11901882.0
2011-05-18 11:00:00	MSFT	Stock	24.45	24.62	24.44	24.57	6927162.0
2011-05-18 12:00:00	MSFT	Stock	24.57	24.6	24.47	24.49	6932958.0
2011-05-18 13:00:00	MSFT	Stock	24.49	24.68	24.48	24.63	3570648.0
2011-05-18 14:00:00	MSFT	Stock	24.635	24.74	24.58	24.629	6455661.0
2011-05-18 15:00:00	MSFT	Stock	24.63	24.72	24.605	24.69	8431100.0
2011-05-18 16:00:00	MSFT	Stock	24.7	24.716	24.52	24.67	2794699.0
2011-05-18 17:00:00	MSFT	Stock	24.68	24.69	24.67	24.69	3400.0
2011-05-18 18:00:00	MSFT	Stock	24.68	24.69	24.68	24.69	7600.0
2011-05-18 19:00:00	MSFT	Stock	24.69	24.7	24.69	24.7	4250.0
2011-05-18 07:00:00	NVDA	Stock	0.4462	0.447	0.441	0.441	129840.0
2011-05-18 08:00:00	NVDA	Stock	0.4355	0.441	0.4355	0.4378	417200.0
2011-05-18 09:00:00	NVDA	Stock	0.44	0.451	0.44	0.4445	111804560.0
2011-05-18 10:00:00	NVDA	Stock	0.4444	0.4518	0.4432	0.4502	129941440.0
2011-05-18 11:00:00	NVDA	Stock	0.4502	0.4518	0.447	0.4482	90249880.0
2011-05-18 12:00:00	NVDA	Stock	0.4485	0.4492	0.4465	0.4475	39219880.0
2011-05-18 13:00:00	NVDA	Stock	0.4475	0.4535	0.4474	0.453	62535400.0
2011-05-18 14:00:00	NVDA	Stock	0.453	0.4548	0.451	0.4518	76034840.0
2011-05-18 15:00:00	NVDA	Stock	0.4519	0.4546	0.4508	0.4508	137881400.0
2011-05-18 16:00:00	NVDA	Stock	0.4508	0.4522	0.4497	0.4511	2537520.0
2011-05-18 17:00:00	NVDA	Stock	0.4518	0.4538	0.4518	0.4538	646480.0
2011-05-18 18:00:00	NVDA	Stock	0.4525	0.4525	0.45	0.45	180000.0
2011-05-18 19:00:00	NVDA	Stock	0.4522	0.4522	0.4518	0.4518	24000.0
2011-05-18 07:00:00	AMZN	Stock	9.7255	9.7255	9.7255	9.7255	20000.0
2011-05-18 08:00:00	AMZN	Stock	9.727	9.7915	9.7005	9.741	100800.0
2011-05-18 09:00:00	AMZN	Stock	9.733	9.768	9.6625	9.6715	14736940.0
2011-05-18 10:00:00	AMZN	Stock	9.6725	9.805	9.6695	9.7893	17037200.0
2011-05-18 11:00:00	AMZN	Stock	9.79	9.8195	9.78	9.781	7586240.0
2011-05-18 12:00:00	AMZN	Stock	9.783	9.858	9.771	9.832	8422240.0
2011-05-18 13:00:00	AMZN	Stock	9.831	9.866	9.8126	9.855	8403000.0
2011-05-18 14:00:00	AMZN	Stock	9.855	9.9142	9.8375	9.8953	18992880.0
2011-05-18 15:00:00	AMZN	Stock	9.8935	9.9	9.849	9.854	20383480.0

> showing 50 of 45,236 rows — these rows as CSV

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