PREVIEW / stock_1hour / 2016-09-08

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-08.parquet
  size:    1.0 MB
  rows:    48,713
  symbols: 3,245

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-08 04:00:00	AAPL	Stock	27.0525	27.06	26.95	26.9875	25600.0
2016-09-08 05:00:00	AAPL	Stock	26.975	26.9875	26.8975	26.9	84136.0
2016-09-08 06:00:00	AAPL	Stock	26.9075	26.9625	26.9	26.9375	52812.0
2016-09-08 07:00:00	AAPL	Stock	26.9375	27.0625	26.93	27.0	273104.0
2016-09-08 08:00:00	AAPL	Stock	27.0025	27.0625	26.9	26.95	807524.0
2016-09-08 09:00:00	AAPL	Stock	26.9575	26.9575	26.455	26.5425	46692548.0
2016-09-08 10:00:00	AAPL	Stock	26.5402	26.56	26.41	26.45	32801148.0
2016-09-08 11:00:00	AAPL	Stock	26.45	26.525	26.4225	26.515	19417756.0
2016-09-08 12:00:00	AAPL	Stock	26.515	26.5325	26.3875	26.4212	13219564.0
2016-09-08 13:00:00	AAPL	Stock	26.42	26.4325	26.31	26.3512	17278644.0
2016-09-08 14:00:00	AAPL	Stock	26.35	26.4775	26.339	26.4275	26544740.0
2016-09-08 15:00:00	AAPL	Stock	26.428	26.4425	26.33	26.3775	27742868.0
2016-09-08 16:00:00	AAPL	Stock	26.3775	26.4772	26.335	26.365	9640648.0
2016-09-08 17:00:00	AAPL	Stock	26.365	26.3825	26.35	26.3625	68268.0
2016-09-08 18:00:00	AAPL	Stock	26.3775	26.38	26.37	26.38	26420.0
2016-09-08 19:00:00	AAPL	Stock	26.38	26.38	26.3575	26.3575	66084.0
2016-09-08 07:00:00	MSFT	Stock	57.57	57.57	57.57	57.57	100.0
2016-09-08 08:00:00	MSFT	Stock	57.57	57.57	57.57	57.57	739.0
2016-09-08 09:00:00	MSFT	Stock	57.5	57.79	57.41	57.43	2695963.0
2016-09-08 10:00:00	MSFT	Stock	57.422	57.64	57.355	57.59	2400926.0
2016-09-08 11:00:00	MSFT	Stock	57.59	57.66	57.45	57.465	2209745.0
2016-09-08 12:00:00	MSFT	Stock	57.465	57.5	57.32	57.335	1661364.0
2016-09-08 13:00:00	MSFT	Stock	57.33	57.38	57.18	57.315	1802150.0
2016-09-08 14:00:00	MSFT	Stock	57.31	57.4	57.25	57.39	1487356.0
2016-09-08 15:00:00	MSFT	Stock	57.397	57.5	57.37	57.42	3377551.0
2016-09-08 16:00:00	MSFT	Stock	57.43	57.43	57.33	57.43	1604131.0
2016-09-08 17:00:00	MSFT	Stock	57.43	57.43	57.43	57.43	130.0
2016-09-08 19:00:00	MSFT	Stock	57.33	57.33	57.33	57.33	150.0
2016-09-08 07:00:00	NVDA	Stock	1.5652	1.5663	1.5652	1.566	52000.0
2016-09-08 08:00:00	NVDA	Stock	1.5663	1.5663	1.5563	1.5563	97080.0
2016-09-08 09:00:00	NVDA	Stock	1.555	1.555	1.5355	1.5455	30089280.0
2016-09-08 10:00:00	NVDA	Stock	1.5453	1.5555	1.5425	1.5555	29127800.0
2016-09-08 11:00:00	NVDA	Stock	1.5555	1.5635	1.553	1.561	34650080.0
2016-09-08 12:00:00	NVDA	Stock	1.561	1.5613	1.5512	1.5512	27194080.0
2016-09-08 13:00:00	NVDA	Stock	1.5512	1.5575	1.551	1.5575	34710600.0
2016-09-08 14:00:00	NVDA	Stock	1.5574	1.567	1.556	1.5666	28665920.0
2016-09-08 15:00:00	NVDA	Stock	1.5666	1.5685	1.5639	1.566	82317160.0
2016-09-08 16:00:00	NVDA	Stock	1.566	1.566	1.5582	1.5628	12992400.0
2016-09-08 17:00:00	NVDA	Stock	1.5628	1.566	1.5628	1.566	639600.0
2016-09-08 18:00:00	NVDA	Stock	1.5652	1.5688	1.565	1.5688	183920.0
2016-09-08 08:00:00	AMZN	Stock	39.183	39.3245	39.1555	39.1555	95300.0
2016-09-08 09:00:00	AMZN	Stock	39.19	39.325	39.145	39.24	6610840.0
2016-09-08 10:00:00	AMZN	Stock	39.247	39.2925	39.1725	39.191	5398920.0
2016-09-08 11:00:00	AMZN	Stock	39.194	39.2415	39.1325	39.1505	3524100.0
2016-09-08 12:00:00	AMZN	Stock	39.1595	39.1765	39.1015	39.1175	3021140.0
2016-09-08 13:00:00	AMZN	Stock	39.118	39.144	39.072	39.122	2916140.0
2016-09-08 14:00:00	AMZN	Stock	39.123	39.2375	39.0975	39.2162	3273700.0
2016-09-08 15:00:00	AMZN	Stock	39.209	39.214	39.148	39.206	5744400.0
2016-09-08 16:00:00	AMZN	Stock	39.203	39.21	39.203	39.21	4438120.0
2016-09-08 17:00:00	AMZN	Stock	39.199	39.199	39.156	39.156	6320.0

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

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