PREVIEW / stock_1hour / 2014-10-27

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-27.parquet
  size:    1.0 MB
  rows:    48,135
  symbols: 3,540

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
2014-10-27 04:00:00	AAPL	Stock	26.315	26.4	26.3125	26.3375	18800.0
2014-10-27 05:00:00	AAPL	Stock	26.3025	26.325	26.2525	26.2525	10800.0
2014-10-27 06:00:00	AAPL	Stock	26.2625	26.2725	26.215	26.2375	41464.0
2014-10-27 07:00:00	AAPL	Stock	26.2375	26.2675	26.195	26.2125	149948.0
2014-10-27 08:00:00	AAPL	Stock	26.215	26.305	26.19	26.2375	852276.0
2014-10-27 09:00:00	AAPL	Stock	26.2375	26.3375	26.165	26.2038	24159344.0
2014-10-27 10:00:00	AAPL	Stock	26.205	26.37	26.175	26.3475	23653668.0
2014-10-27 11:00:00	AAPL	Stock	26.3475	26.36	26.2525	26.29	14365196.0
2014-10-27 12:00:00	AAPL	Stock	26.29	26.3275	26.255	26.2988	12432392.0
2014-10-27 13:00:00	AAPL	Stock	26.3	26.34	26.2575	26.2688	13478544.0
2014-10-27 14:00:00	AAPL	Stock	26.2675	26.3125	26.2425	26.2812	14506384.0
2014-10-27 15:00:00	AAPL	Stock	26.28	26.3225	26.2575	26.275	15767448.0
2014-10-27 16:00:00	AAPL	Stock	26.2775	26.309	26.2198	26.2775	4285996.0
2014-10-27 17:00:00	AAPL	Stock	26.2725	26.28	26.2225	26.2475	193860.0
2014-10-27 18:00:00	AAPL	Stock	26.235	26.2775	26.235	26.25	144132.0
2014-10-27 19:00:00	AAPL	Stock	26.245	26.2725	26.245	26.2675	86400.0
2014-10-27 04:00:00	MSFT	Stock	46.25	46.38	46.25	46.38	1407.0
2014-10-27 05:00:00	MSFT	Stock	46.25	46.38	46.24	46.38	1196.0
2014-10-27 06:00:00	MSFT	Stock	46.11	46.19	46.11	46.19	2100.0
2014-10-27 07:00:00	MSFT	Stock	46.15	46.2	46.1	46.1	1900.0
2014-10-27 08:00:00	MSFT	Stock	46.1	46.2	45.97	45.97	24602.0
2014-10-27 09:00:00	MSFT	Stock	45.99	46.1	45.7	45.86	3574756.0
2014-10-27 10:00:00	MSFT	Stock	45.86	45.915	45.755	45.865	3451702.0
2014-10-27 11:00:00	MSFT	Stock	45.865	45.89	45.8	45.85	3745282.0
2014-10-27 12:00:00	MSFT	Stock	45.85	45.98	45.8	45.94	2065263.0
2014-10-27 13:00:00	MSFT	Stock	45.945	46.01	45.87	45.96	3325913.0
2014-10-27 14:00:00	MSFT	Stock	45.96	46.0	45.9	45.965	2388592.0
2014-10-27 15:00:00	MSFT	Stock	45.965	46.05	45.9	45.92	6574915.0
2014-10-27 16:00:00	MSFT	Stock	45.91	45.953	45.838	45.944	3782784.0
2014-10-27 17:00:00	MSFT	Stock	45.91	45.961	45.86	45.86	1141.0
2014-10-27 18:00:00	MSFT	Stock	45.86	45.91	45.75	45.91	47856.0
2014-10-27 19:00:00	MSFT	Stock	45.9	45.9	45.8	45.89	2900.0
2014-10-27 09:00:00	NVDA	Stock	0.461	0.4628	0.4575	0.458	20235600.0
2014-10-27 10:00:00	NVDA	Stock	0.4579	0.4605	0.4568	0.4603	27165120.0
2014-10-27 11:00:00	NVDA	Stock	0.4605	0.4635	0.4584	0.4585	13386360.0
2014-10-27 12:00:00	NVDA	Stock	0.4585	0.4618	0.4582	0.4615	10493960.0
2014-10-27 13:00:00	NVDA	Stock	0.4615	0.464	0.4615	0.4616	22056120.0
2014-10-27 14:00:00	NVDA	Stock	0.4615	0.4619	0.4605	0.4612	10617320.0
2014-10-27 15:00:00	NVDA	Stock	0.4615	0.4633	0.461	0.4622	24845760.0
2014-10-27 16:00:00	NVDA	Stock	0.4622	0.4622	0.4618	0.4618	6663960.0
2014-10-27 18:00:00	NVDA	Stock	0.4622	0.4622	0.4622	0.4622	20000.0
2014-10-27 04:00:00	AMZN	Stock	14.4015	14.45	14.35	14.35	64100.0
2014-10-27 05:00:00	AMZN	Stock	14.325	14.325	14.2555	14.2555	40200.0
2014-10-27 06:00:00	AMZN	Stock	14.2555	14.27	14.25	14.27	41000.0
2014-10-27 07:00:00	AMZN	Stock	14.25	14.28	14.25	14.275	137040.0
2014-10-27 08:00:00	AMZN	Stock	14.28	14.2965	14.2	14.21	502620.0
2014-10-27 09:00:00	AMZN	Stock	14.22	14.4095	14.1665	14.285	19372660.0
2014-10-27 10:00:00	AMZN	Stock	14.2845	14.4245	14.252	14.3755	19825300.0
2014-10-27 11:00:00	AMZN	Stock	14.3755	14.466	14.365	14.3905	14793700.0
2014-10-27 12:00:00	AMZN	Stock	14.387	14.399	14.3055	14.3867	12391120.0

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

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