PREVIEW / stock_1hour / 2015-01-08

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-08.parquet
  size:    1.1 MB
  rows:    49,236
  symbols: 3,534

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-08 04:00:00	AAPL	Stock	27.0475	27.2125	27.0475	27.175	31512.0
2015-01-08 05:00:00	AAPL	Stock	27.15	27.1925	27.15	27.1925	18156.0
2015-01-08 06:00:00	AAPL	Stock	27.1925	27.275	27.1875	27.275	109944.0
2015-01-08 07:00:00	AAPL	Stock	27.2625	27.2875	27.2275	27.2475	225892.0
2015-01-08 08:00:00	AAPL	Stock	27.2375	27.2875	27.0625	27.24	746292.0
2015-01-08 09:00:00	AAPL	Stock	27.245	27.4725	26.9375	27.4625	30299896.0
2015-01-08 10:00:00	AAPL	Stock	27.4625	27.6025	27.4475	27.5805	34254028.0
2015-01-08 11:00:00	AAPL	Stock	27.5825	27.8825	27.575	27.8712	33823040.0
2015-01-08 12:00:00	AAPL	Stock	27.8712	27.9	27.7275	27.8625	21318268.0
2015-01-08 13:00:00	AAPL	Stock	27.8612	28.0375	27.8575	27.9	29431164.0
2015-01-08 14:00:00	AAPL	Stock	27.9025	28.025	27.8778	27.985	20234564.0
2015-01-08 15:00:00	AAPL	Stock	27.985	28.0375	27.8925	27.9675	32427016.0
2015-01-08 16:00:00	AAPL	Stock	27.9725	28.0225	27.3545	28.0	18561652.0
2015-01-08 17:00:00	AAPL	Stock	28.0	28.0575	27.99	28.0325	291600.0
2015-01-08 18:00:00	AAPL	Stock	28.03	28.12	27.9725	28.12	305232.0
2015-01-08 19:00:00	AAPL	Stock	28.1225	28.1425	28.0775	28.0875	182244.0
2015-01-08 04:00:00	MSFT	Stock	46.52	46.57	46.52	46.57	900.0
2015-01-08 05:00:00	MSFT	Stock	46.57	46.57	46.57	46.57	200.0
2015-01-08 06:00:00	MSFT	Stock	46.57	46.62	46.35	46.35	2292.0
2015-01-08 07:00:00	MSFT	Stock	46.55	46.67	46.55	46.55	3250.0
2015-01-08 08:00:00	MSFT	Stock	46.48	46.62	46.48	46.56	7961.0
2015-01-08 09:00:00	MSFT	Stock	46.54	47.42	46.23	47.37	3751721.0
2015-01-08 10:00:00	MSFT	Stock	47.37	47.635	47.32	47.63	4648760.0
2015-01-08 11:00:00	MSFT	Stock	47.64	47.75	47.43	47.47	3468029.0
2015-01-08 12:00:00	MSFT	Stock	47.47	47.58	47.38	47.53	1909883.0
2015-01-08 13:00:00	MSFT	Stock	47.53	47.66	47.48	47.599	2334166.0
2015-01-08 14:00:00	MSFT	Stock	47.59	47.63	47.47	47.48	2899987.0
2015-01-08 15:00:00	MSFT	Stock	47.48	47.64	47.47	47.59	5740848.0
2015-01-08 16:00:00	MSFT	Stock	47.59	47.6	47.454	47.489	3677674.0
2015-01-08 17:00:00	MSFT	Stock	47.57	47.59	47.57	47.57	4995.0
2015-01-08 18:00:00	MSFT	Stock	47.55	47.59	47.55	47.59	9137.0
2015-01-08 19:00:00	MSFT	Stock	47.5	47.57	47.5	47.57	1465.0
2015-01-08 08:00:00	NVDA	Stock	0.486	0.4862	0.4855	0.4855	16000.0
2015-01-08 09:00:00	NVDA	Stock	0.4818	0.4942	0.4812	0.494	30671200.0
2015-01-08 10:00:00	NVDA	Stock	0.4942	0.4986	0.4932	0.4985	60262920.0
2015-01-08 11:00:00	NVDA	Stock	0.4988	0.4995	0.496	0.4978	27215280.0
2015-01-08 12:00:00	NVDA	Stock	0.4976	0.498	0.4958	0.497	17532640.0
2015-01-08 13:00:00	NVDA	Stock	0.4968	0.4988	0.496	0.4965	18328480.0
2015-01-08 14:00:00	NVDA	Stock	0.4964	0.4985	0.4959	0.4975	18637120.0
2015-01-08 15:00:00	NVDA	Stock	0.4975	0.499	0.4963	0.4965	60812720.0
2015-01-08 16:00:00	NVDA	Stock	0.4965	0.4975	0.4957	0.4965	22409560.0
2015-01-08 17:00:00	NVDA	Stock	0.496	0.496	0.496	0.496	8000.0
2015-01-08 04:00:00	AMZN	Stock	15.0165	15.0165	15.0165	15.0165	2000.0
2015-01-08 05:00:00	AMZN	Stock	15.017	15.017	15.017	15.017	2000.0
2015-01-08 07:00:00	AMZN	Stock	15.0495	15.0495	15.0495	15.0495	2000.0
2015-01-08 08:00:00	AMZN	Stock	15.037	15.037	15.003	15.012	44720.0
2015-01-08 09:00:00	AMZN	Stock	15.01	15.0295	14.8055	14.873	7225300.0
2015-01-08 10:00:00	AMZN	Stock	14.86	15.09	14.845	15.088	11631300.0
2015-01-08 11:00:00	AMZN	Stock	15.088	15.119	15.0215	15.0456	5178160.0
2015-01-08 12:00:00	AMZN	Stock	15.0465	15.132	15.0235	15.1145	4562440.0

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

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