PREVIEW / stock_1hour / 2022-12-21

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-12-21.parquet
  size:    1.4 MB
  rows:    61,412
  symbols: 1,974

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-12-21 04:00:00	AAPL	Stock	133.31	133.35	133.07	133.33	25903.0
2022-12-21 05:00:00	AAPL	Stock	133.33	133.33	132.93	133.03	14371.0
2022-12-21 06:00:00	AAPL	Stock	133.08	133.19	132.76	133.04	12249.0
2022-12-21 07:00:00	AAPL	Stock	133.0	133.14	132.53	133.04	63997.0
2022-12-21 08:00:00	AAPL	Stock	132.6108	133.4	132.53	133.1	188219.0
2022-12-21 09:00:00	AAPL	Stock	133.16	134.43	132.75	133.54	8275450.0
2022-12-21 10:00:00	AAPL	Stock	133.54	136.67	133.47	136.605	14251458.0
2022-12-21 11:00:00	AAPL	Stock	136.6	136.81	135.281	135.5288	9651779.0
2022-12-21 12:00:00	AAPL	Stock	135.53	136.01	135.08	135.9935	6132627.0
2022-12-21 13:00:00	AAPL	Stock	136.01	136.17	135.16	135.47	5276093.0
2022-12-21 14:00:00	AAPL	Stock	135.48	136.1199	135.11	135.39	6106343.0
2022-12-21 15:00:00	AAPL	Stock	135.4	135.77	135.01	135.43	9435326.0
2022-12-21 16:00:00	AAPL	Stock	135.43	135.73	135.32	135.59	13809754.0
2022-12-21 17:00:00	AAPL	Stock	135.58	135.66	135.5	135.66	36556.0
2022-12-21 18:00:00	AAPL	Stock	135.67	135.7	135.56	135.63	35452.0
2022-12-21 19:00:00	AAPL	Stock	135.63	135.73	135.51	135.67	31802.0
2022-12-21 04:00:00	MSFT	Stock	243.0	243.39	243.0	243.39	6325.0
2022-12-21 05:00:00	MSFT	Stock	243.25	243.25	242.55	242.55	13722.0
2022-12-21 06:00:00	MSFT	Stock	242.47	242.7	242.1	242.47	5411.0
2022-12-21 07:00:00	MSFT	Stock	242.55	242.66	241.74	242.55	6523.0
2022-12-21 08:00:00	MSFT	Stock	242.45	242.9054	241.196	242.63	29992.0
2022-12-21 09:00:00	MSFT	Stock	242.59	243.68	240.11	242.1432	2696328.0
2022-12-21 10:00:00	MSFT	Stock	242.15	244.51	241.92	244.37	2699811.0
2022-12-21 11:00:00	MSFT	Stock	244.39	245.39	243.48	243.67	2053943.0
2022-12-21 12:00:00	MSFT	Stock	243.7	245.18	243.48	245.1	1500988.0
2022-12-21 13:00:00	MSFT	Stock	245.1017	245.61	244.44	244.77	1469494.0
2022-12-21 14:00:00	MSFT	Stock	244.79	245.615	244.48	244.75	1498068.0
2022-12-21 15:00:00	MSFT	Stock	244.76	245.1	243.655	244.46	3189040.0
2022-12-21 16:00:00	MSFT	Stock	244.43	244.7	244.29	244.63	3940474.0
2022-12-21 17:00:00	MSFT	Stock	244.63	244.63	244.448	244.448	998.0
2022-12-21 18:00:00	MSFT	Stock	244.44	244.94	244.44	244.55	3619.0
2022-12-21 19:00:00	MSFT	Stock	244.45	244.55	244.43	244.49	2052.0
2022-12-21 04:00:00	NVDA	Stock	16.196	16.231	16.182	16.182	37020.0
2022-12-21 05:00:00	NVDA	Stock	16.185	16.185	16.129	16.129	18160.0
2022-12-21 06:00:00	NVDA	Stock	16.15	16.16	16.123	16.16	28800.0
2022-12-21 07:00:00	NVDA	Stock	16.158	16.166	16.09	16.165	114910.0
2022-12-21 08:00:00	NVDA	Stock	16.1401	16.232	16.0448	16.189	607760.0
2022-12-21 09:00:00	NVDA	Stock	16.225	16.508	16.085	16.3335	49489090.0
2022-12-21 10:00:00	NVDA	Stock	16.337	16.547	16.314	16.528	54975320.0
2022-12-21 11:00:00	NVDA	Stock	16.527	16.593	16.393	16.4645	34368190.0
2022-12-21 12:00:00	NVDA	Stock	16.466	16.541	16.437	16.526	23650160.0
2022-12-21 13:00:00	NVDA	Stock	16.526	16.567	16.5035	16.546	21260630.0
2022-12-21 14:00:00	NVDA	Stock	16.546	16.627	16.535	16.56	26568930.0
2022-12-21 15:00:00	NVDA	Stock	16.558	16.5627	16.441	16.502	38126010.0
2022-12-21 16:00:00	NVDA	Stock	16.501	16.543	16.45	16.493	22808540.0
2022-12-21 17:00:00	NVDA	Stock	16.493	16.5	16.493	16.5	47200.0
2022-12-21 18:00:00	NVDA	Stock	16.497	16.509	16.493	16.509	85040.0
2022-12-21 19:00:00	NVDA	Stock	16.5	16.5	16.443	16.456	178870.0
2022-12-21 04:00:00	AMZN	Stock	86.04	86.43	86.04	86.41	8521.0
2022-12-21 05:00:00	AMZN	Stock	86.3	86.3	86.03	86.03	9506.0

> showing 50 of 61,412 rows — these rows as CSV

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