PREVIEW / stock_1hour / 2014-10-07

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-07.parquet
  size:    1.0 MB
  rows:    48,339
  symbols: 3,570

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
2014-10-07 04:00:00	AAPL	Stock	24.8575	24.8575	24.785	24.785	2000.0
2014-10-07 05:00:00	AAPL	Stock	24.785	24.795	24.75	24.795	32184.0
2014-10-07 06:00:00	AAPL	Stock	24.7875	24.935	24.7875	24.8925	33928.0
2014-10-07 07:00:00	AAPL	Stock	24.8875	24.955	24.875	24.9225	366528.0
2014-10-07 08:00:00	AAPL	Stock	24.92	24.9875	24.8925	24.9425	537180.0
2014-10-07 09:00:00	AAPL	Stock	24.945	25.0225	24.825	24.9925	25540564.0
2014-10-07 10:00:00	AAPL	Stock	24.99	25.03	24.92	24.9338	30980996.0
2014-10-07 11:00:00	AAPL	Stock	24.935	24.9575	24.79	24.91	20182628.0
2014-10-07 12:00:00	AAPL	Stock	24.9125	24.9725	24.84	24.872	12466292.0
2014-10-07 13:00:00	AAPL	Stock	24.8725	24.905	24.82	24.8908	11784940.0
2014-10-07 14:00:00	AAPL	Stock	24.8903	24.8903	24.765	24.7802	16930836.0
2014-10-07 15:00:00	AAPL	Stock	24.78	24.8075	24.6825	24.6875	32784432.0
2014-10-07 16:00:00	AAPL	Stock	24.6875	24.92	24.6675	24.7	4907440.0
2014-10-07 17:00:00	AAPL	Stock	24.7	24.705	24.69	24.7025	69820.0
2014-10-07 18:00:00	AAPL	Stock	24.7	24.7025	24.6875	24.7	200708.0
2014-10-07 19:00:00	AAPL	Stock	24.6975	24.705	24.6875	24.7	92592.0
2014-10-07 08:00:00	MSFT	Stock	45.96	46.0	45.9	45.9	2960.0
2014-10-07 09:00:00	MSFT	Stock	45.95	45.95	45.42	45.48	3476018.0
2014-10-07 10:00:00	MSFT	Stock	45.48	45.87	45.48	45.605	3416388.0
2014-10-07 11:00:00	MSFT	Stock	45.6	45.71	45.51	45.675	2314319.0
2014-10-07 12:00:00	MSFT	Stock	45.675	45.77	45.6	45.64	2159479.0
2014-10-07 13:00:00	MSFT	Stock	45.64	45.725	45.55	45.71	1930980.0
2014-10-07 14:00:00	MSFT	Stock	45.71	45.869	45.64	45.73	3521466.0
2014-10-07 15:00:00	MSFT	Stock	45.73	45.75	45.5	45.515	5853335.0
2014-10-07 16:00:00	MSFT	Stock	45.53	45.681	45.4	45.4	1852681.0
2014-10-07 17:00:00	MSFT	Stock	45.47	45.5	45.47	45.5	1110.0
2014-10-07 18:00:00	MSFT	Stock	45.53	45.55	45.49	45.5	105362.0
2014-10-07 19:00:00	MSFT	Stock	45.5	45.5	45.5	45.5	600.0
2014-10-07 07:00:00	NVDA	Stock	0.4575	0.4622	0.4575	0.4622	32000.0
2014-10-07 08:00:00	NVDA	Stock	0.455	0.455	0.4508	0.4512	1691000.0
2014-10-07 09:00:00	NVDA	Stock	0.451	0.452	0.4481	0.4508	24060320.0
2014-10-07 10:00:00	NVDA	Stock	0.451	0.4554	0.4508	0.4508	74988000.0
2014-10-07 11:00:00	NVDA	Stock	0.4508	0.4538	0.4499	0.4528	33760600.0
2014-10-07 12:00:00	NVDA	Stock	0.4529	0.4545	0.4508	0.4508	23210760.0
2014-10-07 13:00:00	NVDA	Stock	0.451	0.453	0.4498	0.4521	19946680.0
2014-10-07 14:00:00	NVDA	Stock	0.4521	0.453	0.4498	0.4505	21900920.0
2014-10-07 15:00:00	NVDA	Stock	0.4505	0.4512	0.4476	0.4481	74211280.0
2014-10-07 16:00:00	NVDA	Stock	0.4481	0.4505	0.4475	0.448	11537360.0
2014-10-07 17:00:00	NVDA	Stock	0.4488	0.4488	0.4488	0.4488	8000.0
2014-10-07 04:00:00	AMZN	Stock	15.95	15.9515	15.95	15.9515	4000.0
2014-10-07 07:00:00	AMZN	Stock	16.019	16.019	16.019	16.019	2000.0
2014-10-07 08:00:00	AMZN	Stock	16.039	16.05	16.025	16.05	16140.0
2014-10-07 09:00:00	AMZN	Stock	16.0475	16.0475	15.875	15.969	6030020.0
2014-10-07 10:00:00	AMZN	Stock	15.963	16.1	15.958	16.0175	7429420.0
2014-10-07 11:00:00	AMZN	Stock	16.0165	16.0345	15.934	16.0235	4825460.0
2014-10-07 12:00:00	AMZN	Stock	16.019	16.079	15.9805	15.9923	3069420.0
2014-10-07 13:00:00	AMZN	Stock	15.989	16.017	15.9505	15.994	2420820.0
2014-10-07 14:00:00	AMZN	Stock	15.9935	16.0205	15.9115	15.9135	3858200.0
2014-10-07 15:00:00	AMZN	Stock	15.911	15.9437	15.8335	15.8495	14021340.0
2014-10-07 16:00:00	AMZN	Stock	15.849	15.9572	15.8385	15.8458	347360.0

> showing 50 of 48,339 rows — these rows as CSV

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