PREVIEW / stock_1hour / 2023-10-18

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-18.parquet
  size:    1.3 MB
  rows:    57,815
  symbols: 1,357

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-10-18 04:00:00	AAPL	Stock	176.66	176.73	176.6	176.73	4576.0
2023-10-18 05:00:00	AAPL	Stock	176.61	176.73	175.8	176.02	14171.0
2023-10-18 06:00:00	AAPL	Stock	176.1	176.12	175.7	175.84	16290.0
2023-10-18 07:00:00	AAPL	Stock	175.98	176.1	175.45	175.61	47903.0
2023-10-18 08:00:00	AAPL	Stock	175.99	176.8	175.41	175.66	155519.0
2023-10-18 09:00:00	AAPL	Stock	175.66	176.65	175.35	176.58	5635754.0
2023-10-18 10:00:00	AAPL	Stock	176.585	177.575	175.755	176.14	7899805.0
2023-10-18 11:00:00	AAPL	Stock	176.14	177.4	176.12	177.02	4958439.0
2023-10-18 12:00:00	AAPL	Stock	177.015	177.53	176.26	176.38	4183041.0
2023-10-18 13:00:00	AAPL	Stock	176.3709	177.37	176.22	176.76	4413973.0
2023-10-18 14:00:00	AAPL	Stock	176.751	177.13	176.23	176.42	3554037.0
2023-10-18 15:00:00	AAPL	Stock	176.42	176.44	175.11	175.84	8174874.0
2023-10-18 16:00:00	AAPL	Stock	175.81	175.92	175.5	175.68	6777728.0
2023-10-18 17:00:00	AAPL	Stock	175.71	175.84	175.56	175.62	86539.0
2023-10-18 18:00:00	AAPL	Stock	175.6	175.79	175.5	175.56	29613.0
2023-10-18 19:00:00	AAPL	Stock	175.56	175.69	175.4987	175.5	20443.0
2023-10-18 04:00:00	MSFT	Stock	333.25	333.3	332.52	333.2	2493.0
2023-10-18 05:00:00	MSFT	Stock	333.27	333.27	332.52	332.8	883.0
2023-10-18 06:00:00	MSFT	Stock	332.65	332.65	332.0	332.47	2554.0
2023-10-18 07:00:00	MSFT	Stock	332.9	333.9	332.9	333.0	15239.0
2023-10-18 08:00:00	MSFT	Stock	332.75	334.0	332.1	332.1	30988.0
2023-10-18 09:00:00	MSFT	Stock	332.1	335.59	332.03	334.8701	2310449.0
2023-10-18 10:00:00	MSFT	Stock	334.906	335.28	331.46	332.12	2795096.0
2023-10-18 11:00:00	MSFT	Stock	332.12	333.6245	331.94	332.94	1253734.0
2023-10-18 12:00:00	MSFT	Stock	332.98	333.98	331.55	331.7	1106311.0
2023-10-18 13:00:00	MSFT	Stock	331.67	333.31	330.74	332.02	1753873.0
2023-10-18 14:00:00	MSFT	Stock	331.99	332.62	330.25	330.8	1349409.0
2023-10-18 15:00:00	MSFT	Stock	330.8	330.8195	328.3	330.16	3579629.0
2023-10-18 16:00:00	MSFT	Stock	330.13	332.04	329.79	331.75	2790302.0
2023-10-18 17:00:00	MSFT	Stock	331.53	332.2	331.46	331.5	28624.0
2023-10-18 18:00:00	MSFT	Stock	331.48	331.75	330.82	330.96	12185.0
2023-10-18 19:00:00	MSFT	Stock	331.02	331.27	330.66	330.8	9148.0
2023-10-18 04:00:00	NVDA	Stock	43.488	43.488	43.2	43.31	277490.0
2023-10-18 05:00:00	NVDA	Stock	43.3	43.461	43.265	43.338	163050.0
2023-10-18 06:00:00	NVDA	Stock	43.325	43.325	43.187	43.253	195390.0
2023-10-18 07:00:00	NVDA	Stock	43.26	43.435	43.13	43.134	854020.0
2023-10-18 08:00:00	NVDA	Stock	43.2798	43.66	43.001	43.063	3568620.0
2023-10-18 09:00:00	NVDA	Stock	43.05	43.219	42.324	42.723	99237650.0
2023-10-18 10:00:00	NVDA	Stock	42.7245	42.9333	42.302	42.3382	99502970.0
2023-10-18 11:00:00	NVDA	Stock	42.338	42.5675	42.18	42.324	55592910.0
2023-10-18 12:00:00	NVDA	Stock	42.3197	42.698	42.116	42.145	52385090.0
2023-10-18 13:00:00	NVDA	Stock	42.144	42.4932	42.038	42.3202	44371680.0
2023-10-18 14:00:00	NVDA	Stock	42.341	42.4012	42.009	42.0411	39075960.0
2023-10-18 15:00:00	NVDA	Stock	42.04	42.261	41.825	42.197	71294360.0
2023-10-18 16:00:00	NVDA	Stock	42.187	42.41	42.077	42.2	18377490.0
2023-10-18 17:00:00	NVDA	Stock	42.193	42.25	42.103	42.168	436180.0
2023-10-18 18:00:00	NVDA	Stock	42.124	42.15	41.825	41.85	698270.0
2023-10-18 19:00:00	NVDA	Stock	41.835	42.16	41.825	42.16	702890.0
2023-10-18 04:00:00	AMZN	Stock	130.4	131.0	130.24	131.0	6234.0
2023-10-18 05:00:00	AMZN	Stock	130.95	131.05	130.56	130.59	10033.0

> showing 50 of 57,815 rows — these rows as CSV

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