PREVIEW / stock_1hour / 2023-10-17

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-17.parquet
  size:    1.3 MB
  rows:    58,643
  symbols: 1,348

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-17 04:00:00	AAPL	Stock	178.5	178.5	177.9	178.05	25721.0
2023-10-17 05:00:00	AAPL	Stock	178.05	178.2	177.97	177.97	4709.0
2023-10-17 06:00:00	AAPL	Stock	178.05	178.18	177.97	178.16	11970.0
2023-10-17 07:00:00	AAPL	Stock	178.16	178.3	177.96	178.3	26374.0
2023-10-17 08:00:00	AAPL	Stock	178.1893	178.44	177.35	177.38	227146.0
2023-10-17 09:00:00	AAPL	Stock	177.4003	177.5	174.8	175.3433	8688533.0
2023-10-17 10:00:00	AAPL	Stock	175.345	177.23	175.28	176.66	8577213.0
2023-10-17 11:00:00	AAPL	Stock	176.665	177.845	176.491	177.73	5130523.0
2023-10-17 12:00:00	AAPL	Stock	177.73	178.42	177.63	178.19	4008205.0
2023-10-17 13:00:00	AAPL	Stock	178.2	178.35	176.95	177.16	4494133.0
2023-10-17 14:00:00	AAPL	Stock	177.17	177.5399	176.365	176.62	5403641.0
2023-10-17 15:00:00	AAPL	Stock	176.62	177.3	176.445	177.14	7984266.0
2023-10-17 16:00:00	AAPL	Stock	177.13	177.23	176.94	176.98	5181624.0
2023-10-17 17:00:00	AAPL	Stock	176.95	177.1	176.95	177.09	17417.0
2023-10-17 18:00:00	AAPL	Stock	177.1	177.1	176.93	176.95	10091.0
2023-10-17 19:00:00	AAPL	Stock	176.94	176.99	176.52	176.68	18689.0
2023-10-17 04:00:00	MSFT	Stock	333.04	333.04	332.2	332.5	3868.0
2023-10-17 05:00:00	MSFT	Stock	332.55	332.69	332.55	332.69	749.0
2023-10-17 06:00:00	MSFT	Stock	332.6	332.6	332.19	332.19	4366.0
2023-10-17 07:00:00	MSFT	Stock	332.21	332.21	331.1	332.2	12267.0
2023-10-17 08:00:00	MSFT	Stock	332.35	332.5	329.66	330.5	61439.0
2023-10-17 09:00:00	MSFT	Stock	330.39	330.66	327.41	328.615	2222184.0
2023-10-17 10:00:00	MSFT	Stock	328.59	332.43	328.59	331.3	1971874.0
2023-10-17 11:00:00	MSFT	Stock	331.27	332.43	330.81	331.9	1271577.0
2023-10-17 12:00:00	MSFT	Stock	331.95	333.46	331.86	332.815	1036255.0
2023-10-17 13:00:00	MSFT	Stock	332.82	333.0957	330.59	330.89	809597.0
2023-10-17 14:00:00	MSFT	Stock	330.91	331.49	329.945	330.31	1010442.0
2023-10-17 15:00:00	MSFT	Stock	330.29	332.1275	329.9	332.07	2210047.0
2023-10-17 16:00:00	MSFT	Stock	332.06	335.2	331.5	334.4	2937206.0
2023-10-17 17:00:00	MSFT	Stock	334.41	335.86	334.06	334.07	56913.0
2023-10-17 18:00:00	MSFT	Stock	334.1999	334.5	334.06	334.16	13703.0
2023-10-17 19:00:00	MSFT	Stock	334.29	334.5	333.72	334.0	17805.0
2023-10-17 04:00:00	NVDA	Stock	46.107	46.108	45.904	45.98	33220.0
2023-10-17 05:00:00	NVDA	Stock	45.975	46.064	45.975	45.987	16130.0
2023-10-17 06:00:00	NVDA	Stock	45.955	45.965	45.72	45.82	105700.0
2023-10-17 07:00:00	NVDA	Stock	45.82	45.879	45.45	45.74	1029920.0
2023-10-17 08:00:00	NVDA	Stock	45.818	46.1	44.15	44.407	10754030.0
2023-10-17 09:00:00	NVDA	Stock	44.407	44.645	42.48	43.012	143629590.0
2023-10-17 10:00:00	NVDA	Stock	43.009	44.247	42.965	43.975	139570450.0
2023-10-17 11:00:00	NVDA	Stock	43.982	44.5	43.79	44.4255	82294530.0
2023-10-17 12:00:00	NVDA	Stock	44.42	44.754	44.334	44.425	61611630.0
2023-10-17 13:00:00	NVDA	Stock	44.421	44.458	43.654	43.694	62082370.0
2023-10-17 14:00:00	NVDA	Stock	43.7005	44.115	43.668	43.762	56883990.0
2023-10-17 15:00:00	NVDA	Stock	43.755	44.0365	43.642	43.955	59399370.0
2023-10-17 16:00:00	NVDA	Stock	43.938	43.945	43.5122	43.758	17892000.0
2023-10-17 17:00:00	NVDA	Stock	43.751	43.81	43.549	43.636	1036960.0
2023-10-17 18:00:00	NVDA	Stock	43.631	43.648	43.521	43.535	859630.0
2023-10-17 19:00:00	NVDA	Stock	43.6	43.63	43.425	43.436	919030.0
2023-10-17 04:00:00	AMZN	Stock	132.55	132.55	131.96	131.96	16011.0
2023-10-17 05:00:00	AMZN	Stock	132.06	132.22	131.51	131.67	30464.0

> showing 50 of 58,643 rows — these rows as CSV

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