PREVIEW / stock_1hour / 2012-06-22

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-22.parquet
  size:    1.0 MB
  rows:    48,612
  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
2012-06-22 05:00:00	AAPL	Stock	20.7	20.7	20.6964	20.6964	15400.0
2012-06-22 06:00:00	AAPL	Stock	20.6961	20.7	20.6961	20.7	36400.0
2012-06-22 07:00:00	AAPL	Stock	20.7036	20.7043	20.6518	20.695	242088.0
2012-06-22 08:00:00	AAPL	Stock	20.6893	20.7	20.63	20.6832	679168.0
2012-06-22 09:00:00	AAPL	Stock	20.6789	20.7232	20.6071	20.6489	45095288.0
2012-06-22 10:00:00	AAPL	Stock	20.6436	20.7139	20.5507	20.5735	51727312.0
2012-06-22 11:00:00	AAPL	Stock	20.5728	20.6506	20.5596	20.6189	31433584.0
2012-06-22 12:00:00	AAPL	Stock	20.6182	20.6493	20.5861	20.6361	21401408.0
2012-06-22 13:00:00	AAPL	Stock	20.6361	20.66	20.5982	20.66	18261936.0
2012-06-22 14:00:00	AAPL	Stock	20.6599	20.7211	20.6529	20.7204	29924048.0
2012-06-22 15:00:00	AAPL	Stock	20.72	20.7925	20.6796	20.7857	52081568.0
2012-06-22 16:00:00	AAPL	Stock	20.7857	20.7966	20.6153	20.7874	29396584.0
2012-06-22 17:00:00	AAPL	Stock	20.7525	20.7891	20.7518	20.7611	787024.0
2012-06-22 18:00:00	AAPL	Stock	20.7789	20.7864	20.7571	20.7586	663348.0
2012-06-22 19:00:00	AAPL	Stock	20.7579	20.7643	20.7536	20.7625	163548.0
2012-06-22 08:00:00	MSFT	Stock	30.27	30.38	30.2	30.34	19156.0
2012-06-22 09:00:00	MSFT	Stock	30.3	30.39	30.05	30.23	3671927.0
2012-06-22 10:00:00	MSFT	Stock	30.24	30.3	30.03	30.18	4703754.0
2012-06-22 11:00:00	MSFT	Stock	30.18	30.35	30.17	30.33	3242739.0
2012-06-22 12:00:00	MSFT	Stock	30.33	30.36	30.27	30.35	2876673.0
2012-06-22 13:00:00	MSFT	Stock	30.345	30.48	30.34	30.47	3080992.0
2012-06-22 14:00:00	MSFT	Stock	30.465	30.6	30.42	30.575	3930908.0
2012-06-22 15:00:00	MSFT	Stock	30.58	30.73	30.44	30.7	13209326.0
2012-06-22 16:00:00	MSFT	Stock	30.7	30.711	30.167	30.65	8548817.0
2012-06-22 17:00:00	MSFT	Stock	30.67	30.67	30.63	30.63	4150.0
2012-06-22 18:00:00	MSFT	Stock	30.67	30.696	30.66	30.696	71056.0
2012-06-22 19:00:00	MSFT	Stock	30.64	30.64	30.6	30.64	2370.0
2012-06-22 08:00:00	NVDA	Stock	0.325	0.3263	0.322	0.325	473200.0
2012-06-22 09:00:00	NVDA	Stock	0.3253	0.3315	0.323	0.3277	50685560.0
2012-06-22 10:00:00	NVDA	Stock	0.3275	0.3288	0.3243	0.3245	76659720.0
2012-06-22 11:00:00	NVDA	Stock	0.3245	0.3248	0.3205	0.3228	75172720.0
2012-06-22 12:00:00	NVDA	Stock	0.323	0.3238	0.322	0.3235	20019680.0
2012-06-22 13:00:00	NVDA	Stock	0.3235	0.3263	0.3233	0.3248	41229160.0
2012-06-22 14:00:00	NVDA	Stock	0.3248	0.3276	0.3248	0.3274	44843680.0
2012-06-22 15:00:00	NVDA	Stock	0.3273	0.3275	0.3243	0.3248	145616120.0
2012-06-22 16:00:00	NVDA	Stock	0.3245	0.3261	0.3225	0.3248	190588160.0
2012-06-22 17:00:00	NVDA	Stock	0.324	0.324	0.324	0.324	44000.0
2012-06-22 18:00:00	NVDA	Stock	0.3248	0.3248	0.3247	0.3248	16429880.0
2012-06-22 19:00:00	NVDA	Stock	0.324	0.324	0.324	0.324	4000.0
2012-06-22 08:00:00	AMZN	Stock	11.0505	11.0615	11.005	11.0575	402000.0
2012-06-22 09:00:00	AMZN	Stock	11.0355	11.1	10.9675	11.024	8727020.0
2012-06-22 10:00:00	AMZN	Stock	11.0295	11.0705	10.9755	11.0	8955460.0
2012-06-22 11:00:00	AMZN	Stock	10.9995	11.0494	10.9995	11.0365	4846020.0
2012-06-22 12:00:00	AMZN	Stock	11.038	11.0485	11.015	11.0265	2137640.0
2012-06-22 13:00:00	AMZN	Stock	11.026	11.035	11.0125	11.035	1671220.0
2012-06-22 14:00:00	AMZN	Stock	11.0355	11.0855	11.0345	11.0736	3529120.0
2012-06-22 15:00:00	AMZN	Stock	11.0746	11.1255	11.0743	11.1065	8975200.0
2012-06-22 16:00:00	AMZN	Stock	11.103	11.1235	11.0234	11.109	3654440.0
2012-06-22 17:00:00	AMZN	Stock	11.107	11.1121	11.1046	11.1046	129540.0
2012-06-22 18:00:00	AMZN	Stock	11.1136	11.1136	11.1056	11.1064	125180.0

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

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