PREVIEW / stock_1hour / 2014-05-20

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-20.parquet
  size:    1.0 MB
  rows:    48,913
  symbols: 3,541

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
2014-05-20 04:00:00	AAPL	Stock	21.6071	21.6071	21.6071	21.6071	2800.0
2014-05-20 05:00:00	AAPL	Stock	21.5996	21.6296	21.5996	21.6296	16800.0
2014-05-20 06:00:00	AAPL	Stock	21.6507	21.6604	21.6161	21.6561	109200.0
2014-05-20 07:00:00	AAPL	Stock	21.6482	21.6625	21.6061	21.6061	312396.0
2014-05-20 08:00:00	AAPL	Stock	21.6036	21.6554	21.56	21.5982	497980.0
2014-05-20 09:00:00	AAPL	Stock	21.5989	21.6393	21.5361	21.5821	34070568.0
2014-05-20 10:00:00	AAPL	Stock	21.5843	21.65	21.5611	21.6343	42658392.0
2014-05-20 11:00:00	AAPL	Stock	21.6332	21.6571	21.5718	21.6468	17277008.0
2014-05-20 12:00:00	AAPL	Stock	21.6536	21.6536	21.5639	21.5871	14238756.0
2014-05-20 13:00:00	AAPL	Stock	21.5893	21.5911	21.4546	21.4661	26640628.0
2014-05-20 14:00:00	AAPL	Stock	21.4661	21.54	21.4661	21.5036	17144008.0
2014-05-20 15:00:00	AAPL	Stock	21.5032	21.6071	21.4914	21.5932	30966488.0
2014-05-20 16:00:00	AAPL	Stock	21.5911	21.5968	21.5761	21.5839	9658740.0
2014-05-20 17:00:00	AAPL	Stock	21.5811	21.5918	21.5768	21.5804	1273720.0
2014-05-20 18:00:00	AAPL	Stock	21.585	21.5911	21.5439	21.5454	530936.0
2014-05-20 19:00:00	AAPL	Stock	21.5443	21.5454	21.5243	21.5375	243796.0
2014-05-20 04:00:00	MSFT	Stock	39.65	39.65	39.65	39.65	500.0
2014-05-20 05:00:00	MSFT	Stock	39.65	39.65	39.65	39.65	500.0
2014-05-20 07:00:00	MSFT	Stock	39.61	39.61	39.6	39.6	1300.0
2014-05-20 08:00:00	MSFT	Stock	39.74	39.74	39.59	39.65	7450.0
2014-05-20 09:00:00	MSFT	Stock	39.63	39.94	39.52	39.6	2277292.0
2014-05-20 10:00:00	MSFT	Stock	39.6	39.69	39.58	39.68	1928447.0
2014-05-20 11:00:00	MSFT	Stock	39.68	39.74	39.622	39.72	2088141.0
2014-05-20 12:00:00	MSFT	Stock	39.72	39.73	39.52	39.61	1971385.0
2014-05-20 13:00:00	MSFT	Stock	39.6	39.625	39.46	39.548	3067358.0
2014-05-20 14:00:00	MSFT	Stock	39.54	39.75	39.54	39.65	2304940.0
2014-05-20 15:00:00	MSFT	Stock	39.645	39.8	39.62	39.69	4749371.0
2014-05-20 16:00:00	MSFT	Stock	39.68	39.72	39.648	39.65	1994881.0
2014-05-20 17:00:00	MSFT	Stock	39.65	39.68	39.6	39.6	116290.0
2014-05-20 18:00:00	MSFT	Stock	39.61	39.61	39.6	39.6	1000.0
2014-05-20 19:00:00	MSFT	Stock	39.61	39.61	39.6	39.6	1405.0
2014-05-20 08:00:00	NVDA	Stock	0.4643	0.4645	0.4635	0.4635	48000.0
2014-05-20 09:00:00	NVDA	Stock	0.4615	0.4628	0.4572	0.4585	30048640.0
2014-05-20 10:00:00	NVDA	Stock	0.4588	0.4603	0.4562	0.46	32167600.0
2014-05-20 11:00:00	NVDA	Stock	0.46	0.461	0.4588	0.4604	26176200.0
2014-05-20 12:00:00	NVDA	Stock	0.4605	0.4608	0.4571	0.4585	17574680.0
2014-05-20 13:00:00	NVDA	Stock	0.4582	0.4584	0.4538	0.4544	24919360.0
2014-05-20 14:00:00	NVDA	Stock	0.4544	0.4578	0.4544	0.4575	34871680.0
2014-05-20 15:00:00	NVDA	Stock	0.4578	0.458	0.4558	0.456	68837800.0
2014-05-20 16:00:00	NVDA	Stock	0.456	0.4609	0.4559	0.4572	16706120.0
2014-05-20 17:00:00	NVDA	Stock	0.456	0.456	0.456	0.456	282880.0
2014-05-20 08:00:00	AMZN	Stock	14.85	14.8685	14.835	14.839	18000.0
2014-05-20 09:00:00	AMZN	Stock	14.829	14.968	14.829	14.937	10337280.0
2014-05-20 10:00:00	AMZN	Stock	14.943	15.212	14.9075	15.2015	20803180.0
2014-05-20 11:00:00	AMZN	Stock	15.199	15.223	15.08	15.1595	9956760.0
2014-05-20 12:00:00	AMZN	Stock	15.162	15.162	15.0325	15.099	7353480.0
2014-05-20 13:00:00	AMZN	Stock	15.1007	15.1007	14.9626	14.9743	6470460.0
2014-05-20 14:00:00	AMZN	Stock	14.9794	15.065	14.9475	14.9665	5143040.0
2014-05-20 15:00:00	AMZN	Stock	14.971	15.086	14.9705	15.06	10656440.0
2014-05-20 16:00:00	AMZN	Stock	15.0595	15.1323	15.0446	15.0595	3692880.0

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

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