PREVIEW / stock_1hour / 2022-06-13

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-13.parquet
  size:    1.5 MB
  rows:    66,951
  symbols: 2,428

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
2022-06-13 04:00:00	AAPL	Stock	134.98	135.98	132.54	132.89	222372.0
2022-06-13 05:00:00	AAPL	Stock	132.88	133.2	132.56	133.07	103233.0
2022-06-13 06:00:00	AAPL	Stock	133.02	133.6	132.92	133.48	60128.0
2022-06-13 07:00:00	AAPL	Stock	133.48	133.8	132.53	132.69	374064.0
2022-06-13 08:00:00	AAPL	Stock	133.69	134.5	132.54	133.1	956490.0
2022-06-13 09:00:00	AAPL	Stock	133.07	134.66	132.582	134.5999	16033566.0
2022-06-13 10:00:00	AAPL	Stock	134.6	135.2	132.57	133.07	15869564.0
2022-06-13 11:00:00	AAPL	Stock	133.0899	134.53	132.63	133.73	11947486.0
2022-06-13 12:00:00	AAPL	Stock	133.73	135.0569	133.51	133.725	10239176.0
2022-06-13 13:00:00	AAPL	Stock	133.73	134.3179	133.14	134.2325	7265563.0
2022-06-13 14:00:00	AAPL	Stock	134.23	134.25	132.71	132.745	8541254.0
2022-06-13 15:00:00	AAPL	Stock	132.75	133.32	131.44	131.88	22457039.0
2022-06-13 16:00:00	AAPL	Stock	131.88	132.62	131.88	132.45	13611330.0
2022-06-13 17:00:00	AAPL	Stock	132.37	132.52	132.25	132.35	57671.0
2022-06-13 18:00:00	AAPL	Stock	132.4	132.87	132.3	132.5	86133.0
2022-06-13 19:00:00	AAPL	Stock	132.5	132.52	132.03	132.4	100993.0
2022-06-13 04:00:00	MSFT	Stock	249.97	250.0	245.1	245.74	37440.0
2022-06-13 05:00:00	MSFT	Stock	245.79	246.61	245.53	246.29	23236.0
2022-06-13 06:00:00	MSFT	Stock	246.43	247.09	246.11	246.81	17444.0
2022-06-13 07:00:00	MSFT	Stock	246.86	247.44	246.06	246.37	41313.0
2022-06-13 08:00:00	MSFT	Stock	247.2	252.358	246.0201	246.75	107233.0
2022-06-13 09:00:00	MSFT	Stock	246.75	249.0242	244.2171	247.39	4075877.0
2022-06-13 10:00:00	MSFT	Stock	247.4	248.6101	245.43	245.75	4254906.0
2022-06-13 11:00:00	MSFT	Stock	245.75	246.65	244.4862	245.5	2683861.0
2022-06-13 12:00:00	MSFT	Stock	245.48	247.61	245.24	245.43	2031843.0
2022-06-13 13:00:00	MSFT	Stock	245.44	246.14	244.27	245.83	1742118.0
2022-06-13 14:00:00	MSFT	Stock	245.81	245.84	243.55	243.61	2050107.0
2022-06-13 15:00:00	MSFT	Stock	243.59	244.22	241.53	242.33	6186404.0
2022-06-13 16:00:00	MSFT	Stock	242.28	244.2799	242.25	243.2581	8027710.0
2022-06-13 17:00:00	MSFT	Stock	243.5957	243.8	243.49	243.6799	8921.0
2022-06-13 18:00:00	MSFT	Stock	243.68	244.6	243.68	244.15	11637.0
2022-06-13 19:00:00	MSFT	Stock	244.16	244.16	243.25	243.66	8356.0
2022-06-13 04:00:00	NVDA	Stock	16.446	16.546	16.1	16.185	1350310.0
2022-06-13 05:00:00	NVDA	Stock	16.182	16.24	16.125	16.178	281570.0
2022-06-13 06:00:00	NVDA	Stock	16.2	16.3	16.172	16.264	266800.0
2022-06-13 07:00:00	NVDA	Stock	16.28	16.3	15.958	16.007	2192680.0
2022-06-13 08:00:00	NVDA	Stock	16.2526	16.32	15.978	16.057	2894810.0
2022-06-13 09:00:00	NVDA	Stock	16.053	16.312	15.935	15.9815	68570820.0
2022-06-13 10:00:00	NVDA	Stock	15.975	16.137	15.705	15.764	80216730.0
2022-06-13 11:00:00	NVDA	Stock	15.763	15.93	15.66	15.8627	55438010.0
2022-06-13 12:00:00	NVDA	Stock	15.862	16.155	15.819	15.9059	51565550.0
2022-06-13 13:00:00	NVDA	Stock	15.908	16.013	15.855	15.999	39750390.0
2022-06-13 14:00:00	NVDA	Stock	15.998	16.001	15.78	15.781	44630890.0
2022-06-13 15:00:00	NVDA	Stock	15.784	15.896	15.606	15.645	86246910.0
2022-06-13 16:00:00	NVDA	Stock	15.647	15.741	15.64	15.706	36360380.0
2022-06-13 17:00:00	NVDA	Stock	15.694	15.73	15.6858	15.71	291940.0
2022-06-13 18:00:00	NVDA	Stock	15.71	15.745	15.65	15.69	502530.0
2022-06-13 19:00:00	NVDA	Stock	15.697	15.705	15.647	15.68	401170.0
2022-06-13 04:00:00	AMZN	Stock	107.0	108.48	105.55	105.82	168238.0
2022-06-13 05:00:00	AMZN	Stock	105.73	106.1	105.51	105.98	46719.0

> showing 50 of 66,951 rows — these rows as CSV

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