PREVIEW / stock_1hour / 2016-11-02

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-02.parquet
  size:    1.0 MB
  rows:    47,661
  symbols: 3,183

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-11-02 04:00:00	AAPL	Stock	27.8	27.8	27.675	27.71	14224.0
2016-11-02 05:00:00	AAPL	Stock	27.7125	27.7475	27.7	27.7475	8384.0
2016-11-02 06:00:00	AAPL	Stock	27.7275	27.775	27.7275	27.75	1880.0
2016-11-02 07:00:00	AAPL	Stock	27.7525	27.8425	27.75	27.805	74864.0
2016-11-02 08:00:00	AAPL	Stock	27.7875	27.825	27.75	27.825	203228.0
2016-11-02 09:00:00	AAPL	Stock	27.825	28.0625	27.805	28.0125	15362648.0
2016-11-02 10:00:00	AAPL	Stock	28.0075	28.0275	27.8725	27.885	15733620.0
2016-11-02 11:00:00	AAPL	Stock	27.8842	28.0875	27.8775	28.0075	13391268.0
2016-11-02 12:00:00	AAPL	Stock	28.0075	28.0225	27.95	27.9875	8592284.0
2016-11-02 13:00:00	AAPL	Stock	27.989	28.005	27.8775	27.9625	8938904.0
2016-11-02 14:00:00	AAPL	Stock	27.96	28.055	27.8938	27.9635	14757548.0
2016-11-02 15:00:00	AAPL	Stock	27.9638	28.01	27.8975	27.9	15439328.0
2016-11-02 16:00:00	AAPL	Stock	27.8975	27.9025	27.84	27.8825	6050576.0
2016-11-02 17:00:00	AAPL	Stock	27.8975	27.8975	27.75	27.755	137484.0
2016-11-02 18:00:00	AAPL	Stock	27.75	27.75	27.6875	27.7	171348.0
2016-11-02 19:00:00	AAPL	Stock	27.7	27.7325	27.6975	27.7275	201280.0
2016-11-02 07:00:00	MSFT	Stock	59.7	59.7	59.7	59.7	450.0
2016-11-02 08:00:00	MSFT	Stock	59.71	59.76	59.67	59.67	4256.0
2016-11-02 09:00:00	MSFT	Stock	59.63	59.95	59.63	59.78	2097020.0
2016-11-02 10:00:00	MSFT	Stock	59.77	59.83	59.51	59.545	2329291.0
2016-11-02 11:00:00	MSFT	Stock	59.545	59.79	59.54	59.71	2202457.0
2016-11-02 12:00:00	MSFT	Stock	59.71	59.82	59.59	59.6	1745864.0
2016-11-02 13:00:00	MSFT	Stock	59.603	59.625	59.31	59.53	2699820.0
2016-11-02 14:00:00	MSFT	Stock	59.53	59.77	59.3	59.55	3826790.0
2016-11-02 15:00:00	MSFT	Stock	59.545	59.69	59.41	59.43	3692316.0
2016-11-02 16:00:00	MSFT	Stock	59.43	59.51	59.18	59.43	2123791.0
2016-11-02 17:00:00	MSFT	Stock	59.22	59.25	59.22	59.22	2831.0
2016-11-02 18:00:00	MSFT	Stock	59.24	59.3	59.04	59.12	3448.0
2016-11-02 19:00:00	MSFT	Stock	59.14	59.24	59.14	59.24	2323.0
2016-11-02 05:00:00	NVDA	Stock	1.7312	1.7312	1.7312	1.7312	4000.0
2016-11-02 07:00:00	NVDA	Stock	1.735	1.735	1.735	1.735	4800.0
2016-11-02 08:00:00	NVDA	Stock	1.7413	1.7425	1.7332	1.7332	702440.0
2016-11-02 09:00:00	NVDA	Stock	1.7365	1.763	1.7312	1.7585	40609600.0
2016-11-02 10:00:00	NVDA	Stock	1.759	1.7615	1.735	1.7402	42867640.0
2016-11-02 11:00:00	NVDA	Stock	1.7398	1.7413	1.7325	1.7386	31298160.0
2016-11-02 12:00:00	NVDA	Stock	1.7385	1.741	1.7245	1.7258	28622240.0
2016-11-02 13:00:00	NVDA	Stock	1.7259	1.726	1.7168	1.723	37006280.0
2016-11-02 14:00:00	NVDA	Stock	1.7232	1.7282	1.7159	1.7208	36900360.0
2016-11-02 15:00:00	NVDA	Stock	1.7205	1.7268	1.7175	1.719	64808800.0
2016-11-02 16:00:00	NVDA	Stock	1.7183	1.7319	1.7175	1.7175	2247960.0
2016-11-02 17:00:00	NVDA	Stock	1.7228	1.723	1.7125	1.7125	178440.0
2016-11-02 18:00:00	NVDA	Stock	1.7125	1.7175	1.7003	1.7175	129680.0
2016-11-02 19:00:00	NVDA	Stock	1.715	1.725	1.715	1.7248	89720.0
2016-11-02 05:00:00	AMZN	Stock	39.068	39.068	39.068	39.068	2000.0
2016-11-02 06:00:00	AMZN	Stock	39.125	39.125	39.1235	39.1235	4000.0
2016-11-02 07:00:00	AMZN	Stock	39.125	39.265	39.125	39.2	21040.0
2016-11-02 08:00:00	AMZN	Stock	39.2155	39.22	39.047	39.15	97720.0
2016-11-02 09:00:00	AMZN	Stock	39.143	39.2375	38.932	39.0525	9264940.0
2016-11-02 10:00:00	AMZN	Stock	39.0525	39.09	38.7575	38.7755	12058280.0
2016-11-02 11:00:00	AMZN	Stock	38.776	38.964	38.7325	38.8015	12318160.0

> showing 50 of 47,661 rows — these rows as CSV

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