PREVIEW / stock_1hour / 2013-04-25

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-25.parquet
  size:    978 KB
  rows:    45,603
  symbols: 3,496

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
2013-04-25 04:00:00	AAPL	Stock	14.5218	14.5354	14.5136	14.5136	59584.0
2013-04-25 05:00:00	AAPL	Stock	14.5232	14.5261	14.5229	14.5261	30800.0
2013-04-25 06:00:00	AAPL	Stock	14.525	14.5625	14.525	14.5625	85204.0
2013-04-25 07:00:00	AAPL	Stock	14.5418	14.6207	14.535	14.5625	776608.0
2013-04-25 08:00:00	AAPL	Stock	14.5518	14.6393	14.5271	14.6161	2291604.0
2013-04-25 09:00:00	AAPL	Stock	14.6179	14.7836	14.5875	14.6129	88654804.0
2013-04-25 10:00:00	AAPL	Stock	14.6161	14.6429	14.5357	14.5732	65803332.0
2013-04-25 11:00:00	AAPL	Stock	14.5761	14.6804	14.5732	14.6179	47671764.0
2013-04-25 12:00:00	AAPL	Stock	14.6171	14.7211	14.6089	14.6782	38023188.0
2013-04-25 13:00:00	AAPL	Stock	14.6771	14.7004	14.6357	14.6654	25778032.0
2013-04-25 14:00:00	AAPL	Stock	14.6638	14.6686	14.5821	14.6043	31724420.0
2013-04-25 15:00:00	AAPL	Stock	14.6018	14.6304	14.5564	14.5964	48033972.0
2013-04-25 16:00:00	AAPL	Stock	14.5964	14.6411	14.5714	14.5857	20761300.0
2013-04-25 17:00:00	AAPL	Stock	14.5857	14.5893	14.5754	14.5768	512708.0
2013-04-25 18:00:00	AAPL	Stock	14.5786	14.5893	14.5771	14.5882	91756.0
2013-04-25 19:00:00	AAPL	Stock	14.5807	14.5961	14.5804	14.5925	122080.0
2013-04-25 07:00:00	MSFT	Stock	31.82	31.85	31.8	31.8	5103.0
2013-04-25 08:00:00	MSFT	Stock	31.78	31.85	31.76	31.81	14570.0
2013-04-25 09:00:00	MSFT	Stock	31.82	32.6	31.54	32.512	17717788.0
2013-04-25 10:00:00	MSFT	Stock	32.53	32.84	32.33	32.57	29211418.0
2013-04-25 11:00:00	MSFT	Stock	32.57	32.705	32.29	32.33	11894652.0
2013-04-25 12:00:00	MSFT	Stock	32.33	32.41	32.05	32.17	10413899.0
2013-04-25 13:00:00	MSFT	Stock	32.17	32.31	31.95	31.96	8845911.0
2013-04-25 14:00:00	MSFT	Stock	31.963	32.14	31.88	31.91	9268274.0
2013-04-25 15:00:00	MSFT	Stock	31.91	32.08	31.77	31.93	14501485.0
2013-04-25 16:00:00	MSFT	Stock	31.94	32.599	31.849	31.94	4721795.0
2013-04-25 17:00:00	MSFT	Stock	32.0	32.02	31.94	31.98	201616.0
2013-04-25 18:00:00	MSFT	Stock	32.05	32.07	32.04	32.04	11040.0
2013-04-25 19:00:00	MSFT	Stock	32.04	32.04	32.02	32.02	3290.0
2013-04-25 08:00:00	NVDA	Stock	0.334	0.334	0.334	0.334	4000.0
2013-04-25 09:00:00	NVDA	Stock	0.336	0.3373	0.3328	0.337	48510280.0
2013-04-25 10:00:00	NVDA	Stock	0.337	0.3375	0.3358	0.336	47179320.0
2013-04-25 11:00:00	NVDA	Stock	0.3362	0.3373	0.335	0.336	48614680.0
2013-04-25 12:00:00	NVDA	Stock	0.336	0.3368	0.336	0.3366	32719760.0
2013-04-25 13:00:00	NVDA	Stock	0.3366	0.3366	0.3355	0.3365	28121720.0
2013-04-25 14:00:00	NVDA	Stock	0.3364	0.337	0.3361	0.3369	46809880.0
2013-04-25 15:00:00	NVDA	Stock	0.337	0.337	0.3353	0.3369	86618680.0
2013-04-25 16:00:00	NVDA	Stock	0.3368	0.3368	0.336	0.3365	8839440.0
2013-04-25 17:00:00	NVDA	Stock	0.3368	0.3368	0.3368	0.3368	262800.0
2013-04-25 19:00:00	NVDA	Stock	0.335	0.335	0.335	0.335	4000.0
2013-04-25 07:00:00	AMZN	Stock	13.5	13.5465	13.5	13.5465	8000.0
2013-04-25 08:00:00	AMZN	Stock	13.5495	13.5495	13.5	13.5205	243760.0
2013-04-25 09:00:00	AMZN	Stock	13.523	13.6295	13.504	13.6195	9409880.0
2013-04-25 10:00:00	AMZN	Stock	13.6213	13.734	13.6183	13.675	13655060.0
2013-04-25 11:00:00	AMZN	Stock	13.6725	13.68	13.606	13.6385	9714040.0
2013-04-25 12:00:00	AMZN	Stock	13.6345	13.707	13.6265	13.689	7257000.0
2013-04-25 13:00:00	AMZN	Stock	13.6935	13.7712	13.666	13.758	8295660.0
2013-04-25 14:00:00	AMZN	Stock	13.758	13.79	13.728	13.7414	9666720.0
2013-04-25 15:00:00	AMZN	Stock	13.7415	13.7705	13.6875	13.733	19084280.0
2013-04-25 16:00:00	AMZN	Stock	13.725	14.544	13.1695	14.033	28463980.0

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

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