PREVIEW / stock_1hour / 2023-05-22

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-22.parquet
  size:    1.4 MB
  rows:    60,685
  symbols: 1,647

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
2023-05-22 04:00:00	AAPL	Stock	175.25	175.46	175.22	175.3	14377.0
2023-05-22 05:00:00	AAPL	Stock	175.27	175.3	172.87	173.31	104526.0
2023-05-22 06:00:00	AAPL	Stock	173.31	173.7	172.6	173.5	119729.0
2023-05-22 07:00:00	AAPL	Stock	173.5	173.75	173.24	173.42	133150.0
2023-05-22 08:00:00	AAPL	Stock	173.4998	175.16	173.22	173.56	275214.0
2023-05-22 09:00:00	AAPL	Stock	173.56	174.71	173.42	174.0199	5959334.0
2023-05-22 10:00:00	AAPL	Stock	174.015	174.38	173.45	173.905	6031100.0
2023-05-22 11:00:00	AAPL	Stock	173.905	174.6	173.83	174.3391	3922408.0
2023-05-22 12:00:00	AAPL	Stock	174.335	174.45	173.91	174.21	3199682.0
2023-05-22 13:00:00	AAPL	Stock	174.22	174.52	173.87	174.235	2887096.0
2023-05-22 14:00:00	AAPL	Stock	174.2399	174.62	174.09	174.375	2673249.0
2023-05-22 15:00:00	AAPL	Stock	174.37	174.5	174.035	174.24	5477768.0
2023-05-22 16:00:00	AAPL	Stock	174.2	174.34	174.09	174.2	4448879.0
2023-05-22 17:00:00	AAPL	Stock	174.19	174.2381	174.13	174.15	20937.0
2023-05-22 18:00:00	AAPL	Stock	174.16	174.3489	174.16	174.33	15659.0
2023-05-22 19:00:00	AAPL	Stock	174.36	174.74	174.3	174.7	45416.0
2023-05-22 04:00:00	MSFT	Stock	318.45	318.84	318.42	318.71	4258.0
2023-05-22 05:00:00	MSFT	Stock	318.42	318.74	318.24	318.69	7898.0
2023-05-22 06:00:00	MSFT	Stock	318.4	318.75	318.2	318.6	5593.0
2023-05-22 07:00:00	MSFT	Stock	318.28	318.88	317.85	318.88	13046.0
2023-05-22 08:00:00	MSFT	Stock	318.45	319.29	317.8033	318.7	34599.0
2023-05-22 09:00:00	MSFT	Stock	318.6427	321.94	318.01	320.965	3188676.0
2023-05-22 10:00:00	MSFT	Stock	320.95	321.94	319.53	321.85	2681412.0
2023-05-22 11:00:00	MSFT	Stock	321.87	322.59	320.54	320.68	1958896.0
2023-05-22 12:00:00	MSFT	Stock	320.69	321.3201	320.27	320.485	1197996.0
2023-05-22 13:00:00	MSFT	Stock	320.45	321.41	319.75	320.8455	1409415.0
2023-05-22 14:00:00	MSFT	Stock	320.851	321.6	320.73	321.12	1152438.0
2023-05-22 15:00:00	MSFT	Stock	321.11	321.29	320.58	321.235	2394351.0
2023-05-22 16:00:00	MSFT	Stock	321.18	321.35	321.1343	321.2	2258183.0
2023-05-22 17:00:00	MSFT	Stock	321.28	321.28	321.18	321.23	3199.0
2023-05-22 18:00:00	MSFT	Stock	321.27	321.55	321.25	321.54	9194.0
2023-05-22 19:00:00	MSFT	Stock	321.56	322.2	321.56	322.15	16286.0
2023-05-22 04:00:00	NVDA	Stock	31.488	31.488	30.921	30.957	247810.0
2023-05-22 05:00:00	NVDA	Stock	30.935	30.948	30.784	30.784	273440.0
2023-05-22 06:00:00	NVDA	Stock	30.77	30.937	30.741	30.935	362010.0
2023-05-22 07:00:00	NVDA	Stock	30.904	31.05	30.904	31.035	945130.0
2023-05-22 08:00:00	NVDA	Stock	31.105	31.28	30.9248	31.025	1870200.0
2023-05-22 09:00:00	NVDA	Stock	31.025	31.3625	30.68	31.28	68315660.0
2023-05-22 10:00:00	NVDA	Stock	31.286	31.52	31.071	31.372	66773670.0
2023-05-22 11:00:00	NVDA	Stock	31.3725	31.4	31.183	31.2508	31494720.0
2023-05-22 12:00:00	NVDA	Stock	31.249	31.361	31.15	31.24	28263640.0
2023-05-22 13:00:00	NVDA	Stock	31.2411	31.399	31.1709	31.3338	23762490.0
2023-05-22 14:00:00	NVDA	Stock	31.3334	31.4148	31.279	31.332	18900260.0
2023-05-22 15:00:00	NVDA	Stock	31.3295	31.347	31.1025	31.182	34486350.0
2023-05-22 16:00:00	NVDA	Stock	31.182	31.21	31.15	31.2	16209960.0
2023-05-22 17:00:00	NVDA	Stock	31.194	31.2	31.161	31.178	1071140.0
2023-05-22 18:00:00	NVDA	Stock	31.178	31.227	31.178	31.217	166050.0
2023-05-22 19:00:00	NVDA	Stock	31.218	31.317	31.218	31.295	242280.0
2023-05-22 04:00:00	AMZN	Stock	116.25	116.75	116.14	116.65	34124.0
2023-05-22 05:00:00	AMZN	Stock	116.63	116.89	116.6	116.83	22984.0

> showing 50 of 60,685 rows — these rows as CSV

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