PREVIEW / stock_1hour / 2011-04-04

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-04.parquet
  size:    963 KB
  rows:    46,135
  symbols: 3,536

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-04 05:00:00	AAPL	Stock	12.3214	12.36	12.3214	12.325	9240.0
2011-04-04 06:00:00	AAPL	Stock	12.35	12.35	12.35	12.35	10780.0
2011-04-04 07:00:00	AAPL	Stock	12.3575	12.3779	12.3432	12.3571	229096.0
2011-04-04 08:00:00	AAPL	Stock	12.3561	12.4468	12.33	12.3482	1355004.0
2011-04-04 09:00:00	AAPL	Stock	12.3514	12.3514	12.1546	12.1589	94796072.0
2011-04-04 10:00:00	AAPL	Stock	12.1596	12.1964	12.0857	12.1254	115847200.0
2011-04-04 11:00:00	AAPL	Stock	12.1257	12.215	12.125	12.2032	51643816.0
2011-04-04 12:00:00	AAPL	Stock	12.2032	12.2196	12.1464	12.1575	34007260.0
2011-04-04 13:00:00	AAPL	Stock	12.1579	12.1675	12.1289	12.1368	38375260.0
2011-04-04 14:00:00	AAPL	Stock	12.1368	12.1782	12.1221	12.1507	46281480.0
2011-04-04 15:00:00	AAPL	Stock	12.1529	12.1936	12.125	12.1857	59649604.0
2011-04-04 16:00:00	AAPL	Stock	12.1854	12.314	12.1601	12.1957	9859752.0
2011-04-04 17:00:00	AAPL	Stock	12.1964	12.2	12.1889	12.1889	208096.0
2011-04-04 18:00:00	AAPL	Stock	12.1882	12.1946	12.1854	12.1946	217504.0
2011-04-04 19:00:00	AAPL	Stock	12.1946	12.2054	12.1946	12.1961	73332.0
2011-04-04 07:00:00	MSFT	Stock	25.48	25.56	25.48	25.48	1136.0
2011-04-04 08:00:00	MSFT	Stock	25.5	25.55	25.5	25.55	4116.0
2011-04-04 09:00:00	MSFT	Stock	25.54	25.54	25.41	25.515	4912758.0
2011-04-04 10:00:00	MSFT	Stock	25.52	25.66	25.49	25.6	7686296.0
2011-04-04 11:00:00	MSFT	Stock	25.598	25.65	25.58	25.63	3532380.0
2011-04-04 12:00:00	MSFT	Stock	25.62	25.66	25.56	25.571	3541264.0
2011-04-04 13:00:00	MSFT	Stock	25.575	25.585	25.5	25.502	2783253.0
2011-04-04 14:00:00	MSFT	Stock	25.51	25.55	25.47	25.53	2817362.0
2011-04-04 15:00:00	MSFT	Stock	25.525	25.58	25.41	25.54	8064167.0
2011-04-04 16:00:00	MSFT	Stock	25.54	25.63	25.48	25.61	1744038.0
2011-04-04 17:00:00	MSFT	Stock	25.62	25.64	25.6	25.6	8375.0
2011-04-04 18:00:00	MSFT	Stock	25.55	25.6	25.55	25.57	6518.0
2011-04-04 19:00:00	MSFT	Stock	25.57	25.6	25.57	25.6	885.0
2011-04-04 07:00:00	NVDA	Stock	0.4518	0.4518	0.4518	0.4518	28400.0
2011-04-04 08:00:00	NVDA	Stock	0.455	0.4588	0.455	0.4575	1709000.0
2011-04-04 09:00:00	NVDA	Stock	0.4575	0.4578	0.444	0.4462	149769720.0
2011-04-04 10:00:00	NVDA	Stock	0.4462	0.4475	0.4375	0.4382	180517600.0
2011-04-04 11:00:00	NVDA	Stock	0.4382	0.4425	0.4362	0.4365	168881720.0
2011-04-04 12:00:00	NVDA	Stock	0.4366	0.441	0.4355	0.44	94156840.0
2011-04-04 13:00:00	NVDA	Stock	0.4398	0.441	0.4375	0.4399	79195000.0
2011-04-04 14:00:00	NVDA	Stock	0.4399	0.4412	0.4378	0.4379	67531120.0
2011-04-04 15:00:00	NVDA	Stock	0.438	0.4398	0.4362	0.4388	143775760.0
2011-04-04 16:00:00	NVDA	Stock	0.4385	0.4538	0.4362	0.451	28844800.0
2011-04-04 17:00:00	NVDA	Stock	0.4512	0.4525	0.4488	0.4488	2630680.0
2011-04-04 18:00:00	NVDA	Stock	0.45	0.4512	0.4488	0.4488	1854000.0
2011-04-04 19:00:00	NVDA	Stock	0.4488	0.4498	0.4488	0.4498	311400.0
2011-04-04 05:00:00	AMZN	Stock	9.019	9.035	9.019	9.035	4000.0
2011-04-04 07:00:00	AMZN	Stock	9.03	9.03	9.03	9.03	2000.0
2011-04-04 08:00:00	AMZN	Stock	9.02	9.021	9.006	9.0125	46100.0
2011-04-04 09:00:00	AMZN	Stock	9.0095	9.117	9.0095	9.0975	13033120.0
2011-04-04 10:00:00	AMZN	Stock	9.0995	9.1015	9.0345	9.0735	12130340.0
2011-04-04 11:00:00	AMZN	Stock	9.074	9.1805	9.072	9.175	16765780.0
2011-04-04 12:00:00	AMZN	Stock	9.1735	9.176	9.135	9.145	7377920.0
2011-04-04 13:00:00	AMZN	Stock	9.146	9.15	9.0675	9.0895	8372360.0
2011-04-04 14:00:00	AMZN	Stock	9.0885	9.1135	9.079	9.106	7140780.0

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

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