PREVIEW / stock_1hour / 2014-03-18

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-18.parquet
  size:    1.0 MB
  rows:    48,463
  symbols: 3,560

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-03-18 04:00:00	AAPL	Stock	18.8054	18.8054	18.7857	18.7857	8400.0
2014-03-18 05:00:00	AAPL	Stock	18.765	18.7671	18.7293	18.7671	14000.0
2014-03-18 06:00:00	AAPL	Stock	18.7714	18.7732	18.7714	18.7732	14252.0
2014-03-18 07:00:00	AAPL	Stock	18.8143	18.8929	18.8143	18.8396	157528.0
2014-03-18 08:00:00	AAPL	Stock	18.8454	18.8929	18.7593	18.8593	1093372.0
2014-03-18 09:00:00	AAPL	Stock	18.8593	18.9071	18.7571	18.8752	30168600.0
2014-03-18 10:00:00	AAPL	Stock	18.8754	18.9032	18.8482	18.8576	21565852.0
2014-03-18 11:00:00	AAPL	Stock	18.8598	18.9189	18.8546	18.8779	16664564.0
2014-03-18 12:00:00	AAPL	Stock	18.8775	18.9107	18.8696	18.9107	9840516.0
2014-03-18 13:00:00	AAPL	Stock	18.91	18.9693	18.885	18.9618	17131184.0
2014-03-18 14:00:00	AAPL	Stock	18.9611	18.9989	18.9332	18.9732	17923584.0
2014-03-18 15:00:00	AAPL	Stock	18.9739	18.9929	18.9482	18.9757	25691792.0
2014-03-18 16:00:00	AAPL	Stock	18.9786	18.9829	18.9111	18.9768	12217772.0
2014-03-18 17:00:00	AAPL	Stock	18.9775	18.9786	18.9679	18.9725	312424.0
2014-03-18 18:00:00	AAPL	Stock	18.9732	18.975	18.9732	18.975	15400.0
2014-03-18 19:00:00	AAPL	Stock	18.9779	18.9804	18.9679	18.9786	189616.0
2014-03-18 04:00:00	MSFT	Stock	38.05	38.05	38.05	38.05	100.0
2014-03-18 07:00:00	MSFT	Stock	38.38	38.4	38.38	38.4	4900.0
2014-03-18 08:00:00	MSFT	Stock	38.34	38.34	38.2	38.26	11300.0
2014-03-18 09:00:00	MSFT	Stock	38.26	39.12	38.22	39.1	8354451.0
2014-03-18 10:00:00	MSFT	Stock	39.1	39.9	39.02	39.64	16006593.0
2014-03-18 11:00:00	MSFT	Stock	39.64	39.69	39.46	39.61	8391096.0
2014-03-18 12:00:00	MSFT	Stock	39.61	39.72	39.42	39.446	5512927.0
2014-03-18 13:00:00	MSFT	Stock	39.45	39.66	39.36	39.575	3600877.0
2014-03-18 14:00:00	MSFT	Stock	39.575	39.64	39.5	39.584	4372770.0
2014-03-18 15:00:00	MSFT	Stock	39.59	39.7	39.41	39.55	9336757.0
2014-03-18 16:00:00	MSFT	Stock	39.56	39.615	39.44	39.47	6082408.0
2014-03-18 17:00:00	MSFT	Stock	39.48	39.56	39.47	39.5	97399.0
2014-03-18 18:00:00	MSFT	Stock	39.499	39.499	39.45	39.45	5604.0
2014-03-18 19:00:00	MSFT	Stock	39.45	39.48	39.43	39.43	3938.0
2014-03-18 09:00:00	NVDA	Stock	0.4472	0.4502	0.4452	0.4502	26571320.0
2014-03-18 10:00:00	NVDA	Stock	0.4501	0.4582	0.4498	0.4578	68969240.0
2014-03-18 11:00:00	NVDA	Stock	0.4579	0.4582	0.454	0.458	36654200.0
2014-03-18 12:00:00	NVDA	Stock	0.4579	0.459	0.4558	0.457	25891840.0
2014-03-18 13:00:00	NVDA	Stock	0.4569	0.457	0.455	0.4558	31528080.0
2014-03-18 14:00:00	NVDA	Stock	0.4559	0.4562	0.4552	0.456	28617080.0
2014-03-18 15:00:00	NVDA	Stock	0.456	0.456	0.455	0.4558	46158720.0
2014-03-18 16:00:00	NVDA	Stock	0.456	0.4562	0.4548	0.4562	3477160.0
2014-03-18 17:00:00	NVDA	Stock	0.456	0.456	0.456	0.456	237720.0
2014-03-18 04:00:00	AMZN	Stock	18.705	18.705	18.705	18.705	2000.0
2014-03-18 05:00:00	AMZN	Stock	18.715	18.715	18.715	18.715	2000.0
2014-03-18 06:00:00	AMZN	Stock	18.7225	18.7225	18.7225	18.7225	2000.0
2014-03-18 07:00:00	AMZN	Stock	18.715	18.95	18.715	18.95	93240.0
2014-03-18 08:00:00	AMZN	Stock	18.95	18.95	18.868	18.89	105000.0
2014-03-18 09:00:00	AMZN	Stock	18.8875	18.95	18.781	18.826	8499560.0
2014-03-18 10:00:00	AMZN	Stock	18.8255	18.867	18.75	18.771	7519180.0
2014-03-18 11:00:00	AMZN	Stock	18.7765	18.8399	18.7593	18.822	5196820.0
2014-03-18 12:00:00	AMZN	Stock	18.8243	18.88	18.765	18.789	3938480.0
2014-03-18 13:00:00	AMZN	Stock	18.792	18.867	18.7575	18.8405	3887560.0
2014-03-18 14:00:00	AMZN	Stock	18.847	18.878	18.8175	18.86	3391420.0

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

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