PREVIEW / stock_1hour / 2023-10-12

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-12.parquet
  size:    1.3 MB
  rows:    58,332
  symbols: 1,380

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-12 04:00:00	AAPL	Stock	180.24	180.5	180.2	180.46	13648.0
2023-10-12 05:00:00	AAPL	Stock	180.53	180.64	180.46	180.46	15321.0
2023-10-12 06:00:00	AAPL	Stock	180.48	180.58	180.43	180.49	17459.0
2023-10-12 07:00:00	AAPL	Stock	180.45	180.5	180.22	180.47	32980.0
2023-10-12 08:00:00	AAPL	Stock	180.27	180.5595	179.49	179.94	266388.0
2023-10-12 09:00:00	AAPL	Stock	179.82	180.99	179.71	180.93	5007422.0
2023-10-12 10:00:00	AAPL	Stock	180.93	182.1499	180.81	182.06	9570175.0
2023-10-12 11:00:00	AAPL	Stock	182.065	182.34	181.51	181.94	5867335.0
2023-10-12 12:00:00	AAPL	Stock	181.94	182.29	181.7907	181.955	4111291.0
2023-10-12 13:00:00	AAPL	Stock	181.955	182.06	179.96	179.985	5303087.0
2023-10-12 14:00:00	AAPL	Stock	179.99	180.13	179.04	179.8099	5233604.0
2023-10-12 15:00:00	AAPL	Stock	179.82	180.815	179.73	180.73	7438017.0
2023-10-12 16:00:00	AAPL	Stock	180.7201	181.2	180.69	181.1	4213326.0
2023-10-12 17:00:00	AAPL	Stock	181.09	181.23	181.09	181.19	33294.0
2023-10-12 18:00:00	AAPL	Stock	181.2	181.2	180.71	181.15	32324.0
2023-10-12 19:00:00	AAPL	Stock	181.1399	181.4988	181.1	181.45	33653.0
2023-10-12 04:00:00	MSFT	Stock	330.56	331.05	330.56	331.0	795.0
2023-10-12 05:00:00	MSFT	Stock	331.5	331.75	331.44	331.75	1199.0
2023-10-12 06:00:00	MSFT	Stock	331.6	331.65	331.2	331.2	1443.0
2023-10-12 07:00:00	MSFT	Stock	331.08	331.27	330.35	330.36	23235.0
2023-10-12 08:00:00	MSFT	Stock	330.93	331.74	329.1313	330.05	102837.0
2023-10-12 09:00:00	MSFT	Stock	330.0	332.16	329.55	331.86	1907517.0
2023-10-12 10:00:00	MSFT	Stock	331.865	333.485	331.2	332.73	2152076.0
2023-10-12 11:00:00	MSFT	Stock	332.74	333.6299	331.71	332.225	1516160.0
2023-10-12 12:00:00	MSFT	Stock	332.275	332.96	331.87	332.4593	1255812.0
2023-10-12 13:00:00	MSFT	Stock	332.43	332.57	329.76	329.7852	2054829.0
2023-10-12 14:00:00	MSFT	Stock	329.8	330.18	328.72	329.92	1302704.0
2023-10-12 15:00:00	MSFT	Stock	329.92	331.67	329.86	331.19	1982088.0
2023-10-12 16:00:00	MSFT	Stock	331.16	331.55	331.09	331.45	1912175.0
2023-10-12 17:00:00	MSFT	Stock	331.43	331.48	331.33	331.33	1466.0
2023-10-12 18:00:00	MSFT	Stock	331.33	331.43	330.96	331.16	8977.0
2023-10-12 19:00:00	MSFT	Stock	331.16	331.6	331.16	331.33	5397.0
2023-10-12 04:00:00	NVDA	Stock	47.033	47.143	47.032	47.05	221370.0
2023-10-12 05:00:00	NVDA	Stock	47.036	47.036	46.945	46.99	152400.0
2023-10-12 06:00:00	NVDA	Stock	46.984	47.05	46.889	46.9	217690.0
2023-10-12 07:00:00	NVDA	Stock	46.9	46.921	46.771	46.798	860470.0
2023-10-12 08:00:00	NVDA	Stock	46.897	47.065	46.66	46.866	4256650.0
2023-10-12 09:00:00	NVDA	Stock	46.864	47.178	46.66	47.172	49174610.0
2023-10-12 10:00:00	NVDA	Stock	47.173	47.609	47.05	47.2784	77982480.0
2023-10-12 11:00:00	NVDA	Stock	47.2763	47.469	47.144	47.385	39170490.0
2023-10-12 12:00:00	NVDA	Stock	47.392	47.56	47.275	47.457	38011540.0
2023-10-12 13:00:00	NVDA	Stock	47.454	47.498	46.7	46.7475	54170800.0
2023-10-12 14:00:00	NVDA	Stock	46.741	46.91	46.33	46.753	55419500.0
2023-10-12 15:00:00	NVDA	Stock	46.765	47.06	46.748	46.946	45788390.0
2023-10-12 16:00:00	NVDA	Stock	46.945	46.948	46.825	46.857	11641930.0
2023-10-12 17:00:00	NVDA	Stock	46.86	46.895	46.837	46.855	215550.0
2023-10-12 18:00:00	NVDA	Stock	46.855	46.855	46.8	46.82	199970.0
2023-10-12 19:00:00	NVDA	Stock	46.821	46.878	46.78	46.848	351730.0
2023-10-12 04:00:00	AMZN	Stock	132.43	132.7	132.39	132.7	6075.0
2023-10-12 05:00:00	AMZN	Stock	132.65	132.7	132.6	132.6	6768.0

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

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