PREVIEW / stock_1hour / 2015-05-27

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-27.parquet
  size:    1.1 MB
  rows:    49,190
  symbols: 3,521

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-05-27 04:00:00	AAPL	Stock	32.4625	32.5	32.4625	32.4875	34928.0
2015-05-27 05:00:00	AAPL	Stock	32.4875	32.51	32.4875	32.51	25576.0
2015-05-27 06:00:00	AAPL	Stock	32.5	32.5	32.4625	32.4925	55496.0
2015-05-27 07:00:00	AAPL	Stock	32.4825	32.5025	32.445	32.47	99548.0
2015-05-27 08:00:00	AAPL	Stock	32.47	32.575	32.47	32.5075	761864.0
2015-05-27 09:00:00	AAPL	Stock	32.5025	32.7975	32.4875	32.7425	32475100.0
2015-05-27 10:00:00	AAPL	Stock	32.7475	32.87	32.7125	32.8628	29908404.0
2015-05-27 11:00:00	AAPL	Stock	32.8625	32.9775	32.8425	32.9628	21359896.0
2015-05-27 12:00:00	AAPL	Stock	32.965	32.9875	32.8862	32.9475	15388588.0
2015-05-27 13:00:00	AAPL	Stock	32.95	33.0625	32.925	33.0238	17842892.0
2015-05-27 14:00:00	AAPL	Stock	33.0245	33.0275	32.955	33.0275	14156024.0
2015-05-27 15:00:00	AAPL	Stock	33.0258	33.065	32.9938	33.0025	25647816.0
2015-05-27 16:00:00	AAPL	Stock	33.0112	33.015	32.6782	32.9875	15661744.0
2015-05-27 17:00:00	AAPL	Stock	32.9825	32.9875	32.97	32.9775	89060.0
2015-05-27 18:00:00	AAPL	Stock	32.9775	32.9875	32.975	32.985	63904.0
2015-05-27 19:00:00	AAPL	Stock	32.975	33.005	32.975	32.975	104324.0
2015-05-27 08:00:00	MSFT	Stock	46.69	46.79	46.69	46.72	3139.0
2015-05-27 09:00:00	MSFT	Stock	46.7	47.3	46.62	47.25	3294203.0
2015-05-27 10:00:00	MSFT	Stock	47.25	47.49	47.21	47.445	3293332.0
2015-05-27 11:00:00	MSFT	Stock	47.44	47.49	47.16	47.24	2966224.0
2015-05-27 12:00:00	MSFT	Stock	47.24	47.38	47.21	47.36	1813968.0
2015-05-27 13:00:00	MSFT	Stock	47.37	47.65	47.36	47.6	3374842.0
2015-05-27 14:00:00	MSFT	Stock	47.6	47.72	47.595	47.675	2692697.0
2015-05-27 15:00:00	MSFT	Stock	47.68	47.77	47.61	47.62	4871018.0
2015-05-27 16:00:00	MSFT	Stock	47.61	47.64	47.55	47.6	2091951.0
2015-05-27 18:00:00	MSFT	Stock	47.6	47.6	47.56	47.6	1200.0
2015-05-27 19:00:00	MSFT	Stock	47.6	47.6	47.55	47.55	689.0
2015-05-27 08:00:00	NVDA	Stock	0.5235	0.5235	0.5235	0.5235	36000.0
2015-05-27 09:00:00	NVDA	Stock	0.5218	0.529	0.52	0.5275	35864240.0
2015-05-27 10:00:00	NVDA	Stock	0.5275	0.5285	0.5258	0.5269	21411800.0
2015-05-27 11:00:00	NVDA	Stock	0.5269	0.5327	0.5265	0.532	35292920.0
2015-05-27 12:00:00	NVDA	Stock	0.532	0.532	0.5298	0.5312	22403320.0
2015-05-27 13:00:00	NVDA	Stock	0.5312	0.5352	0.5308	0.5348	29914400.0
2015-05-27 14:00:00	NVDA	Stock	0.5348	0.5465	0.5335	0.5448	132192160.0
2015-05-27 15:00:00	NVDA	Stock	0.5448	0.5484	0.5432	0.546	126404760.0
2015-05-27 16:00:00	NVDA	Stock	0.546	0.5468	0.545	0.546	8366200.0
2015-05-27 17:00:00	NVDA	Stock	0.546	0.548	0.546	0.5475	178400.0
2015-05-27 07:00:00	AMZN	Stock	21.393	21.393	21.393	21.393	7600.0
2015-05-27 08:00:00	AMZN	Stock	21.37	21.385	21.3505	21.385	40720.0
2015-05-27 09:00:00	AMZN	Stock	21.3655	21.522	21.2505	21.469	6658880.0
2015-05-27 10:00:00	AMZN	Stock	21.4625	21.505	21.411	21.4422	5442400.0
2015-05-27 11:00:00	AMZN	Stock	21.4525	21.477	21.4075	21.433	3850340.0
2015-05-27 12:00:00	AMZN	Stock	21.432	21.482	21.4035	21.4555	2491180.0
2015-05-27 13:00:00	AMZN	Stock	21.4583	21.516	21.4583	21.5	4864500.0
2015-05-27 14:00:00	AMZN	Stock	21.5	21.5885	21.5	21.5465	4815600.0
2015-05-27 15:00:00	AMZN	Stock	21.545	21.5925	21.5105	21.571	7366540.0
2015-05-27 16:00:00	AMZN	Stock	21.571	21.575	21.571	21.575	4310820.0
2015-05-27 17:00:00	AMZN	Stock	21.55	21.571	21.55	21.571	48000.0
2015-05-27 18:00:00	AMZN	Stock	21.55	21.55	21.55	21.55	6400.0
2015-05-27 19:00:00	AMZN	Stock	21.5625	21.575	21.5625	21.575	12000.0

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

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