PREVIEW / stock_1hour / 2023-05-19

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-19.parquet
  size:    1.3 MB
  rows:    59,401
  symbols: 1,635

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-05-19 04:00:00	AAPL	Stock	175.35	175.51	175.05	175.51	23034.0
2023-05-19 05:00:00	AAPL	Stock	175.58	175.62	175.4	175.62	7299.0
2023-05-19 06:00:00	AAPL	Stock	175.54	175.55	175.22	175.35	7423.0
2023-05-19 07:00:00	AAPL	Stock	175.35	175.95	175.25	175.7	86464.0
2023-05-19 08:00:00	AAPL	Stock	175.39	176.0	175.06	175.95	177724.0
2023-05-19 09:00:00	AAPL	Stock	175.98	176.44	175.53	176.0	7309739.0
2023-05-19 10:00:00	AAPL	Stock	175.995	176.29	175.4	175.7	6373415.0
2023-05-19 11:00:00	AAPL	Stock	175.705	176.02	175.21	175.645	6207912.0
2023-05-19 12:00:00	AAPL	Stock	175.64	175.825	175.085	175.33	4395838.0
2023-05-19 13:00:00	AAPL	Stock	175.32	175.89	175.26	175.32	3003523.0
2023-05-19 14:00:00	AAPL	Stock	175.32	175.6	175.1	175.53	3403596.0
2023-05-19 15:00:00	AAPL	Stock	175.5289	175.6	174.94	175.19	6406481.0
2023-05-19 16:00:00	AAPL	Stock	175.21	175.21	174.96	174.99	6363497.0
2023-05-19 17:00:00	AAPL	Stock	174.99	175.0	174.95	174.95	13244.0
2023-05-19 18:00:00	AAPL	Stock	174.94	175.07	174.94	175.07	25434.0
2023-05-19 19:00:00	AAPL	Stock	175.06	175.1	174.98	175.09	11433.0
2023-05-19 04:00:00	MSFT	Stock	319.4	319.48	317.83	319.0	3284.0
2023-05-19 05:00:00	MSFT	Stock	319.01	319.18	318.8	318.8	2488.0
2023-05-19 06:00:00	MSFT	Stock	318.87	318.87	316.0	316.18	19414.0
2023-05-19 07:00:00	MSFT	Stock	316.36	318.31	316.02	317.2	39728.0
2023-05-19 08:00:00	MSFT	Stock	316.37	319.5	316.37	317.5	52217.0
2023-05-19 09:00:00	MSFT	Stock	317.69	318.66	316.06	317.74	3389870.0
2023-05-19 10:00:00	MSFT	Stock	317.72	318.4199	316.77	317.87	2267419.0
2023-05-19 11:00:00	MSFT	Stock	317.86	318.09	316.62	317.535	2103777.0
2023-05-19 12:00:00	MSFT	Stock	317.55	317.76	316.37	317.44	1625976.0
2023-05-19 13:00:00	MSFT	Stock	317.44	318.38	317.3492	317.4763	1175968.0
2023-05-19 14:00:00	MSFT	Stock	317.48	318.31	317.27	318.01	1368783.0
2023-05-19 15:00:00	MSFT	Stock	318.0	318.75	317.76	318.38	2259043.0
2023-05-19 16:00:00	MSFT	Stock	318.34	318.4	317.5501	317.85	3939262.0
2023-05-19 17:00:00	MSFT	Stock	317.85	317.89	317.75	317.75	1632.0
2023-05-19 18:00:00	MSFT	Stock	317.7544	318.05	317.7501	318.03	7748.0
2023-05-19 19:00:00	MSFT	Stock	318.04	318.15	317.9	318.09	4755.0
2023-05-19 04:00:00	NVDA	Stock	31.79	31.825	31.73	31.825	152990.0
2023-05-19 05:00:00	NVDA	Stock	31.809	31.825	31.77	31.825	101630.0
2023-05-19 06:00:00	NVDA	Stock	31.8	31.833	31.498	31.534	262760.0
2023-05-19 07:00:00	NVDA	Stock	31.531	31.68	31.509	31.571	829240.0
2023-05-19 08:00:00	NVDA	Stock	31.598	31.85	31.458	31.62	1791010.0
2023-05-19 09:00:00	NVDA	Stock	31.6236	31.63	31.067	31.2479	70082730.0
2023-05-19 10:00:00	NVDA	Stock	31.244	31.305	30.916	30.9865	71824100.0
2023-05-19 11:00:00	NVDA	Stock	30.9846	31.349	30.951	31.2632	63789780.0
2023-05-19 12:00:00	NVDA	Stock	31.263	31.498	31.169	31.3322	44860660.0
2023-05-19 13:00:00	NVDA	Stock	31.334	31.358	31.217	31.225	26551980.0
2023-05-19 14:00:00	NVDA	Stock	31.227	31.315	31.113	31.2979	29275760.0
2023-05-19 15:00:00	NVDA	Stock	31.2985	31.337	31.24	31.2635	37499500.0
2023-05-19 16:00:00	NVDA	Stock	31.264	31.27	31.215	31.218	20762110.0
2023-05-19 17:00:00	NVDA	Stock	31.218	31.255	31.155	31.16	884070.0
2023-05-19 18:00:00	NVDA	Stock	31.1526	31.2	31.151	31.2	231880.0
2023-05-19 19:00:00	NVDA	Stock	31.198	31.205	31.18	31.192	416720.0
2023-05-19 04:00:00	AMZN	Stock	117.96	118.45	117.96	118.42	22328.0
2023-05-19 05:00:00	AMZN	Stock	118.4	118.45	117.92	118.02	14714.0

> showing 50 of 59,401 rows — these rows as CSV

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