PREVIEW / stock_1hour / 2015-07-27

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-27.parquet
  size:    1.0 MB
  rows:    49,046
  symbols: 3,490

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
2015-07-27 04:00:00	AAPL	Stock	31.125	31.15	31.075	31.1	35408.0
2015-07-27 05:00:00	AAPL	Stock	31.07	31.07	30.925	30.925	57820.0
2015-07-27 06:00:00	AAPL	Stock	30.9125	30.915	30.8	30.8775	211724.0
2015-07-27 07:00:00	AAPL	Stock	30.8775	30.8825	30.6875	30.775	475000.0
2015-07-27 08:00:00	AAPL	Stock	30.765	30.8775	30.7	30.7375	1073180.0
2015-07-27 09:00:00	AAPL	Stock	30.75	30.8325	30.53	30.8025	37679948.0
2015-07-27 10:00:00	AAPL	Stock	30.8	30.89	30.595	30.8362	28574656.0
2015-07-27 11:00:00	AAPL	Stock	30.8375	30.9025	30.69	30.7538	17714008.0
2015-07-27 12:00:00	AAPL	Stock	30.755	30.77	30.651	30.6875	11608892.0
2015-07-27 13:00:00	AAPL	Stock	30.6875	30.7725	30.6688	30.7525	12665952.0
2015-07-27 14:00:00	AAPL	Stock	30.755	30.8288	30.6875	30.7075	11494236.0
2015-07-27 15:00:00	AAPL	Stock	30.71	30.7375	30.615	30.725	28684648.0
2015-07-27 16:00:00	AAPL	Stock	30.7275	30.775	30.625	30.735	13340084.0
2015-07-27 17:00:00	AAPL	Stock	30.725	30.725	30.71	30.7168	67552.0
2015-07-27 18:00:00	AAPL	Stock	30.7175	30.7325	30.71	30.715	98816.0
2015-07-27 19:00:00	AAPL	Stock	30.715	30.735	30.71	30.7192	190856.0
2015-07-27 04:00:00	MSFT	Stock	46.3	46.3	46.3	46.3	100.0
2015-07-27 06:00:00	MSFT	Stock	46.1	46.15	46.02	46.13	1400.0
2015-07-27 07:00:00	MSFT	Stock	46.05	46.05	45.91	46.02	3150.0
2015-07-27 08:00:00	MSFT	Stock	46.05	46.05	45.93	45.99	29014.0
2015-07-27 09:00:00	MSFT	Stock	46.01	46.01	45.545	45.67	4094074.0
2015-07-27 10:00:00	MSFT	Stock	45.67	45.97	45.6	45.77	5727601.0
2015-07-27 11:00:00	MSFT	Stock	45.77	45.86	45.48	45.62	3658779.0
2015-07-27 12:00:00	MSFT	Stock	45.62	45.75	45.51	45.546	3997114.0
2015-07-27 13:00:00	MSFT	Stock	45.55	45.56	45.34	45.445	2954502.0
2015-07-27 14:00:00	MSFT	Stock	45.44	45.58	45.28	45.35	3327104.0
2015-07-27 15:00:00	MSFT	Stock	45.34	45.44	45.25	45.36	9753091.0
2015-07-27 16:00:00	MSFT	Stock	45.37	45.43	45.35	45.393	4277109.0
2015-07-27 17:00:00	MSFT	Stock	45.36	45.36	45.35	45.35	225300.0
2015-07-27 18:00:00	MSFT	Stock	45.43	45.43	45.43	45.43	2830.0
2015-07-27 19:00:00	MSFT	Stock	45.43	45.43	45.43	45.43	200.0
2015-07-27 09:00:00	NVDA	Stock	0.4838	0.4858	0.4772	0.484	25347160.0
2015-07-27 10:00:00	NVDA	Stock	0.4843	0.4883	0.4825	0.4845	29289360.0
2015-07-27 11:00:00	NVDA	Stock	0.4845	0.4866	0.4838	0.4845	23465280.0
2015-07-27 12:00:00	NVDA	Stock	0.4843	0.4852	0.4835	0.4845	11104200.0
2015-07-27 13:00:00	NVDA	Stock	0.4848	0.486	0.4843	0.4854	10579640.0
2015-07-27 14:00:00	NVDA	Stock	0.4852	0.4858	0.484	0.485	20571240.0
2015-07-27 15:00:00	NVDA	Stock	0.485	0.485	0.4805	0.483	55460080.0
2015-07-27 16:00:00	NVDA	Stock	0.4828	0.4829	0.4828	0.4828	9936000.0
2015-07-27 17:00:00	NVDA	Stock	0.4848	0.4848	0.4848	0.4848	2993640.0
2015-07-27 18:00:00	NVDA	Stock	0.485	0.485	0.485	0.485	8000.0
2015-07-27 04:00:00	AMZN	Stock	26.5	26.587	26.4995	26.583	49220.0
2015-07-27 05:00:00	AMZN	Stock	26.525	26.528	26.495	26.495	29800.0
2015-07-27 06:00:00	AMZN	Stock	26.4875	26.4875	26.35	26.3715	130020.0
2015-07-27 07:00:00	AMZN	Stock	26.3625	26.45	26.354	26.404	160360.0
2015-07-27 08:00:00	AMZN	Stock	26.405	26.482	26.303	26.42	1068720.0
2015-07-27 09:00:00	AMZN	Stock	26.401	27.1415	26.33	27.1025	32234440.0
2015-07-27 10:00:00	AMZN	Stock	27.09	27.2475	26.9	26.9478	27250340.0
2015-07-27 11:00:00	AMZN	Stock	26.9485	26.9865	26.7555	26.8305	15406480.0
2015-07-27 12:00:00	AMZN	Stock	26.8315	26.938	26.65	26.694	14707600.0

> showing 50 of 49,046 rows — these rows as CSV

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