PREVIEW / stock_1hour / 2019-09-03

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-03.parquet
  size:    1.1 MB
  rows:    50,339
  symbols: 2,560

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
2019-09-03 04:00:00	AAPL	Stock	51.425	51.8475	51.365	51.6275	25824.0
2019-09-03 05:00:00	AAPL	Stock	51.7325	51.775	51.45	51.45	53832.0
2019-09-03 06:00:00	AAPL	Stock	51.45	51.675	51.425	51.625	13228.0
2019-09-03 07:00:00	AAPL	Stock	51.575	51.75	51.5625	51.5775	124712.0
2019-09-03 08:00:00	AAPL	Stock	51.625	51.77	51.5025	51.585	371072.0
2019-09-03 09:00:00	AAPL	Stock	51.585	51.745	51.4575	51.6725	10957592.0
2019-09-03 10:00:00	AAPL	Stock	51.6675	51.6675	51.055	51.355	15768272.0
2019-09-03 11:00:00	AAPL	Stock	51.3575	51.44	51.1325	51.3225	8459592.0
2019-09-03 12:00:00	AAPL	Stock	51.315	51.35	51.1875	51.2212	5336976.0
2019-09-03 13:00:00	AAPL	Stock	51.2218	51.2638	51.115	51.1575	5754684.0
2019-09-03 14:00:00	AAPL	Stock	51.16	51.395	51.15	51.3475	4979372.0
2019-09-03 15:00:00	AAPL	Stock	51.35	51.5275	51.2925	51.4238	10015016.0
2019-09-03 16:00:00	AAPL	Stock	51.425	51.4725	51.4075	51.445	4809244.0
2019-09-03 17:00:00	AAPL	Stock	51.4725	51.4875	51.4375	51.4625	35792.0
2019-09-03 18:00:00	AAPL	Stock	51.4625	51.55	51.4625	51.5225	67880.0
2019-09-03 19:00:00	AAPL	Stock	51.5	51.525	51.45	51.495	78004.0
2019-09-03 04:00:00	MSFT	Stock	136.9	136.9	136.5	136.78	5108.0
2019-09-03 05:00:00	MSFT	Stock	136.77	136.77	136.2	136.2	2939.0
2019-09-03 06:00:00	MSFT	Stock	136.6	136.88	136.5	136.78	5037.0
2019-09-03 07:00:00	MSFT	Stock	136.9	137.0	136.65	136.7	8525.0
2019-09-03 08:00:00	MSFT	Stock	136.8	137.19	136.61	137.0	43470.0
2019-09-03 09:00:00	MSFT	Stock	137.0	137.2	136.34	137.05	1936899.0
2019-09-03 10:00:00	MSFT	Stock	137.04	137.04	135.85	136.75	2779616.0
2019-09-03 11:00:00	MSFT	Stock	136.75	136.805	136.11	136.57	1929582.0
2019-09-03 12:00:00	MSFT	Stock	136.57	136.68	136.2	136.362	1067937.0
2019-09-03 13:00:00	MSFT	Stock	136.36	136.51	135.71	135.73	1331578.0
2019-09-03 14:00:00	MSFT	Stock	135.73	136.09	135.7	135.937	1315274.0
2019-09-03 15:00:00	MSFT	Stock	135.932	136.37	135.81	136.12	3109988.0
2019-09-03 16:00:00	MSFT	Stock	136.04	136.12	135.91	136.0	2804309.0
2019-09-03 17:00:00	MSFT	Stock	136.0	136.04	136.0	136.03	2144.0
2019-09-03 18:00:00	MSFT	Stock	135.96	136.1	135.96	136.1	4240.0
2019-09-03 19:00:00	MSFT	Stock	136.15	136.19	136.0	136.0	6492.0
2019-09-03 04:00:00	NVDA	Stock	4.1298	4.1375	4.1298	4.1375	28000.0
2019-09-03 05:00:00	NVDA	Stock	4.1332	4.1422	4.115	4.115	98480.0
2019-09-03 06:00:00	NVDA	Stock	4.1165	4.136	4.1165	4.136	12000.0
2019-09-03 07:00:00	NVDA	Stock	4.1375	4.1375	4.1275	4.1275	288360.0
2019-09-03 08:00:00	NVDA	Stock	4.1375	4.1505	4.1263	4.14	905840.0
2019-09-03 09:00:00	NVDA	Stock	4.135	4.1478	4.0892	4.1329	41768920.0
2019-09-03 10:00:00	NVDA	Stock	4.1315	4.1328	4.0825	4.106	63349200.0
2019-09-03 11:00:00	NVDA	Stock	4.1055	4.1218	4.0813	4.1145	43719640.0
2019-09-03 12:00:00	NVDA	Stock	4.1148	4.1238	4.1088	4.1125	17180760.0
2019-09-03 13:00:00	NVDA	Stock	4.1125	4.117	4.095	4.0975	16614240.0
2019-09-03 14:00:00	NVDA	Stock	4.0975	4.1092	4.0928	4.0932	22053480.0
2019-09-03 15:00:00	NVDA	Stock	4.0931	4.1218	4.089	4.104	49716040.0
2019-09-03 16:00:00	NVDA	Stock	4.1042	4.1075	4.0988	4.1023	3024400.0
2019-09-03 17:00:00	NVDA	Stock	4.0963	4.102	4.096	4.0963	214760.0
2019-09-03 18:00:00	NVDA	Stock	4.096	4.1	4.0938	4.0975	84480.0
2019-09-03 19:00:00	NVDA	Stock	4.0975	4.1023	4.0975	4.1023	294120.0
2019-09-03 04:00:00	AMZN	Stock	88.094	88.3	88.041	88.15	65100.0
2019-09-03 05:00:00	AMZN	Stock	88.25	88.25	87.745	87.78	68040.0

> showing 50 of 50,339 rows — these rows as CSV

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