PREVIEW / stock_1hour / 2021-11-16

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-16.parquet
  size:    1.5 MB
  rows:    67,577
  symbols: 2,696

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
2021-11-16 04:00:00	AAPL	Stock	149.92	149.92	149.6	149.7	8074.0
2021-11-16 05:00:00	AAPL	Stock	149.62	149.68	149.57	149.68	4572.0
2021-11-16 06:00:00	AAPL	Stock	149.67	150.0	149.66	149.99	4458.0
2021-11-16 07:00:00	AAPL	Stock	149.98	150.24	149.98	150.13	46237.0
2021-11-16 08:00:00	AAPL	Stock	150.08	150.25	149.625	149.99	221199.0
2021-11-16 09:00:00	AAPL	Stock	149.99	150.39	149.6	149.845	6175943.0
2021-11-16 10:00:00	AAPL	Stock	149.84	149.9	149.34	149.68	5166001.0
2021-11-16 11:00:00	AAPL	Stock	149.675	151.37	149.6627	151.17	8743311.0
2021-11-16 12:00:00	AAPL	Stock	151.18	151.488	151.06	151.155	4228505.0
2021-11-16 13:00:00	AAPL	Stock	151.14	151.47	151.0	151.385	3632709.0
2021-11-16 14:00:00	AAPL	Stock	151.39	151.47	150.94	151.03	3418064.0
2021-11-16 15:00:00	AAPL	Stock	151.03	151.25	150.805	151.0	6301877.0
2021-11-16 16:00:00	AAPL	Stock	151.0	151.24	150.63	150.99	8267000.0
2021-11-16 17:00:00	AAPL	Stock	150.96	151.14	150.91	151.13	26496.0
2021-11-16 18:00:00	AAPL	Stock	151.1	151.15	150.94	151.05	45775.0
2021-11-16 19:00:00	AAPL	Stock	151.02	151.08	150.91	151.0	14159.0
2021-11-16 04:00:00	MSFT	Stock	336.55	336.68	336.55	336.68	400.0
2021-11-16 05:00:00	MSFT	Stock	336.67	336.8	336.32	336.77	3162.0
2021-11-16 06:00:00	MSFT	Stock	336.73	337.75	336.73	337.25	15338.0
2021-11-16 07:00:00	MSFT	Stock	337.13	337.13	336.62	336.8	20031.0
2021-11-16 08:00:00	MSFT	Stock	337.05	337.19	336.35	336.4	30278.0
2021-11-16 09:00:00	MSFT	Stock	336.38	337.56	335.51	337.0	1743988.0
2021-11-16 10:00:00	MSFT	Stock	337.02	338.01	336.71	337.7199	1688648.0
2021-11-16 11:00:00	MSFT	Stock	337.7	339.98	337.69	339.09	2077319.0
2021-11-16 12:00:00	MSFT	Stock	339.11	340.43	339.02	340.3386	1495198.0
2021-11-16 13:00:00	MSFT	Stock	340.335	340.54	339.81	340.35	1164755.0
2021-11-16 14:00:00	MSFT	Stock	340.355	340.67	339.81	339.855	1135824.0
2021-11-16 15:00:00	MSFT	Stock	339.85	340.37	339.2	339.58	2338857.0
2021-11-16 16:00:00	MSFT	Stock	339.51	339.65	339.35	339.6	2876482.0
2021-11-16 17:00:00	MSFT	Stock	339.65	339.77	339.54	339.7	9520.0
2021-11-16 18:00:00	MSFT	Stock	339.55	339.79	339.52	339.79	5057.0
2021-11-16 19:00:00	MSFT	Stock	339.8	339.98	339.75	339.95	3417.0
2021-11-16 04:00:00	NVDA	Stock	29.97	29.988	29.668	29.778	103590.0
2021-11-16 05:00:00	NVDA	Stock	29.76	29.776	29.58	29.675	119790.0
2021-11-16 06:00:00	NVDA	Stock	29.692	29.837	29.692	29.816	86690.0
2021-11-16 07:00:00	NVDA	Stock	29.821	29.877	29.642	29.665	315240.0
2021-11-16 08:00:00	NVDA	Stock	29.789	30.1	29.61	29.78	1104640.0
2021-11-16 09:00:00	NVDA	Stock	29.752	30.2284	29.58	29.875	31618600.0
2021-11-16 10:00:00	NVDA	Stock	29.875	30.24	29.855	30.184	28123350.0
2021-11-16 11:00:00	NVDA	Stock	30.186	30.39	30.181	30.248	26157520.0
2021-11-16 12:00:00	NVDA	Stock	30.2451	30.25	29.81	29.9105	19890190.0
2021-11-16 13:00:00	NVDA	Stock	29.9105	29.966	29.808	29.9505	14083940.0
2021-11-16 14:00:00	NVDA	Stock	29.947	30.192	29.932	30.096	19132050.0
2021-11-16 15:00:00	NVDA	Stock	30.098	30.266	29.99	30.1865	23739660.0
2021-11-16 16:00:00	NVDA	Stock	30.203	30.3	30.185	30.27	15222620.0
2021-11-16 17:00:00	NVDA	Stock	30.279	30.375	30.216	30.35	422130.0
2021-11-16 18:00:00	NVDA	Stock	30.342	30.369	30.333	30.353	451530.0
2021-11-16 19:00:00	NVDA	Stock	30.35	30.379	30.335	30.35	373250.0
2021-11-16 07:00:00	AMZN	Stock	177.2185	177.2185	176.797	177.1945	49880.0
2021-11-16 08:00:00	AMZN	Stock	176.9	177.4	176.7539	177.1	64360.0

> showing 50 of 67,577 rows — these rows as CSV

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