PREVIEW / stock_1hour / 2013-07-29

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-29.parquet
  size:    993 KB
  rows:    46,096
  symbols: 3,504

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-07-29 04:00:00	AAPL	Stock	15.7661	15.7661	15.75	15.75	11200.0
2013-07-29 05:00:00	AAPL	Stock	15.7571	15.7571	15.7571	15.7571	2800.0
2013-07-29 06:00:00	AAPL	Stock	15.75	15.75	15.75	15.75	2800.0
2013-07-29 07:00:00	AAPL	Stock	15.7571	15.7679	15.7136	15.7289	133644.0
2013-07-29 08:00:00	AAPL	Stock	15.7429	15.7843	15.7143	15.7268	337736.0
2013-07-29 09:00:00	AAPL	Stock	15.7221	16.0264	15.7168	16.0032	65463496.0
2013-07-29 10:00:00	AAPL	Stock	16.0051	16.0279	15.9529	15.9891	38221764.0
2013-07-29 11:00:00	AAPL	Stock	15.9907	16.0054	15.9364	15.9661	23927148.0
2013-07-29 12:00:00	AAPL	Stock	15.9679	16.0021	15.9579	16.0011	15579144.0
2013-07-29 13:00:00	AAPL	Stock	16.0007	16.0154	15.95	15.9879	17242848.0
2013-07-29 14:00:00	AAPL	Stock	15.9864	16.0536	15.9864	16.0445	26985924.0
2013-07-29 15:00:00	AAPL	Stock	16.0432	16.0711	15.9839	15.9925	46197424.0
2013-07-29 16:00:00	AAPL	Stock	15.9925	16.0651	15.9693	16.0321	10691408.0
2013-07-29 17:00:00	AAPL	Stock	16.0221	16.0268	15.7496	16.0107	100520.0
2013-07-29 18:00:00	AAPL	Stock	16.0146	16.0211	16.0107	16.0179	86968.0
2013-07-29 19:00:00	AAPL	Stock	16.0282	16.0329	16.0196	16.0329	268856.0
2013-07-29 04:00:00	MSFT	Stock	31.56	31.56	31.56	31.56	200.0
2013-07-29 05:00:00	MSFT	Stock	31.56	31.56	31.56	31.56	100.0
2013-07-29 06:00:00	MSFT	Stock	31.51	31.51	31.49	31.49	1600.0
2013-07-29 07:00:00	MSFT	Stock	31.44	31.46	31.4	31.46	4737.0
2013-07-29 08:00:00	MSFT	Stock	31.46	31.51	31.41	31.46	7786.0
2013-07-29 09:00:00	MSFT	Stock	31.44	31.6	31.4	31.57	3597358.0
2013-07-29 10:00:00	MSFT	Stock	31.56	31.59	31.45	31.56	4907168.0
2013-07-29 11:00:00	MSFT	Stock	31.55	31.58	31.41	31.44	4153405.0
2013-07-29 12:00:00	MSFT	Stock	31.445	31.5	31.4	31.49	2813825.0
2013-07-29 13:00:00	MSFT	Stock	31.495	31.55	31.46	31.536	3496183.0
2013-07-29 14:00:00	MSFT	Stock	31.535	31.6	31.53	31.54	2259199.0
2013-07-29 15:00:00	MSFT	Stock	31.535	31.58	31.48	31.56	4479224.0
2013-07-29 16:00:00	MSFT	Stock	31.54	31.56	31.483	31.52	1573177.0
2013-07-29 17:00:00	MSFT	Stock	31.54	31.62	31.54	31.54	102873.0
2013-07-29 18:00:00	MSFT	Stock	31.5	31.54	31.5	31.54	210.0
2013-07-29 19:00:00	MSFT	Stock	31.54	31.54	31.54	31.54	700.0
2013-07-29 09:00:00	NVDA	Stock	0.3542	0.3575	0.3533	0.3575	15980080.0
2013-07-29 10:00:00	NVDA	Stock	0.3575	0.3588	0.3555	0.358	35700680.0
2013-07-29 11:00:00	NVDA	Stock	0.358	0.3582	0.356	0.3562	26538600.0
2013-07-29 12:00:00	NVDA	Stock	0.3562	0.3582	0.356	0.3576	12652040.0
2013-07-29 13:00:00	NVDA	Stock	0.3576	0.3582	0.357	0.357	9590000.0
2013-07-29 14:00:00	NVDA	Stock	0.357	0.358	0.3562	0.3562	8896840.0
2013-07-29 15:00:00	NVDA	Stock	0.3562	0.3565	0.3538	0.3542	57423600.0
2013-07-29 16:00:00	NVDA	Stock	0.3542	0.3553	0.3542	0.3542	11391280.0
2013-07-29 07:00:00	AMZN	Stock	15.5775	15.5775	15.5505	15.5515	10140.0
2013-07-29 08:00:00	AMZN	Stock	15.5515	15.588	15.54	15.556	120580.0
2013-07-29 09:00:00	AMZN	Stock	15.5535	15.65	15.485	15.5125	14808360.0
2013-07-29 10:00:00	AMZN	Stock	15.512	15.5365	15.4385	15.5245	10852380.0
2013-07-29 11:00:00	AMZN	Stock	15.525	15.547	15.3625	15.3735	9935680.0
2013-07-29 12:00:00	AMZN	Stock	15.3735	15.4156	15.3575	15.364	4874540.0
2013-07-29 13:00:00	AMZN	Stock	15.359	15.3765	15.295	15.3385	5975380.0
2013-07-29 14:00:00	AMZN	Stock	15.342	15.3825	15.314	15.3175	5954240.0
2013-07-29 15:00:00	AMZN	Stock	15.3208	15.3483	15.2955	15.305	9282060.0
2013-07-29 16:00:00	AMZN	Stock	15.305	15.4605	15.305	15.316	2340160.0

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

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