PREVIEW / stock_1hour / 2014-06-03

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-03.parquet
  size:    1.0 MB
  rows:    47,887
  symbols: 3,530

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-06-03 04:00:00	AAPL	Stock	22.3464	22.3464	22.3232	22.3232	11200.0
2014-06-03 05:00:00	AAPL	Stock	22.3214	22.3361	22.3214	22.3271	22428.0
2014-06-03 06:00:00	AAPL	Stock	22.3325	22.3571	22.3304	22.3571	42364.0
2014-06-03 07:00:00	AAPL	Stock	22.3571	22.3711	22.3296	22.35	284984.0
2014-06-03 08:00:00	AAPL	Stock	22.3554	22.4479	22.3325	22.4239	1192072.0
2014-06-03 09:00:00	AAPL	Stock	22.4239	22.78	22.4221	22.7551	66691408.0
2014-06-03 10:00:00	AAPL	Stock	22.7571	22.8121	22.6575	22.7071	48920956.0
2014-06-03 11:00:00	AAPL	Stock	22.7093	22.7136	22.575	22.6479	31794280.0
2014-06-03 12:00:00	AAPL	Stock	22.6479	22.7446	22.6443	22.645	15900248.0
2014-06-03 13:00:00	AAPL	Stock	22.6478	22.7714	22.6454	22.725	18747484.0
2014-06-03 14:00:00	AAPL	Stock	22.7307	22.7636	22.6871	22.6954	15281504.0
2014-06-03 15:00:00	AAPL	Stock	22.6961	22.7896	22.6871	22.7693	31225712.0
2014-06-03 16:00:00	AAPL	Stock	22.7693	22.7818	22.4409	22.78	6555220.0
2014-06-03 17:00:00	AAPL	Stock	22.775	22.8036	22.7693	22.8036	378504.0
2014-06-03 18:00:00	AAPL	Stock	22.7971	22.8032	22.7814	22.7839	132636.0
2014-06-03 19:00:00	AAPL	Stock	22.7893	22.8025	22.7857	22.7932	52668.0
2014-06-03 05:00:00	MSFT	Stock	40.7	40.7	40.57	40.63	500.0
2014-06-03 06:00:00	MSFT	Stock	40.72	40.72	40.72	40.72	100.0
2014-06-03 07:00:00	MSFT	Stock	40.64	40.7	40.64	40.7	700.0
2014-06-03 08:00:00	MSFT	Stock	40.71	40.71	40.65	40.65	300.0
2014-06-03 09:00:00	MSFT	Stock	40.69	40.71	40.35	40.46	2572690.0
2014-06-03 10:00:00	MSFT	Stock	40.47	40.525	40.29	40.35	2681674.0
2014-06-03 11:00:00	MSFT	Stock	40.35	40.4	40.31	40.374	1545749.0
2014-06-03 12:00:00	MSFT	Stock	40.38	40.45	40.32	40.35	1256178.0
2014-06-03 13:00:00	MSFT	Stock	40.345	40.42	40.33	40.35	1003809.0
2014-06-03 14:00:00	MSFT	Stock	40.35	40.42	40.31	40.31	1599333.0
2014-06-03 15:00:00	MSFT	Stock	40.315	40.32	40.25	40.28	4050691.0
2014-06-03 16:00:00	MSFT	Stock	40.29	40.79	40.28	40.36	2005169.0
2014-06-03 17:00:00	MSFT	Stock	40.29	40.32	40.29	40.32	35222.0
2014-06-03 18:00:00	MSFT	Stock	40.32	40.32	40.31	40.32	2300.0
2014-06-03 19:00:00	MSFT	Stock	40.32	40.32	40.32	40.32	700.0
2014-06-03 08:00:00	NVDA	Stock	0.4735	0.4735	0.4735	0.4735	1588000.0
2014-06-03 09:00:00	NVDA	Stock	0.4755	0.4755	0.4708	0.4725	14533600.0
2014-06-03 10:00:00	NVDA	Stock	0.4725	0.4735	0.4695	0.4713	54062440.0
2014-06-03 11:00:00	NVDA	Stock	0.4713	0.4714	0.4655	0.467	37422040.0
2014-06-03 12:00:00	NVDA	Stock	0.467	0.4675	0.4652	0.4666	27711960.0
2014-06-03 13:00:00	NVDA	Stock	0.4665	0.4698	0.466	0.4698	36337440.0
2014-06-03 14:00:00	NVDA	Stock	0.4695	0.471	0.4692	0.4706	11323800.0
2014-06-03 15:00:00	NVDA	Stock	0.4706	0.4723	0.47	0.4715	35927480.0
2014-06-03 16:00:00	NVDA	Stock	0.4715	0.4718	0.4684	0.4684	17818280.0
2014-06-03 05:00:00	AMZN	Stock	15.45	15.45	15.45	15.45	2000.0
2014-06-03 08:00:00	AMZN	Stock	15.4	15.4	15.35	15.365	88800.0
2014-06-03 09:00:00	AMZN	Stock	15.365	15.396	15.255	15.373	9918740.0
2014-06-03 10:00:00	AMZN	Stock	15.3685	15.375	15.267	15.2871	8187140.0
2014-06-03 11:00:00	AMZN	Stock	15.295	15.336	15.2535	15.3168	7760580.0
2014-06-03 12:00:00	AMZN	Stock	15.321	15.3625	15.2935	15.314	4844840.0
2014-06-03 13:00:00	AMZN	Stock	15.3135	15.3575	15.313	15.328	2145260.0
2014-06-03 14:00:00	AMZN	Stock	15.328	15.344	15.2905	15.3074	3060680.0
2014-06-03 15:00:00	AMZN	Stock	15.314	15.3685	15.3	15.3575	6501120.0
2014-06-03 16:00:00	AMZN	Stock	15.3595	15.442	15.3034	15.3034	703180.0

> showing 50 of 47,887 rows — these rows as CSV

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