PREVIEW / stock_1hour / 2011-05-23

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-23.parquet
  size:    955 KB
  rows:    46,106
  symbols: 3,530

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-23 04:00:00	AAPL	Stock	11.8736	11.875	11.85	11.85	28140.0
2011-05-23 05:00:00	AAPL	Stock	11.85	11.8536	11.8393	11.8536	57960.0
2011-05-23 06:00:00	AAPL	Stock	11.8539	11.8679	11.8539	11.8607	38360.0
2011-05-23 07:00:00	AAPL	Stock	11.8679	11.8793	11.85	11.8571	380352.0
2011-05-23 08:00:00	AAPL	Stock	11.8579	11.8686	11.8214	11.8346	1879024.0
2011-05-23 09:00:00	AAPL	Stock	11.8329	11.8679	11.765	11.8264	81760924.0
2011-05-23 10:00:00	AAPL	Stock	11.8282	11.8832	11.8036	11.8479	63001428.0
2011-05-23 11:00:00	AAPL	Stock	11.8504	11.9032	11.8289	11.87	43875972.0
2011-05-23 12:00:00	AAPL	Stock	11.8694	11.91	11.8479	11.9075	35039844.0
2011-05-23 13:00:00	AAPL	Stock	11.9071	11.9196	11.875	11.9011	28841876.0
2011-05-23 14:00:00	AAPL	Stock	11.9007	11.9929	11.8964	11.9696	54371576.0
2011-05-23 15:00:00	AAPL	Stock	11.9696	11.9993	11.9179	11.9429	60803568.0
2011-05-23 16:00:00	AAPL	Stock	11.9432	11.9721	11.8344	11.9518	6989780.0
2011-05-23 17:00:00	AAPL	Stock	11.9464	11.9482	11.9464	11.9464	51800.0
2011-05-23 18:00:00	AAPL	Stock	11.9468	11.9468	11.9429	11.9464	90888.0
2011-05-23 19:00:00	AAPL	Stock	11.9446	11.9496	11.9439	11.9464	234276.0
2011-05-23 05:00:00	MSFT	Stock	24.38	24.38	24.38	24.38	200.0
2011-05-23 06:00:00	MSFT	Stock	24.25	24.25	24.25	24.25	100.0
2011-05-23 07:00:00	MSFT	Stock	24.37	24.37	24.26	24.29	1100.0
2011-05-23 08:00:00	MSFT	Stock	24.35	24.36	24.25	24.26	24729.0
2011-05-23 09:00:00	MSFT	Stock	24.25	24.3	24.03	24.19	6505336.0
2011-05-23 10:00:00	MSFT	Stock	24.195	24.25	24.13	24.19	7413303.0
2011-05-23 11:00:00	MSFT	Stock	24.19	24.21	24.09	24.125	5980043.0
2011-05-23 12:00:00	MSFT	Stock	24.125	24.15	24.07	24.14	4502747.0
2011-05-23 13:00:00	MSFT	Stock	24.14	24.18	24.09	24.18	5743423.0
2011-05-23 14:00:00	MSFT	Stock	24.175	24.205	24.15	24.15	5241329.0
2011-05-23 15:00:00	MSFT	Stock	24.16	24.22	24.12	24.17	11116879.0
2011-05-23 16:00:00	MSFT	Stock	24.16	24.2	24.13	24.19	4819607.0
2011-05-23 17:00:00	MSFT	Stock	24.2	24.21	24.17	24.17	48599.0
2011-05-23 18:00:00	MSFT	Stock	24.17	24.18	24.14	24.14	42288.0
2011-05-23 19:00:00	MSFT	Stock	24.14	24.15	24.13	24.14	3902.0
2011-05-23 08:00:00	NVDA	Stock	0.446	0.4472	0.442	0.442	375120.0
2011-05-23 09:00:00	NVDA	Stock	0.4425	0.4518	0.44	0.4515	75173720.0
2011-05-23 10:00:00	NVDA	Stock	0.4515	0.4532	0.447	0.4528	139731640.0
2011-05-23 11:00:00	NVDA	Stock	0.4528	0.455	0.4515	0.454	81125760.0
2011-05-23 12:00:00	NVDA	Stock	0.454	0.4544	0.4498	0.4528	67446920.0
2011-05-23 13:00:00	NVDA	Stock	0.4528	0.4532	0.4512	0.4528	35960720.0
2011-05-23 14:00:00	NVDA	Stock	0.4525	0.4545	0.452	0.4532	59272720.0
2011-05-23 15:00:00	NVDA	Stock	0.4531	0.4544	0.4508	0.452	108752920.0
2011-05-23 16:00:00	NVDA	Stock	0.4518	0.4538	0.4477	0.4518	5139160.0
2011-05-23 17:00:00	NVDA	Stock	0.4505	0.4508	0.4505	0.4508	8000.0
2011-05-23 18:00:00	NVDA	Stock	0.453	0.453	0.4518	0.4518	196000.0
2011-05-23 19:00:00	NVDA	Stock	0.4518	0.4518	0.4505	0.4505	16000.0
2011-05-23 04:00:00	AMZN	Stock	9.8915	9.8915	9.8915	9.8915	2000.0
2011-05-23 05:00:00	AMZN	Stock	9.7505	9.7505	9.75	9.75	6000.0
2011-05-23 06:00:00	AMZN	Stock	9.7875	9.7875	9.7875	9.7875	2000.0
2011-05-23 07:00:00	AMZN	Stock	9.755	9.802	9.755	9.8	32000.0
2011-05-23 08:00:00	AMZN	Stock	9.82	9.82	9.74	9.7535	341080.0
2011-05-23 09:00:00	AMZN	Stock	9.768	9.7865	9.613	9.6457	16602720.0
2011-05-23 10:00:00	AMZN	Stock	9.6425	9.7395	9.601	9.717	18828140.0

> showing 50 of 46,106 rows — these rows as CSV

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