PREVIEW / stock_1hour / 2015-05-26

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-26.parquet
  size:    1.0 MB
  rows:    48,939
  symbols: 3,512

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-05-26 04:00:00	AAPL	Stock	33.125	33.125	32.94	32.9775	54244.0
2015-05-26 05:00:00	AAPL	Stock	32.9975	33.025	32.9975	33.025	47660.0
2015-05-26 06:00:00	AAPL	Stock	33.025	33.0925	33.0125	33.0925	18180.0
2015-05-26 07:00:00	AAPL	Stock	33.0875	33.16	33.0825	33.1325	118464.0
2015-05-26 08:00:00	AAPL	Stock	33.1475	33.225	33.03	33.195	984336.0
2015-05-26 09:00:00	AAPL	Stock	33.1925	33.2275	32.805	32.845	35009380.0
2015-05-26 10:00:00	AAPL	Stock	32.84	32.9085	32.6725	32.6975	42990068.0
2015-05-26 11:00:00	AAPL	Stock	32.6975	32.7222	32.5652	32.6602	29808408.0
2015-05-26 12:00:00	AAPL	Stock	32.66	32.6825	32.575	32.5775	15842200.0
2015-05-26 13:00:00	AAPL	Stock	32.5762	32.585	32.4425	32.4475	29250084.0
2015-05-26 14:00:00	AAPL	Stock	32.4475	32.48	32.3025	32.3028	30917116.0
2015-05-26 15:00:00	AAPL	Stock	32.305	32.46	32.28	32.4075	43909212.0
2015-05-26 16:00:00	AAPL	Stock	32.405	33.15	32.395	32.4375	19161764.0
2015-05-26 17:00:00	AAPL	Stock	32.4375	32.4725	32.4375	32.4625	209096.0
2015-05-26 18:00:00	AAPL	Stock	32.4625	32.4625	32.425	32.44	141832.0
2015-05-26 19:00:00	AAPL	Stock	32.4275	32.445	32.4275	32.4375	110736.0
2015-05-26 04:00:00	MSFT	Stock	46.65	46.65	46.65	46.65	200.0
2015-05-26 05:00:00	MSFT	Stock	46.65	46.65	46.65	46.65	300.0
2015-05-26 08:00:00	MSFT	Stock	46.84	46.84	46.68	46.72	20375.0
2015-05-26 09:00:00	MSFT	Stock	46.71	46.88	46.43	46.44	3107303.0
2015-05-26 10:00:00	MSFT	Stock	46.45	46.59	46.235	46.5	4883556.0
2015-05-26 11:00:00	MSFT	Stock	46.5	46.51	46.4	46.5	3441275.0
2015-05-26 12:00:00	MSFT	Stock	46.5	46.51	46.3	46.345	2073070.0
2015-05-26 13:00:00	MSFT	Stock	46.35	46.48	46.25	46.29	2368469.0
2015-05-26 14:00:00	MSFT	Stock	46.3	46.365	46.19	46.295	2976445.0
2015-05-26 15:00:00	MSFT	Stock	46.29	46.66	46.29	46.6	6402330.0
2015-05-26 16:00:00	MSFT	Stock	46.59	46.67	46.328	46.65	2481163.0
2015-05-26 19:00:00	MSFT	Stock	46.61	46.61	46.59	46.59	461.0
2015-05-26 08:00:00	NVDA	Stock	0.5285	0.5285	0.5215	0.5215	27400.0
2015-05-26 09:00:00	NVDA	Stock	0.5192	0.5225	0.5148	0.5152	39339960.0
2015-05-26 10:00:00	NVDA	Stock	0.5152	0.5192	0.5145	0.5158	49152320.0
2015-05-26 11:00:00	NVDA	Stock	0.5156	0.5182	0.5144	0.5177	21381840.0
2015-05-26 12:00:00	NVDA	Stock	0.5176	0.518	0.516	0.5162	13377240.0
2015-05-26 13:00:00	NVDA	Stock	0.516	0.517	0.5148	0.5155	17624080.0
2015-05-26 14:00:00	NVDA	Stock	0.5152	0.5165	0.5146	0.5151	16498720.0
2015-05-26 15:00:00	NVDA	Stock	0.5151	0.5192	0.5148	0.5182	62556840.0
2015-05-26 16:00:00	NVDA	Stock	0.5182	0.52	0.5182	0.52	31636560.0
2015-05-26 17:00:00	NVDA	Stock	0.5285	0.5285	0.5285	0.5285	16000.0
2015-05-26 07:00:00	AMZN	Stock	21.35	21.351	21.35	21.351	6000.0
2015-05-26 08:00:00	AMZN	Stock	21.3525	21.3525	21.3185	21.3185	45140.0
2015-05-26 09:00:00	AMZN	Stock	21.3155	21.35	21.15	21.1675	6321100.0
2015-05-26 10:00:00	AMZN	Stock	21.182	21.2105	21.1	21.1475	8160460.0
2015-05-26 11:00:00	AMZN	Stock	21.154	21.2422	21.1025	21.2155	6008960.0
2015-05-26 12:00:00	AMZN	Stock	21.2185	21.28	21.187	21.225	3037380.0
2015-05-26 13:00:00	AMZN	Stock	21.222	21.2395	21.164	21.169	3289500.0
2015-05-26 14:00:00	AMZN	Stock	21.1815	21.2322	21.15	21.1778	2546480.0
2015-05-26 15:00:00	AMZN	Stock	21.174	21.2935	21.174	21.2745	6918420.0
2015-05-26 16:00:00	AMZN	Stock	21.2735	21.3065	21.2501	21.2735	2178160.0
2015-05-26 19:00:00	AMZN	Stock	21.2875	21.2875	21.2875	21.2875	2000.0
2015-05-26 08:00:00	GOOGL	Stock	27.7375	27.7375	27.7175	27.7175	10000.0

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

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