PREVIEW / stock_1hour / 2011-07-29

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-29.parquet
  size:    950 KB
  rows:    44,831
  symbols: 3,549

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
2011-07-29 04:00:00	AAPL	Stock	13.9286	13.9332	13.8757	13.9036	61600.0
2011-07-29 05:00:00	AAPL	Stock	13.93	13.93	13.9161	13.9161	8400.0
2011-07-29 06:00:00	AAPL	Stock	13.9239	13.9239	13.875	13.875	25704.0
2011-07-29 07:00:00	AAPL	Stock	13.8904	13.9196	13.8857	13.9093	339920.0
2011-07-29 08:00:00	AAPL	Stock	13.9079	13.9429	13.8571	13.8646	5638164.0
2011-07-29 09:00:00	AAPL	Stock	13.8679	13.9143	13.7143	13.9054	101678528.0
2011-07-29 10:00:00	AAPL	Stock	13.9082	14.0671	13.8404	14.0589	128810360.0
2011-07-29 11:00:00	AAPL	Stock	14.0589	14.1125	13.9864	14.0246	111153980.0
2011-07-29 12:00:00	AAPL	Stock	14.0268	14.0454	13.9571	13.9768	55338640.0
2011-07-29 13:00:00	AAPL	Stock	13.9768	14.0561	13.9679	14.0296	48757492.0
2011-07-29 14:00:00	AAPL	Stock	14.0265	14.0618	14.0007	14.0089	44382968.0
2011-07-29 15:00:00	AAPL	Stock	14.0082	14.0186	13.9407	13.9533	103682236.0
2011-07-29 16:00:00	AAPL	Stock	13.9704	13.9894	13.9364	13.9375	22119496.0
2011-07-29 17:00:00	AAPL	Stock	13.9418	13.9771	13.9396	13.9729	403424.0
2011-07-29 18:00:00	AAPL	Stock	13.9725	13.9811	13.9457	13.9661	433216.0
2011-07-29 19:00:00	AAPL	Stock	13.9682	14.0	13.9646	13.9911	433384.0
2011-07-29 06:00:00	MSFT	Stock	27.51	27.51	27.51	27.51	200.0
2011-07-29 07:00:00	MSFT	Stock	27.53	27.56	27.48	27.49	7475.0
2011-07-29 08:00:00	MSFT	Stock	27.5	27.59	27.49	27.53	123609.0
2011-07-29 09:00:00	MSFT	Stock	27.53	27.62	27.36	27.56	6373603.0
2011-07-29 10:00:00	MSFT	Stock	27.56	27.63	27.26	27.535	15260258.0
2011-07-29 11:00:00	MSFT	Stock	27.53	27.71	27.47	27.534	7098172.0
2011-07-29 12:00:00	MSFT	Stock	27.54	27.57	27.45	27.48	5177539.0
2011-07-29 13:00:00	MSFT	Stock	27.48	27.59	27.44	27.56	4018531.0
2011-07-29 14:00:00	MSFT	Stock	27.56	27.59	27.44	27.502	5675651.0
2011-07-29 15:00:00	MSFT	Stock	27.5	27.56	27.39	27.42	18638049.0
2011-07-29 16:00:00	MSFT	Stock	27.42	27.52	27.25	27.36	39405014.0
2011-07-29 17:00:00	MSFT	Stock	27.32	27.44	27.32	27.4	23976.0
2011-07-29 18:00:00	MSFT	Stock	27.39	27.4	27.37	27.4	31578.0
2011-07-29 19:00:00	MSFT	Stock	27.4	27.4	27.4	27.4	52989.0
2011-07-29 08:00:00	NVDA	Stock	0.3418	0.3425	0.3413	0.3413	239880.0
2011-07-29 09:00:00	NVDA	Stock	0.3413	0.3478	0.3405	0.3475	106205640.0
2011-07-29 10:00:00	NVDA	Stock	0.3473	0.3478	0.341	0.3455	141986680.0
2011-07-29 11:00:00	NVDA	Stock	0.3453	0.3468	0.3435	0.3455	104213760.0
2011-07-29 12:00:00	NVDA	Stock	0.3458	0.346	0.3438	0.3445	74735840.0
2011-07-29 13:00:00	NVDA	Stock	0.3448	0.3482	0.3442	0.3482	61372640.0
2011-07-29 14:00:00	NVDA	Stock	0.348	0.349	0.3465	0.3471	60368440.0
2011-07-29 15:00:00	NVDA	Stock	0.347	0.3478	0.3453	0.3458	99210040.0
2011-07-29 16:00:00	NVDA	Stock	0.3455	0.3464	0.345	0.3464	27357480.0
2011-07-29 17:00:00	NVDA	Stock	0.3485	0.3485	0.3485	0.3485	12000.0
2011-07-29 18:00:00	NVDA	Stock	0.3462	0.3462	0.3462	0.3462	12000.0
2011-07-29 19:00:00	NVDA	Stock	0.3462	0.3462	0.3462	0.3462	30000.0
2011-07-29 04:00:00	AMZN	Stock	11.1755	11.18	11.15	11.18	6000.0
2011-07-29 07:00:00	AMZN	Stock	11.125	11.125	11.075	11.075	36000.0
2011-07-29 08:00:00	AMZN	Stock	11.0725	11.125	11.05	11.05	169280.0
2011-07-29 09:00:00	AMZN	Stock	11.0515	11.16	10.9755	11.0632	13382060.0
2011-07-29 10:00:00	AMZN	Stock	11.0632	11.245	11.01	11.237	15625480.0
2011-07-29 11:00:00	AMZN	Stock	11.2345	11.2875	11.1795	11.2245	13732740.0
2011-07-29 12:00:00	AMZN	Stock	11.2265	11.2315	11.128	11.1585	13495380.0
2011-07-29 13:00:00	AMZN	Stock	11.1585	11.199	11.146	11.179	8051680.0

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

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