PREVIEW / stock_1hour / 2023-11-09

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-09.parquet
  size:    1.3 MB
  rows:    58,049
  symbols: 1,279

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-11-09 04:00:00	AAPL	Stock	182.69	182.69	181.51	182.15	26592.0
2023-11-09 05:00:00	AAPL	Stock	182.11	182.48	182.1	182.4	8220.0
2023-11-09 06:00:00	AAPL	Stock	182.34	182.34	182.11	182.11	6197.0
2023-11-09 07:00:00	AAPL	Stock	182.22	182.6	182.2	182.39	45165.0
2023-11-09 08:00:00	AAPL	Stock	182.6	182.8	182.16	182.6486	90544.0
2023-11-09 09:00:00	AAPL	Stock	182.6	183.55	182.4029	183.299	5075273.0
2023-11-09 10:00:00	AAPL	Stock	183.29	183.415	182.48	183.36	5693109.0
2023-11-09 11:00:00	AAPL	Stock	183.35	184.12	183.325	183.97	5905043.0
2023-11-09 12:00:00	AAPL	Stock	183.97	184.015	183.51	183.93	3460867.0
2023-11-09 13:00:00	AAPL	Stock	183.93	183.97	182.69	183.1188	5213948.0
2023-11-09 14:00:00	AAPL	Stock	183.11	183.11	182.16	182.375	4518759.0
2023-11-09 15:00:00	AAPL	Stock	182.37	182.48	181.81	182.44	7356583.0
2023-11-09 16:00:00	AAPL	Stock	182.44	182.64	182.21	182.49	5919136.0
2023-11-09 17:00:00	AAPL	Stock	182.47	182.6	182.28	182.29	52294.0
2023-11-09 18:00:00	AAPL	Stock	182.28	182.43	182.21	182.35	71810.0
2023-11-09 19:00:00	AAPL	Stock	182.39	182.49	182.12	182.38	13924.0
2023-11-09 04:00:00	MSFT	Stock	362.9	363.2	362.85	363.05	4608.0
2023-11-09 05:00:00	MSFT	Stock	363.27	363.27	363.04	363.1	647.0
2023-11-09 06:00:00	MSFT	Stock	363.5	363.5	362.69	362.7	1961.0
2023-11-09 07:00:00	MSFT	Stock	362.7	363.7	362.7	363.55	22591.0
2023-11-09 08:00:00	MSFT	Stock	362.7	364.1726	362.45	363.5493	64868.0
2023-11-09 09:00:00	MSFT	Stock	363.5	363.75	361.63	363.35	2122263.0
2023-11-09 10:00:00	MSFT	Stock	363.37	363.55	361.33	362.57	1861864.0
2023-11-09 11:00:00	MSFT	Stock	362.575	364.79	362.52	364.2	1714147.0
2023-11-09 12:00:00	MSFT	Stock	364.24	364.24	363.1	363.51	1265348.0
2023-11-09 13:00:00	MSFT	Stock	363.4576	363.61	361.11	362.9221	1543226.0
2023-11-09 14:00:00	MSFT	Stock	362.88	362.88	361.11	361.24	1398068.0
2023-11-09 15:00:00	MSFT	Stock	361.2	361.85	360.362	360.78	2047568.0
2023-11-09 16:00:00	MSFT	Stock	360.77	361.59	360.56	361.25	3395872.0
2023-11-09 17:00:00	MSFT	Stock	361.0995	361.33	360.7	360.71	9997.0
2023-11-09 18:00:00	MSFT	Stock	360.71	360.99	359.75	360.1	22178.0
2023-11-09 19:00:00	MSFT	Stock	360.1	360.39	359.7	359.77	8019.0
2023-11-09 04:00:00	NVDA	Stock	46.7	47.0	46.7	46.87	487830.0
2023-11-09 05:00:00	NVDA	Stock	46.916	46.988	46.788	46.8	168300.0
2023-11-09 06:00:00	NVDA	Stock	46.8	46.8	46.602	46.725	293060.0
2023-11-09 07:00:00	NVDA	Stock	46.725	47.233	46.7	47.181	2077650.0
2023-11-09 08:00:00	NVDA	Stock	46.7	47.548	46.486	47.482	6968530.0
2023-11-09 09:00:00	NVDA	Stock	47.4777	47.848	47.18	47.824	74625990.0
2023-11-09 10:00:00	NVDA	Stock	47.825	47.865	47.4136	47.7195	54127700.0
2023-11-09 11:00:00	NVDA	Stock	47.7125	48.23	47.671	48.171	57883440.0
2023-11-09 12:00:00	NVDA	Stock	48.171	48.225	47.775	48.092	38368510.0
2023-11-09 13:00:00	NVDA	Stock	48.085	48.094	47.49	47.7316	46289380.0
2023-11-09 14:00:00	NVDA	Stock	47.731	47.74	46.86	46.927	59674730.0
2023-11-09 15:00:00	NVDA	Stock	46.9161	47.107	46.75	46.953	52347890.0
2023-11-09 16:00:00	NVDA	Stock	46.95	47.04	46.89	46.89	23311010.0
2023-11-09 17:00:00	NVDA	Stock	46.891	46.93	46.767	46.8	437670.0
2023-11-09 18:00:00	NVDA	Stock	46.808	46.879	46.754	46.879	431040.0
2023-11-09 19:00:00	NVDA	Stock	46.88	46.89	46.775	46.812	305150.0
2023-11-09 04:00:00	AMZN	Stock	141.89	141.98	141.78	141.87	6414.0
2023-11-09 05:00:00	AMZN	Stock	141.89	142.25	141.89	142.18	1973.0

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

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