PREVIEW / stock_1hour / 2015-02-27

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-27.parquet
  size:    1.1 MB
  rows:    48,916
  symbols: 3,517

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-02-27 04:00:00	AAPL	Stock	32.5975	32.6675	32.5625	32.6	23680.0
2015-02-27 05:00:00	AAPL	Stock	32.62	32.6225	32.59	32.6225	11116.0
2015-02-27 06:00:00	AAPL	Stock	32.575	32.6325	32.545	32.63	29660.0
2015-02-27 07:00:00	AAPL	Stock	32.625	32.645	32.6025	32.645	132600.0
2015-02-27 08:00:00	AAPL	Stock	32.6375	32.6375	32.48	32.52	761024.0
2015-02-27 09:00:00	AAPL	Stock	32.5275	32.55	32.1475	32.475	38974884.0
2015-02-27 10:00:00	AAPL	Stock	32.475	32.6425	32.32	32.445	39997728.0
2015-02-27 11:00:00	AAPL	Stock	32.445	32.505	32.3775	32.475	19823688.0
2015-02-27 12:00:00	AAPL	Stock	32.4775	32.5025	32.3925	32.4275	14153048.0
2015-02-27 13:00:00	AAPL	Stock	32.4252	32.4875	32.3625	32.4035	17823100.0
2015-02-27 14:00:00	AAPL	Stock	32.405	32.4075	32.1925	32.2675	25305248.0
2015-02-27 15:00:00	AAPL	Stock	32.2675	32.2975	32.06	32.1175	44840612.0
2015-02-27 16:00:00	AAPL	Stock	32.115	32.3795	32.097	32.125	33239616.0
2015-02-27 17:00:00	AAPL	Stock	32.125	32.1275	32.0925	32.0975	594080.0
2015-02-27 18:00:00	AAPL	Stock	32.0972	32.115	32.0925	32.11	151348.0
2015-02-27 19:00:00	AAPL	Stock	32.11	32.1125	32.0975	32.1125	93472.0
2015-02-27 06:00:00	MSFT	Stock	44.0	44.0	44.0	44.0	900.0
2015-02-27 08:00:00	MSFT	Stock	44.0	44.04	44.0	44.0	8322.0
2015-02-27 09:00:00	MSFT	Stock	44.0	44.22	43.76	43.86	3572745.0
2015-02-27 10:00:00	MSFT	Stock	43.86	43.948	43.75	43.815	3967448.0
2015-02-27 11:00:00	MSFT	Stock	43.82	43.88	43.7	43.77	3066887.0
2015-02-27 12:00:00	MSFT	Stock	43.77	43.9	43.75	43.814	1609838.0
2015-02-27 13:00:00	MSFT	Stock	43.815	43.836	43.74	43.795	2030726.0
2015-02-27 14:00:00	MSFT	Stock	43.8	43.82	43.71	43.755	3230115.0
2015-02-27 15:00:00	MSFT	Stock	43.76	43.89	43.66	43.84	7384450.0
2015-02-27 16:00:00	MSFT	Stock	43.85	43.88	43.68	43.83	7196133.0
2015-02-27 17:00:00	MSFT	Stock	43.8	43.85	43.8	43.81	126987.0
2015-02-27 18:00:00	MSFT	Stock	43.8	43.84	43.8	43.81	3348.0
2015-02-27 19:00:00	MSFT	Stock	43.81	43.82	43.81	43.81	4033.0
2015-02-27 08:00:00	NVDA	Stock	0.5572	0.5572	0.5572	0.5572	40000.0
2015-02-27 09:00:00	NVDA	Stock	0.555	0.555	0.5495	0.5518	12801400.0
2015-02-27 10:00:00	NVDA	Stock	0.5516	0.5535	0.5516	0.552	12721480.0
2015-02-27 11:00:00	NVDA	Stock	0.5521	0.5538	0.5515	0.5528	14907480.0
2015-02-27 12:00:00	NVDA	Stock	0.5529	0.5548	0.5525	0.5538	11693080.0
2015-02-27 13:00:00	NVDA	Stock	0.5536	0.554	0.55	0.5512	23619720.0
2015-02-27 14:00:00	NVDA	Stock	0.5514	0.5522	0.5505	0.5515	12265360.0
2015-02-27 15:00:00	NVDA	Stock	0.5514	0.5532	0.5508	0.5512	45126960.0
2015-02-27 16:00:00	NVDA	Stock	0.5515	0.552	0.5512	0.5515	19814680.0
2015-02-27 17:00:00	NVDA	Stock	0.5515	0.5515	0.5515	0.5515	266600.0
2015-02-27 08:00:00	AMZN	Stock	19.158	19.2	19.158	19.1755	29980.0
2015-02-27 09:00:00	AMZN	Stock	19.1795	19.2995	19.125	19.1995	7173460.0
2015-02-27 10:00:00	AMZN	Stock	19.2025	19.248	19.1215	19.1688	5545740.0
2015-02-27 11:00:00	AMZN	Stock	19.1755	19.185	19.1105	19.1285	3949260.0
2015-02-27 12:00:00	AMZN	Stock	19.1306	19.1455	19.0825	19.096	3075460.0
2015-02-27 13:00:00	AMZN	Stock	19.097	19.114	19.0215	19.0958	4972000.0
2015-02-27 14:00:00	AMZN	Stock	19.092	19.108	19.019	19.031	4554980.0
2015-02-27 15:00:00	AMZN	Stock	19.0352	19.052	18.9895	19.013	10425560.0
2015-02-27 16:00:00	AMZN	Stock	19.008	19.1022	18.99	19.1022	2160720.0
2015-02-27 17:00:00	AMZN	Stock	19.008	19.025	19.008	19.008	1366460.0
2015-02-27 18:00:00	AMZN	Stock	19.0085	19.0425	19.008	19.03	87040.0

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

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