PREVIEW / stock_1hour / 2017-05-03

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-03.parquet
  size:    1.0 MB
  rows:    48,159
  symbols: 3,037

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-03 04:00:00	AAPL	Stock	36.2475	36.3375	36.225	36.31	13576.0
2017-05-03 05:00:00	AAPL	Stock	36.3175	36.4	36.2925	36.2925	28332.0
2017-05-03 06:00:00	AAPL	Stock	36.3	36.3225	36.0875	36.2225	32012.0
2017-05-03 07:00:00	AAPL	Stock	36.225	36.6675	36.225	36.575	1306864.0
2017-05-03 08:00:00	AAPL	Stock	36.565	36.65	36.155	36.525	2039832.0
2017-05-03 09:00:00	AAPL	Stock	36.525	36.5725	36.0675	36.29	36234376.0
2017-05-03 10:00:00	AAPL	Stock	36.2875	36.625	36.19	36.4875	32466720.0
2017-05-03 11:00:00	AAPL	Stock	36.4865	36.585	36.44	36.5288	11986728.0
2017-05-03 12:00:00	AAPL	Stock	36.5275	36.8725	36.525	36.76	21557124.0
2017-05-03 13:00:00	AAPL	Stock	36.7625	36.7975	36.6875	36.7475	10650088.0
2017-05-03 14:00:00	AAPL	Stock	36.75	36.865	36.705	36.84	14285816.0
2017-05-03 15:00:00	AAPL	Stock	36.839	36.855	36.625	36.765	29004440.0
2017-05-03 16:00:00	AAPL	Stock	36.76	36.765	36.4575	36.6125	7538812.0
2017-05-03 17:00:00	AAPL	Stock	36.6125	36.6625	36.57	36.5875	283772.0
2017-05-03 18:00:00	AAPL	Stock	36.6	36.66	36.6	36.64	143420.0
2017-05-03 19:00:00	AAPL	Stock	36.64	36.6875	36.6325	36.6875	82440.0
2017-05-03 04:00:00	MSFT	Stock	69.1	69.2	69.1	69.2	600.0
2017-05-03 06:00:00	MSFT	Stock	69.19	69.19	69.03	69.03	500.0
2017-05-03 07:00:00	MSFT	Stock	69.15	69.18	69.15	69.18	3371.0
2017-05-03 08:00:00	MSFT	Stock	69.18	69.2	69.1	69.1	7494.0
2017-05-03 09:00:00	MSFT	Stock	69.11	69.38	69.05	69.13	2134654.0
2017-05-03 10:00:00	MSFT	Stock	69.125	69.18	68.8	68.903	3928750.0
2017-05-03 11:00:00	MSFT	Stock	68.905	68.99	68.88	68.885	2810321.0
2017-05-03 12:00:00	MSFT	Stock	68.885	68.956	68.86	68.895	1801206.0
2017-05-03 13:00:00	MSFT	Stock	68.9	68.91	68.75	68.77	1952840.0
2017-05-03 14:00:00	MSFT	Stock	68.78	68.9	68.71	68.885	2791490.0
2017-05-03 15:00:00	MSFT	Stock	68.89	69.08	68.71	69.08	9197027.0
2017-05-03 16:00:00	MSFT	Stock	69.07	69.08	68.9	68.9	2442823.0
2017-05-03 17:00:00	MSFT	Stock	68.93	69.07	68.93	68.93	5985.0
2017-05-03 18:00:00	MSFT	Stock	68.92	69.02	68.92	69.02	890.0
2017-05-03 19:00:00	MSFT	Stock	69.02	69.04	69.02	69.04	913.0
2017-05-03 08:00:00	NVDA	Stock	2.5775	2.58	2.5775	2.5778	260640.0
2017-05-03 09:00:00	NVDA	Stock	2.5775	2.6043	2.5695	2.5738	50176320.0
2017-05-03 10:00:00	NVDA	Stock	2.5746	2.5915	2.565	2.5913	68111000.0
2017-05-03 11:00:00	NVDA	Stock	2.5908	2.601	2.5813	2.5958	43095880.0
2017-05-03 12:00:00	NVDA	Stock	2.5958	2.616	2.5915	2.6108	39947640.0
2017-05-03 13:00:00	NVDA	Stock	2.6102	2.6112	2.6018	2.6035	27546680.0
2017-05-03 14:00:00	NVDA	Stock	2.6032	2.6055	2.5928	2.595	33692160.0
2017-05-03 15:00:00	NVDA	Stock	2.595	2.6099	2.5935	2.6062	49204400.0
2017-05-03 16:00:00	NVDA	Stock	2.6062	2.6062	2.5998	2.6055	1694400.0
2017-05-03 17:00:00	NVDA	Stock	2.6025	2.6025	2.6	2.6022	214280.0
2017-05-03 18:00:00	NVDA	Stock	2.6025	2.605	2.6	2.6	429680.0
2017-05-03 19:00:00	NVDA	Stock	2.6	2.6	2.5965	2.6	80000.0
2017-05-03 07:00:00	AMZN	Stock	47.308	47.343	47.308	47.308	24320.0
2017-05-03 08:00:00	AMZN	Stock	47.311	47.311	47.25	47.302	67440.0
2017-05-03 09:00:00	AMZN	Stock	47.297	47.3	46.99	47.0385	10361480.0
2017-05-03 10:00:00	AMZN	Stock	47.0358	47.0385	46.795	46.8099	13539440.0
2017-05-03 11:00:00	AMZN	Stock	46.8025	46.9351	46.7955	46.8325	8875520.0
2017-05-03 12:00:00	AMZN	Stock	46.832	47.039	46.832	47.022	5213180.0
2017-05-03 13:00:00	AMZN	Stock	47.0186	47.075	46.9805	47.056	3688260.0

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

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