PREVIEW / stock_1hour / 2012-05-15

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-15.parquet
  size:    944 KB
  rows:    44,867
  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
2012-05-15 04:00:00	AAPL	Stock	20.0521	20.105	20.0471	20.0714	95928.0
2012-05-15 05:00:00	AAPL	Stock	20.0714	20.0714	20.0643	20.0714	28616.0
2012-05-15 06:00:00	AAPL	Stock	20.0696	20.1143	20.0696	20.0893	68068.0
2012-05-15 07:00:00	AAPL	Stock	20.0807	20.125	20.0282	20.125	613060.0
2012-05-15 08:00:00	AAPL	Stock	20.1204	20.1357	20.0454	20.0454	3187828.0
2012-05-15 09:00:00	AAPL	Stock	20.0457	20.0643	19.8839	19.9568	73533348.0
2012-05-15 10:00:00	AAPL	Stock	19.9561	20.1025	19.8936	20.0005	91981064.0
2012-05-15 11:00:00	AAPL	Stock	20.0018	20.1021	19.9475	20.0507	46129832.0
2012-05-15 12:00:00	AAPL	Stock	20.0489	20.115	20.0171	20.0403	37488192.0
2012-05-15 13:00:00	AAPL	Stock	20.0389	20.0857	19.9643	19.9946	26521684.0
2012-05-15 14:00:00	AAPL	Stock	19.9993	20.045	19.9382	19.9461	29220044.0
2012-05-15 15:00:00	AAPL	Stock	19.9379	19.9411	19.7054	19.7532	123497388.0
2012-05-15 16:00:00	AAPL	Stock	19.7539	20.0689	19.7389	19.7568	33795020.0
2012-05-15 17:00:00	AAPL	Stock	19.7521	19.7554	19.7429	19.7496	259644.0
2012-05-15 18:00:00	AAPL	Stock	19.7464	19.7911	19.7457	19.7911	408436.0
2012-05-15 19:00:00	AAPL	Stock	19.7857	19.7979	19.75	19.7979	312396.0
2012-05-15 06:00:00	MSFT	Stock	30.92	30.92	30.88	30.88	300.0
2012-05-15 07:00:00	MSFT	Stock	30.8	30.8	30.77	30.78	11100.0
2012-05-15 08:00:00	MSFT	Stock	30.73	30.82	30.7	30.7	18311.0
2012-05-15 09:00:00	MSFT	Stock	30.69	30.77	30.56	30.72	3556085.0
2012-05-15 10:00:00	MSFT	Stock	30.72	30.77	30.54	30.685	7859290.0
2012-05-15 11:00:00	MSFT	Stock	30.69	30.795	30.45	30.77	5162989.0
2012-05-15 12:00:00	MSFT	Stock	30.775	30.78	30.63	30.642	4236398.0
2012-05-15 13:00:00	MSFT	Stock	30.65	30.665	30.465	30.52	4081706.0
2012-05-15 14:00:00	MSFT	Stock	30.52	30.7	30.47	30.48	4265414.0
2012-05-15 15:00:00	MSFT	Stock	30.48	30.482	30.15	30.2	18941500.0
2012-05-15 16:00:00	MSFT	Stock	30.21	30.72	30.18	30.22	13084363.0
2012-05-15 17:00:00	MSFT	Stock	30.22	30.25	30.22	30.24	2624.0
2012-05-15 18:00:00	MSFT	Stock	30.28	30.3	30.28	30.3	2900.0
2012-05-15 19:00:00	MSFT	Stock	30.29	30.38	30.29	30.38	4676.0
2012-05-15 07:00:00	NVDA	Stock	0.3315	0.3315	0.3315	0.3315	4000.0
2012-05-15 08:00:00	NVDA	Stock	0.332	0.3325	0.3315	0.3315	216000.0
2012-05-15 09:00:00	NVDA	Stock	0.332	0.3349	0.328	0.3342	97681600.0
2012-05-15 10:00:00	NVDA	Stock	0.3342	0.3355	0.3313	0.332	122304400.0
2012-05-15 11:00:00	NVDA	Stock	0.3322	0.3322	0.3293	0.3295	49250800.0
2012-05-15 12:00:00	NVDA	Stock	0.3295	0.331	0.3265	0.3275	48841400.0
2012-05-15 13:00:00	NVDA	Stock	0.3275	0.3303	0.3264	0.33	60944280.0
2012-05-15 14:00:00	NVDA	Stock	0.3303	0.3313	0.3288	0.3303	68893280.0
2012-05-15 15:00:00	NVDA	Stock	0.3303	0.3303	0.3235	0.3248	132227600.0
2012-05-15 16:00:00	NVDA	Stock	0.3248	0.3302	0.3245	0.3275	5136960.0
2012-05-15 17:00:00	NVDA	Stock	0.3263	0.3263	0.3263	0.3263	20040.0
2012-05-15 18:00:00	NVDA	Stock	0.3248	0.3248	0.3235	0.3238	55600.0
2012-05-15 19:00:00	NVDA	Stock	0.3248	0.3248	0.3248	0.3248	8000.0
2012-05-15 04:00:00	AMZN	Stock	11.255	11.255	11.255	11.255	2000.0
2012-05-15 05:00:00	AMZN	Stock	11.2945	11.2995	11.28	11.28	42000.0
2012-05-15 06:00:00	AMZN	Stock	11.312	11.337	11.3	11.337	68640.0
2012-05-15 07:00:00	AMZN	Stock	11.337	11.3445	11.3	11.3445	209200.0
2012-05-15 08:00:00	AMZN	Stock	11.3255	11.365	11.3	11.3415	1475440.0
2012-05-15 09:00:00	AMZN	Stock	11.3305	11.46	11.3	11.411	20568740.0
2012-05-15 10:00:00	AMZN	Stock	11.418	11.5305	11.404	11.5045	22714200.0

> showing 50 of 44,867 rows — these rows as CSV

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