PREVIEW / stock_1hour / 2014-09-24

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-24.parquet
  size:    1.0 MB
  rows:    48,160
  symbols: 3,566

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-09-24 04:00:00	AAPL	Stock	25.595	25.6175	25.5625	25.6175	6328.0
2014-09-24 05:00:00	AAPL	Stock	25.575	25.6125	25.575	25.605	6880.0
2014-09-24 06:00:00	AAPL	Stock	25.605	25.635	25.575	25.5875	66168.0
2014-09-24 07:00:00	AAPL	Stock	25.6075	25.6075	25.475	25.525	654972.0
2014-09-24 08:00:00	AAPL	Stock	25.5125	25.66	25.4575	25.4975	9674864.0
2014-09-24 09:00:00	AAPL	Stock	25.4975	25.7125	25.4375	25.4925	38099452.0
2014-09-24 10:00:00	AAPL	Stock	25.4925	25.5225	25.3	25.4292	41473468.0
2014-09-24 11:00:00	AAPL	Stock	25.43	25.5362	25.395	25.435	27408876.0
2014-09-24 12:00:00	AAPL	Stock	25.435	25.5	25.4025	25.436	15577628.0
2014-09-24 13:00:00	AAPL	Stock	25.4362	25.5475	25.415	25.5188	21042440.0
2014-09-24 14:00:00	AAPL	Stock	25.52	25.5375	25.3375	25.395	30005856.0
2014-09-24 15:00:00	AAPL	Stock	25.3972	25.4825	25.38	25.4375	33050736.0
2014-09-24 16:00:00	AAPL	Stock	25.4362	25.475	25.3675	25.395	12485528.0
2014-09-24 17:00:00	AAPL	Stock	25.3875	25.4375	25.3175	25.345	499880.0
2014-09-24 18:00:00	AAPL	Stock	25.335	25.4375	25.33	25.37	302936.0
2014-09-24 19:00:00	AAPL	Stock	25.365	25.375	25.34	25.345	211048.0
2014-09-24 07:00:00	MSFT	Stock	46.7	46.75	46.57	46.7	2898.0
2014-09-24 08:00:00	MSFT	Stock	46.78	46.78	46.63	46.65	13463.0
2014-09-24 09:00:00	MSFT	Stock	46.63	46.69	46.39	46.545	2531487.0
2014-09-24 10:00:00	MSFT	Stock	46.53	46.55	46.34	46.516	4269827.0
2014-09-24 11:00:00	MSFT	Stock	46.515	46.925	46.49	46.91	4024711.0
2014-09-24 12:00:00	MSFT	Stock	46.91	46.95	46.76	46.8	1818127.0
2014-09-24 13:00:00	MSFT	Stock	46.8	46.94	46.77	46.9	2026727.0
2014-09-24 14:00:00	MSFT	Stock	46.9	46.98	46.86	46.964	1948436.0
2014-09-24 15:00:00	MSFT	Stock	46.97	47.11	46.94	47.08	4855038.0
2014-09-24 16:00:00	MSFT	Stock	47.08	47.086	46.785	46.954	4314291.0
2014-09-24 17:00:00	MSFT	Stock	47.08	47.08	47.08	47.08	100.0
2014-09-24 18:00:00	MSFT	Stock	47.07	47.08	47.02	47.08	28814.0
2014-09-24 19:00:00	MSFT	Stock	47.08	47.08	47.08	47.08	19710.0
2014-09-24 08:00:00	NVDA	Stock	0.4793	0.4793	0.4793	0.4793	40000.0
2014-09-24 09:00:00	NVDA	Stock	0.47	0.4729	0.4698	0.4702	16406960.0
2014-09-24 10:00:00	NVDA	Stock	0.4705	0.4729	0.4695	0.472	31752960.0
2014-09-24 11:00:00	NVDA	Stock	0.472	0.4745	0.4713	0.4735	18140760.0
2014-09-24 12:00:00	NVDA	Stock	0.4735	0.474	0.471	0.4715	11271640.0
2014-09-24 13:00:00	NVDA	Stock	0.4715	0.4728	0.4711	0.4718	10216600.0
2014-09-24 14:00:00	NVDA	Stock	0.4718	0.473	0.4714	0.4725	18839600.0
2014-09-24 15:00:00	NVDA	Stock	0.4723	0.4735	0.472	0.473	37777680.0
2014-09-24 16:00:00	NVDA	Stock	0.473	0.4738	0.4729	0.4729	3909720.0
2014-09-24 08:00:00	AMZN	Stock	16.258	16.268	16.2565	16.268	20140.0
2014-09-24 09:00:00	AMZN	Stock	16.249	16.26	16.1125	16.1355	6314900.0
2014-09-24 10:00:00	AMZN	Stock	16.133	16.139	15.978	16.1265	11201040.0
2014-09-24 11:00:00	AMZN	Stock	16.1265	16.3055	16.121	16.3055	6480140.0
2014-09-24 12:00:00	AMZN	Stock	16.302	16.302	16.237	16.2415	3141680.0
2014-09-24 13:00:00	AMZN	Stock	16.245	16.37	16.2435	16.3505	3574840.0
2014-09-24 14:00:00	AMZN	Stock	16.357	16.472	16.331	16.4355	6432780.0
2014-09-24 15:00:00	AMZN	Stock	16.4355	16.4594	16.4005	16.4095	8988600.0
2014-09-24 16:00:00	AMZN	Stock	16.4085	16.428	16.4	16.4072	1162120.0
2014-09-24 17:00:00	AMZN	Stock	16.4025	16.4105	16.4025	16.4105	42000.0
2014-09-24 18:00:00	AMZN	Stock	16.4105	16.4105	16.4105	16.4105	62780.0
2014-09-24 19:00:00	AMZN	Stock	16.4105	16.4105	16.4025	16.4025	27900.0

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

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