PREVIEW / stock_1hour / 2014-03-03

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-03.parquet
  size:    1.0 MB
  rows:    49,278
  symbols: 3,537

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-03-03 04:00:00	AAPL	Stock	18.6436	18.6436	18.5536	18.6229	161672.0
2014-03-03 05:00:00	AAPL	Stock	18.625	18.625	18.5893	18.6104	73500.0
2014-03-03 06:00:00	AAPL	Stock	18.5989	18.6411	18.5896	18.5896	105196.0
2014-03-03 07:00:00	AAPL	Stock	18.5821	18.6604	18.5821	18.6393	538664.0
2014-03-03 08:00:00	AAPL	Stock	18.6429	18.7943	18.5821	18.6714	1265796.0
2014-03-03 09:00:00	AAPL	Stock	18.6696	18.9518	18.6696	18.8771	48592180.0
2014-03-03 10:00:00	AAPL	Stock	18.8771	18.9186	18.775	18.8671	31343060.0
2014-03-03 11:00:00	AAPL	Stock	18.8718	18.8761	18.6907	18.6946	24088932.0
2014-03-03 12:00:00	AAPL	Stock	18.6962	18.7546	18.6718	18.7382	19985084.0
2014-03-03 13:00:00	AAPL	Stock	18.7414	18.8125	18.7332	18.7589	14527100.0
2014-03-03 14:00:00	AAPL	Stock	18.7589	18.8321	18.75	18.7857	14157248.0
2014-03-03 15:00:00	AAPL	Stock	18.7864	18.8486	18.7436	18.8486	28240380.0
2014-03-03 16:00:00	AAPL	Stock	18.8468	18.8546	18.7732	18.85	5208616.0
2014-03-03 17:00:00	AAPL	Stock	18.8436	18.8557	18.8414	18.8504	149464.0
2014-03-03 18:00:00	AAPL	Stock	18.8504	18.8589	18.8446	18.8546	200536.0
2014-03-03 19:00:00	AAPL	Stock	18.8518	18.8675	18.8504	18.8607	64680.0
2014-03-03 05:00:00	MSFT	Stock	37.91	37.91	37.91	37.91	100.0
2014-03-03 06:00:00	MSFT	Stock	37.93	37.94	37.93	37.94	2000.0
2014-03-03 07:00:00	MSFT	Stock	37.78	37.85	37.78	37.83	6742.0
2014-03-03 08:00:00	MSFT	Stock	37.78	37.89	37.78	37.87	17019.0
2014-03-03 09:00:00	MSFT	Stock	37.86	38.13	37.86	38.03	3514478.0
2014-03-03 10:00:00	MSFT	Stock	38.03	38.085	37.58	37.72	4031971.0
2014-03-03 11:00:00	MSFT	Stock	37.73	37.73	37.5	37.51	3226632.0
2014-03-03 12:00:00	MSFT	Stock	37.51	37.65	37.495	37.629	3244261.0
2014-03-03 13:00:00	MSFT	Stock	37.62	37.73	37.58	37.67	2221196.0
2014-03-03 14:00:00	MSFT	Stock	37.67	37.81	37.625	37.7	2380218.0
2014-03-03 15:00:00	MSFT	Stock	37.69	37.78	37.61	37.78	7556323.0
2014-03-03 16:00:00	MSFT	Stock	37.78	37.83	37.5	37.76	1818989.0
2014-03-03 17:00:00	MSFT	Stock	37.75	37.75	37.75	37.75	1300.0
2014-03-03 18:00:00	MSFT	Stock	37.78	37.78	37.78	37.78	8930.0
2014-03-03 19:00:00	MSFT	Stock	37.8	37.8	37.8	37.8	209.0
2014-03-03 09:00:00	NVDA	Stock	0.454	0.456	0.4452	0.4545	68766560.0
2014-03-03 10:00:00	NVDA	Stock	0.4545	0.4552	0.4499	0.4524	76810360.0
2014-03-03 11:00:00	NVDA	Stock	0.4522	0.4535	0.4498	0.4502	50102080.0
2014-03-03 12:00:00	NVDA	Stock	0.4502	0.4546	0.4501	0.4544	30337760.0
2014-03-03 13:00:00	NVDA	Stock	0.4544	0.4562	0.454	0.4553	36545320.0
2014-03-03 14:00:00	NVDA	Stock	0.4555	0.4571	0.4545	0.4552	29258720.0
2014-03-03 15:00:00	NVDA	Stock	0.4554	0.4572	0.4539	0.4572	55522000.0
2014-03-03 16:00:00	NVDA	Stock	0.4572	0.4572	0.4572	0.4572	990160.0
2014-03-03 04:00:00	AMZN	Stock	17.768	17.773	17.7635	17.773	11740.0
2014-03-03 05:00:00	AMZN	Stock	17.812	17.812	17.812	17.812	2000.0
2014-03-03 06:00:00	AMZN	Stock	17.787	17.79	17.75	17.75	23240.0
2014-03-03 07:00:00	AMZN	Stock	17.8	17.875	17.793	17.825	67220.0
2014-03-03 08:00:00	AMZN	Stock	17.8865	18.105	17.86	17.8885	229080.0
2014-03-03 09:00:00	AMZN	Stock	17.8895	18.048	17.8875	17.9815	8382780.0
2014-03-03 10:00:00	AMZN	Stock	17.9762	18.0061	17.8275	17.9375	11008520.0
2014-03-03 11:00:00	AMZN	Stock	17.9365	17.942	17.8	17.809	6091560.0
2014-03-03 12:00:00	AMZN	Stock	17.802	17.8655	17.724	17.8578	6077440.0
2014-03-03 13:00:00	AMZN	Stock	17.859	17.922	17.8505	17.8995	3820660.0
2014-03-03 14:00:00	AMZN	Stock	17.896	17.9895	17.8765	17.957	4206220.0

> showing 50 of 49,278 rows — these rows as CSV

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