PREVIEW / stock_1hour / 2017-02-02

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-02.parquet
  size:    1.0 MB
  rows:    48,643
  symbols: 3,110

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
2017-02-02 04:00:00	AAPL	Stock	32.125	32.1325	32.03	32.075	14688.0
2017-02-02 05:00:00	AAPL	Stock	32.03	32.095	32.0175	32.095	30068.0
2017-02-02 06:00:00	AAPL	Stock	32.1225	32.125	32.0525	32.095	44680.0
2017-02-02 07:00:00	AAPL	Stock	32.095	32.1275	32.07	32.1	106236.0
2017-02-02 08:00:00	AAPL	Stock	32.0875	32.14	32.06	32.08	534992.0
2017-02-02 09:00:00	AAPL	Stock	32.085	32.3475	31.975	32.195	29253172.0
2017-02-02 10:00:00	AAPL	Stock	32.1925	32.205	32.065	32.1722	20409260.0
2017-02-02 11:00:00	AAPL	Stock	32.1712	32.1825	31.985	32.0012	14315096.0
2017-02-02 12:00:00	AAPL	Stock	32.0012	32.115	31.945	32.07	14004768.0
2017-02-02 13:00:00	AAPL	Stock	32.0695	32.0875	32.0088	32.0625	6904536.0
2017-02-02 14:00:00	AAPL	Stock	32.0612	32.0635	31.975	32.05	8409932.0
2017-02-02 15:00:00	AAPL	Stock	32.0513	32.1375	32.0325	32.1275	17461900.0
2017-02-02 16:00:00	AAPL	Stock	32.1275	32.1325	32.0002	32.09	8245836.0
2017-02-02 17:00:00	AAPL	Stock	32.08	32.1325	32.0625	32.065	242160.0
2017-02-02 18:00:00	AAPL	Stock	32.065	32.0825	32.005	32.02	73832.0
2017-02-02 19:00:00	AAPL	Stock	32.005	32.0625	32.005	32.0125	40836.0
2017-02-02 04:00:00	MSFT	Stock	63.45	63.54	63.45	63.54	389.0
2017-02-02 05:00:00	MSFT	Stock	63.42	63.43	63.39	63.39	980.0
2017-02-02 06:00:00	MSFT	Stock	63.4	63.4	63.36	63.36	700.0
2017-02-02 07:00:00	MSFT	Stock	63.4	63.46	63.36	63.46	19397.0
2017-02-02 08:00:00	MSFT	Stock	63.45	63.47	63.31	63.32	13321.0
2017-02-02 09:00:00	MSFT	Stock	63.35	63.41	62.75	63.295	8467590.0
2017-02-02 10:00:00	MSFT	Stock	63.29	63.35	62.92	63.13	7726367.0
2017-02-02 11:00:00	MSFT	Stock	63.14	63.37	62.91	62.934	6020657.0
2017-02-02 12:00:00	MSFT	Stock	62.935	63.1	62.86	62.995	2953012.0
2017-02-02 13:00:00	MSFT	Stock	62.995	63.16	62.97	63.08	2854975.0
2017-02-02 14:00:00	MSFT	Stock	63.08	63.165	63.04	63.15	3837416.0
2017-02-02 15:00:00	MSFT	Stock	63.15	63.255	63.08	63.13	7183858.0
2017-02-02 16:00:00	MSFT	Stock	63.13	63.24	63.02	63.1	3897959.0
2017-02-02 17:00:00	MSFT	Stock	63.17	63.17	63.02	63.02	147861.0
2017-02-02 18:00:00	MSFT	Stock	63.02	63.08	63.02	63.07	3477.0
2017-02-02 19:00:00	MSFT	Stock	63.07	63.08	63.01	63.01	1100.0
2017-02-02 04:00:00	NVDA	Stock	2.845	2.845	2.8253	2.8253	39200.0
2017-02-02 05:00:00	NVDA	Stock	2.8343	2.8343	2.8343	2.8343	4000.0
2017-02-02 07:00:00	NVDA	Stock	2.8338	2.834	2.8305	2.8325	79520.0
2017-02-02 08:00:00	NVDA	Stock	2.8372	2.8462	2.83	2.8395	867560.0
2017-02-02 09:00:00	NVDA	Stock	2.84	2.8593	2.8015	2.8555	94583160.0
2017-02-02 10:00:00	NVDA	Stock	2.8552	2.8558	2.8238	2.8505	76955520.0
2017-02-02 11:00:00	NVDA	Stock	2.85	2.885	2.8465	2.8668	85189600.0
2017-02-02 12:00:00	NVDA	Stock	2.8671	2.8935	2.861	2.8901	47687720.0
2017-02-02 13:00:00	NVDA	Stock	2.8905	2.8925	2.8755	2.8785	41184360.0
2017-02-02 14:00:00	NVDA	Stock	2.8793	2.8875	2.8705	2.8868	40193720.0
2017-02-02 15:00:00	NVDA	Stock	2.8872	2.8923	2.875	2.8848	72870600.0
2017-02-02 16:00:00	NVDA	Stock	2.8848	2.8858	2.8626	2.875	11870120.0
2017-02-02 17:00:00	NVDA	Stock	2.8772	2.8772	2.8725	2.8725	292000.0
2017-02-02 18:00:00	NVDA	Stock	2.8703	2.8703	2.8625	2.87	169240.0
2017-02-02 19:00:00	NVDA	Stock	2.87	2.87	2.8688	2.87	211280.0
2017-02-02 05:00:00	AMZN	Stock	41.6925	41.6925	41.6925	41.6925	5740.0
2017-02-02 06:00:00	AMZN	Stock	41.704	41.75	41.67	41.75	25840.0
2017-02-02 07:00:00	AMZN	Stock	41.75	41.906	41.75	41.892	121160.0

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

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