PREVIEW / stock_1hour / 2023-07-26

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-26.parquet
  size:    1.3 MB
  rows:    59,974
  symbols: 1,522

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-07-26 04:00:00	AAPL	Stock	193.59	193.92	193.59	193.8	8374.0
2023-07-26 05:00:00	AAPL	Stock	193.7	193.75	193.63	193.63	2920.0
2023-07-26 06:00:00	AAPL	Stock	193.69	193.69	193.21	193.3	17751.0
2023-07-26 07:00:00	AAPL	Stock	193.37	193.46	193.3	193.3	19070.0
2023-07-26 08:00:00	AAPL	Stock	194.05	194.05	193.19	193.6	108063.0
2023-07-26 09:00:00	AAPL	Stock	193.59	194.18	193.27	193.65	3605575.0
2023-07-26 10:00:00	AAPL	Stock	193.655	194.72	193.64	194.4106	5345381.0
2023-07-26 11:00:00	AAPL	Stock	194.41	194.83	194.02	194.78	2998995.0
2023-07-26 12:00:00	AAPL	Stock	194.7664	194.94	194.185	194.375	2163153.0
2023-07-26 13:00:00	AAPL	Stock	194.37	194.45	194.05	194.155	1917288.0
2023-07-26 14:00:00	AAPL	Stock	194.1521	195.64	193.94	195.065	5416270.0
2023-07-26 15:00:00	AAPL	Stock	195.08	195.19	193.66	194.52	7611232.0
2023-07-26 16:00:00	AAPL	Stock	194.52	195.09	194.42	194.48	7336363.0
2023-07-26 17:00:00	AAPL	Stock	194.44	194.77	194.36	194.71	46340.0
2023-07-26 18:00:00	AAPL	Stock	194.7	194.91	194.65	194.83	65933.0
2023-07-26 19:00:00	AAPL	Stock	194.81	195.0	194.78	195.0	19840.0
2023-07-26 04:00:00	MSFT	Stock	337.78	340.0	335.82	336.3	76454.0
2023-07-26 05:00:00	MSFT	Stock	336.05	338.23	336.05	338.0	44178.0
2023-07-26 06:00:00	MSFT	Stock	338.11	339.2	337.8	338.11	49463.0
2023-07-26 07:00:00	MSFT	Stock	338.0	339.8	338.0	338.94	158327.0
2023-07-26 08:00:00	MSFT	Stock	338.02	341.9	337.58	338.38	434812.0
2023-07-26 09:00:00	MSFT	Stock	338.4	344.67	337.1	341.3652	8800082.0
2023-07-26 10:00:00	MSFT	Stock	341.37	341.6	333.93	334.09	9087477.0
2023-07-26 11:00:00	MSFT	Stock	334.106	337.45	333.11	336.95	5239296.0
2023-07-26 12:00:00	MSFT	Stock	336.98	336.98	334.58	335.3	2968970.0
2023-07-26 13:00:00	MSFT	Stock	335.29	335.73	334.5	334.93	2446535.0
2023-07-26 14:00:00	MSFT	Stock	334.84	338.1887	334.5	336.01	4519959.0
2023-07-26 15:00:00	MSFT	Stock	335.985	338.01	334.03	337.93	5900092.0
2023-07-26 16:00:00	MSFT	Stock	337.77	338.55	337.0	337.28	2967512.0
2023-07-26 17:00:00	MSFT	Stock	337.37	337.77	337.16	337.6	24901.0
2023-07-26 18:00:00	MSFT	Stock	337.54	337.77	337.4	337.75	14987.0
2023-07-26 19:00:00	MSFT	Stock	337.71	338.09	337.6	338.0	19821.0
2023-07-26 04:00:00	NVDA	Stock	46.05	46.098	45.852	45.853	116500.0
2023-07-26 05:00:00	NVDA	Stock	45.915	45.954	45.885	45.9	27790.0
2023-07-26 06:00:00	NVDA	Stock	45.899	45.901	45.706	45.74	176210.0
2023-07-26 07:00:00	NVDA	Stock	45.751	45.92	45.75	45.88	269970.0
2023-07-26 08:00:00	NVDA	Stock	45.74	46.205	45.735	45.782	888910.0
2023-07-26 09:00:00	NVDA	Stock	45.765	46.097	45.151	45.49	43017150.0
2023-07-26 10:00:00	NVDA	Stock	45.5125	45.63	44.7642	44.822	42562600.0
2023-07-26 11:00:00	NVDA	Stock	44.8165	45.23	44.63	45.0586	36485760.0
2023-07-26 12:00:00	NVDA	Stock	45.0523	45.168	44.817	44.94	19612970.0
2023-07-26 13:00:00	NVDA	Stock	44.939	45.307	44.921	45.217	21675100.0
2023-07-26 14:00:00	NVDA	Stock	45.2185	45.892	45.13	45.652	48726380.0
2023-07-26 15:00:00	NVDA	Stock	45.66	45.75	45.143	45.455	51208130.0
2023-07-26 16:00:00	NVDA	Stock	45.461	45.73	45.3	45.395	16198960.0
2023-07-26 17:00:00	NVDA	Stock	45.4	45.46	45.331	45.45	399530.0
2023-07-26 18:00:00	NVDA	Stock	45.425	45.63	45.425	45.596	364150.0
2023-07-26 19:00:00	NVDA	Stock	45.58	45.788	45.575	45.7	617590.0
2023-07-26 04:00:00	AMZN	Stock	125.96	126.77	125.96	126.57	35966.0
2023-07-26 05:00:00	AMZN	Stock	126.5	126.8	126.46	126.8	15295.0

> showing 50 of 59,974 rows — these rows as CSV

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