PREVIEW / stock_1hour / 2015-06-17

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-17.parquet
  size:    1.0 MB
  rows:    49,217
  symbols: 3,510

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
2015-06-17 04:00:00	AAPL	Stock	31.955	31.955	31.925	31.95	28348.0
2015-06-17 06:00:00	AAPL	Stock	31.9625	31.9825	31.8325	31.9125	25460.0
2015-06-17 07:00:00	AAPL	Stock	31.9325	31.9375	31.8675	31.8875	60532.0
2015-06-17 08:00:00	AAPL	Stock	31.8875	31.945	31.875	31.925	330772.0
2015-06-17 09:00:00	AAPL	Stock	31.93	31.97	31.8125	31.86	14416340.0
2015-06-17 10:00:00	AAPL	Stock	31.86	31.8725	31.765	31.852	16034672.0
2015-06-17 11:00:00	AAPL	Stock	31.8475	31.87	31.7575	31.8	11946476.0
2015-06-17 12:00:00	AAPL	Stock	31.8	31.8175	31.6925	31.705	11196192.0
2015-06-17 13:00:00	AAPL	Stock	31.705	31.785	31.7	31.7475	9525992.0
2015-06-17 14:00:00	AAPL	Stock	31.74	31.9425	31.685	31.925	28478648.0
2015-06-17 15:00:00	AAPL	Stock	31.9235	31.94	31.82	31.8225	19853028.0
2015-06-17 16:00:00	AAPL	Stock	31.825	31.8325	31.7475	31.7525	13021288.0
2015-06-17 17:00:00	AAPL	Stock	31.75	31.825	31.7325	31.75	145468.0
2015-06-17 18:00:00	AAPL	Stock	31.75	31.75	31.7375	31.74	22320.0
2015-06-17 19:00:00	AAPL	Stock	31.75	31.7508	31.7375	31.7425	102708.0
2015-06-17 07:00:00	MSFT	Stock	45.9	45.9	45.9	45.9	100.0
2015-06-17 08:00:00	MSFT	Stock	46.01	46.01	45.93	45.93	402.0
2015-06-17 09:00:00	MSFT	Stock	45.83	45.96	45.73	45.84	2705469.0
2015-06-17 10:00:00	MSFT	Stock	45.84	45.953	45.76	45.95	3009714.0
2015-06-17 11:00:00	MSFT	Stock	45.95	45.99	45.65	45.75	3121780.0
2015-06-17 12:00:00	MSFT	Stock	45.75	45.76	45.37	45.47	2848754.0
2015-06-17 13:00:00	MSFT	Stock	45.465	45.6	45.36	45.55	2137381.0
2015-06-17 14:00:00	MSFT	Stock	45.54	46.07	45.4	45.98	4889497.0
2015-06-17 15:00:00	MSFT	Stock	45.99	46.01	45.83	45.97	5298056.0
2015-06-17 16:00:00	MSFT	Stock	45.97	45.97	45.61	45.8	2997101.0
2015-06-17 17:00:00	MSFT	Stock	45.78	45.93	45.78	45.93	6500.0
2015-06-17 18:00:00	MSFT	Stock	45.9	45.9	45.9	45.9	114.0
2015-06-17 19:00:00	MSFT	Stock	45.94	45.94	45.94	45.94	400.0
2015-06-17 08:00:00	NVDA	Stock	0.5395	0.5407	0.536	0.536	282800.0
2015-06-17 09:00:00	NVDA	Stock	0.5372	0.5379	0.5318	0.5354	26992240.0
2015-06-17 10:00:00	NVDA	Stock	0.5355	0.5378	0.5349	0.5372	21213840.0
2015-06-17 11:00:00	NVDA	Stock	0.5375	0.5392	0.5372	0.538	23502280.0
2015-06-17 12:00:00	NVDA	Stock	0.538	0.5382	0.5362	0.5371	15099000.0
2015-06-17 13:00:00	NVDA	Stock	0.537	0.5382	0.5365	0.5381	12429960.0
2015-06-17 14:00:00	NVDA	Stock	0.538	0.5425	0.5365	0.5421	44743320.0
2015-06-17 15:00:00	NVDA	Stock	0.5422	0.5425	0.539	0.5395	46487960.0
2015-06-17 16:00:00	NVDA	Stock	0.5395	0.5398	0.5395	0.5395	34839320.0
2015-06-17 17:00:00	NVDA	Stock	0.5398	0.5398	0.5398	0.5398	48000.0
2015-06-17 19:00:00	NVDA	Stock	0.5398	0.5398	0.5398	0.5398	8000.0
2015-06-17 08:00:00	AMZN	Stock	21.396	21.475	21.396	21.475	45740.0
2015-06-17 09:00:00	AMZN	Stock	21.4515	21.5675	21.403	21.4955	5220100.0
2015-06-17 10:00:00	AMZN	Stock	21.4945	21.4975	21.3902	21.4163	5293820.0
2015-06-17 11:00:00	AMZN	Stock	21.4155	21.419	21.307	21.371	4374280.0
2015-06-17 12:00:00	AMZN	Stock	21.3695	21.3845	21.2377	21.2505	4619980.0
2015-06-17 13:00:00	AMZN	Stock	21.248	21.346	21.2425	21.341	3080720.0
2015-06-17 14:00:00	AMZN	Stock	21.335	21.5	21.3	21.4785	8633100.0
2015-06-17 15:00:00	AMZN	Stock	21.483	21.5	21.3885	21.3905	7731060.0
2015-06-17 16:00:00	AMZN	Stock	21.3905	21.3905	21.35	21.35	1558740.0
2015-06-17 17:00:00	AMZN	Stock	21.39	21.39	21.365	21.365	14800.0
2015-06-17 18:00:00	AMZN	Stock	21.3755	21.3755	21.3755	21.3755	2000.0

> showing 50 of 49,217 rows — these rows as CSV

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