PREVIEW / stock_1hour / 2014-08-15

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-15.parquet
  size:    1.0 MB
  rows:    48,036
  symbols: 3,564

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-15 04:00:00	AAPL	Stock	24.385	24.4	24.38	24.4	6784.0
2014-08-15 05:00:00	AAPL	Stock	24.3825	24.405	24.3825	24.405	10800.0
2014-08-15 06:00:00	AAPL	Stock	24.4125	24.4125	24.4075	24.4075	800.0
2014-08-15 07:00:00	AAPL	Stock	24.43	24.45	24.4	24.41	64316.0
2014-08-15 08:00:00	AAPL	Stock	24.415	24.4475	24.4	24.4175	402104.0
2014-08-15 09:00:00	AAPL	Stock	24.4175	24.5125	24.3625	24.445	39907568.0
2014-08-15 10:00:00	AAPL	Stock	24.445	24.5475	24.3375	24.3988	39111832.0
2014-08-15 11:00:00	AAPL	Stock	24.4	24.46	24.215	24.28	33965384.0
2014-08-15 12:00:00	AAPL	Stock	24.28	24.3725	24.235	24.34	15159904.0
2014-08-15 13:00:00	AAPL	Stock	24.3375	24.39	24.3	24.35	10681688.0
2014-08-15 14:00:00	AAPL	Stock	24.3525	24.44	24.3375	24.4225	14636304.0
2014-08-15 15:00:00	AAPL	Stock	24.4225	24.5	24.38	24.495	26442572.0
2014-08-15 16:00:00	AAPL	Stock	24.495	24.5375	24.47	24.4775	4241768.0
2014-08-15 17:00:00	AAPL	Stock	24.4775	24.4875	24.465	24.4875	184356.0
2014-08-15 18:00:00	AAPL	Stock	24.4875	24.4975	24.485	24.495	209412.0
2014-08-15 19:00:00	AAPL	Stock	24.495	24.5	24.49	24.4975	158856.0
2014-08-15 08:00:00	MSFT	Stock	44.31	44.46	44.31	44.4	2288.0
2014-08-15 09:00:00	MSFT	Stock	44.32	44.78	44.32	44.62	10163834.0
2014-08-15 10:00:00	MSFT	Stock	44.62	44.73	44.48	44.615	6732210.0
2014-08-15 11:00:00	MSFT	Stock	44.61	44.65	44.41	44.49	5965192.0
2014-08-15 12:00:00	MSFT	Stock	44.49	44.62	44.4	44.535	2642621.0
2014-08-15 13:00:00	MSFT	Stock	44.54	44.67	44.455	44.595	2689578.0
2014-08-15 14:00:00	MSFT	Stock	44.597	44.84	44.51	44.7	3443523.0
2014-08-15 15:00:00	MSFT	Stock	44.71	44.895	44.63	44.79	6591362.0
2014-08-15 16:00:00	MSFT	Stock	44.79	44.85	44.645	44.7	2145114.0
2014-08-15 17:00:00	MSFT	Stock	44.79	44.88	44.79	44.86	62516.0
2014-08-15 18:00:00	MSFT	Stock	44.79	44.85	44.78	44.85	59074.0
2014-08-15 19:00:00	MSFT	Stock	44.84	44.84	44.84	44.84	200.0
2014-08-15 07:00:00	NVDA	Stock	0.47	0.47	0.47	0.47	8000.0
2014-08-15 08:00:00	NVDA	Stock	0.4698	0.47	0.4698	0.47	104000.0
2014-08-15 09:00:00	NVDA	Stock	0.4725	0.475	0.4715	0.4748	36703600.0
2014-08-15 10:00:00	NVDA	Stock	0.4748	0.4786	0.4699	0.4718	55613040.0
2014-08-15 11:00:00	NVDA	Stock	0.4715	0.4734	0.467	0.468	46698480.0
2014-08-15 12:00:00	NVDA	Stock	0.468	0.4738	0.4678	0.4736	39405480.0
2014-08-15 13:00:00	NVDA	Stock	0.4736	0.474	0.4726	0.4736	32125840.0
2014-08-15 14:00:00	NVDA	Stock	0.4735	0.477	0.4732	0.4758	27099920.0
2014-08-15 15:00:00	NVDA	Stock	0.4758	0.4766	0.4745	0.476	123151720.0
2014-08-15 16:00:00	NVDA	Stock	0.476	0.476	0.4758	0.4758	1945560.0
2014-08-15 19:00:00	NVDA	Stock	0.4763	0.4763	0.4758	0.4758	178360.0
2014-08-15 07:00:00	AMZN	Stock	16.7	16.7	16.694	16.7	18000.0
2014-08-15 08:00:00	AMZN	Stock	16.694	16.725	16.6105	16.7025	291660.0
2014-08-15 09:00:00	AMZN	Stock	16.695	16.7555	16.5675	16.613	15679500.0
2014-08-15 10:00:00	AMZN	Stock	16.6125	16.6675	16.4658	16.501	14904600.0
2014-08-15 11:00:00	AMZN	Stock	16.5079	16.5685	16.416	16.471	10308680.0
2014-08-15 12:00:00	AMZN	Stock	16.465	16.5465	16.429	16.511	4279460.0
2014-08-15 13:00:00	AMZN	Stock	16.511	16.55	16.493	16.5175	3071940.0
2014-08-15 14:00:00	AMZN	Stock	16.515	16.6005	16.503	16.5845	6028360.0
2014-08-15 15:00:00	AMZN	Stock	16.585	16.6885	16.5685	16.6815	13433320.0
2014-08-15 16:00:00	AMZN	Stock	16.6815	16.682	16.5862	16.6782	1914540.0
2014-08-15 17:00:00	AMZN	Stock	16.657	16.657	16.657	16.657	2000.0

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

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