PREVIEW / stock_1hour / 2013-08-05

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-05.parquet
  size:    1015 KB
  rows:    46,811
  symbols: 3,503

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-08-05 04:00:00	AAPL	Stock	16.5054	16.55	16.5054	16.55	5600.0
2013-08-05 05:00:00	AAPL	Stock	16.5675	16.5675	16.5675	16.5675	2800.0
2013-08-05 06:00:00	AAPL	Stock	16.5771	16.6257	16.5771	16.6071	78064.0
2013-08-05 07:00:00	AAPL	Stock	16.5979	16.7143	16.5843	16.6411	1716792.0
2013-08-05 08:00:00	AAPL	Stock	16.6268	16.7121	16.4643	16.6382	2638636.0
2013-08-05 09:00:00	AAPL	Stock	16.6246	16.6414	16.5054	16.62	64737008.0
2013-08-05 10:00:00	AAPL	Stock	16.62	16.7607	16.6043	16.7536	68274612.0
2013-08-05 11:00:00	AAPL	Stock	16.7536	16.7643	16.6575	16.6882	34605788.0
2013-08-05 12:00:00	AAPL	Stock	16.6875	16.7464	16.6821	16.7396	17873352.0
2013-08-05 13:00:00	AAPL	Stock	16.7396	16.7946	16.7107	16.7789	30085468.0
2013-08-05 14:00:00	AAPL	Stock	16.7793	16.7868	16.7336	16.7429	25032812.0
2013-08-05 15:00:00	AAPL	Stock	16.7489	16.8096	16.7336	16.7643	44278136.0
2013-08-05 16:00:00	AAPL	Stock	16.7661	16.782	16.6942	16.77	14222768.0
2013-08-05 17:00:00	AAPL	Stock	16.5193	16.7786	16.5193	16.7768	166572.0
2013-08-05 18:00:00	AAPL	Stock	16.7732	16.7768	16.7657	16.7657	207592.0
2013-08-05 19:00:00	AAPL	Stock	16.7643	16.7643	16.7368	16.7496	287056.0
2013-08-05 05:00:00	MSFT	Stock	31.86	32.09	31.86	32.09	400.0
2013-08-05 07:00:00	MSFT	Stock	31.96	31.96	31.96	31.96	400.0
2013-08-05 08:00:00	MSFT	Stock	31.89	31.9	31.8	31.8	3412.0
2013-08-05 09:00:00	MSFT	Stock	31.82	31.91	31.78	31.86	2287777.0
2013-08-05 10:00:00	MSFT	Stock	31.85	32.0	31.83	31.88	4875773.0
2013-08-05 11:00:00	MSFT	Stock	31.89	31.91	31.69	31.705	2963933.0
2013-08-05 12:00:00	MSFT	Stock	31.705	31.76	31.69	31.72	2143375.0
2013-08-05 13:00:00	MSFT	Stock	31.72	31.82	31.69	31.74	2418026.0
2013-08-05 14:00:00	MSFT	Stock	31.75	31.78	31.69	31.705	3853417.0
2013-08-05 15:00:00	MSFT	Stock	31.71	31.73	31.64	31.69	7150669.0
2013-08-05 16:00:00	MSFT	Stock	31.69	31.89	31.68	31.71	4967597.0
2013-08-05 17:00:00	MSFT	Stock	31.88	31.88	31.64	31.66	2320.0
2013-08-05 18:00:00	MSFT	Stock	31.67	31.67	31.67	31.67	1970.0
2013-08-05 09:00:00	NVDA	Stock	0.368	0.3713	0.3661	0.371	29183080.0
2013-08-05 10:00:00	NVDA	Stock	0.3708	0.372	0.369	0.3703	33599920.0
2013-08-05 11:00:00	NVDA	Stock	0.3703	0.372	0.37	0.37	19373440.0
2013-08-05 12:00:00	NVDA	Stock	0.3703	0.3713	0.37	0.3701	13989320.0
2013-08-05 13:00:00	NVDA	Stock	0.3703	0.3718	0.3698	0.3713	18576640.0
2013-08-05 14:00:00	NVDA	Stock	0.3713	0.3713	0.3698	0.371	19397720.0
2013-08-05 15:00:00	NVDA	Stock	0.371	0.3713	0.3703	0.3708	40190200.0
2013-08-05 16:00:00	NVDA	Stock	0.3708	0.3708	0.37	0.3707	7567880.0
2013-08-05 17:00:00	NVDA	Stock	0.369	0.369	0.369	0.369	144000.0
2013-08-05 19:00:00	NVDA	Stock	0.3698	0.3698	0.3698	0.3698	20000.0
2013-08-05 09:00:00	AMZN	Stock	15.17	15.181	15.0025	15.0238	8834180.0
2013-08-05 10:00:00	AMZN	Stock	15.021	15.0635	14.969	15.0	8683280.0
2013-08-05 11:00:00	AMZN	Stock	15.0035	15.01	14.98	15.0032	4792460.0
2013-08-05 12:00:00	AMZN	Stock	14.9995	15.009	14.9276	14.954	5483680.0
2013-08-05 13:00:00	AMZN	Stock	14.951	15.0	14.915	14.9778	3954840.0
2013-08-05 14:00:00	AMZN	Stock	14.974	15.009	14.954	14.995	3080280.0
2013-08-05 15:00:00	AMZN	Stock	14.9937	15.05	14.9845	15.0495	7241000.0
2013-08-05 16:00:00	AMZN	Stock	15.0495	15.059	14.9438	15.0475	1675360.0
2013-08-05 17:00:00	AMZN	Stock	15.0185	15.05	15.0155	15.05	19180.0
2013-08-05 19:00:00	AMZN	Stock	15.0575	15.0575	15.0575	15.0575	2000.0
2013-08-05 04:00:00	META	Stock	38.28	38.5	38.2	38.45	29916.0

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

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