PREVIEW / stock_1hour / 2016-04-07

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-07.parquet
  size:    1.0 MB
  rows:    47,994
  symbols: 3,324

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
2016-04-07 04:00:00	AAPL	Stock	27.65	27.75	27.625	27.625	24800.0
2016-04-07 05:00:00	AAPL	Stock	27.625	27.6375	27.605	27.605	16744.0
2016-04-07 06:00:00	AAPL	Stock	27.605	27.65	27.5975	27.5975	14520.0
2016-04-07 07:00:00	AAPL	Stock	27.6375	27.64	27.475	27.525	222320.0
2016-04-07 08:00:00	AAPL	Stock	27.5475	27.6275	27.5375	27.6225	499560.0
2016-04-07 09:00:00	AAPL	Stock	27.61	27.6225	27.3875	27.48	18441332.0
2016-04-07 10:00:00	AAPL	Stock	27.4825	27.605	27.34	27.3415	15661868.0
2016-04-07 11:00:00	AAPL	Stock	27.34	27.38	27.255	27.34	12360128.0
2016-04-07 12:00:00	AAPL	Stock	27.34	27.4425	27.32	27.3675	9402100.0
2016-04-07 13:00:00	AAPL	Stock	27.3688	27.3925	27.2292	27.2452	9914540.0
2016-04-07 14:00:00	AAPL	Stock	27.245	27.2462	27.095	27.095	15489208.0
2016-04-07 15:00:00	AAPL	Stock	27.095	27.195	27.0302	27.135	21976532.0
2016-04-07 16:00:00	AAPL	Stock	27.135	27.1775	27.089	27.1375	8840072.0
2016-04-07 17:00:00	AAPL	Stock	27.1475	27.175	27.14	27.1525	61236.0
2016-04-07 18:00:00	AAPL	Stock	27.155	27.155	27.1025	27.1125	140428.0
2016-04-07 19:00:00	AAPL	Stock	27.1125	27.13	27.0875	27.0975	66272.0
2016-04-07 07:00:00	MSFT	Stock	54.71	54.71	54.7	54.7	1500.0
2016-04-07 08:00:00	MSFT	Stock	54.87	54.87	54.84	54.86	1300.0
2016-04-07 09:00:00	MSFT	Stock	54.85	54.91	54.6	54.844	1796416.0
2016-04-07 10:00:00	MSFT	Stock	54.845	54.87	54.55	54.62	2512137.0
2016-04-07 11:00:00	MSFT	Stock	54.62	54.65	54.37	54.52	1929000.0
2016-04-07 12:00:00	MSFT	Stock	54.523	54.59	54.3	54.53	1483258.0
2016-04-07 13:00:00	MSFT	Stock	54.53	54.65	54.315	54.375	1158061.0
2016-04-07 14:00:00	MSFT	Stock	54.37	54.47	54.23	54.29	2435102.0
2016-04-07 15:00:00	MSFT	Stock	54.28	54.51	54.245	54.45	3822234.0
2016-04-07 16:00:00	MSFT	Stock	54.44	54.55	54.44	54.55	2038329.0
2016-04-07 17:00:00	MSFT	Stock	54.46	54.55	54.46	54.46	91613.0
2016-04-07 18:00:00	MSFT	Stock	54.46	54.46	54.41	54.41	2455.0
2016-04-07 19:00:00	MSFT	Stock	54.45	54.45	54.42	54.42	1080.0
2016-04-07 05:00:00	NVDA	Stock	0.8925	0.8925	0.8925	0.8925	4000.0
2016-04-07 08:00:00	NVDA	Stock	0.8875	0.8875	0.8875	0.8875	4000.0
2016-04-07 09:00:00	NVDA	Stock	0.89	0.895	0.8855	0.8898	39777400.0
2016-04-07 10:00:00	NVDA	Stock	0.8898	0.8973	0.889	0.8915	48496280.0
2016-04-07 11:00:00	NVDA	Stock	0.8915	0.894	0.8883	0.893	36694360.0
2016-04-07 12:00:00	NVDA	Stock	0.893	0.894	0.8901	0.8915	27738000.0
2016-04-07 13:00:00	NVDA	Stock	0.8914	0.8938	0.8875	0.8893	28944040.0
2016-04-07 14:00:00	NVDA	Stock	0.8893	0.8902	0.884	0.8845	46369360.0
2016-04-07 15:00:00	NVDA	Stock	0.8845	0.8865	0.882	0.8858	114759560.0
2016-04-07 16:00:00	NVDA	Stock	0.8858	0.886	0.8858	0.8858	17988520.0
2016-04-07 17:00:00	NVDA	Stock	0.887	0.889	0.887	0.889	1552640.0
2016-04-07 19:00:00	NVDA	Stock	0.885	0.885	0.885	0.885	18000.0
2016-04-07 06:00:00	AMZN	Stock	30.05	30.05	29.875	29.95	8000.0
2016-04-07 07:00:00	AMZN	Stock	29.889	29.9	29.8655	29.8985	38000.0
2016-04-07 08:00:00	AMZN	Stock	29.9	29.9975	29.9	29.928	149800.0
2016-04-07 09:00:00	AMZN	Stock	29.959	29.98	29.7	29.787	10680220.0
2016-04-07 10:00:00	AMZN	Stock	29.8013	29.9475	29.5525	29.595	12307900.0
2016-04-07 11:00:00	AMZN	Stock	29.587	29.7225	29.5135	29.6845	8083700.0
2016-04-07 12:00:00	AMZN	Stock	29.6865	29.69	29.54	29.615	4205160.0
2016-04-07 13:00:00	AMZN	Stock	29.624	29.717	29.55	29.5645	2778040.0
2016-04-07 14:00:00	AMZN	Stock	29.5665	29.588	29.454	29.505	4904100.0

> showing 50 of 47,994 rows — these rows as CSV

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