PREVIEW / stock_1hour / 2017-01-31

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-31.parquet
  size:    1.1 MB
  rows:    48,913
  symbols: 3,129

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-01-31 04:00:00	AAPL	Stock	30.3375	30.36	30.305	30.305	1944.0
2017-01-31 05:00:00	AAPL	Stock	30.4	30.4	30.37	30.37	7996.0
2017-01-31 06:00:00	AAPL	Stock	30.375	30.4125	30.345	30.395	24884.0
2017-01-31 07:00:00	AAPL	Stock	30.3875	30.425	30.34	30.3475	64200.0
2017-01-31 08:00:00	AAPL	Stock	30.4	30.4	30.2875	30.2875	256276.0
2017-01-31 09:00:00	AAPL	Stock	30.29	30.3475	30.2025	30.29	20582836.0
2017-01-31 10:00:00	AAPL	Stock	30.29	30.2962	30.1775	30.23	21464520.0
2017-01-31 11:00:00	AAPL	Stock	30.23	30.3075	30.2262	30.28	17598692.0
2017-01-31 12:00:00	AAPL	Stock	30.28	30.305	30.2525	30.2788	10354304.0
2017-01-31 13:00:00	AAPL	Stock	30.28	30.2958	30.16	30.1675	14847768.0
2017-01-31 14:00:00	AAPL	Stock	30.1688	30.2725	30.155	30.265	18780556.0
2017-01-31 15:00:00	AAPL	Stock	30.2675	30.3325	30.255	30.325	39424300.0
2017-01-31 16:00:00	AAPL	Stock	30.3375	31.3175	29.765	30.9975	28128672.0
2017-01-31 17:00:00	AAPL	Stock	31.0	31.4025	30.99	31.275	9668908.0
2017-01-31 18:00:00	AAPL	Stock	31.275	31.35	31.2125	31.2125	1203784.0
2017-01-31 19:00:00	AAPL	Stock	31.2125	31.3	31.2125	31.255	939732.0
2017-01-31 04:00:00	MSFT	Stock	65.0	65.1	65.0	65.1	1606.0
2017-01-31 05:00:00	MSFT	Stock	65.1	65.19	65.1	65.17	1974.0
2017-01-31 07:00:00	MSFT	Stock	65.17	65.17	65.05	65.05	18058.0
2017-01-31 08:00:00	MSFT	Stock	65.05	65.17	64.91	65.0	8548.0
2017-01-31 09:00:00	MSFT	Stock	64.95	65.15	64.54	64.67	2760025.0
2017-01-31 10:00:00	MSFT	Stock	64.665	64.81	64.43	64.505	3236943.0
2017-01-31 11:00:00	MSFT	Stock	64.505	64.6	64.26	64.355	3115930.0
2017-01-31 12:00:00	MSFT	Stock	64.354	64.53	64.345	64.45	1738158.0
2017-01-31 13:00:00	MSFT	Stock	64.46	64.49	64.31	64.37	2272083.0
2017-01-31 14:00:00	MSFT	Stock	64.37	64.53	64.31	64.51	2588756.0
2017-01-31 15:00:00	MSFT	Stock	64.51	64.65	64.5	64.65	4701481.0
2017-01-31 16:00:00	MSFT	Stock	64.65	64.82	64.56	64.75	2821498.0
2017-01-31 17:00:00	MSFT	Stock	64.79	64.8	64.74	64.75	4287.0
2017-01-31 18:00:00	MSFT	Stock	64.75	64.78	64.75	64.78	831.0
2017-01-31 19:00:00	MSFT	Stock	64.7	64.74	64.65	64.74	2468.0
2017-01-31 04:00:00	NVDA	Stock	2.7425	2.7425	2.7425	2.7425	11360.0
2017-01-31 06:00:00	NVDA	Stock	2.728	2.728	2.728	2.728	31880.0
2017-01-31 07:00:00	NVDA	Stock	2.728	2.7375	2.7093	2.7375	146720.0
2017-01-31 08:00:00	NVDA	Stock	2.7423	2.7423	2.7245	2.725	428480.0
2017-01-31 09:00:00	NVDA	Stock	2.7275	2.7513	2.7172	2.73	56917120.0
2017-01-31 10:00:00	NVDA	Stock	2.73	2.7305	2.705	2.7142	74350800.0
2017-01-31 11:00:00	NVDA	Stock	2.7148	2.729	2.7068	2.7098	40847080.0
2017-01-31 12:00:00	NVDA	Stock	2.709	2.726	2.706	2.7212	33961120.0
2017-01-31 13:00:00	NVDA	Stock	2.721	2.725	2.7165	2.7208	20338560.0
2017-01-31 14:00:00	NVDA	Stock	2.7212	2.7375	2.718	2.7338	39218440.0
2017-01-31 15:00:00	NVDA	Stock	2.7332	2.7383	2.7253	2.7293	51681880.0
2017-01-31 16:00:00	NVDA	Stock	2.7296	2.75	2.687	2.7413	8644480.0
2017-01-31 17:00:00	NVDA	Stock	2.745	2.7488	2.7425	2.7428	344560.0
2017-01-31 18:00:00	NVDA	Stock	2.7428	2.7438	2.7393	2.7393	250520.0
2017-01-31 19:00:00	NVDA	Stock	2.7462	2.7473	2.7413	2.745	182760.0
2017-01-31 07:00:00	AMZN	Stock	41.3995	41.3995	41.325	41.325	14580.0
2017-01-31 08:00:00	AMZN	Stock	41.303	41.435	41.209	41.225	237120.0
2017-01-31 09:00:00	AMZN	Stock	41.216	41.3495	41.1	41.2425	10056860.0
2017-01-31 10:00:00	AMZN	Stock	41.2318	41.321	41.052	41.1265	10962880.0

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

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