PREVIEW / stock_1hour / 2022-07-05

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-07-05.parquet
  size:    1.4 MB
  rows:    63,042
  symbols: 2,373

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-07-05 04:00:00	AAPL	Stock	139.02	140.22	137.83	138.03	44544.0
2022-07-05 05:00:00	AAPL	Stock	138.15	138.17	137.85	138.17	15571.0
2022-07-05 06:00:00	AAPL	Stock	138.2	138.55	138.18	138.45	16338.0
2022-07-05 07:00:00	AAPL	Stock	138.41	138.55	137.88	137.89	117869.0
2022-07-05 08:00:00	AAPL	Stock	138.43	138.54	137.2	137.3001	355768.0
2022-07-05 09:00:00	AAPL	Stock	137.27	138.84	136.93	138.22	8744512.0
2022-07-05 10:00:00	AAPL	Stock	138.21	139.66	137.8166	138.9	9273867.0
2022-07-05 11:00:00	AAPL	Stock	138.88	139.73	138.17	139.331	6601518.0
2022-07-05 12:00:00	AAPL	Stock	139.33	140.03	138.94	138.965	6176962.0
2022-07-05 13:00:00	AAPL	Stock	138.97	140.179	138.87	140.05	5559265.0
2022-07-05 14:00:00	AAPL	Stock	140.0504	141.44	139.885	140.92	6636635.0
2022-07-05 15:00:00	AAPL	Stock	140.92	141.61	140.55	141.59	10587928.0
2022-07-05 16:00:00	AAPL	Stock	141.59	141.69	141.4	141.51	8114302.0
2022-07-05 17:00:00	AAPL	Stock	141.58	141.6	141.45	141.55	40638.0
2022-07-05 18:00:00	AAPL	Stock	141.58	141.78	141.55	141.61	23417.0
2022-07-05 19:00:00	AAPL	Stock	141.61	141.66	141.32	141.37	40167.0
2022-07-05 04:00:00	MSFT	Stock	260.04	260.39	257.74	257.74	2913.0
2022-07-05 05:00:00	MSFT	Stock	257.5	258.0	257.27	257.5	950.0
2022-07-05 06:00:00	MSFT	Stock	258.29	258.73	258.0	258.55	2500.0
2022-07-05 07:00:00	MSFT	Stock	258.59	258.72	257.01	257.03	13267.0
2022-07-05 08:00:00	MSFT	Stock	258.48	258.932	255.58	255.58	77969.0
2022-07-05 09:00:00	MSFT	Stock	255.98	256.8755	254.74	256.19	2032721.0
2022-07-05 10:00:00	MSFT	Stock	256.09	258.78	255.56	257.23	1934407.0
2022-07-05 11:00:00	MSFT	Stock	257.21	258.1	255.95	257.39	1189701.0
2022-07-05 12:00:00	MSFT	Stock	257.38	258.55	256.56	257.575	1282314.0
2022-07-05 13:00:00	MSFT	Stock	257.58	260.31	257.49	259.655	1559196.0
2022-07-05 14:00:00	MSFT	Stock	259.66	262.26	259.04	262.12	1759098.0
2022-07-05 15:00:00	MSFT	Stock	262.12	262.98	260.96	262.97	2776034.0
2022-07-05 16:00:00	MSFT	Stock	262.94	262.94	262.6658	262.83	3835290.0
2022-07-05 17:00:00	MSFT	Stock	262.8	263.15	262.73	263.1	9919.0
2022-07-05 18:00:00	MSFT	Stock	263.21	263.87	262.76	262.95	4033.0
2022-07-05 19:00:00	MSFT	Stock	263.11	263.11	262.0	262.1	16068.0
2022-07-05 04:00:00	NVDA	Stock	14.545	14.6	14.361	14.364	313790.0
2022-07-05 05:00:00	NVDA	Stock	14.37	14.373	14.313	14.35	116800.0
2022-07-05 06:00:00	NVDA	Stock	14.353	14.394	14.34	14.35	76860.0
2022-07-05 07:00:00	NVDA	Stock	14.35	14.4	14.2	14.225	517620.0
2022-07-05 08:00:00	NVDA	Stock	14.3562	14.6	14.125	14.145	2657200.0
2022-07-05 09:00:00	NVDA	Stock	14.1404	14.346	14.055	14.267	80112520.0
2022-07-05 10:00:00	NVDA	Stock	14.265	14.884	14.163	14.615	123177330.0
2022-07-05 11:00:00	NVDA	Stock	14.614	14.646	14.465	14.596	63630980.0
2022-07-05 12:00:00	NVDA	Stock	14.596	14.749	14.531	14.6035	49445260.0
2022-07-05 13:00:00	NVDA	Stock	14.606	14.943	14.602	14.8255	65305250.0
2022-07-05 14:00:00	NVDA	Stock	14.826	14.944	14.751	14.858	50618530.0
2022-07-05 15:00:00	NVDA	Stock	14.859	14.971	14.776	14.964	69991390.0
2022-07-05 16:00:00	NVDA	Stock	14.964	14.99	14.93	14.97	20542990.0
2022-07-05 17:00:00	NVDA	Stock	14.971	14.98	14.9367	14.9404	640180.0
2022-07-05 18:00:00	NVDA	Stock	14.948	14.974	14.94	14.95	189050.0
2022-07-05 19:00:00	NVDA	Stock	14.948	14.964	14.893	14.934	499480.0
2022-07-05 04:00:00	AMZN	Stock	109.9	109.93	108.3	108.5	21839.0
2022-07-05 05:00:00	AMZN	Stock	108.49	108.49	108.07	108.28	9203.0

> showing 50 of 63,042 rows — these rows as CSV

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