PREVIEW / stock_1hour / 2023-03-06

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-06.parquet
  size:    1.4 MB
  rows:    60,958
  symbols: 1,802

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-03-06 04:00:00	AAPL	Stock	152.05	152.86	152.05	152.27	50736.0
2023-03-06 05:00:00	AAPL	Stock	152.32	152.87	152.3	152.81	27939.0
2023-03-06 06:00:00	AAPL	Stock	152.76	152.88	152.28	152.75	47678.0
2023-03-06 07:00:00	AAPL	Stock	152.68	153.49	152.5	153.45	204370.0
2023-03-06 08:00:00	AAPL	Stock	152.7	154.01	150.653	153.72	660463.0
2023-03-06 09:00:00	AAPL	Stock	153.74	155.03	153.46	154.4299	13337252.0
2023-03-06 10:00:00	AAPL	Stock	154.41	155.58	154.14	155.1467	11224002.0
2023-03-06 11:00:00	AAPL	Stock	155.15	156.07	155.15	155.735	9292619.0
2023-03-06 12:00:00	AAPL	Stock	155.735	156.3	154.96	155.06	8846857.0
2023-03-06 13:00:00	AAPL	Stock	155.06	155.445	154.5	154.55	7036074.0
2023-03-06 14:00:00	AAPL	Stock	154.55	154.63	153.96	154.1176	7288248.0
2023-03-06 15:00:00	AAPL	Stock	154.12	154.2958	153.7	153.87	9115247.0
2023-03-06 16:00:00	AAPL	Stock	153.89	153.89	153.6	153.62	7471119.0
2023-03-06 17:00:00	AAPL	Stock	153.62	153.83	153.56	153.7	71042.0
2023-03-06 18:00:00	AAPL	Stock	153.71	153.9	153.65	153.89	82317.0
2023-03-06 19:00:00	AAPL	Stock	153.85	153.98	153.72	153.78	58937.0
2023-03-06 04:00:00	MSFT	Stock	255.98	255.99	254.75	254.75	11773.0
2023-03-06 05:00:00	MSFT	Stock	255.19	255.65	255.19	255.65	1767.0
2023-03-06 06:00:00	MSFT	Stock	255.65	256.18	254.91	255.25	8273.0
2023-03-06 07:00:00	MSFT	Stock	255.45	255.73	255.4	255.51	8262.0
2023-03-06 08:00:00	MSFT	Stock	255.373	256.83	254.652	256.12	31563.0
2023-03-06 09:00:00	MSFT	Stock	256.29	257.97	255.98	257.55	2080605.0
2023-03-06 10:00:00	MSFT	Stock	257.5316	259.89	257.14	259.29	2555232.0
2023-03-06 11:00:00	MSFT	Stock	259.29	260.12	258.925	259.38	1868300.0
2023-03-06 12:00:00	MSFT	Stock	259.4	259.4	257.56	258.44	1764758.0
2023-03-06 13:00:00	MSFT	Stock	258.44	258.7	257.76	257.97	1190997.0
2023-03-06 14:00:00	MSFT	Stock	257.9884	258.515	257.53	257.6782	1144992.0
2023-03-06 15:00:00	MSFT	Stock	257.68	257.81	256.66	256.9	2630022.0
2023-03-06 16:00:00	MSFT	Stock	256.87	256.91	256.55	256.7	5335613.0
2023-03-06 17:00:00	MSFT	Stock	256.75	256.87	256.36	256.38	17751.0
2023-03-06 18:00:00	MSFT	Stock	256.3	256.89	256.26	256.86	5735.0
2023-03-06 19:00:00	MSFT	Stock	256.85	256.93	256.7001	256.93	5986.0
2023-03-06 04:00:00	NVDA	Stock	23.95	23.95	23.673	23.7	250950.0
2023-03-06 05:00:00	NVDA	Stock	23.7	23.813	23.679	23.813	138900.0
2023-03-06 06:00:00	NVDA	Stock	23.8	23.8	23.7	23.74	138070.0
2023-03-06 07:00:00	NVDA	Stock	23.744	23.835	23.737	23.815	272200.0
2023-03-06 08:00:00	NVDA	Stock	23.91	24.11	23.75	23.93	1494710.0
2023-03-06 09:00:00	NVDA	Stock	23.923	24.009	23.697	23.821	47730120.0
2023-03-06 10:00:00	NVDA	Stock	23.824	24.248	23.679	24.193	83244120.0
2023-03-06 11:00:00	NVDA	Stock	24.189	24.212	23.925	24.031	46476650.0
2023-03-06 12:00:00	NVDA	Stock	24.0305	24.0518	23.777	23.808	32529310.0
2023-03-06 13:00:00	NVDA	Stock	23.801	23.8472	23.651	23.6921	30701870.0
2023-03-06 14:00:00	NVDA	Stock	23.693	23.759	23.642	23.692	35415010.0
2023-03-06 15:00:00	NVDA	Stock	23.6905	23.723	23.487	23.557	51185230.0
2023-03-06 16:00:00	NVDA	Stock	23.554	23.575	23.526	23.556	26129640.0
2023-03-06 17:00:00	NVDA	Stock	23.555	23.56	23.531	23.556	323820.0
2023-03-06 18:00:00	NVDA	Stock	23.546	23.565	23.54	23.565	104010.0
2023-03-06 19:00:00	NVDA	Stock	23.564	23.597	23.56	23.575	250160.0
2023-03-06 04:00:00	AMZN	Stock	95.15	95.28	94.65	94.65	20925.0
2023-03-06 05:00:00	AMZN	Stock	94.65	94.65	94.28	94.55	38750.0

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

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