PREVIEW / stock_1hour / 2019-08-08

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-08.parquet
  size:    1.1 MB
  rows:    50,668
  symbols: 2,578

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-08-08 04:00:00	AAPL	Stock	49.9	50.075	49.8375	50.06	22780.0
2019-08-08 05:00:00	AAPL	Stock	50.0	50.06	50.0	50.0275	30960.0
2019-08-08 06:00:00	AAPL	Stock	50.0375	50.16	49.915	49.9625	41036.0
2019-08-08 07:00:00	AAPL	Stock	49.98	50.0875	49.9175	50.035	311960.0
2019-08-08 08:00:00	AAPL	Stock	49.95	50.1125	49.915	50.0625	424436.0
2019-08-08 09:00:00	AAPL	Stock	50.075	50.375	49.8475	50.1112	14824364.0
2019-08-08 10:00:00	AAPL	Stock	50.11	50.534	50.0778	50.485	13797824.0
2019-08-08 11:00:00	AAPL	Stock	50.4875	50.5925	50.3775	50.5425	10960512.0
2019-08-08 12:00:00	AAPL	Stock	50.5425	50.615	50.51	50.54	7233676.0
2019-08-08 13:00:00	AAPL	Stock	50.5425	50.6125	50.42	50.5525	5604932.0
2019-08-08 14:00:00	AAPL	Stock	50.555	50.6425	50.4375	50.54	7809404.0
2019-08-08 15:00:00	AAPL	Stock	50.5388	50.8825	50.5175	50.8625	15979336.0
2019-08-08 16:00:00	AAPL	Stock	50.8575	50.935	50.805	50.8625	10925524.0
2019-08-08 17:00:00	AAPL	Stock	50.8625	50.8625	50.4825	50.64	276916.0
2019-08-08 18:00:00	AAPL	Stock	50.6375	50.69	50.425	50.5625	234696.0
2019-08-08 19:00:00	AAPL	Stock	50.5875	50.7925	50.575	50.7875	99596.0
2019-08-08 04:00:00	MSFT	Stock	135.8	135.9	135.47	135.7	2481.0
2019-08-08 05:00:00	MSFT	Stock	135.9	135.9	135.9	135.9	900.0
2019-08-08 06:00:00	MSFT	Stock	136.45	136.55	136.0	136.1	1000.0
2019-08-08 07:00:00	MSFT	Stock	135.96	136.0	135.67	135.84	25686.0
2019-08-08 08:00:00	MSFT	Stock	135.75	136.25	135.507	136.25	53538.0
2019-08-08 09:00:00	MSFT	Stock	136.25	136.92	135.93	136.85	2942047.0
2019-08-08 10:00:00	MSFT	Stock	136.84	137.9	136.626	137.805	3273296.0
2019-08-08 11:00:00	MSFT	Stock	137.805	138.28	137.3	138.249	2536127.0
2019-08-08 12:00:00	MSFT	Stock	138.247	138.385	137.96	138.33	2004759.0
2019-08-08 13:00:00	MSFT	Stock	138.33	138.395	137.841	138.16	1674559.0
2019-08-08 14:00:00	MSFT	Stock	138.169	138.49	137.92	138.22	1474467.0
2019-08-08 15:00:00	MSFT	Stock	138.22	138.99	138.04	138.91	4804766.0
2019-08-08 16:00:00	MSFT	Stock	138.89	139.25	136.979	138.9	5690946.0
2019-08-08 17:00:00	MSFT	Stock	138.91	138.91	138.12	138.5	18305.0
2019-08-08 18:00:00	MSFT	Stock	138.53	138.53	138.05	138.45	41847.0
2019-08-08 19:00:00	MSFT	Stock	138.49	138.77	138.3	138.77	10850.0
2019-08-08 06:00:00	NVDA	Stock	3.8742	3.8742	3.8663	3.8663	20000.0
2019-08-08 07:00:00	NVDA	Stock	3.8675	3.8733	3.8608	3.8688	189720.0
2019-08-08 08:00:00	NVDA	Stock	3.8722	3.8958	3.8548	3.8958	1256160.0
2019-08-08 09:00:00	NVDA	Stock	3.8975	3.9162	3.8475	3.893	41449640.0
2019-08-08 10:00:00	NVDA	Stock	3.896	3.924	3.8895	3.9202	35543040.0
2019-08-08 11:00:00	NVDA	Stock	3.92	3.9298	3.8903	3.925	36411080.0
2019-08-08 12:00:00	NVDA	Stock	3.9252	3.9362	3.9168	3.932	30346320.0
2019-08-08 13:00:00	NVDA	Stock	3.9325	3.9458	3.9238	3.9375	21378080.0
2019-08-08 14:00:00	NVDA	Stock	3.937	3.9458	3.928	3.939	21196120.0
2019-08-08 15:00:00	NVDA	Stock	3.9385	3.9578	3.9303	3.9578	48447000.0
2019-08-08 16:00:00	NVDA	Stock	3.9565	3.97	3.9505	3.9578	23732680.0
2019-08-08 17:00:00	NVDA	Stock	3.9525	3.9525	3.9125	3.9408	834840.0
2019-08-08 18:00:00	NVDA	Stock	3.9328	3.9373	3.9155	3.9295	474240.0
2019-08-08 19:00:00	NVDA	Stock	3.9315	3.9425	3.9315	3.938	167400.0
2019-08-08 04:00:00	AMZN	Stock	90.4	90.4	90.0875	90.0875	23420.0
2019-08-08 05:00:00	AMZN	Stock	90.1	90.237	90.1	90.237	14240.0
2019-08-08 06:00:00	AMZN	Stock	90.332	90.35	90.19	90.243	53740.0
2019-08-08 07:00:00	AMZN	Stock	90.2715	90.3	90.0175	90.1465	226580.0

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

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