PREVIEW / stock_1hour / 2023-12-20

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-20.parquet
  size:    1.4 MB
  rows:    61,248
  symbols: 1,236

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-12-20 04:00:00	AAPL	Stock	196.0	196.2	195.68	195.95	12748.0
2023-12-20 05:00:00	AAPL	Stock	195.97	195.99	195.81	195.99	8934.0
2023-12-20 06:00:00	AAPL	Stock	195.99	196.12	195.86	196.0	9672.0
2023-12-20 07:00:00	AAPL	Stock	196.0	196.25	195.89	196.04	28703.0
2023-12-20 08:00:00	AAPL	Stock	196.04	196.9	195.9799	196.14	65375.0
2023-12-20 09:00:00	AAPL	Stock	196.14	197.68	195.95	197.52	5295733.0
2023-12-20 10:00:00	AAPL	Stock	197.51	197.665	197.23	197.385	3934793.0
2023-12-20 11:00:00	AAPL	Stock	197.385	197.44	197.01	197.3037	3119023.0
2023-12-20 12:00:00	AAPL	Stock	197.31	197.44	197.2	197.41	2260695.0
2023-12-20 13:00:00	AAPL	Stock	197.41	197.57	197.1668	197.235	2448761.0
2023-12-20 14:00:00	AAPL	Stock	197.23	197.34	195.68	195.72	4279790.0
2023-12-20 15:00:00	AAPL	Stock	195.72	196.18	194.84	194.84	10236450.0
2023-12-20 16:00:00	AAPL	Stock	194.85	195.373	194.76	195.3001	9446126.0
2023-12-20 17:00:00	AAPL	Stock	195.33	195.52	195.31	195.33	49605.0
2023-12-20 18:00:00	AAPL	Stock	195.36	195.44	194.83	195.3301	55313.0
2023-12-20 19:00:00	AAPL	Stock	195.38	195.5	195.37	195.4	20662.0
2023-12-20 04:00:00	MSFT	Stock	373.01	373.01	371.54	371.66	2792.0
2023-12-20 05:00:00	MSFT	Stock	371.99	372.16	371.9	372.0	2461.0
2023-12-20 06:00:00	MSFT	Stock	372.0	373.2	371.9	372.39	7516.0
2023-12-20 07:00:00	MSFT	Stock	372.38	372.65	371.9	371.9	15108.0
2023-12-20 08:00:00	MSFT	Stock	372.49	373.35	372.0	373.29	54253.0
2023-12-20 09:00:00	MSFT	Stock	373.3	375.3	371.81	374.3701	3206698.0
2023-12-20 10:00:00	MSFT	Stock	374.3	375.3	373.85	374.83	2401522.0
2023-12-20 11:00:00	MSFT	Stock	374.81	375.04	374.03	374.71	1324583.0
2023-12-20 12:00:00	MSFT	Stock	374.71	376.03	374.71	375.8175	1558828.0
2023-12-20 13:00:00	MSFT	Stock	375.82	375.83	374.86	375.12	927094.0
2023-12-20 14:00:00	MSFT	Stock	375.115	375.33	371.53	371.8612	1477917.0
2023-12-20 15:00:00	MSFT	Stock	371.9	372.65	370.53	370.57	3602014.0
2023-12-20 16:00:00	MSFT	Stock	370.57	370.83	370.0	370.62	4930821.0
2023-12-20 17:00:00	MSFT	Stock	370.64	371.49	370.56	371.1299	21907.0
2023-12-20 18:00:00	MSFT	Stock	371.1899	371.35	371.0	371.35	2384.0
2023-12-20 19:00:00	MSFT	Stock	371.27	371.4	370.62	371.0	74128.0
2023-12-20 04:00:00	NVDA	Stock	49.521	49.521	49.0	49.099	333060.0
2023-12-20 05:00:00	NVDA	Stock	49.077	49.2	49.071	49.124	66710.0
2023-12-20 06:00:00	NVDA	Stock	49.106	49.168	49.106	49.117	34680.0
2023-12-20 07:00:00	NVDA	Stock	49.199	49.375	49.149	49.265	466780.0
2023-12-20 08:00:00	NVDA	Stock	49.204	49.567	49.1599	49.384	1169610.0
2023-12-20 09:00:00	NVDA	Stock	49.37	49.999	49.288	49.724	47412600.0
2023-12-20 10:00:00	NVDA	Stock	49.718	49.998	49.664	49.8165	43226340.0
2023-12-20 11:00:00	NVDA	Stock	49.812	49.933	49.734	49.79	26488040.0
2023-12-20 12:00:00	NVDA	Stock	49.79	49.843	49.608	49.8258	21069050.0
2023-12-20 13:00:00	NVDA	Stock	49.823	49.868	49.678	49.731	16307410.0
2023-12-20 14:00:00	NVDA	Stock	49.7338	49.752	48.501	48.5226	53509660.0
2023-12-20 15:00:00	NVDA	Stock	48.524	48.635	48.098	48.11	78371270.0
2023-12-20 16:00:00	NVDA	Stock	48.111	48.369	48.088	48.357	28386100.0
2023-12-20 17:00:00	NVDA	Stock	48.362	48.365	48.23	48.263	532820.0
2023-12-20 18:00:00	NVDA	Stock	48.2632	48.3	48.111	48.29	853190.0
2023-12-20 19:00:00	NVDA	Stock	48.296	48.368	48.111	48.35	745340.0
2023-12-20 04:00:00	AMZN	Stock	153.7	153.7	152.81	152.98	15761.0
2023-12-20 05:00:00	AMZN	Stock	152.97	153.08	152.9	153.06	8681.0

> showing 50 of 61,248 rows — these rows as CSV

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