PREVIEW / stock_1hour / 2020-04-07

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-07.parquet
  size:    1.2 MB
  rows:    55,198
  symbols: 2,392

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
2020-04-07 04:00:00	AAPL	Stock	67.25	67.4625	66.7625	67.075	142996.0
2020-04-07 05:00:00	AAPL	Stock	67.125	67.2125	66.97	67.1475	42660.0
2020-04-07 06:00:00	AAPL	Stock	67.1375	67.65	67.075	67.61	88664.0
2020-04-07 07:00:00	AAPL	Stock	67.54	67.625	66.995	67.1	1065464.0
2020-04-07 08:00:00	AAPL	Stock	67.4055	67.61	67.0	67.575	1610072.0
2020-04-07 09:00:00	AAPL	Stock	67.575	67.925	66.575	67.335	29748144.0
2020-04-07 10:00:00	AAPL	Stock	67.3375	67.41	65.7525	66.0625	29132548.0
2020-04-07 11:00:00	AAPL	Stock	66.0475	66.6975	65.86	66.4625	15229956.0
2020-04-07 12:00:00	AAPL	Stock	66.47	66.9248	66.235	66.4925	17839996.0
2020-04-07 13:00:00	AAPL	Stock	66.5075	66.5875	65.7125	65.8412	14425740.0
2020-04-07 14:00:00	AAPL	Stock	65.8325	65.8675	64.775	65.0035	18351132.0
2020-04-07 15:00:00	AAPL	Stock	65.01	65.7775	64.75	64.8462	31942024.0
2020-04-07 16:00:00	AAPL	Stock	64.8575	65.895	64.2412	64.5625	9376136.0
2020-04-07 17:00:00	AAPL	Stock	64.5975	64.6125	64.5	64.5475	80288.0
2020-04-07 18:00:00	AAPL	Stock	64.5275	64.625	64.4025	64.5475	138032.0
2020-04-07 19:00:00	AAPL	Stock	64.5025	65.0425	64.5	65.0	139000.0
2020-04-07 04:00:00	MSFT	Stock	169.01	169.88	168.69	168.8	22621.0
2020-04-07 05:00:00	MSFT	Stock	168.8	169.4	168.56	168.56	9340.0
2020-04-07 06:00:00	MSFT	Stock	168.88	170.5	168.88	170.0	25712.0
2020-04-07 07:00:00	MSFT	Stock	169.58	170.2	169.13	169.41	146512.0
2020-04-07 08:00:00	MSFT	Stock	169.6	170.15	169.34	169.8	272508.0
2020-04-07 09:00:00	MSFT	Stock	169.9	170.5	166.82	167.721	9418037.0
2020-04-07 10:00:00	MSFT	Stock	167.71	168.09	164.06	165.54	9760684.0
2020-04-07 11:00:00	MSFT	Stock	165.54	167.22	164.42	166.13	5897603.0
2020-04-07 12:00:00	MSFT	Stock	166.175	168.0	166.03	167.254	4411980.0
2020-04-07 13:00:00	MSFT	Stock	167.29	167.88	166.2	166.44	3683716.0
2020-04-07 14:00:00	MSFT	Stock	166.435	166.56	164.06	164.425	4811360.0
2020-04-07 15:00:00	MSFT	Stock	164.45	166.77	163.26	163.49	8833308.0
2020-04-07 16:00:00	MSFT	Stock	163.65	165.449	161.937	163.07	5389115.0
2020-04-07 17:00:00	MSFT	Stock	163.13	163.17	163.0	163.08	14596.0
2020-04-07 18:00:00	MSFT	Stock	163.17	163.17	162.47	162.88	20109.0
2020-04-07 19:00:00	MSFT	Stock	162.8	164.2	162.5	163.96	35170.0
2020-04-07 04:00:00	NVDA	Stock	6.825	6.8855	6.825	6.8625	74560.0
2020-04-07 05:00:00	NVDA	Stock	6.8353	6.8622	6.8353	6.8622	53800.0
2020-04-07 06:00:00	NVDA	Stock	6.8942	6.9055	6.85	6.9	121640.0
2020-04-07 07:00:00	NVDA	Stock	6.8972	6.9248	6.8708	6.901	2332600.0
2020-04-07 08:00:00	NVDA	Stock	6.9045	6.9422	6.8625	6.9395	3961840.0
2020-04-07 09:00:00	NVDA	Stock	6.9375	6.9562	6.7495	6.8294	105059040.0
2020-04-07 10:00:00	NVDA	Stock	6.8253	6.8408	6.5333	6.5914	129959120.0
2020-04-07 11:00:00	NVDA	Stock	6.585	6.742	6.565	6.6847	81065320.0
2020-04-07 12:00:00	NVDA	Stock	6.685	6.7882	6.6795	6.7168	69984680.0
2020-04-07 13:00:00	NVDA	Stock	6.7168	6.7332	6.6105	6.6398	47416520.0
2020-04-07 14:00:00	NVDA	Stock	6.6387	6.6425	6.45	6.4703	92557960.0
2020-04-07 15:00:00	NVDA	Stock	6.4704	6.5752	6.4325	6.4738	130754120.0
2020-04-07 16:00:00	NVDA	Stock	6.4738	6.6099	6.4458	6.465	23515160.0
2020-04-07 17:00:00	NVDA	Stock	6.45	6.4588	6.45	6.4575	81040.0
2020-04-07 18:00:00	NVDA	Stock	6.4575	6.4598	6.4105	6.425	894920.0
2020-04-07 19:00:00	NVDA	Stock	6.425	6.5075	6.4245	6.5	871240.0
2020-04-07 04:00:00	AMZN	Stock	100.4	100.8	100.4	100.8	12440.0
2020-04-07 05:00:00	AMZN	Stock	100.75	100.925	100.75	100.9	23540.0

> showing 50 of 55,198 rows — these rows as CSV

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