PREVIEW / stock_1hour / 2022-09-13

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-13.parquet
  size:    1.4 MB
  rows:    62,833
  symbols: 2,196

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-09-13 04:00:00	AAPL	Stock	164.07	164.68	164.07	164.55	44578.0
2022-09-13 05:00:00	AAPL	Stock	164.6	164.6	164.35	164.51	16949.0
2022-09-13 06:00:00	AAPL	Stock	164.45	164.73	164.37	164.6	26553.0
2022-09-13 07:00:00	AAPL	Stock	164.62	164.9	164.51	164.68	95865.0
2022-09-13 08:00:00	AAPL	Stock	164.6937	164.9	159.59	159.6	1934313.0
2022-09-13 09:00:00	AAPL	Stock	159.6	160.54	158.26	158.2701	14345025.0
2022-09-13 10:00:00	AAPL	Stock	158.28	158.3679	156.84	157.23	14497336.0
2022-09-13 11:00:00	AAPL	Stock	157.22	157.27	156.25	156.335	9767171.0
2022-09-13 12:00:00	AAPL	Stock	156.33	156.76	156.15	156.31	7855643.0
2022-09-13 13:00:00	AAPL	Stock	156.3	156.67	155.76	155.785	9575222.0
2022-09-13 14:00:00	AAPL	Stock	155.7812	155.87	154.59	154.8	10525164.0
2022-09-13 15:00:00	AAPL	Stock	154.79	154.89	153.37	153.85	21810755.0
2022-09-13 16:00:00	AAPL	Stock	153.85	154.07	153.57	153.88	16315253.0
2022-09-13 17:00:00	AAPL	Stock	153.8475	154.22	153.82	154.05	258380.0
2022-09-13 18:00:00	AAPL	Stock	154.1	154.2	153.8	154.19	65451.0
2022-09-13 19:00:00	AAPL	Stock	154.18	154.3	154.01	154.26	76201.0
2022-09-13 04:00:00	MSFT	Stock	268.05	268.05	267.15	268.05	1945.0
2022-09-13 05:00:00	MSFT	Stock	268.08	268.08	267.75	267.85	663.0
2022-09-13 06:00:00	MSFT	Stock	267.99	268.56	267.99	268.55	1225.0
2022-09-13 07:00:00	MSFT	Stock	268.5	268.8	268.33	268.8	5784.0
2022-09-13 08:00:00	MSFT	Stock	268.71	269.5	259.14	259.25	270541.0
2022-09-13 09:00:00	MSFT	Stock	259.15	260.4	257.4	257.42	2607137.0
2022-09-13 10:00:00	MSFT	Stock	257.42	257.7	255.61	255.79	2566690.0
2022-09-13 11:00:00	MSFT	Stock	255.79	255.99	254.62	255.265	2245692.0
2022-09-13 12:00:00	MSFT	Stock	255.24	256.0899	254.98	255.87	1486137.0
2022-09-13 13:00:00	MSFT	Stock	255.86	256.96	255.52	255.79	1548088.0
2022-09-13 14:00:00	MSFT	Stock	255.81	255.8996	254.01	254.22	1363105.0
2022-09-13 15:00:00	MSFT	Stock	254.23	254.32	251.59	251.995	5136434.0
2022-09-13 16:00:00	MSFT	Stock	252.0	252.33	251.7	252.32	8392395.0
2022-09-13 17:00:00	MSFT	Stock	252.3022	252.44	251.99	252.31	155262.0
2022-09-13 18:00:00	MSFT	Stock	252.31	254.3	252.1	253.87	21480.0
2022-09-13 19:00:00	MSFT	Stock	253.8	253.8	253.05	253.05	9971.0
2022-09-13 04:00:00	NVDA	Stock	14.552	14.6	14.552	14.578	87120.0
2022-09-13 05:00:00	NVDA	Stock	14.58	14.582	14.551	14.58	35140.0
2022-09-13 06:00:00	NVDA	Stock	14.579	14.613	14.579	14.61	46670.0
2022-09-13 07:00:00	NVDA	Stock	14.605	14.65	14.581	14.65	221860.0
2022-09-13 08:00:00	NVDA	Stock	14.625	14.716	13.817	13.834	8252500.0
2022-09-13 09:00:00	NVDA	Stock	13.832	13.922	13.691	13.7115	73888780.0
2022-09-13 10:00:00	NVDA	Stock	13.71	13.776	13.443	13.4815	93549040.0
2022-09-13 11:00:00	NVDA	Stock	13.482	13.5	13.38	13.442	63562970.0
2022-09-13 12:00:00	NVDA	Stock	13.441	13.493	13.403	13.4125	43343090.0
2022-09-13 13:00:00	NVDA	Stock	13.412	13.504	13.39	13.422	50016640.0
2022-09-13 14:00:00	NVDA	Stock	13.422	13.47	13.306	13.312	51056420.0
2022-09-13 15:00:00	NVDA	Stock	13.312	13.325	13.099	13.131	132112470.0
2022-09-13 16:00:00	NVDA	Stock	13.131	13.165	13.088	13.127	65336010.0
2022-09-13 17:00:00	NVDA	Stock	13.129	13.133	13.119	13.132	379530.0
2022-09-13 18:00:00	NVDA	Stock	13.133	13.177	13.118	13.165	714020.0
2022-09-13 19:00:00	NVDA	Stock	13.173	13.174	13.135	13.135	553870.0
2022-09-13 04:00:00	AMZN	Stock	136.88	137.0	136.66	136.7	6848.0
2022-09-13 05:00:00	AMZN	Stock	136.86	136.86	136.54	136.61	6258.0

> showing 50 of 62,833 rows — these rows as CSV

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