PREVIEW / stock_1hour / 2014-11-05

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-05.parquet
  size:    1.0 MB
  rows:    48,883
  symbols: 3,544

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-11-05 04:00:00	AAPL	Stock	27.225	27.2625	27.2125	27.2625	28056.0
2014-11-05 05:00:00	AAPL	Stock	27.2625	27.3375	27.2625	27.29	16524.0
2014-11-05 06:00:00	AAPL	Stock	27.295	27.32	27.265	27.2725	34712.0
2014-11-05 07:00:00	AAPL	Stock	27.265	27.2925	27.25	27.2875	117872.0
2014-11-05 08:00:00	AAPL	Stock	27.2875	27.32	27.1	27.29	647972.0
2014-11-05 09:00:00	AAPL	Stock	27.295	27.325	27.0312	27.14	26052600.0
2014-11-05 10:00:00	AAPL	Stock	27.135	27.265	27.09	27.235	23870244.0
2014-11-05 11:00:00	AAPL	Stock	27.235	27.27	27.195	27.24	12554300.0
2014-11-05 12:00:00	AAPL	Stock	27.24	27.2525	27.2	27.2312	7626696.0
2014-11-05 13:00:00	AAPL	Stock	27.2325	27.235	27.115	27.1525	11412844.0
2014-11-05 14:00:00	AAPL	Stock	27.1525	27.25	27.1462	27.2025	14278956.0
2014-11-05 15:00:00	AAPL	Stock	27.2025	27.23	27.18	27.215	20154896.0
2014-11-05 16:00:00	AAPL	Stock	27.215	27.2325	27.15	27.215	6541100.0
2014-11-05 17:00:00	AAPL	Stock	27.205	27.2975	27.2025	27.225	186288.0
2014-11-05 18:00:00	AAPL	Stock	27.225	27.23	27.22	27.22	74320.0
2014-11-05 19:00:00	AAPL	Stock	27.225	27.23	27.215	27.2225	104360.0
2014-11-05 07:00:00	MSFT	Stock	47.75	47.75	47.75	47.75	100.0
2014-11-05 08:00:00	MSFT	Stock	47.75	47.9	47.75	47.88	4654.0
2014-11-05 09:00:00	MSFT	Stock	47.9	47.9	47.26	47.56	2921012.0
2014-11-05 10:00:00	MSFT	Stock	47.56	47.66	47.33	47.52	2903105.0
2014-11-05 11:00:00	MSFT	Stock	47.53	47.66	47.47	47.61	2135798.0
2014-11-05 12:00:00	MSFT	Stock	47.615	47.765	47.59	47.59	1620013.0
2014-11-05 13:00:00	MSFT	Stock	47.59	47.66	47.39	47.48	1540146.0
2014-11-05 14:00:00	MSFT	Stock	47.47	47.835	47.46	47.815	2425052.0
2014-11-05 15:00:00	MSFT	Stock	47.82	47.9	47.76	47.855	5582059.0
2014-11-05 16:00:00	MSFT	Stock	47.86	47.91	47.57	47.6	2441999.0
2014-11-05 17:00:00	MSFT	Stock	47.88	47.89	47.88	47.89	500.0
2014-11-05 19:00:00	MSFT	Stock	47.89	47.89	47.84	47.87	2100.0
2014-11-05 05:00:00	NVDA	Stock	0.5025	0.5025	0.5025	0.5025	28000.0
2014-11-05 08:00:00	NVDA	Stock	0.5038	0.5062	0.5025	0.5062	55200.0
2014-11-05 09:00:00	NVDA	Stock	0.5062	0.5064	0.5005	0.5028	34718080.0
2014-11-05 10:00:00	NVDA	Stock	0.5028	0.5048	0.4995	0.5028	53634440.0
2014-11-05 11:00:00	NVDA	Stock	0.5028	0.505	0.502	0.5043	32200240.0
2014-11-05 12:00:00	NVDA	Stock	0.5043	0.5053	0.5025	0.5046	21783880.0
2014-11-05 13:00:00	NVDA	Stock	0.5045	0.5062	0.5018	0.502	32229000.0
2014-11-05 14:00:00	NVDA	Stock	0.502	0.5038	0.501	0.5038	29771120.0
2014-11-05 15:00:00	NVDA	Stock	0.5038	0.5048	0.5032	0.5032	97305720.0
2014-11-05 16:00:00	NVDA	Stock	0.5035	0.5035	0.5025	0.5032	1357280.0
2014-11-05 17:00:00	NVDA	Stock	0.503	0.503	0.503	0.503	12000.0
2014-11-05 18:00:00	NVDA	Stock	0.503	0.503	0.503	0.503	14000.0
2014-11-05 19:00:00	NVDA	Stock	0.5005	0.5005	0.5005	0.5005	16000.0
2014-11-05 04:00:00	AMZN	Stock	15.2	15.2	15.2	15.2	4000.0
2014-11-05 07:00:00	AMZN	Stock	15.225	15.225	15.225	15.225	2000.0
2014-11-05 08:00:00	AMZN	Stock	15.2015	15.214	15.1405	15.205	146440.0
2014-11-05 09:00:00	AMZN	Stock	15.2135	15.2275	14.9755	14.9855	12712180.0
2014-11-05 10:00:00	AMZN	Stock	14.9855	15.053	14.9335	15.0055	11539060.0
2014-11-05 11:00:00	AMZN	Stock	15.003	15.085	14.9548	15.079	8297100.0
2014-11-05 12:00:00	AMZN	Stock	15.075	15.099	14.9525	14.9675	8161160.0
2014-11-05 13:00:00	AMZN	Stock	14.9645	14.9926	14.835	14.866	10486760.0
2014-11-05 14:00:00	AMZN	Stock	14.8643	14.8845	14.7565	14.7845	12201600.0

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

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