PREVIEW / stock_1hour / 2023-12-21

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-21.parquet
  size:    1.4 MB
  rows:    60,379
  symbols: 1,242

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-21 04:00:00	AAPL	Stock	195.86	196.1	195.7	195.94	17814.0
2023-12-21 05:00:00	AAPL	Stock	195.93	195.94	195.75	195.79	3840.0
2023-12-21 06:00:00	AAPL	Stock	195.86	195.99	195.79	195.84	3377.0
2023-12-21 07:00:00	AAPL	Stock	195.89	195.99	195.81	195.85	23988.0
2023-12-21 08:00:00	AAPL	Stock	195.9	196.49	195.5	196.05	155253.0
2023-12-21 09:00:00	AAPL	Stock	196.08	197.08	195.68	195.78	4211510.0
2023-12-21 10:00:00	AAPL	Stock	195.78	195.82	194.29	194.44	6315832.0
2023-12-21 11:00:00	AAPL	Stock	194.435	194.97	194.34	194.49	3686250.0
2023-12-21 12:00:00	AAPL	Stock	194.4909	194.53	193.67	193.75	4108256.0
2023-12-21 13:00:00	AAPL	Stock	193.75	194.24	193.5	194.0601	3374903.0
2023-12-21 14:00:00	AAPL	Stock	194.06	194.36	193.78	193.89	2969116.0
2023-12-21 15:00:00	AAPL	Stock	193.89	194.98	193.76	194.68	6224203.0
2023-12-21 16:00:00	AAPL	Stock	194.7	194.99	194.68	194.85	5674893.0
2023-12-21 17:00:00	AAPL	Stock	194.84	194.9	194.78	194.8	44531.0
2023-12-21 18:00:00	AAPL	Stock	194.76	194.7663	194.58	194.65	42861.0
2023-12-21 19:00:00	AAPL	Stock	194.64	194.6793	194.6	194.63	18584.0
2023-12-21 04:00:00	MSFT	Stock	372.44	372.61	372.11	372.4	3935.0
2023-12-21 05:00:00	MSFT	Stock	372.05	372.19	372.0	372.19	864.0
2023-12-21 06:00:00	MSFT	Stock	372.29	372.3	371.92	371.92	1603.0
2023-12-21 07:00:00	MSFT	Stock	372.19	372.62	372.19	372.42	5296.0
2023-12-21 08:00:00	MSFT	Stock	372.1	374.1	371.42	373.0005	72115.0
2023-12-21 09:00:00	MSFT	Stock	373.01	374.41	371.78	372.007	1777388.0
2023-12-21 10:00:00	MSFT	Stock	372.03	372.58	370.82	371.45	1582192.0
2023-12-21 11:00:00	MSFT	Stock	371.4384	371.95	370.99	371.2	907300.0
2023-12-21 12:00:00	MSFT	Stock	371.195	371.2032	370.04	370.36	1106816.0
2023-12-21 13:00:00	MSFT	Stock	370.35	371.55	370.0701	371.544	1078498.0
2023-12-21 14:00:00	MSFT	Stock	371.52	372.25	371.32	372.08	958028.0
2023-12-21 15:00:00	MSFT	Stock	372.075	373.83	371.71	373.54	2049396.0
2023-12-21 16:00:00	MSFT	Stock	373.54	373.83	373.27	373.59	3788980.0
2023-12-21 17:00:00	MSFT	Stock	373.57	373.75	373.54	373.5401	10989.0
2023-12-21 18:00:00	MSFT	Stock	373.54	373.54	373.0	373.32	3636.0
2023-12-21 19:00:00	MSFT	Stock	373.31	373.31	373.07	373.12	4593.0
2023-12-21 04:00:00	NVDA	Stock	48.514	48.76	48.514	48.652	206820.0
2023-12-21 05:00:00	NVDA	Stock	48.642	48.7	48.574	48.624	45020.0
2023-12-21 06:00:00	NVDA	Stock	48.639	48.681	48.6	48.618	69330.0
2023-12-21 07:00:00	NVDA	Stock	48.602	48.796	48.58	48.74	688860.0
2023-12-21 08:00:00	NVDA	Stock	48.59	48.933	48.464	48.84	2904660.0
2023-12-21 09:00:00	NVDA	Stock	48.839	49.095	48.63	48.738	42799840.0
2023-12-21 10:00:00	NVDA	Stock	48.732	48.9052	48.504	48.633	41586830.0
2023-12-21 11:00:00	NVDA	Stock	48.6316	48.936	48.596	48.771	28121180.0
2023-12-21 12:00:00	NVDA	Stock	48.781	48.79	48.539	48.58	23382980.0
2023-12-21 13:00:00	NVDA	Stock	48.5805	48.678	48.419	48.5135	25960700.0
2023-12-21 14:00:00	NVDA	Stock	48.51	48.7235	48.467	48.6322	22316800.0
2023-12-21 15:00:00	NVDA	Stock	48.635	49.046	48.5911	48.997	36090190.0
2023-12-21 16:00:00	NVDA	Stock	48.99	49.0	48.91	48.9508	10840680.0
2023-12-21 17:00:00	NVDA	Stock	48.95	48.967	48.935	48.95	65370.0
2023-12-21 18:00:00	NVDA	Stock	48.95	48.959	48.93	48.958	140940.0
2023-12-21 19:00:00	NVDA	Stock	48.95	48.96	48.915	48.915	177790.0
2023-12-21 04:00:00	AMZN	Stock	153.0	153.36	152.95	153.05	10826.0
2023-12-21 05:00:00	AMZN	Stock	153.01	153.06	152.82	152.88	7759.0

> showing 50 of 60,379 rows — these rows as CSV

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