PREVIEW / stock_1hour / 2019-12-02

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-02.parquet
  size:    1.2 MB
  rows:    51,429
  symbols: 2,496

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-12-02 04:00:00	AAPL	Stock	67.0625	67.31	67.0625	67.225	64204.0
2019-12-02 05:00:00	AAPL	Stock	67.2525	67.3	67.2525	67.2675	20524.0
2019-12-02 06:00:00	AAPL	Stock	67.2675	67.2675	66.975	67.1	83964.0
2019-12-02 07:00:00	AAPL	Stock	67.075	67.075	66.9675	67.0175	257780.0
2019-12-02 08:00:00	AAPL	Stock	67.0175	67.045	66.8125	66.975	1121860.0
2019-12-02 09:00:00	AAPL	Stock	66.9975	67.0625	66.6375	66.64	12025656.0
2019-12-02 10:00:00	AAPL	Stock	66.6425	66.6462	65.9365	65.9365	15425820.0
2019-12-02 11:00:00	AAPL	Stock	65.9475	66.2225	65.8625	66.169	9136112.0
2019-12-02 12:00:00	AAPL	Stock	66.17	66.245	65.9375	66.1525	5447840.0
2019-12-02 13:00:00	AAPL	Stock	66.1475	66.4035	66.14	66.3432	4734332.0
2019-12-02 14:00:00	AAPL	Stock	66.3435	66.4375	66.2875	66.3675	4468732.0
2019-12-02 15:00:00	AAPL	Stock	66.37	66.385	65.9975	66.0225	11922076.0
2019-12-02 16:00:00	AAPL	Stock	66.0225	66.1125	66.0	66.04	10657980.0
2019-12-02 17:00:00	AAPL	Stock	66.0375	66.0475	66.0	66.0	41528.0
2019-12-02 18:00:00	AAPL	Stock	66.035	66.035	65.75	65.78	200104.0
2019-12-02 19:00:00	AAPL	Stock	65.79	65.97	65.775	65.89	67924.0
2019-12-02 04:00:00	MSFT	Stock	152.02	152.29	152.02	152.15	3153.0
2019-12-02 05:00:00	MSFT	Stock	152.1	152.14	152.1	152.14	400.0
2019-12-02 06:00:00	MSFT	Stock	152.01	152.16	151.76	151.8	4952.0
2019-12-02 07:00:00	MSFT	Stock	151.71	151.85	151.69	151.82	17448.0
2019-12-02 08:00:00	MSFT	Stock	151.8	151.9	151.38	151.65	381624.0
2019-12-02 09:00:00	MSFT	Stock	151.65	151.87	149.22	149.31	2938566.0
2019-12-02 10:00:00	MSFT	Stock	149.29	149.64	148.32	148.95	4507927.0
2019-12-02 11:00:00	MSFT	Stock	148.94	149.6	148.47	149.58	2778665.0
2019-12-02 12:00:00	MSFT	Stock	149.585	149.92	149.23	149.535	1879076.0
2019-12-02 13:00:00	MSFT	Stock	149.53	150.21	149.51	150.02	1180523.0
2019-12-02 14:00:00	MSFT	Stock	150.02	150.22	149.97	150.17	1274346.0
2019-12-02 15:00:00	MSFT	Stock	150.165	150.2	149.48	149.55	3587127.0
2019-12-02 16:00:00	MSFT	Stock	149.55	149.89	149.12	149.39	3497813.0
2019-12-02 17:00:00	MSFT	Stock	149.4	149.53	149.34	149.47	3032.0
2019-12-02 18:00:00	MSFT	Stock	149.48	149.5	148.85	149.3	24764.0
2019-12-02 19:00:00	MSFT	Stock	149.06	149.5	148.75	149.2	24170.0
2019-12-02 04:00:00	NVDA	Stock	5.435	5.454	5.435	5.4525	59680.0
2019-12-02 06:00:00	NVDA	Stock	5.4438	5.4438	5.4338	5.4338	69440.0
2019-12-02 07:00:00	NVDA	Stock	5.435	5.44	5.428	5.4312	317560.0
2019-12-02 08:00:00	NVDA	Stock	5.4297	5.4375	5.4078	5.4245	1742760.0
2019-12-02 09:00:00	NVDA	Stock	5.422	5.425	5.3165	5.3215	42247320.0
2019-12-02 10:00:00	NVDA	Stock	5.3198	5.3208	5.2525	5.2596	59021720.0
2019-12-02 11:00:00	NVDA	Stock	5.259	5.2928	5.2544	5.2708	39397840.0
2019-12-02 12:00:00	NVDA	Stock	5.2712	5.2838	5.2425	5.2505	38583840.0
2019-12-02 13:00:00	NVDA	Stock	5.2505	5.2678	5.2488	5.2572	25915440.0
2019-12-02 14:00:00	NVDA	Stock	5.2571	5.2778	5.2515	5.2699	32963640.0
2019-12-02 15:00:00	NVDA	Stock	5.27	5.2722	5.216	5.229	72772640.0
2019-12-02 16:00:00	NVDA	Stock	5.2312	5.2312	5.223	5.2278	3936680.0
2019-12-02 17:00:00	NVDA	Stock	5.2278	5.232	5.225	5.2275	101160.0
2019-12-02 18:00:00	NVDA	Stock	5.225	5.225	5.1812	5.1858	1083840.0
2019-12-02 19:00:00	NVDA	Stock	5.1808	5.1998	5.18	5.189	437080.0
2019-12-02 04:00:00	AMZN	Stock	90.5	90.6495	90.5	90.6	14520.0
2019-12-02 05:00:00	AMZN	Stock	90.55	90.57	90.5	90.5	18140.0
2019-12-02 06:00:00	AMZN	Stock	90.494	90.494	90.261	90.261	13200.0

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

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