PREVIEW / stock_1hour / 2017-05-05

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-05.parquet
  size:    1.0 MB
  rows:    47,632
  symbols: 3,045

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-05-05 04:00:00	AAPL	Stock	36.6325	36.6325	36.6325	36.6325	1648.0
2017-05-05 05:00:00	AAPL	Stock	36.68	36.7	36.68	36.7	4328.0
2017-05-05 06:00:00	AAPL	Stock	36.72	36.72	36.72	36.72	800.0
2017-05-05 07:00:00	AAPL	Stock	36.725	36.725	36.6625	36.665	15944.0
2017-05-05 08:00:00	AAPL	Stock	36.675	36.75	36.6625	36.7125	162804.0
2017-05-05 09:00:00	AAPL	Stock	36.7225	36.955	36.6875	36.91	16190492.0
2017-05-05 10:00:00	AAPL	Stock	36.9118	37.0	36.88	36.949	15553832.0
2017-05-05 11:00:00	AAPL	Stock	36.9487	37.169	36.9425	37.165	16125156.0
2017-05-05 12:00:00	AAPL	Stock	37.1665	37.2275	37.09	37.1325	13407032.0
2017-05-05 13:00:00	AAPL	Stock	37.13	37.175	37.12	37.1625	5828596.0
2017-05-05 14:00:00	AAPL	Stock	37.165	37.2	37.1475	37.155	6979652.0
2017-05-05 15:00:00	AAPL	Stock	37.155	37.245	37.125	37.24	16692092.0
2017-05-05 16:00:00	AAPL	Stock	37.24	37.2625	37.0492	37.255	6818880.0
2017-05-05 17:00:00	AAPL	Stock	37.255	37.255	37.2425	37.25	64072.0
2017-05-05 18:00:00	AAPL	Stock	37.25	37.26	37.245	37.25	36236.0
2017-05-05 19:00:00	AAPL	Stock	37.2575	37.2625	37.2425	37.2625	49764.0
2017-05-05 08:00:00	MSFT	Stock	68.8	68.98	68.8	68.97	1499.0
2017-05-05 09:00:00	MSFT	Stock	68.9	69.0	68.65	68.79	2606799.0
2017-05-05 10:00:00	MSFT	Stock	68.795	68.87	68.6	68.645	2659142.0
2017-05-05 11:00:00	MSFT	Stock	68.65	68.7	68.485	68.62	2145203.0
2017-05-05 12:00:00	MSFT	Stock	68.62	68.82	68.615	68.805	1527812.0
2017-05-05 13:00:00	MSFT	Stock	68.805	69.0	68.755	69.0	1453588.0
2017-05-05 14:00:00	MSFT	Stock	68.995	69.03	68.74	68.755	1774143.0
2017-05-05 15:00:00	MSFT	Stock	68.755	69.01	68.71	68.99	3487158.0
2017-05-05 16:00:00	MSFT	Stock	69.0	69.02	68.685	69.01	1896571.0
2017-05-05 17:00:00	MSFT	Stock	69.0	69.02	69.0	69.0	8002.0
2017-05-05 18:00:00	MSFT	Stock	69.02	69.14	69.02	69.14	2522.0
2017-05-05 19:00:00	MSFT	Stock	69.02	69.02	69.0	69.0	1400.0
2017-05-05 07:00:00	NVDA	Stock	2.5813	2.5813	2.5813	2.5813	16000.0
2017-05-05 08:00:00	NVDA	Stock	2.5948	2.5962	2.585	2.5962	61440.0
2017-05-05 09:00:00	NVDA	Stock	2.5905	2.6038	2.5725	2.579	43565800.0
2017-05-05 10:00:00	NVDA	Stock	2.5792	2.5888	2.5688	2.5785	34204800.0
2017-05-05 11:00:00	NVDA	Stock	2.5784	2.5898	2.575	2.5886	24081000.0
2017-05-05 12:00:00	NVDA	Stock	2.5884	2.5898	2.5818	2.5894	14203120.0
2017-05-05 13:00:00	NVDA	Stock	2.5895	2.5988	2.5892	2.5942	17218440.0
2017-05-05 14:00:00	NVDA	Stock	2.594	2.5955	2.589	2.5913	19918440.0
2017-05-05 15:00:00	NVDA	Stock	2.5915	2.5978	2.5885	2.5965	48871320.0
2017-05-05 16:00:00	NVDA	Stock	2.5965	2.5982	2.5872	2.5982	8860400.0
2017-05-05 17:00:00	NVDA	Stock	2.5982	2.6	2.5982	2.6	210640.0
2017-05-05 18:00:00	NVDA	Stock	2.6	2.6	2.5968	2.5992	328960.0
2017-05-05 19:00:00	NVDA	Stock	2.598	2.5988	2.5975	2.5988	46600.0
2017-05-05 04:00:00	AMZN	Stock	46.725	46.725	46.725	46.725	4000.0
2017-05-05 07:00:00	AMZN	Stock	46.9725	46.9725	46.9725	46.9725	2000.0
2017-05-05 08:00:00	AMZN	Stock	46.95	46.972	46.9425	46.965	45960.0
2017-05-05 09:00:00	AMZN	Stock	46.965	47.0395	46.661	46.668	6273620.0
2017-05-05 10:00:00	AMZN	Stock	46.6685	46.729	46.601	46.6682	7268440.0
2017-05-05 11:00:00	AMZN	Stock	46.6655	46.6715	46.525	46.5937	6553320.0
2017-05-05 12:00:00	AMZN	Stock	46.5975	46.6675	46.515	46.5625	4232520.0
2017-05-05 13:00:00	AMZN	Stock	46.565	46.6665	46.558	46.604	3837120.0
2017-05-05 14:00:00	AMZN	Stock	46.5906	46.65	46.5415	46.6305	8618720.0

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

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