PREVIEW / stock_1hour / 2012-07-18

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-18.parquet
  size:    938 KB
  rows:    45,215
  symbols: 3,480

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
2012-07-18 05:00:00	AAPL	Stock	21.6289	21.6289	21.625	21.6286	18200.0
2012-07-18 06:00:00	AAPL	Stock	21.6214	21.6214	21.6214	21.6214	11200.0
2012-07-18 07:00:00	AAPL	Stock	21.6429	21.6607	21.6071	21.6607	180992.0
2012-07-18 08:00:00	AAPL	Stock	21.6511	21.7	21.6375	21.6664	1086288.0
2012-07-18 09:00:00	AAPL	Stock	21.6607	21.7264	21.5993	21.6318	41844824.0
2012-07-18 10:00:00	AAPL	Stock	21.6336	21.7143	21.6114	21.6554	46897368.0
2012-07-18 11:00:00	AAPL	Stock	21.6518	21.6786	21.6186	21.6561	27227144.0
2012-07-18 12:00:00	AAPL	Stock	21.6586	21.6989	21.6307	21.6321	26298160.0
2012-07-18 13:00:00	AAPL	Stock	21.6321	21.6564	21.6071	21.6211	20981044.0
2012-07-18 14:00:00	AAPL	Stock	21.6261	21.6525	21.5557	21.5896	24759392.0
2012-07-18 15:00:00	AAPL	Stock	21.5921	21.6507	21.5743	21.6486	46932676.0
2012-07-18 16:00:00	AAPL	Stock	21.6491	21.7071	21.5032	21.6964	11017244.0
2012-07-18 17:00:00	AAPL	Stock	21.7007	21.7671	21.6521	21.7536	2581404.0
2012-07-18 18:00:00	AAPL	Stock	21.7568	21.7568	21.7321	21.7321	565908.0
2012-07-18 19:00:00	AAPL	Stock	21.7318	21.7357	21.7179	21.7321	393148.0
2012-07-18 07:00:00	MSFT	Stock	29.7	29.7	29.7	29.7	1000.0
2012-07-18 08:00:00	MSFT	Stock	29.68	29.78	29.66	29.67	33260.0
2012-07-18 09:00:00	MSFT	Stock	29.69	30.01	29.46	30.01	4031899.0
2012-07-18 10:00:00	MSFT	Stock	30.01	30.2	29.93	30.19	7231856.0
2012-07-18 11:00:00	MSFT	Stock	30.19	30.23	30.085	30.205	4642026.0
2012-07-18 12:00:00	MSFT	Stock	30.2	30.36	30.2	30.341	4134603.0
2012-07-18 13:00:00	MSFT	Stock	30.35	30.38	30.27	30.315	3448274.0
2012-07-18 14:00:00	MSFT	Stock	30.315	30.35	30.2	30.248	3890546.0
2012-07-18 15:00:00	MSFT	Stock	30.242	30.45	30.242	30.44	9927865.0
2012-07-18 16:00:00	MSFT	Stock	30.45	30.53	30.176	30.53	2733707.0
2012-07-18 17:00:00	MSFT	Stock	30.51	30.6	30.45	30.54	48998.0
2012-07-18 18:00:00	MSFT	Stock	30.55	30.6	30.5	30.54	9002.0
2012-07-18 19:00:00	MSFT	Stock	30.55	30.6	30.5	30.58	4425.0
2012-07-18 08:00:00	NVDA	Stock	0.3093	0.3093	0.3093	0.3093	260000.0
2012-07-18 09:00:00	NVDA	Stock	0.309	0.322	0.307	0.3193	108985800.0
2012-07-18 10:00:00	NVDA	Stock	0.3195	0.325	0.3183	0.3248	132036560.0
2012-07-18 11:00:00	NVDA	Stock	0.325	0.328	0.324	0.328	78857840.0
2012-07-18 12:00:00	NVDA	Stock	0.328	0.331	0.3278	0.3283	74586400.0
2012-07-18 13:00:00	NVDA	Stock	0.3284	0.3285	0.3265	0.3276	54904760.0
2012-07-18 14:00:00	NVDA	Stock	0.3278	0.3288	0.3253	0.3261	47082000.0
2012-07-18 15:00:00	NVDA	Stock	0.326	0.328	0.3258	0.3265	100210200.0
2012-07-18 16:00:00	NVDA	Stock	0.3263	0.328	0.324	0.3273	3706560.0
2012-07-18 17:00:00	NVDA	Stock	0.3265	0.3288	0.3265	0.3288	509280.0
2012-07-18 18:00:00	NVDA	Stock	0.3288	0.329	0.3288	0.3288	58000.0
2012-07-18 19:00:00	NVDA	Stock	0.3288	0.3293	0.3288	0.3293	80000.0
2012-07-18 08:00:00	AMZN	Stock	10.78	10.822	10.78	10.822	8000.0
2012-07-18 09:00:00	AMZN	Stock	10.801	10.9275	10.7855	10.856	5873880.0
2012-07-18 10:00:00	AMZN	Stock	10.862	10.871	10.7985	10.855	10418680.0
2012-07-18 11:00:00	AMZN	Stock	10.851	10.865	10.8255	10.853	5049340.0
2012-07-18 12:00:00	AMZN	Stock	10.855	10.9335	10.855	10.917	3940220.0
2012-07-18 13:00:00	AMZN	Stock	10.9175	10.9195	10.8575	10.8734	2982240.0
2012-07-18 14:00:00	AMZN	Stock	10.8705	10.893	10.838	10.8455	3621300.0
2012-07-18 15:00:00	AMZN	Stock	10.847	10.9125	10.846	10.877	7960440.0
2012-07-18 16:00:00	AMZN	Stock	10.8735	10.95	10.8651	10.95	1422220.0
2012-07-18 17:00:00	AMZN	Stock	10.96	11.01	10.95	11.0	417940.0

> showing 50 of 45,215 rows — these rows as CSV

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