PREVIEW / stock_1hour / 2013-05-22

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-22.parquet
  size:    1023 KB
  rows:    46,637
  symbols: 3,523

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
2013-05-22 04:00:00	AAPL	Stock	15.7246	15.7246	15.7246	15.7246	8400.0
2013-05-22 05:00:00	AAPL	Stock	15.725	15.7818	15.725	15.7271	8400.0
2013-05-22 07:00:00	AAPL	Stock	15.7729	15.7946	15.7593	15.7946	303520.0
2013-05-22 08:00:00	AAPL	Stock	15.785	15.8929	15.6536	15.8682	2910460.0
2013-05-22 09:00:00	AAPL	Stock	15.8668	16.0125	15.8446	15.9661	87016524.0
2013-05-22 10:00:00	AAPL	Stock	15.9696	16.0064	15.7921	15.8343	90724816.0
2013-05-22 11:00:00	AAPL	Stock	15.8271	15.9479	15.8036	15.9136	62111672.0
2013-05-22 12:00:00	AAPL	Stock	15.9132	15.9425	15.8571	15.9171	28075740.0
2013-05-22 13:00:00	AAPL	Stock	15.9132	15.9171	15.7807	15.8446	40707632.0
2013-05-22 14:00:00	AAPL	Stock	15.8446	15.8679	15.6739	15.7622	62444256.0
2013-05-22 15:00:00	AAPL	Stock	15.7604	15.7668	15.6507	15.7636	53253928.0
2013-05-22 16:00:00	AAPL	Stock	15.7636	15.9604	15.7021	15.7911	10730748.0
2013-05-22 17:00:00	AAPL	Stock	15.7907	15.7943	15.7636	15.7714	596288.0
2013-05-22 18:00:00	AAPL	Stock	15.7721	15.7768	15.7021	15.7714	250684.0
2013-05-22 19:00:00	AAPL	Stock	15.7829	15.7857	15.7768	15.7857	99512.0
2013-05-22 06:00:00	MSFT	Stock	34.85	34.85	34.85	34.85	550.0
2013-05-22 07:00:00	MSFT	Stock	34.89	34.92	34.89	34.92	1576.0
2013-05-22 08:00:00	MSFT	Stock	34.81	34.91	34.75	34.9	28944.0
2013-05-22 09:00:00	MSFT	Stock	34.88	34.97	34.38	34.53	6763917.0
2013-05-22 10:00:00	MSFT	Stock	34.53	34.82	34.36	34.45	10503031.0
2013-05-22 11:00:00	MSFT	Stock	34.45	34.81	34.44	34.75	9275917.0
2013-05-22 12:00:00	MSFT	Stock	34.753	34.79	34.69	34.74	4663308.0
2013-05-22 13:00:00	MSFT	Stock	34.74	34.75	34.55	34.564	5485077.0
2013-05-22 14:00:00	MSFT	Stock	34.56	34.64	34.45	34.63	8720847.0
2013-05-22 15:00:00	MSFT	Stock	34.62	34.625	34.42	34.61	10605917.0
2013-05-22 16:00:00	MSFT	Stock	34.61	34.85	34.457	34.75	3882347.0
2013-05-22 17:00:00	MSFT	Stock	34.74	34.77	34.61	34.73	82510.0
2013-05-22 18:00:00	MSFT	Stock	34.73	34.85	34.67	34.67	6404.0
2013-05-22 19:00:00	MSFT	Stock	34.67	34.67	34.67	34.67	1333.0
2013-05-22 08:00:00	NVDA	Stock	0.373	0.373	0.373	0.373	40000.0
2013-05-22 09:00:00	NVDA	Stock	0.374	0.3745	0.3688	0.3708	25714200.0
2013-05-22 10:00:00	NVDA	Stock	0.371	0.3733	0.3682	0.3695	96534040.0
2013-05-22 11:00:00	NVDA	Stock	0.3692	0.3704	0.3678	0.3698	38185360.0
2013-05-22 12:00:00	NVDA	Stock	0.3698	0.37	0.3678	0.3699	43164040.0
2013-05-22 13:00:00	NVDA	Stock	0.3698	0.3699	0.366	0.3662	39521720.0
2013-05-22 14:00:00	NVDA	Stock	0.3662	0.367	0.3605	0.3618	91395080.0
2013-05-22 15:00:00	NVDA	Stock	0.3618	0.3618	0.3585	0.36	126173520.0
2013-05-22 16:00:00	NVDA	Stock	0.36	0.3608	0.3583	0.36	3639760.0
2013-05-22 17:00:00	NVDA	Stock	0.36	0.36	0.36	0.36	214680.0
2013-05-22 18:00:00	NVDA	Stock	0.3605	0.3605	0.3605	0.3605	6000.0
2013-05-22 19:00:00	NVDA	Stock	0.3622	0.3622	0.3622	0.3622	4000.0
2013-05-22 08:00:00	AMZN	Stock	13.405	13.51	13.405	13.4595	103480.0
2013-05-22 09:00:00	AMZN	Stock	13.455	13.4745	13.2555	13.278	9065460.0
2013-05-22 10:00:00	AMZN	Stock	13.2701	13.349	13.202	13.2295	11294960.0
2013-05-22 11:00:00	AMZN	Stock	13.2295	13.361	13.2185	13.347	7014020.0
2013-05-22 12:00:00	AMZN	Stock	13.347	13.3525	13.292	13.322	3547680.0
2013-05-22 13:00:00	AMZN	Stock	13.3205	13.325	13.1685	13.1955	7493980.0
2013-05-22 14:00:00	AMZN	Stock	13.1975	13.2235	13.062	13.138	10240360.0
2013-05-22 15:00:00	AMZN	Stock	13.1345	13.1605	13.04	13.1575	13297020.0
2013-05-22 16:00:00	AMZN	Stock	13.148	13.2879	13.09	13.148	2759320.0

> showing 50 of 46,637 rows — these rows as CSV

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