PREVIEW / stock_1hour / 2023-08-24

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-24.parquet
  size:    1.3 MB
  rows:    58,510
  symbols: 1,447

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-08-24 04:00:00	AAPL	Stock	182.04	182.78	181.79	181.99	58165.0
2023-08-24 05:00:00	AAPL	Stock	181.94	181.95	181.39	181.88	43869.0
2023-08-24 06:00:00	AAPL	Stock	181.85	181.9	181.72	181.76	42841.0
2023-08-24 07:00:00	AAPL	Stock	181.7	182.0	181.49	181.49	63212.0
2023-08-24 08:00:00	AAPL	Stock	181.67	183.34	180.34	180.74	331008.0
2023-08-24 09:00:00	AAPL	Stock	180.76	181.104	179.61	180.02	5139035.0
2023-08-24 10:00:00	AAPL	Stock	180.02	180.13	177.68	177.895	7270691.0
2023-08-24 11:00:00	AAPL	Stock	177.91	178.41	177.52	177.6099	4674724.0
2023-08-24 12:00:00	AAPL	Stock	177.61	178.31	177.5	177.955	2732937.0
2023-08-24 13:00:00	AAPL	Stock	177.96	178.14	177.43	177.5514	2289705.0
2023-08-24 14:00:00	AAPL	Stock	177.56	177.88	177.0	177.3537	3571314.0
2023-08-24 15:00:00	AAPL	Stock	177.36	177.47	176.01	176.33	8333048.0
2023-08-24 16:00:00	AAPL	Stock	176.32	176.4645	175.92	176.09	10776910.0
2023-08-24 17:00:00	AAPL	Stock	176.09	176.1	175.88	176.05	32176.0
2023-08-24 18:00:00	AAPL	Stock	176.0599	176.65	176.0599	176.6014	39975.0
2023-08-24 19:00:00	AAPL	Stock	176.57	176.57	176.22	176.33	19699.0
2023-08-24 04:00:00	MSFT	Stock	332.42	334.71	332.42	333.2	10087.0
2023-08-24 05:00:00	MSFT	Stock	333.2	333.2	332.66	332.77	6629.0
2023-08-24 06:00:00	MSFT	Stock	333.0	333.27	332.42	332.5	10111.0
2023-08-24 07:00:00	MSFT	Stock	332.9	334.68	332.85	333.31	30053.0
2023-08-24 08:00:00	MSFT	Stock	333.13	334.6785	332.3	333.02	91543.0
2023-08-24 09:00:00	MSFT	Stock	332.81	333.3	327.42	329.43	2219145.0
2023-08-24 10:00:00	MSFT	Stock	329.47	329.865	324.14	324.5	2299814.0
2023-08-24 11:00:00	MSFT	Stock	324.51	324.53	321.06	321.345	1711625.0
2023-08-24 12:00:00	MSFT	Stock	321.38	323.25	321.32	322.42	1055096.0
2023-08-24 13:00:00	MSFT	Stock	322.45	322.875	321.63	321.92	702884.0
2023-08-24 14:00:00	MSFT	Stock	321.94	322.68	320.93	321.73	965958.0
2023-08-24 15:00:00	MSFT	Stock	321.73	321.99	319.96	319.98	2690879.0
2023-08-24 16:00:00	MSFT	Stock	319.99	320.13	318.2	318.73	4088424.0
2023-08-24 17:00:00	MSFT	Stock	318.8	318.98	318.4201	318.94	14153.0
2023-08-24 18:00:00	MSFT	Stock	318.9	320.77	318.9	320.55	20453.0
2023-08-24 19:00:00	MSFT	Stock	319.72	320.19	319.05	319.65	12561.0
2023-08-24 04:00:00	NVDA	Stock	50.998	51.248	50.601	50.969	1950560.0
2023-08-24 05:00:00	NVDA	Stock	50.968	51.08	50.55	50.845	1008790.0
2023-08-24 06:00:00	NVDA	Stock	50.88	50.95	50.65	50.898	778420.0
2023-08-24 07:00:00	NVDA	Stock	50.9	51.21	50.665	50.87	4334830.0
2023-08-24 08:00:00	NVDA	Stock	50.8	51.245	49.951	50.2	13839070.0
2023-08-24 09:00:00	NVDA	Stock	50.19	50.758	48.063	48.345	190127250.0
2023-08-24 10:00:00	NVDA	Stock	48.357	49.046	47.712	47.8095	172528970.0
2023-08-24 11:00:00	NVDA	Stock	47.82	48.139	47.47	47.9125	105166050.0
2023-08-24 12:00:00	NVDA	Stock	47.917	48.95	47.854	48.524	94552150.0
2023-08-24 13:00:00	NVDA	Stock	48.53	48.761	48.1839	48.453	67059850.0
2023-08-24 14:00:00	NVDA	Stock	48.45	48.6975	47.827	48.0698	63208090.0
2023-08-24 15:00:00	NVDA	Stock	48.055	48.11	47.159	47.162	122620640.0
2023-08-24 16:00:00	NVDA	Stock	47.167	47.2645	46.92	46.94	38857370.0
2023-08-24 17:00:00	NVDA	Stock	46.931	46.991	46.67	46.874	3016220.0
2023-08-24 18:00:00	NVDA	Stock	46.879	47.089	46.879	47.035	1103520.0
2023-08-24 19:00:00	NVDA	Stock	47.05	47.05	46.861	46.865	1446880.0
2023-08-24 04:00:00	AMZN	Stock	137.65	137.99	137.15	137.5	26184.0
2023-08-24 05:00:00	AMZN	Stock	137.43	137.59	137.17	137.17	12212.0

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

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