PREVIEW / stock_1hour / 2016-03-31

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-31.parquet
  size:    1.0 MB
  rows:    48,731
  symbols: 3,381

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
2016-03-31 05:00:00	AAPL	Stock	27.355	27.355	27.355	27.355	400.0
2016-03-31 06:00:00	AAPL	Stock	27.355	27.355	27.2225	27.245	105736.0
2016-03-31 07:00:00	AAPL	Stock	27.2625	27.3525	27.25	27.3525	120248.0
2016-03-31 08:00:00	AAPL	Stock	27.335	27.375	27.3	27.3375	277652.0
2016-03-31 09:00:00	AAPL	Stock	27.3475	27.475	27.2725	27.2875	14127280.0
2016-03-31 10:00:00	AAPL	Stock	27.29	27.4575	27.2375	27.435	15170200.0
2016-03-31 11:00:00	AAPL	Stock	27.435	27.45	27.2625	27.3788	13147712.0
2016-03-31 12:00:00	AAPL	Stock	27.38	27.3938	27.305	27.3088	6746288.0
2016-03-31 13:00:00	AAPL	Stock	27.3088	27.345	27.2625	27.2902	8012132.0
2016-03-31 14:00:00	AAPL	Stock	27.29	27.32	27.2675	27.3125	7103724.0
2016-03-31 15:00:00	AAPL	Stock	27.3128	27.3475	27.22	27.24	15477748.0
2016-03-31 16:00:00	AAPL	Stock	27.2475	27.265	27.23	27.2625	13962620.0
2016-03-31 17:00:00	AAPL	Stock	27.255	27.2625	27.2475	27.26	27520.0
2016-03-31 18:00:00	AAPL	Stock	27.26	27.27	27.2475	27.2675	28012.0
2016-03-31 19:00:00	AAPL	Stock	27.2675	27.285	27.2575	27.2575	27288.0
2016-03-31 06:00:00	MSFT	Stock	54.85	54.98	54.55	54.98	1647.0
2016-03-31 07:00:00	MSFT	Stock	55.03	55.12	54.9	54.9	1200.0
2016-03-31 08:00:00	MSFT	Stock	54.55	55.28	54.55	55.28	10706.0
2016-03-31 09:00:00	MSFT	Stock	55.2	55.23	54.82	55.13	4221027.0
2016-03-31 10:00:00	MSFT	Stock	55.136	55.5	55.06	55.495	2212247.0
2016-03-31 11:00:00	MSFT	Stock	55.5	55.59	55.29	55.309	2655431.0
2016-03-31 12:00:00	MSFT	Stock	55.31	55.48	55.29	55.339	1823179.0
2016-03-31 13:00:00	MSFT	Stock	55.335	55.36	55.25	55.265	1408920.0
2016-03-31 14:00:00	MSFT	Stock	55.26	55.3	55.075	55.17	2076575.0
2016-03-31 15:00:00	MSFT	Stock	55.17	55.4	55.14	55.23	5265540.0
2016-03-31 16:00:00	MSFT	Stock	55.23	55.32	55.225	55.3	4545273.0
2016-03-31 17:00:00	MSFT	Stock	55.25	55.25	55.25	55.25	460.0
2016-03-31 18:00:00	MSFT	Stock	55.2	55.2	55.2	55.2	400.0
2016-03-31 08:00:00	NVDA	Stock	0.8938	0.8938	0.8938	0.8938	4000.0
2016-03-31 09:00:00	NVDA	Stock	0.898	0.8985	0.8875	0.891	24794520.0
2016-03-31 10:00:00	NVDA	Stock	0.891	0.8944	0.8888	0.8922	99322800.0
2016-03-31 11:00:00	NVDA	Stock	0.8925	0.9	0.8918	0.8973	29406440.0
2016-03-31 12:00:00	NVDA	Stock	0.8973	0.8998	0.8918	0.8922	41463160.0
2016-03-31 13:00:00	NVDA	Stock	0.8922	0.8925	0.8838	0.8872	33096600.0
2016-03-31 14:00:00	NVDA	Stock	0.887	0.8922	0.8858	0.888	50572160.0
2016-03-31 15:00:00	NVDA	Stock	0.8883	0.8939	0.8879	0.8905	63171320.0
2016-03-31 16:00:00	NVDA	Stock	0.8908	0.8908	0.8905	0.8908	25209680.0
2016-03-31 19:00:00	NVDA	Stock	0.8908	0.8922	0.8908	0.8922	21840.0
2016-03-31 05:00:00	AMZN	Stock	29.9345	29.9345	29.9345	29.9345	4000.0
2016-03-31 06:00:00	AMZN	Stock	29.9	29.9	29.9	29.9	4900.0
2016-03-31 07:00:00	AMZN	Stock	29.875	29.9	29.875	29.9	11200.0
2016-03-31 08:00:00	AMZN	Stock	29.962	30.0125	29.95	29.95	90980.0
2016-03-31 09:00:00	AMZN	Stock	29.961	30.0375	29.771	29.8128	6477720.0
2016-03-31 10:00:00	AMZN	Stock	29.8345	29.991	29.83	29.89	5993340.0
2016-03-31 11:00:00	AMZN	Stock	29.9006	29.9335	29.7185	29.8064	6660540.0
2016-03-31 12:00:00	AMZN	Stock	29.806	29.9	29.7805	29.809	4047420.0
2016-03-31 13:00:00	AMZN	Stock	29.8155	29.8165	29.7	29.7274	4546000.0
2016-03-31 14:00:00	AMZN	Stock	29.7325	29.74	29.6105	29.685	5564880.0
2016-03-31 15:00:00	AMZN	Stock	29.6865	29.766	29.657	29.683	8189480.0
2016-03-31 16:00:00	AMZN	Stock	29.682	29.8265	29.6818	29.8265	5325780.0

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

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