PREVIEW / stock_1hour / 2023-09-07

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-07.parquet
  size:    1.3 MB
  rows:    58,220
  symbols: 1,416

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-07 04:00:00	AAPL	Stock	181.48	181.9	177.0	177.8	315175.0
2023-09-07 05:00:00	AAPL	Stock	177.99	178.36	177.25	177.9	118445.0
2023-09-07 06:00:00	AAPL	Stock	177.96	178.9	177.22	177.43	156535.0
2023-09-07 07:00:00	AAPL	Stock	177.45	178.49	177.4	178.39	380434.0
2023-09-07 08:00:00	AAPL	Stock	177.55	182.52	176.06	176.1729	1696590.0
2023-09-07 09:00:00	AAPL	Stock	176.1707	177.79	173.54	176.23	26737827.0
2023-09-07 10:00:00	AAPL	Stock	176.23	177.175	175.69	176.6999	15886244.0
2023-09-07 11:00:00	AAPL	Stock	176.69	178.21	176.65	176.975	10245720.0
2023-09-07 12:00:00	AAPL	Stock	176.97	177.68	176.65	176.735	6296840.0
2023-09-07 13:00:00	AAPL	Stock	176.7335	177.1	175.95	177.03	6933230.0
2023-09-07 14:00:00	AAPL	Stock	177.025	177.39	176.49	177.19	6389686.0
2023-09-07 15:00:00	AAPL	Stock	177.185	178.14	176.78	177.56	12127328.0
2023-09-07 16:00:00	AAPL	Stock	177.56	178.3	176.7087	178.22	7652431.0
2023-09-07 17:00:00	AAPL	Stock	178.2	178.3	177.94	178.01	120020.0
2023-09-07 18:00:00	AAPL	Stock	178.0131	178.14	177.95	178.03	27815.0
2023-09-07 19:00:00	AAPL	Stock	178.04	178.22	177.77	178.04	53901.0
2023-09-07 04:00:00	MSFT	Stock	332.32	332.43	330.5	332.09	10819.0
2023-09-07 05:00:00	MSFT	Stock	332.36	332.5	331.73	332.39	3136.0
2023-09-07 06:00:00	MSFT	Stock	332.4	332.4	331.91	331.94	5057.0
2023-09-07 07:00:00	MSFT	Stock	332.02	332.56	331.7	331.81	8054.0
2023-09-07 08:00:00	MSFT	Stock	332.05	332.55	329.19	329.7	64515.0
2023-09-07 09:00:00	MSFT	Stock	329.46	332.01	329.46	331.1499	1384102.0
2023-09-07 10:00:00	MSFT	Stock	331.15	333.08	330.425	331.68	1607696.0
2023-09-07 11:00:00	MSFT	Stock	331.71	332.42	330.47	330.5	1064228.0
2023-09-07 12:00:00	MSFT	Stock	330.49	332.13	330.4	330.5	914741.0
2023-09-07 13:00:00	MSFT	Stock	330.45	331.15	330.1	330.3	935751.0
2023-09-07 14:00:00	MSFT	Stock	330.29	330.66	329.03	330.25	1295647.0
2023-09-07 15:00:00	MSFT	Stock	330.27	331.01	329.5201	329.92	2033755.0
2023-09-07 16:00:00	MSFT	Stock	329.94	330.41	329.64	329.99	3085926.0
2023-09-07 17:00:00	MSFT	Stock	329.9342	329.9342	329.87	329.87	398.0
2023-09-07 18:00:00	MSFT	Stock	329.99	330.85	329.99	330.6999	9708.0
2023-09-07 19:00:00	MSFT	Stock	330.56	330.56	330.22	330.26	4247.0
2023-09-07 04:00:00	NVDA	Stock	46.211	46.466	45.823	45.837	633250.0
2023-09-07 05:00:00	NVDA	Stock	45.841	46.21	45.83	46.105	476140.0
2023-09-07 06:00:00	NVDA	Stock	46.139	46.15	45.951	46.0	242890.0
2023-09-07 07:00:00	NVDA	Stock	45.995	46.25	45.995	46.1	1019710.0
2023-09-07 08:00:00	NVDA	Stock	46.159	46.955	45.662	45.769	5482960.0
2023-09-07 09:00:00	NVDA	Stock	45.766	46.0439	45.152	45.642	73910510.0
2023-09-07 10:00:00	NVDA	Stock	45.651	45.981	45.368	45.726	59130920.0
2023-09-07 11:00:00	NVDA	Stock	45.7424	45.9045	45.54	45.595	35796770.0
2023-09-07 12:00:00	NVDA	Stock	45.583	45.887	45.56	45.64	26265130.0
2023-09-07 13:00:00	NVDA	Stock	45.638	45.88	45.556	45.85	26638110.0
2023-09-07 14:00:00	NVDA	Stock	45.851	46.28	45.811	46.2598	36488950.0
2023-09-07 15:00:00	NVDA	Stock	46.2598	46.344	46.056	46.224	46662470.0
2023-09-07 16:00:00	NVDA	Stock	46.221	46.27	46.135	46.15	14497700.0
2023-09-07 17:00:00	NVDA	Stock	46.159	46.178	46.141	46.17	230310.0
2023-09-07 18:00:00	NVDA	Stock	46.166	46.196	46.16	46.17	150550.0
2023-09-07 19:00:00	NVDA	Stock	46.176	46.197	46.1	46.1	238560.0
2023-09-07 04:00:00	AMZN	Stock	134.8	135.2	134.72	135.09	27132.0
2023-09-07 05:00:00	AMZN	Stock	135.09	135.5	135.05	135.46	6107.0

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

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