PREVIEW / stock_1hour / 2018-01-16

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-16.parquet
  size:    1.1 MB
  rows:    51,530
  symbols: 2,914

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
2018-01-16 04:00:00	AAPL	Stock	44.35	44.6	44.35	44.5625	67468.0
2018-01-16 05:00:00	AAPL	Stock	44.525	44.55	44.5	44.5175	7688.0
2018-01-16 06:00:00	AAPL	Stock	44.5375	44.5975	44.5375	44.5975	63796.0
2018-01-16 07:00:00	AAPL	Stock	44.56	44.63	44.5	44.625	200800.0
2018-01-16 08:00:00	AAPL	Stock	44.5375	44.6625	44.515	44.585	332088.0
2018-01-16 09:00:00	AAPL	Stock	44.575	44.7775	44.3	44.74	18249772.0
2018-01-16 10:00:00	AAPL	Stock	44.74	44.8475	44.5425	44.565	16601680.0
2018-01-16 11:00:00	AAPL	Stock	44.5638	44.5662	44.3325	44.3775	12885336.0
2018-01-16 12:00:00	AAPL	Stock	44.38	44.4718	44.2875	44.3312	6596260.0
2018-01-16 13:00:00	AAPL	Stock	44.3322	44.395	44.2525	44.267	7864612.0
2018-01-16 14:00:00	AAPL	Stock	44.2688	44.31	44.035	44.1125	15151044.0
2018-01-16 15:00:00	AAPL	Stock	44.1145	44.2375	44.0475	44.05	15673472.0
2018-01-16 16:00:00	AAPL	Stock	44.0475	44.1708	44.0475	44.075	13439292.0
2018-01-16 17:00:00	AAPL	Stock	44.0575	44.0725	43.9625	44.0	90640.0
2018-01-16 18:00:00	AAPL	Stock	44.0	44.0125	43.9375	43.9625	71704.0
2018-01-16 19:00:00	AAPL	Stock	43.9625	43.975	43.925	43.9375	70756.0
2018-01-16 04:00:00	MSFT	Stock	89.9	90.17	89.9	90.1	1788.0
2018-01-16 05:00:00	MSFT	Stock	90.2	90.59	90.2	90.59	1365.0
2018-01-16 06:00:00	MSFT	Stock	90.38	90.5	90.34	90.39	6550.0
2018-01-16 07:00:00	MSFT	Stock	90.3	90.4	90.17	90.3	14478.0
2018-01-16 08:00:00	MSFT	Stock	90.17	90.4	90.15	90.25	16058.0
2018-01-16 09:00:00	MSFT	Stock	90.3	90.79	90.1	90.55	4214120.0
2018-01-16 10:00:00	MSFT	Stock	90.55	90.6	89.76	89.805	4483808.0
2018-01-16 11:00:00	MSFT	Stock	89.805	89.97	89.42	89.425	4196901.0
2018-01-16 12:00:00	MSFT	Stock	89.43	89.64	89.22	89.355	2511092.0
2018-01-16 13:00:00	MSFT	Stock	89.35	89.53	88.87	88.87	2591719.0
2018-01-16 14:00:00	MSFT	Stock	88.87	89.01	88.37	88.75	4572912.0
2018-01-16 15:00:00	MSFT	Stock	88.76	89.02	88.01	88.38	6447409.0
2018-01-16 16:00:00	MSFT	Stock	88.35	89.575	88.3	88.5	4554683.0
2018-01-16 17:00:00	MSFT	Stock	88.47	88.55	88.45	88.5	7610.0
2018-01-16 18:00:00	MSFT	Stock	88.5	88.5	88.29	88.29	5092.0
2018-01-16 19:00:00	MSFT	Stock	88.35	88.4	88.3	88.4	2700.0
2018-01-16 04:00:00	NVDA	Stock	5.575	5.6125	5.575	5.6015	43200.0
2018-01-16 05:00:00	NVDA	Stock	5.6015	5.6015	5.6	5.6	43160.0
2018-01-16 06:00:00	NVDA	Stock	5.6	5.62	5.6	5.6125	161480.0
2018-01-16 07:00:00	NVDA	Stock	5.6125	5.6125	5.5678	5.59	1324720.0
2018-01-16 08:00:00	NVDA	Stock	5.613	5.613	5.5712	5.5825	3045280.0
2018-01-16 09:00:00	NVDA	Stock	5.582	5.6688	5.582	5.6625	84948880.0
2018-01-16 10:00:00	NVDA	Stock	5.6622	5.6878	5.636	5.6652	92792760.0
2018-01-16 11:00:00	NVDA	Stock	5.6655	5.6662	5.615	5.6375	76417960.0
2018-01-16 12:00:00	NVDA	Stock	5.6388	5.6565	5.5963	5.5983	46152240.0
2018-01-16 13:00:00	NVDA	Stock	5.599	5.6088	5.5705	5.5725	44060680.0
2018-01-16 14:00:00	NVDA	Stock	5.573	5.576	5.4172	5.452	197956320.0
2018-01-16 15:00:00	NVDA	Stock	5.4538	5.5308	5.449	5.5042	101669360.0
2018-01-16 16:00:00	NVDA	Stock	5.5028	5.5514	5.495	5.5	17039040.0
2018-01-16 17:00:00	NVDA	Stock	5.4955	5.5	5.475	5.4762	762560.0
2018-01-16 18:00:00	NVDA	Stock	5.4803	5.5063	5.45	5.4642	2799000.0
2018-01-16 19:00:00	NVDA	Stock	5.465	5.4812	5.4625	5.4688	770280.0
2018-01-16 04:00:00	AMZN	Stock	65.775	66.137	65.725	65.952	58360.0
2018-01-16 05:00:00	AMZN	Stock	66.0315	66.05	65.9745	65.9745	56760.0

> showing 50 of 51,530 rows — these rows as CSV

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