PREVIEW / stock_1hour / 2017-04-03

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-03.parquet
  size:    1.1 MB
  rows:    48,917
  symbols: 3,067

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-04-03 05:00:00	AAPL	Stock	35.9	35.91	35.9	35.91	28628.0
2017-04-03 06:00:00	AAPL	Stock	35.975	35.975	35.93	35.93	5772.0
2017-04-03 07:00:00	AAPL	Stock	35.9525	35.9675	35.9325	35.9375	34044.0
2017-04-03 08:00:00	AAPL	Stock	35.9375	35.9475	35.8875	35.93	175972.0
2017-04-03 09:00:00	AAPL	Stock	35.925	36.03	35.8825	35.962	10917756.0
2017-04-03 10:00:00	AAPL	Stock	35.96	36.015	35.88	35.925	11418588.0
2017-04-03 11:00:00	AAPL	Stock	35.9233	35.9375	35.8075	35.8462	12633204.0
2017-04-03 12:00:00	AAPL	Stock	35.8475	35.91	35.7625	35.8975	8853584.0
2017-04-03 13:00:00	AAPL	Stock	35.895	35.9275	35.85	35.88	4690616.0
2017-04-03 14:00:00	AAPL	Stock	35.8825	35.94	35.8388	35.925	4845424.0
2017-04-03 15:00:00	AAPL	Stock	35.9242	35.975	35.9125	35.925	10780028.0
2017-04-03 16:00:00	AAPL	Stock	35.925	35.9325	35.8958	35.925	7775796.0
2017-04-03 17:00:00	AAPL	Stock	35.915	35.925	35.9125	35.9225	27244.0
2017-04-03 18:00:00	AAPL	Stock	35.9225	35.9225	35.9	35.9125	10280.0
2017-04-03 19:00:00	AAPL	Stock	35.9125	35.9125	35.9075	35.9075	8996.0
2017-04-03 07:00:00	MSFT	Stock	66.0	66.0	66.0	66.0	813.0
2017-04-03 08:00:00	MSFT	Stock	66.0	66.0	65.86	65.97	4816.0
2017-04-03 09:00:00	MSFT	Stock	65.93	65.94	65.65	65.72	2307618.0
2017-04-03 10:00:00	MSFT	Stock	65.72	65.82	65.4	65.411	2966034.0
2017-04-03 11:00:00	MSFT	Stock	65.415	65.453	65.2	65.37	2753795.0
2017-04-03 12:00:00	MSFT	Stock	65.36	65.49	65.19	65.483	1762945.0
2017-04-03 13:00:00	MSFT	Stock	65.49	65.51	65.26	65.41	1505272.0
2017-04-03 14:00:00	MSFT	Stock	65.41	65.56	65.32	65.5	1179358.0
2017-04-03 15:00:00	MSFT	Stock	65.5	65.64	65.47	65.55	2889461.0
2017-04-03 16:00:00	MSFT	Stock	65.55	65.606	65.0	65.43	3502864.0
2017-04-03 17:00:00	MSFT	Stock	65.42	65.42	65.33	65.39	37625.0
2017-04-03 18:00:00	MSFT	Stock	65.39	65.39	65.35	65.35	1100.0
2017-04-03 04:00:00	NVDA	Stock	2.7372	2.7372	2.7372	2.7372	4000.0
2017-04-03 07:00:00	NVDA	Stock	2.7295	2.7295	2.7285	2.7295	24000.0
2017-04-03 08:00:00	NVDA	Stock	2.7275	2.7278	2.72	2.7225	1367560.0
2017-04-03 09:00:00	NVDA	Stock	2.7242	2.7413	2.7128	2.7238	69269000.0
2017-04-03 10:00:00	NVDA	Stock	2.7232	2.7248	2.6968	2.6989	81301120.0
2017-04-03 11:00:00	NVDA	Stock	2.6985	2.709	2.6898	2.695	65342480.0
2017-04-03 12:00:00	NVDA	Stock	2.6948	2.707	2.6855	2.7065	42342840.0
2017-04-03 13:00:00	NVDA	Stock	2.7068	2.7135	2.6983	2.7068	37722200.0
2017-04-03 14:00:00	NVDA	Stock	2.7072	2.7163	2.6968	2.7141	34566560.0
2017-04-03 15:00:00	NVDA	Stock	2.714	2.7192	2.7082	2.7095	48896200.0
2017-04-03 16:00:00	NVDA	Stock	2.7095	2.7112	2.7095	2.7098	29770480.0
2017-04-03 17:00:00	NVDA	Stock	2.7088	2.7112	2.7065	2.7065	93920.0
2017-04-03 18:00:00	NVDA	Stock	2.7065	2.71	2.7065	2.7075	44000.0
2017-04-03 19:00:00	NVDA	Stock	2.7095	2.7095	2.7015	2.7025	168600.0
2017-04-03 07:00:00	AMZN	Stock	44.405	44.4125	44.4	44.4	20000.0
2017-04-03 08:00:00	AMZN	Stock	44.395	44.465	44.37	44.4495	438240.0
2017-04-03 09:00:00	AMZN	Stock	44.4375	44.6103	44.271	44.505	11498940.0
2017-04-03 10:00:00	AMZN	Stock	44.5055	44.638	44.36	44.43	11686280.0
2017-04-03 11:00:00	AMZN	Stock	44.4293	44.492	44.2775	44.3875	7694480.0
2017-04-03 12:00:00	AMZN	Stock	44.3795	44.5115	44.288	44.5075	5038680.0
2017-04-03 13:00:00	AMZN	Stock	44.5075	44.515	44.41	44.4704	3054140.0
2017-04-03 14:00:00	AMZN	Stock	44.475	44.56	44.4005	44.5099	4930440.0
2017-04-03 15:00:00	AMZN	Stock	44.515	44.6745	44.515	44.576	11883600.0

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

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