PREVIEW / stock_1hour / 2016-09-09

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-09.parquet
  size:    1.1 MB
  rows:    49,528
  symbols: 3,251

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
2016-09-09 04:00:00	AAPL	Stock	26.3475	26.3575	26.325	26.35	6052.0
2016-09-09 05:00:00	AAPL	Stock	26.35	26.35	26.35	26.35	1744.0
2016-09-09 06:00:00	AAPL	Stock	26.3575	26.3575	26.2925	26.3475	9856.0
2016-09-09 07:00:00	AAPL	Stock	26.32	26.325	26.2375	26.2875	134180.0
2016-09-09 08:00:00	AAPL	Stock	26.2675	26.3125	26.2	26.22	730776.0
2016-09-09 09:00:00	AAPL	Stock	26.225	26.43	26.1125	26.2812	26903880.0
2016-09-09 10:00:00	AAPL	Stock	26.2812	26.3325	26.1775	26.2262	19924092.0
2016-09-09 11:00:00	AAPL	Stock	26.226	26.2375	26.0325	26.0562	19657144.0
2016-09-09 12:00:00	AAPL	Stock	26.055	26.06	25.8875	25.9725	23821208.0
2016-09-09 13:00:00	AAPL	Stock	25.9712	25.9875	25.8375	25.8425	13413832.0
2016-09-09 14:00:00	AAPL	Stock	25.8428	25.9525	25.7975	25.935	18927172.0
2016-09-09 15:00:00	AAPL	Stock	25.935	26.005	25.785	25.785	31239848.0
2016-09-09 16:00:00	AAPL	Stock	25.785	30.6338	25.7775	25.8075	16479108.0
2016-09-09 17:00:00	AAPL	Stock	25.8075	25.8375	25.79	25.81	225056.0
2016-09-09 18:00:00	AAPL	Stock	25.8	25.81	25.7675	25.7675	98108.0
2016-09-09 19:00:00	AAPL	Stock	25.765	25.7725	25.7	25.7	171932.0
2016-09-09 07:00:00	MSFT	Stock	57.21	57.21	57.21	57.21	300.0
2016-09-09 08:00:00	MSFT	Stock	57.2	57.2	57.05	57.05	22414.0
2016-09-09 09:00:00	MSFT	Stock	57.05	57.27	56.73	57.261	3571290.0
2016-09-09 10:00:00	MSFT	Stock	57.28	57.52	57.11	57.18	2973411.0
2016-09-09 11:00:00	MSFT	Stock	57.18	57.28	56.95	56.985	2595693.0
2016-09-09 12:00:00	MSFT	Stock	56.985	57.065	56.82	56.91	2729291.0
2016-09-09 13:00:00	MSFT	Stock	56.915	56.94	56.66	56.71	2645849.0
2016-09-09 14:00:00	MSFT	Stock	56.715	56.78	56.44	56.66	4017992.0
2016-09-09 15:00:00	MSFT	Stock	56.67	56.72	56.21	56.22	7821300.0
2016-09-09 16:00:00	MSFT	Stock	56.22	56.4	56.21	56.23	6366046.0
2016-09-09 17:00:00	MSFT	Stock	56.4	56.4	56.21	56.25	17698.0
2016-09-09 18:00:00	MSFT	Stock	56.25	56.25	56.21	56.21	15562.0
2016-09-09 19:00:00	MSFT	Stock	56.22	56.26	56.21	56.21	13748.0
2016-09-09 04:00:00	NVDA	Stock	1.5675	1.5675	1.5675	1.5675	4000.0
2016-09-09 07:00:00	NVDA	Stock	1.5688	1.5688	1.5638	1.5638	46000.0
2016-09-09 08:00:00	NVDA	Stock	1.561	1.561	1.5512	1.5512	104560.0
2016-09-09 09:00:00	NVDA	Stock	1.5512	1.5575	1.5338	1.5428	48347960.0
2016-09-09 10:00:00	NVDA	Stock	1.5428	1.5453	1.5258	1.529	70115640.0
2016-09-09 11:00:00	NVDA	Stock	1.5291	1.5293	1.5125	1.5135	88330600.0
2016-09-09 12:00:00	NVDA	Stock	1.5134	1.5168	1.504	1.509	88110240.0
2016-09-09 13:00:00	NVDA	Stock	1.5091	1.5096	1.475	1.4858	98530080.0
2016-09-09 14:00:00	NVDA	Stock	1.486	1.5026	1.4754	1.5012	104602480.0
2016-09-09 15:00:00	NVDA	Stock	1.5012	1.5045	1.4878	1.4882	130820320.0
2016-09-09 16:00:00	NVDA	Stock	1.488	1.49	1.4875	1.4875	20789680.0
2016-09-09 17:00:00	NVDA	Stock	1.485	1.49	1.485	1.487	60240.0
2016-09-09 18:00:00	NVDA	Stock	1.487	1.487	1.4838	1.4845	87200.0
2016-09-09 19:00:00	NVDA	Stock	1.4862	1.4862	1.4845	1.4845	105800.0
2016-09-09 04:00:00	AMZN	Stock	39.112	39.112	39.112	39.112	6000.0
2016-09-09 06:00:00	AMZN	Stock	39.137	39.137	39.137	39.137	2000.0
2016-09-09 08:00:00	AMZN	Stock	39.0585	39.08	38.95	38.992	178180.0
2016-09-09 09:00:00	AMZN	Stock	38.9915	39.05	38.9115	38.9435	6049860.0
2016-09-09 10:00:00	AMZN	Stock	38.9345	38.9755	38.7765	38.8195	9381620.0
2016-09-09 11:00:00	AMZN	Stock	38.815	38.8255	38.6095	38.625	9463160.0
2016-09-09 12:00:00	AMZN	Stock	38.6258	38.6565	38.3645	38.4315	11568140.0

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

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