PREVIEW / stock_1hour / 2023-06-05

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-05.parquet
  size:    1.3 MB
  rows:    60,781
  symbols: 1,620

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-06-05 04:00:00	AAPL	Stock	181.22	182.0	181.11	181.68	69001.0
2023-06-05 05:00:00	AAPL	Stock	181.67	182.1	181.61	182.09	51750.0
2023-06-05 06:00:00	AAPL	Stock	182.14	182.88	181.98	182.77	39844.0
2023-06-05 07:00:00	AAPL	Stock	182.65	182.8	182.25	182.6	145311.0
2023-06-05 08:00:00	AAPL	Stock	182.61	182.8681	181.0	182.61	448602.0
2023-06-05 09:00:00	AAPL	Stock	182.62	183.86	181.97	183.38	11844813.0
2023-06-05 10:00:00	AAPL	Stock	183.4	184.36	183.25	184.26	12413573.0
2023-06-05 11:00:00	AAPL	Stock	184.26	184.35	183.93	184.0871	6527544.0
2023-06-05 12:00:00	AAPL	Stock	184.085	184.72	183.99	184.565	8459350.0
2023-06-05 13:00:00	AAPL	Stock	184.57	184.951	182.03	182.78	13121947.0
2023-06-05 14:00:00	AAPL	Stock	182.8085	183.69	180.08	181.67	22824908.0
2023-06-05 15:00:00	AAPL	Stock	181.6899	181.78	178.035	179.6	22701939.0
2023-06-05 16:00:00	AAPL	Stock	179.61	179.7	179.35	179.53	4796554.0
2023-06-05 17:00:00	AAPL	Stock	179.52	180.1	179.43	180.01	154621.0
2023-06-05 18:00:00	AAPL	Stock	180.0	180.0	179.0	179.13	130022.0
2023-06-05 19:00:00	AAPL	Stock	179.07	179.24	179.0	179.12	127194.0
2023-06-05 04:00:00	MSFT	Stock	334.96	334.96	333.4	334.2	3913.0
2023-06-05 05:00:00	MSFT	Stock	333.81	334.1	333.1	333.1	2268.0
2023-06-05 06:00:00	MSFT	Stock	333.02	333.98	333.02	333.98	2174.0
2023-06-05 07:00:00	MSFT	Stock	334.01	334.39	333.57	333.65	9569.0
2023-06-05 08:00:00	MSFT	Stock	333.9	334.2499	333.25	333.9799	34120.0
2023-06-05 09:00:00	MSFT	Stock	334.0	337.37	333.53	335.26	2035945.0
2023-06-05 10:00:00	MSFT	Stock	335.31	337.79	335.31	337.36	2229971.0
2023-06-05 11:00:00	MSFT	Stock	337.365	338.5599	336.7401	337.99	1640697.0
2023-06-05 12:00:00	MSFT	Stock	337.99	338.3897	337.44	338.3175	1081413.0
2023-06-05 13:00:00	MSFT	Stock	338.35	338.39	336.99	337.66	1034054.0
2023-06-05 14:00:00	MSFT	Stock	337.65	337.76	335.84	337.18	1544874.0
2023-06-05 15:00:00	MSFT	Stock	337.18	337.62	335.76	335.95	2453842.0
2023-06-05 16:00:00	MSFT	Stock	335.95	336.18	335.6015	335.9	2573276.0
2023-06-05 17:00:00	MSFT	Stock	336.14	336.3999	335.94	336.2	31448.0
2023-06-05 18:00:00	MSFT	Stock	336.02	336.03	335.51	335.6	9106.0
2023-06-05 19:00:00	MSFT	Stock	335.6	335.94	335.05	335.3	7044.0
2023-06-05 04:00:00	NVDA	Stock	38.818	39.155	38.68	38.68	177720.0
2023-06-05 05:00:00	NVDA	Stock	38.701	38.712	38.625	38.691	105100.0
2023-06-05 06:00:00	NVDA	Stock	38.687	38.775	38.665	38.765	198800.0
2023-06-05 07:00:00	NVDA	Stock	38.78	39.061	38.777	38.901	605650.0
2023-06-05 08:00:00	NVDA	Stock	38.874	39.065	38.777	38.83	1499320.0
2023-06-05 09:00:00	NVDA	Stock	38.84	39.565	38.825	38.9395	55198450.0
2023-06-05 10:00:00	NVDA	Stock	38.946	39.274	38.812	39.2325	64073520.0
2023-06-05 11:00:00	NVDA	Stock	39.238	39.418	39.146	39.163	35477190.0
2023-06-05 12:00:00	NVDA	Stock	39.164	39.299	39.007	39.2288	25475090.0
2023-06-05 13:00:00	NVDA	Stock	39.227	39.2943	38.851	38.965	24880460.0
2023-06-05 14:00:00	NVDA	Stock	38.966	39.086	38.707	39.06	34983550.0
2023-06-05 15:00:00	NVDA	Stock	39.063	39.355	38.895	39.174	40076460.0
2023-06-05 16:00:00	NVDA	Stock	39.171	39.179	39.065	39.0806	23611500.0
2023-06-05 17:00:00	NVDA	Stock	39.0991	39.103	39.065	39.0812	183280.0
2023-06-05 18:00:00	NVDA	Stock	39.08	39.08	38.9332	38.972	621450.0
2023-06-05 19:00:00	NVDA	Stock	39.0	39.039	38.98	39.0	217410.0
2023-06-05 04:00:00	AMZN	Stock	124.2	124.2	123.7	123.7	5720.0
2023-06-05 05:00:00	AMZN	Stock	123.7	123.91	123.58	123.62	4364.0

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

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