PREVIEW / stock_1hour / 2015-01-23

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-23.parquet
  size:    1.0 MB
  rows:    48,631
  symbols: 3,520

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-01-23 04:00:00	AAPL	Stock	28.1	28.1375	28.02	28.075	34104.0
2015-01-23 05:00:00	AAPL	Stock	28.05	28.0775	28.05	28.0675	26528.0
2015-01-23 06:00:00	AAPL	Stock	28.0675	28.105	28.035	28.0575	38648.0
2015-01-23 07:00:00	AAPL	Stock	28.0575	28.15	28.0075	28.14	311880.0
2015-01-23 08:00:00	AAPL	Stock	28.1375	28.175	28.015	28.065	857336.0
2015-01-23 09:00:00	AAPL	Stock	28.065	28.21	27.8825	28.165	27589292.0
2015-01-23 10:00:00	AAPL	Stock	28.165	28.1675	27.9425	28.03	22554172.0
2015-01-23 11:00:00	AAPL	Stock	28.0275	28.205	28.0025	28.2	16200636.0
2015-01-23 12:00:00	AAPL	Stock	28.2	28.24	28.1288	28.2395	14940352.0
2015-01-23 13:00:00	AAPL	Stock	28.2388	28.4375	28.21	28.405	23534908.0
2015-01-23 14:00:00	AAPL	Stock	28.405	28.4275	28.23	28.2762	19671900.0
2015-01-23 15:00:00	AAPL	Stock	28.2762	28.2825	28.2	28.2475	29298276.0
2015-01-23 16:00:00	AAPL	Stock	28.245	28.26	28.0745	28.2175	17138808.0
2015-01-23 17:00:00	AAPL	Stock	28.2175	28.225	28.2	28.22	89872.0
2015-01-23 18:00:00	AAPL	Stock	28.22	28.245	28.205	28.2175	64516.0
2015-01-23 19:00:00	AAPL	Stock	28.2175	28.2375	28.2125	28.235	60768.0
2015-01-23 04:00:00	MSFT	Stock	47.24	47.26	47.21	47.21	1500.0
2015-01-23 05:00:00	MSFT	Stock	47.25	47.41	47.25	47.41	1000.0
2015-01-23 06:00:00	MSFT	Stock	47.41	47.44	47.35	47.35	1600.0
2015-01-23 07:00:00	MSFT	Stock	47.31	47.38	47.3	47.32	2595.0
2015-01-23 08:00:00	MSFT	Stock	47.3	47.43	47.26	47.34	16210.0
2015-01-23 09:00:00	MSFT	Stock	47.34	47.45	47.01	47.1	3575284.0
2015-01-23 10:00:00	MSFT	Stock	47.1	47.14	46.8	46.96	3173311.0
2015-01-23 11:00:00	MSFT	Stock	46.96	47.24	46.91	47.02	2173496.0
2015-01-23 12:00:00	MSFT	Stock	47.01	47.16	46.98	47.15	1533045.0
2015-01-23 13:00:00	MSFT	Stock	47.145	47.23	47.09	47.15	1957953.0
2015-01-23 14:00:00	MSFT	Stock	47.15	47.22	47.08	47.1	1770249.0
2015-01-23 15:00:00	MSFT	Stock	47.1	47.23	47.06	47.18	6183257.0
2015-01-23 16:00:00	MSFT	Stock	47.18	47.2	47.073	47.08	3172618.0
2015-01-23 17:00:00	MSFT	Stock	47.19	47.19	47.14	47.19	56365.0
2015-01-23 18:00:00	MSFT	Stock	47.22	47.23	47.18	47.2	17880.0
2015-01-23 19:00:00	MSFT	Stock	47.26	47.27	47.26	47.27	912.0
2015-01-23 08:00:00	NVDA	Stock	0.525	0.5298	0.5182	0.5225	231600.0
2015-01-23 09:00:00	NVDA	Stock	0.5173	0.5178	0.5125	0.516	12622800.0
2015-01-23 10:00:00	NVDA	Stock	0.5158	0.517	0.5125	0.5142	12875880.0
2015-01-23 11:00:00	NVDA	Stock	0.5144	0.5165	0.5142	0.5155	12580640.0
2015-01-23 12:00:00	NVDA	Stock	0.5156	0.517	0.5148	0.5158	8738440.0
2015-01-23 13:00:00	NVDA	Stock	0.5158	0.5185	0.5153	0.5184	12208640.0
2015-01-23 14:00:00	NVDA	Stock	0.5184	0.5186	0.517	0.518	13109320.0
2015-01-23 15:00:00	NVDA	Stock	0.5182	0.5185	0.5168	0.518	34977000.0
2015-01-23 16:00:00	NVDA	Stock	0.5178	0.5178	0.5162	0.5162	7978520.0
2015-01-23 06:00:00	AMZN	Stock	15.4225	15.435	15.4225	15.435	5300.0
2015-01-23 07:00:00	AMZN	Stock	15.4225	15.4225	15.4225	15.4225	4940.0
2015-01-23 08:00:00	AMZN	Stock	15.516	15.545	15.4095	15.45	1654460.0
2015-01-23 09:00:00	AMZN	Stock	15.427	15.5805	15.3805	15.5675	11692140.0
2015-01-23 10:00:00	AMZN	Stock	15.5675	15.7375	15.5655	15.7075	16845660.0
2015-01-23 11:00:00	AMZN	Stock	15.7046	15.7105	15.629	15.6661	7163640.0
2015-01-23 12:00:00	AMZN	Stock	15.6655	15.8465	15.6605	15.7695	14761060.0
2015-01-23 13:00:00	AMZN	Stock	15.771	15.771	15.7	15.742	7394020.0
2015-01-23 14:00:00	AMZN	Stock	15.742	15.7425	15.668	15.678	6431720.0

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

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