PREVIEW / stock_1hour / 2017-02-01

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-01.parquet
  size:    1.1 MB
  rows:    49,086
  symbols: 3,108

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-01 04:00:00	AAPL	Stock	31.125	31.2375	31.125	31.185	45464.0
2017-02-01 05:00:00	AAPL	Stock	31.175	31.275	31.1425	31.27	101856.0
2017-02-01 06:00:00	AAPL	Stock	31.25	31.3775	31.25	31.325	295240.0
2017-02-01 07:00:00	AAPL	Stock	31.35	31.715	31.3325	31.6825	2412712.0
2017-02-01 08:00:00	AAPL	Stock	31.6875	31.9175	31.2	31.8375	9107812.0
2017-02-01 09:00:00	AAPL	Stock	31.845	32.0725	31.72	32.03	109474956.0
2017-02-01 10:00:00	AAPL	Stock	32.0325	32.1125	31.915	32.042	64353608.0
2017-02-01 11:00:00	AAPL	Stock	32.0412	32.12	31.9625	32.0825	37419440.0
2017-02-01 12:00:00	AAPL	Stock	32.0825	32.375	32.0775	32.3038	41306388.0
2017-02-01 13:00:00	AAPL	Stock	32.3038	32.3575	32.235	32.26	26022768.0
2017-02-01 14:00:00	AAPL	Stock	32.2575	32.53	32.25	32.4975	49889596.0
2017-02-01 15:00:00	AAPL	Stock	32.4975	32.6225	32.1875	32.1875	58706180.0
2017-02-01 16:00:00	AAPL	Stock	32.2	32.295	32.1875	32.225	14709400.0
2017-02-01 17:00:00	AAPL	Stock	32.235	32.25	32.1875	32.205	625972.0
2017-02-01 18:00:00	AAPL	Stock	32.2175	32.2875	32.205	32.2325	215632.0
2017-02-01 19:00:00	AAPL	Stock	32.25	32.2625	32.2	32.2025	117384.0
2017-02-01 04:00:00	MSFT	Stock	64.6	64.94	64.6	64.94	2514.0
2017-02-01 05:00:00	MSFT	Stock	64.8	64.8	64.8	64.8	540.0
2017-02-01 06:00:00	MSFT	Stock	64.8	64.8	64.77	64.8	1900.0
2017-02-01 07:00:00	MSFT	Stock	64.75	64.8	64.73	64.77	22240.0
2017-02-01 08:00:00	MSFT	Stock	64.75	64.85	64.6	64.7	67108.0
2017-02-01 09:00:00	MSFT	Stock	64.7	64.75	64.12	64.24	4734117.0
2017-02-01 10:00:00	MSFT	Stock	64.245	64.37	63.845	63.86	5390559.0
2017-02-01 11:00:00	MSFT	Stock	63.87	63.89	63.65	63.715	3812418.0
2017-02-01 12:00:00	MSFT	Stock	63.72	63.86	63.6	63.805	3796438.0
2017-02-01 13:00:00	MSFT	Stock	63.81	63.87	63.47	63.55	3374583.0
2017-02-01 14:00:00	MSFT	Stock	63.54	63.77	63.5	63.57	4760940.0
2017-02-01 15:00:00	MSFT	Stock	63.57	63.71	63.47	63.57	8335415.0
2017-02-01 16:00:00	MSFT	Stock	63.58	63.65	63.5	63.64	2855771.0
2017-02-01 17:00:00	MSFT	Stock	63.63	63.65	63.58	63.6	18608.0
2017-02-01 18:00:00	MSFT	Stock	63.62	63.62	63.56	63.56	2672.0
2017-02-01 19:00:00	MSFT	Stock	63.54	63.54	63.5	63.5	7974.0
2017-02-01 04:00:00	NVDA	Stock	2.745	2.7488	2.745	2.7488	16000.0
2017-02-01 05:00:00	NVDA	Stock	2.755	2.755	2.755	2.755	10000.0
2017-02-01 06:00:00	NVDA	Stock	2.7498	2.7498	2.7498	2.7498	20000.0
2017-02-01 07:00:00	NVDA	Stock	2.7488	2.7525	2.7362	2.75	440080.0
2017-02-01 08:00:00	NVDA	Stock	2.7503	2.7663	2.7295	2.7635	1055520.0
2017-02-01 09:00:00	NVDA	Stock	2.7658	2.7738	2.7465	2.7711	65123840.0
2017-02-01 10:00:00	NVDA	Stock	2.7713	2.8248	2.7668	2.7977	137361320.0
2017-02-01 11:00:00	NVDA	Stock	2.798	2.8148	2.7955	2.8138	56251320.0
2017-02-01 12:00:00	NVDA	Stock	2.8129	2.8368	2.8105	2.8248	59348600.0
2017-02-01 13:00:00	NVDA	Stock	2.8243	2.845	2.8188	2.8225	63396320.0
2017-02-01 14:00:00	NVDA	Stock	2.8215	2.8372	2.818	2.829	76423120.0
2017-02-01 15:00:00	NVDA	Stock	2.8292	2.853	2.8228	2.8488	92507000.0
2017-02-01 16:00:00	NVDA	Stock	2.8488	2.855	2.8118	2.8515	5371680.0
2017-02-01 17:00:00	NVDA	Stock	2.8525	2.854	2.85	2.852	496280.0
2017-02-01 18:00:00	NVDA	Stock	2.85	2.85	2.8465	2.8488	473520.0
2017-02-01 19:00:00	NVDA	Stock	2.8475	2.8482	2.8435	2.8435	695040.0
2017-02-01 07:00:00	AMZN	Stock	41.3665	41.4	41.363	41.375	18980.0
2017-02-01 08:00:00	AMZN	Stock	41.4	41.525	41.174	41.5	270120.0

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

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