PREVIEW / stock_1hour / 2014-12-26

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-26.parquet
  size:    1.0 MB
  rows:    47,271
  symbols: 3,508

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-12-26 07:00:00	AAPL	Stock	28.0875	28.1075	28.0875	28.095	11608.0
2014-12-26 08:00:00	AAPL	Stock	28.09	28.0925	28.035	28.07	119244.0
2014-12-26 09:00:00	AAPL	Stock	28.07	28.1975	28.0025	28.145	11181804.0
2014-12-26 10:00:00	AAPL	Stock	28.1425	28.2425	28.125	28.21	12868340.0
2014-12-26 11:00:00	AAPL	Stock	28.2102	28.3	28.19	28.25	13654428.0
2014-12-26 12:00:00	AAPL	Stock	28.2475	28.3625	28.2275	28.36	11431044.0
2014-12-26 13:00:00	AAPL	Stock	28.36	28.485	28.3575	28.4825	17842440.0
2014-12-26 14:00:00	AAPL	Stock	28.4825	28.5925	28.4775	28.585	18745504.0
2014-12-26 15:00:00	AAPL	Stock	28.585	28.63	28.4875	28.495	26924652.0
2014-12-26 16:00:00	AAPL	Stock	28.4975	28.515	28.0512	28.5025	15098064.0
2014-12-26 17:00:00	AAPL	Stock	28.5025	28.52	28.5025	28.51	95712.0
2014-12-26 18:00:00	AAPL	Stock	28.51	28.535	28.505	28.52	51964.0
2014-12-26 19:00:00	AAPL	Stock	28.53	28.535	28.5125	28.535	45164.0
2014-12-26 09:00:00	MSFT	Stock	48.12	48.45	48.0	48.007	1488550.0
2014-12-26 10:00:00	MSFT	Stock	48.01	48.1	47.91	47.99	1143631.0
2014-12-26 11:00:00	MSFT	Stock	47.99	48.01	47.87	47.96	1017572.0
2014-12-26 12:00:00	MSFT	Stock	47.965	48.08	47.88	47.89	1052642.0
2014-12-26 13:00:00	MSFT	Stock	47.89	48.0	47.88	47.944	766898.0
2014-12-26 14:00:00	MSFT	Stock	47.95	48.03	47.92	47.94	1097284.0
2014-12-26 15:00:00	MSFT	Stock	47.94	47.96	47.82	47.87	2479679.0
2014-12-26 16:00:00	MSFT	Stock	47.88	47.989	47.81	47.988	3754152.0
2014-12-26 17:00:00	MSFT	Stock	47.88	47.9	47.88	47.9	13557.0
2014-12-26 18:00:00	MSFT	Stock	47.9	47.91	47.9	47.91	600.0
2014-12-26 09:00:00	NVDA	Stock	0.5142	0.5175	0.5133	0.5145	5424160.0
2014-12-26 10:00:00	NVDA	Stock	0.5142	0.5152	0.513	0.5133	7920320.0
2014-12-26 11:00:00	NVDA	Stock	0.5135	0.5155	0.5133	0.5152	4732480.0
2014-12-26 12:00:00	NVDA	Stock	0.5155	0.5162	0.5152	0.5158	3973200.0
2014-12-26 13:00:00	NVDA	Stock	0.5158	0.5162	0.5145	0.5147	8436200.0
2014-12-26 14:00:00	NVDA	Stock	0.5145	0.5162	0.5144	0.516	3531760.0
2014-12-26 15:00:00	NVDA	Stock	0.516	0.5164	0.5142	0.5148	11525160.0
2014-12-26 16:00:00	NVDA	Stock	0.5148	0.5148	0.5148	0.5148	600680.0
2014-12-26 08:00:00	AMZN	Stock	15.155	15.209	15.155	15.209	12660.0
2014-12-26 09:00:00	AMZN	Stock	15.2345	15.3475	15.1905	15.345	5719800.0
2014-12-26 10:00:00	AMZN	Stock	15.346	15.3515	15.29	15.333	7974180.0
2014-12-26 11:00:00	AMZN	Stock	15.3338	15.434	15.303	15.424	7220000.0
2014-12-26 12:00:00	AMZN	Stock	15.4245	15.4825	15.3905	15.4799	6094480.0
2014-12-26 13:00:00	AMZN	Stock	15.4795	15.4925	15.4225	15.437	5057320.0
2014-12-26 14:00:00	AMZN	Stock	15.431	15.4575	15.4285	15.453	2769420.0
2014-12-26 15:00:00	AMZN	Stock	15.449	15.539	15.444	15.4545	16767220.0
2014-12-26 16:00:00	AMZN	Stock	15.4545	15.471	15.4128	15.4576	2784460.0
2014-12-26 17:00:00	AMZN	Stock	15.4545	15.4545	15.45	15.45	94660.0
2014-12-26 18:00:00	AMZN	Stock	15.45	15.45	15.45	15.45	3400.0
2014-12-26 09:00:00	GOOGL	Stock	26.866	26.9645	26.7745	26.954	1727860.0
2014-12-26 10:00:00	GOOGL	Stock	26.95	26.9945	26.9085	26.9445	2542540.0
2014-12-26 11:00:00	GOOGL	Stock	26.9455	27.0285	26.929	27.0135	1671260.0
2014-12-26 12:00:00	GOOGL	Stock	27.013	27.107	27.013	27.096	1899000.0
2014-12-26 13:00:00	GOOGL	Stock	27.1	27.1625	27.0785	27.08	1750580.0
2014-12-26 14:00:00	GOOGL	Stock	27.083	27.144	27.08	27.104	1309400.0
2014-12-26 15:00:00	GOOGL	Stock	27.1066	27.132	27.071	27.0895	3518440.0
2014-12-26 16:00:00	GOOGL	Stock	27.076	27.0885	27.038	27.05	2046560.0

> showing 50 of 47,271 rows — these rows as CSV

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