PREVIEW / stock_1hour / 2015-08-06

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-06.parquet
  size:    1.0 MB
  rows:    48,642
  symbols: 3,486

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-08-06 04:00:00	AAPL	Stock	28.8875	28.8875	28.875	28.875	38480.0
2015-08-06 05:00:00	AAPL	Stock	28.875	28.875	28.84	28.8525	8120.0
2015-08-06 06:00:00	AAPL	Stock	28.86	28.9275	28.855	28.855	25440.0
2015-08-06 07:00:00	AAPL	Stock	28.875	28.9125	28.8475	28.885	255184.0
2015-08-06 08:00:00	AAPL	Stock	28.8775	28.985	28.8475	28.9475	1354288.0
2015-08-06 09:00:00	AAPL	Stock	28.955	29.125	28.6775	28.7475	38702072.0
2015-08-06 10:00:00	AAPL	Stock	28.75	28.79	28.5775	28.61	38591284.0
2015-08-06 11:00:00	AAPL	Stock	28.61	28.7625	28.5288	28.65	28583268.0
2015-08-06 12:00:00	AAPL	Stock	28.6525	28.715	28.5725	28.7125	17280540.0
2015-08-06 13:00:00	AAPL	Stock	28.71	28.8125	28.665	28.715	18597716.0
2015-08-06 14:00:00	AAPL	Stock	28.7125	28.95	28.7125	28.81	21086420.0
2015-08-06 15:00:00	AAPL	Stock	28.8075	28.8375	28.7025	28.785	26082800.0
2015-08-06 16:00:00	AAPL	Stock	28.7825	28.819	28.715	28.755	6765496.0
2015-08-06 17:00:00	AAPL	Stock	28.765	28.78	28.715	28.7725	64948.0
2015-08-06 18:00:00	AAPL	Stock	28.7775	28.795	28.7675	28.775	56736.0
2015-08-06 19:00:00	AAPL	Stock	28.77	28.79	28.76	28.775	83500.0
2015-08-06 04:00:00	MSFT	Stock	47.5	47.5	47.48	47.48	992.0
2015-08-06 08:00:00	MSFT	Stock	47.6	47.69	47.6	47.603	400.0
2015-08-06 09:00:00	MSFT	Stock	47.6	47.77	46.93	47.09	2926947.0
2015-08-06 10:00:00	MSFT	Stock	47.095	47.26	46.93	46.935	3467464.0
2015-08-06 11:00:00	MSFT	Stock	46.93	46.98	46.69	46.735	3367382.0
2015-08-06 12:00:00	MSFT	Stock	46.74	46.76	46.47	46.65	2785989.0
2015-08-06 13:00:00	MSFT	Stock	46.65	46.665	46.38	46.409	2627378.0
2015-08-06 14:00:00	MSFT	Stock	46.41	46.51	46.33	46.37	3244596.0
2015-08-06 15:00:00	MSFT	Stock	46.37	46.68	46.36	46.61	5278822.0
2015-08-06 16:00:00	MSFT	Stock	46.62	46.752	46.58	46.69	1770119.0
2015-08-06 17:00:00	MSFT	Stock	46.61	46.61	46.61	46.61	1908.0
2015-08-06 18:00:00	MSFT	Stock	46.61	46.68	46.61	46.62	580.0
2015-08-06 19:00:00	MSFT	Stock	46.653	46.653	46.62	46.62	927.0
2015-08-06 08:00:00	NVDA	Stock	0.5162	0.5188	0.5162	0.5182	48680.0
2015-08-06 09:00:00	NVDA	Stock	0.5133	0.5158	0.5036	0.505	34100600.0
2015-08-06 10:00:00	NVDA	Stock	0.5049	0.513	0.5045	0.5089	71786080.0
2015-08-06 11:00:00	NVDA	Stock	0.509	0.5098	0.5062	0.507	55900480.0
2015-08-06 12:00:00	NVDA	Stock	0.507	0.5093	0.5028	0.5035	48866880.0
2015-08-06 13:00:00	NVDA	Stock	0.5035	0.5135	0.503	0.5115	78512040.0
2015-08-06 14:00:00	NVDA	Stock	0.5115	0.517	0.5109	0.5145	111251160.0
2015-08-06 15:00:00	NVDA	Stock	0.5145	0.5155	0.51	0.512	141060080.0
2015-08-06 16:00:00	NVDA	Stock	0.5112	0.58	0.497	0.5585	36906600.0
2015-08-06 17:00:00	NVDA	Stock	0.5592	0.5605	0.55	0.5585	8286560.0
2015-08-06 18:00:00	NVDA	Stock	0.5575	0.561	0.5562	0.5608	3688680.0
2015-08-06 19:00:00	NVDA	Stock	0.56	0.5662	0.56	0.5655	2798880.0
2015-08-06 04:00:00	AMZN	Stock	26.816	26.816	26.816	26.816	2000.0
2015-08-06 05:00:00	AMZN	Stock	26.816	26.816	26.816	26.816	2000.0
2015-08-06 06:00:00	AMZN	Stock	26.728	26.728	26.728	26.728	2000.0
2015-08-06 07:00:00	AMZN	Stock	26.85	26.875	26.85	26.875	10080.0
2015-08-06 08:00:00	AMZN	Stock	26.875	26.91	26.875	26.8765	47020.0
2015-08-06 09:00:00	AMZN	Stock	26.895	27.0995	26.7	27.027	11316660.0
2015-08-06 10:00:00	AMZN	Stock	27.045	27.137	26.915	26.9455	9717720.0
2015-08-06 11:00:00	AMZN	Stock	26.941	26.951	26.5455	26.616	11921040.0
2015-08-06 12:00:00	AMZN	Stock	26.6015	26.6565	26.45	26.4755	8332560.0

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

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