PREVIEW / stock_1hour / 2017-09-13

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-13.parquet
  size:    1.0 MB
  rows:    48,356
  symbols: 2,965

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-09-13 04:00:00	AAPL	Stock	40.1025	40.15	40.025	40.045	53096.0
2017-09-13 05:00:00	AAPL	Stock	40.045	40.125	39.975	39.975	51676.0
2017-09-13 06:00:00	AAPL	Stock	39.9975	39.9975	39.925	39.925	116536.0
2017-09-13 07:00:00	AAPL	Stock	39.925	40.0525	39.925	40.02	357908.0
2017-09-13 08:00:00	AAPL	Stock	39.9375	40.1	39.925	39.975	807784.0
2017-09-13 09:00:00	AAPL	Stock	39.97	40.0	39.6625	39.7835	33915284.0
2017-09-13 10:00:00	AAPL	Stock	39.785	39.8475	39.4775	39.5875	40947844.0
2017-09-13 11:00:00	AAPL	Stock	39.59	39.77	39.5625	39.57	20924024.0
2017-09-13 12:00:00	AAPL	Stock	39.57	39.8575	39.5625	39.7038	17583152.0
2017-09-13 13:00:00	AAPL	Stock	39.7025	39.7975	39.69	39.7375	9111156.0
2017-09-13 14:00:00	AAPL	Stock	39.74	39.8075	39.7	39.7125	8015408.0
2017-09-13 15:00:00	AAPL	Stock	39.7125	39.915	39.7	39.905	21251664.0
2017-09-13 16:00:00	AAPL	Stock	39.9025	39.915	39.865	39.9025	10319440.0
2017-09-13 17:00:00	AAPL	Stock	39.9	39.9075	39.875	39.88	57684.0
2017-09-13 18:00:00	AAPL	Stock	39.88	39.8975	39.8375	39.8775	45076.0
2017-09-13 19:00:00	AAPL	Stock	39.86	39.895	39.8575	39.86	65504.0
2017-09-13 07:00:00	MSFT	Stock	74.68	74.68	74.65	74.65	1957.0
2017-09-13 09:00:00	MSFT	Stock	74.6	75.18	74.55	75.05	1567906.0
2017-09-13 10:00:00	MSFT	Stock	75.057	75.057	74.68	75.018	1573750.0
2017-09-13 11:00:00	MSFT	Stock	75.02	75.1	74.82	74.87	1165824.0
2017-09-13 12:00:00	MSFT	Stock	74.87	75.015	74.85	74.915	681719.0
2017-09-13 13:00:00	MSFT	Stock	74.92	75.11	74.84	75.085	1135153.0
2017-09-13 14:00:00	MSFT	Stock	75.085	75.14	75.02	75.095	1278088.0
2017-09-13 15:00:00	MSFT	Stock	75.09	75.23	75.0	75.2	2976747.0
2017-09-13 16:00:00	MSFT	Stock	75.19	75.22	75.04	75.15	1831070.0
2017-09-13 17:00:00	MSFT	Stock	75.17	75.17	75.17	75.17	100.0
2017-09-13 18:00:00	MSFT	Stock	75.17	75.17	75.17	75.17	1200.0
2017-09-13 19:00:00	MSFT	Stock	75.17	75.17	75.0	75.0	15170.0
2017-09-13 07:00:00	NVDA	Stock	4.2188	4.2188	4.1975	4.2098	843680.0
2017-09-13 08:00:00	NVDA	Stock	4.2125	4.2232	4.2	4.2148	1450280.0
2017-09-13 09:00:00	NVDA	Stock	4.215	4.2205	4.182	4.216	70137440.0
2017-09-13 10:00:00	NVDA	Stock	4.2155	4.2448	4.2092	4.2262	93307280.0
2017-09-13 11:00:00	NVDA	Stock	4.227	4.2345	4.215	4.224	37749960.0
2017-09-13 12:00:00	NVDA	Stock	4.2238	4.2788	4.2225	4.2718	140654640.0
2017-09-13 13:00:00	NVDA	Stock	4.272	4.2848	4.2615	4.2775	59429040.0
2017-09-13 14:00:00	NVDA	Stock	4.2778	4.2885	4.2738	4.2803	52749000.0
2017-09-13 15:00:00	NVDA	Stock	4.28	4.283	4.2475	4.2588	91717920.0
2017-09-13 16:00:00	NVDA	Stock	4.2593	4.2597	4.2513	4.2525	16339520.0
2017-09-13 17:00:00	NVDA	Stock	4.2612	4.2612	4.2588	4.2588	20640.0
2017-09-13 18:00:00	NVDA	Stock	4.2572	4.2595	4.2538	4.2593	117040.0
2017-09-13 19:00:00	NVDA	Stock	4.2542	4.2593	4.2538	4.2538	217120.0
2017-09-13 05:00:00	AMZN	Stock	49.1875	49.2	49.1875	49.2	8000.0
2017-09-13 07:00:00	AMZN	Stock	49.19	49.19	49.175	49.175	8600.0
2017-09-13 08:00:00	AMZN	Stock	49.181	49.212	49.165	49.2	108360.0
2017-09-13 09:00:00	AMZN	Stock	49.2335	49.341	48.971	49.3178	7950040.0
2017-09-13 10:00:00	AMZN	Stock	49.3235	49.444	49.2505	49.3445	6954280.0
2017-09-13 11:00:00	AMZN	Stock	49.3581	49.4816	49.275	49.3232	4924100.0
2017-09-13 12:00:00	AMZN	Stock	49.308	49.5368	49.3015	49.4695	4474580.0
2017-09-13 13:00:00	AMZN	Stock	49.468	49.612	49.417	49.601	5515700.0
2017-09-13 14:00:00	AMZN	Stock	49.5986	49.8095	49.579	49.7505	7100560.0

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

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