PREVIEW / stock_1hour / 2014-08-07

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-07.parquet
  size:    1.0 MB
  rows:    48,261
  symbols: 3,562

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-08-07 04:00:00	AAPL	Stock	23.6525	23.745	23.6525	23.745	4628.0
2014-08-07 05:00:00	AAPL	Stock	23.7125	23.735	23.7025	23.705	13764.0
2014-08-07 06:00:00	AAPL	Stock	23.72	23.72	23.6875	23.6925	17600.0
2014-08-07 07:00:00	AAPL	Stock	23.68	23.7325	23.6425	23.67	216012.0
2014-08-07 08:00:00	AAPL	Stock	23.675	23.745	23.6475	23.72	590784.0
2014-08-07 09:00:00	AAPL	Stock	23.7125	23.805	23.6775	23.8	20833804.0
2014-08-07 10:00:00	AAPL	Stock	23.7975	23.9875	23.7475	23.8688	35530004.0
2014-08-07 11:00:00	AAPL	Stock	23.8675	23.93	23.7625	23.775	23646636.0
2014-08-07 12:00:00	AAPL	Stock	23.7775	23.8375	23.6925	23.7262	18868612.0
2014-08-07 13:00:00	AAPL	Stock	23.7275	23.8225	23.7238	23.815	11132384.0
2014-08-07 14:00:00	AAPL	Stock	23.8128	23.815	23.685	23.6975	12912080.0
2014-08-07 15:00:00	AAPL	Stock	23.7	23.7275	23.525	23.62	31107664.0
2014-08-07 16:00:00	AAPL	Stock	23.62	23.8818	23.6	23.62	10009956.0
2014-08-07 17:00:00	AAPL	Stock	23.6175	23.6872	23.575	23.5875	171176.0
2014-08-07 18:00:00	AAPL	Stock	23.5875	23.62	23.55	23.55	315308.0
2014-08-07 19:00:00	AAPL	Stock	23.55	23.565	23.5425	23.55	199148.0
2014-08-07 08:00:00	MSFT	Stock	42.97	42.97	42.8	42.8	7400.0
2014-08-07 09:00:00	MSFT	Stock	42.83	43.39	42.65	43.31	4432973.0
2014-08-07 10:00:00	MSFT	Stock	43.31	43.43	43.07	43.26	4805980.0
2014-08-07 11:00:00	MSFT	Stock	43.26	43.295	43.05	43.215	3745395.0
2014-08-07 12:00:00	MSFT	Stock	43.21	43.25	43.06	43.22	2461010.0
2014-08-07 13:00:00	MSFT	Stock	43.22	43.45	43.195	43.41	3104937.0
2014-08-07 14:00:00	MSFT	Stock	43.41	43.44	43.24	43.246	2631929.0
2014-08-07 15:00:00	MSFT	Stock	43.25	43.34	43.09	43.23	6429554.0
2014-08-07 16:00:00	MSFT	Stock	43.23	43.297	43.1	43.23	1794844.0
2014-08-07 17:00:00	MSFT	Stock	43.249	43.28	43.249	43.28	487.0
2014-08-07 18:00:00	MSFT	Stock	43.17	43.25	43.15	43.23	14351.0
2014-08-07 19:00:00	MSFT	Stock	43.25	43.25	43.25	43.25	114.0
2014-08-07 08:00:00	NVDA	Stock	0.441	0.441	0.441	0.441	844000.0
2014-08-07 09:00:00	NVDA	Stock	0.4448	0.4488	0.4418	0.4428	32799440.0
2014-08-07 10:00:00	NVDA	Stock	0.4428	0.4442	0.4392	0.4415	71826120.0
2014-08-07 11:00:00	NVDA	Stock	0.4415	0.4425	0.4389	0.4408	45559560.0
2014-08-07 12:00:00	NVDA	Stock	0.4408	0.441	0.4375	0.4392	26346920.0
2014-08-07 13:00:00	NVDA	Stock	0.4392	0.4418	0.4382	0.4418	17013880.0
2014-08-07 14:00:00	NVDA	Stock	0.4418	0.4418	0.4372	0.4372	32100680.0
2014-08-07 15:00:00	NVDA	Stock	0.4373	0.4378	0.4335	0.4365	128301160.0
2014-08-07 16:00:00	NVDA	Stock	0.4365	0.457	0.43	0.455	45684720.0
2014-08-07 17:00:00	NVDA	Stock	0.4538	0.4555	0.4525	0.455	948160.0
2014-08-07 18:00:00	NVDA	Stock	0.4555	0.4562	0.4555	0.4562	522840.0
2014-08-07 19:00:00	NVDA	Stock	0.4562	0.4562	0.4558	0.4558	253840.0
2014-08-07 07:00:00	AMZN	Stock	15.7355	15.7355	15.7355	15.7355	2000.0
2014-08-07 08:00:00	AMZN	Stock	15.749	15.79	15.7485	15.779	61440.0
2014-08-07 09:00:00	AMZN	Stock	15.7625	15.7938	15.652	15.6745	7157480.0
2014-08-07 10:00:00	AMZN	Stock	15.6675	15.7195	15.5274	15.57	10885020.0
2014-08-07 11:00:00	AMZN	Stock	15.5639	15.62	15.55	15.5718	6965200.0
2014-08-07 12:00:00	AMZN	Stock	15.5695	15.6	15.5125	15.5435	5594420.0
2014-08-07 13:00:00	AMZN	Stock	15.5435	15.631	15.5405	15.6117	5338500.0
2014-08-07 14:00:00	AMZN	Stock	15.61	15.612	15.5325	15.5435	4181600.0
2014-08-07 15:00:00	AMZN	Stock	15.5368	15.5925	15.4828	15.5735	12568820.0
2014-08-07 16:00:00	AMZN	Stock	15.5725	15.5869	15.569	15.569	1889420.0

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

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