PREVIEW / stock_1hour / 2023-09-22

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-22.parquet
  size:    1.3 MB
  rows:    57,566
  symbols: 1,402

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-09-22 04:00:00	AAPL	Stock	174.5	174.8	174.45	174.7	23101.0
2023-09-22 05:00:00	AAPL	Stock	174.66	175.1	174.6	175.02	11276.0
2023-09-22 06:00:00	AAPL	Stock	175.0	175.02	174.75	174.78	18867.0
2023-09-22 07:00:00	AAPL	Stock	174.84	174.95	174.59	174.7	36551.0
2023-09-22 08:00:00	AAPL	Stock	174.74	175.48	174.33	175.05	224517.0
2023-09-22 09:00:00	AAPL	Stock	175.08	175.28	174.05	174.9	5166244.0
2023-09-22 10:00:00	AAPL	Stock	174.9	176.55	174.5701	176.48	8410147.0
2023-09-22 11:00:00	AAPL	Stock	176.485	176.62	175.94	176.1401	4666258.0
2023-09-22 12:00:00	AAPL	Stock	176.14	177.079	175.97	176.67	5770365.0
2023-09-22 13:00:00	AAPL	Stock	176.6717	176.73	175.15	175.32	4736073.0
2023-09-22 14:00:00	AAPL	Stock	175.32	175.56	174.81	175.291	4080924.0
2023-09-22 15:00:00	AAPL	Stock	175.28	175.99	174.62	174.74	8074539.0
2023-09-22 16:00:00	AAPL	Stock	174.79	175.02	174.69	175.02	6751342.0
2023-09-22 17:00:00	AAPL	Stock	175.0	175.0	174.79	174.95	51849.0
2023-09-22 18:00:00	AAPL	Stock	174.9202	175.0	174.91	174.93	20923.0
2023-09-22 19:00:00	AAPL	Stock	174.97	175.2	174.9	174.95	34662.0
2023-09-22 04:00:00	MSFT	Stock	320.86	321.46	320.5	320.52	7382.0
2023-09-22 05:00:00	MSFT	Stock	320.72	320.87	320.2	320.87	851.0
2023-09-22 06:00:00	MSFT	Stock	321.0	321.06	320.22	320.84	6119.0
2023-09-22 07:00:00	MSFT	Stock	320.95	320.95	320.06	320.46	7056.0
2023-09-22 08:00:00	MSFT	Stock	320.4	321.8	320.03	321.29	48091.0
2023-09-22 09:00:00	MSFT	Stock	321.3	321.67	317.81	320.18	1964096.0
2023-09-22 10:00:00	MSFT	Stock	320.2	321.04	318.55	320.79	1995215.0
2023-09-22 11:00:00	MSFT	Stock	320.79	320.93	319.0	319.05	1269937.0
2023-09-22 12:00:00	MSFT	Stock	319.04	320.13	318.925	319.71	909823.0
2023-09-22 13:00:00	MSFT	Stock	319.7344	319.7454	317.42	317.72	1240180.0
2023-09-22 14:00:00	MSFT	Stock	317.7	318.0485	316.59	317.46	988195.0
2023-09-22 15:00:00	MSFT	Stock	317.43	319.3	316.15	317.01	2607238.0
2023-09-22 16:00:00	MSFT	Stock	317.01	317.36	316.6	317.01	3847156.0
2023-09-22 17:00:00	MSFT	Stock	317.1	317.1599	316.88	317.04	25488.0
2023-09-22 18:00:00	MSFT	Stock	317.1	317.1	316.8121	316.8121	5854.0
2023-09-22 19:00:00	MSFT	Stock	317.0	317.1	316.8	316.96	6345.0
2023-09-22 04:00:00	NVDA	Stock	41.273	41.454	41.184	41.436	350680.0
2023-09-22 05:00:00	NVDA	Stock	41.425	41.59	41.383	41.54	151070.0
2023-09-22 06:00:00	NVDA	Stock	41.545	41.545	41.46	41.46	163660.0
2023-09-22 07:00:00	NVDA	Stock	41.45	41.475	41.33	41.375	597560.0
2023-09-22 08:00:00	NVDA	Stock	41.305	41.637	41.185	41.609	3010060.0
2023-09-22 09:00:00	NVDA	Stock	41.609	41.914	41.335	41.675	53615680.0
2023-09-22 10:00:00	NVDA	Stock	41.677	42.03	41.231	41.971	78788250.0
2023-09-22 11:00:00	NVDA	Stock	41.974	42.115	41.829	41.844	57398140.0
2023-09-22 12:00:00	NVDA	Stock	41.846	41.99	41.8	41.8959	28194440.0
2023-09-22 13:00:00	NVDA	Stock	41.896	41.896	41.489	41.493	37105310.0
2023-09-22 14:00:00	NVDA	Stock	41.4927	41.606	41.299	41.5489	36888530.0
2023-09-22 15:00:00	NVDA	Stock	41.546	41.979	41.53	41.615	54718830.0
2023-09-22 16:00:00	NVDA	Stock	41.61	41.675	41.59	41.62	14040160.0
2023-09-22 17:00:00	NVDA	Stock	41.62	41.6468	41.616	41.638	178880.0
2023-09-22 18:00:00	NVDA	Stock	41.644	41.644	41.592	41.592	293670.0
2023-09-22 19:00:00	NVDA	Stock	41.6	41.6	41.52	41.587	497950.0
2023-09-22 04:00:00	AMZN	Stock	130.25	130.39	129.58	130.04	25617.0
2023-09-22 05:00:00	AMZN	Stock	130.06	130.9	130.0	130.9	22434.0

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

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