PREVIEW / stock_1hour / 2023-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-24.parquet
  size:    1.4 MB
  rows:    61,011
  symbols: 1,920

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-01-24 04:00:00	AAPL	Stock	141.21	141.21	140.6	141.11	20460.0
2023-01-24 05:00:00	AAPL	Stock	141.1	141.17	140.84	141.0	14031.0
2023-01-24 06:00:00	AAPL	Stock	140.96	140.96	140.5	140.5	11080.0
2023-01-24 07:00:00	AAPL	Stock	140.5	140.65	140.3	140.44	53229.0
2023-01-24 08:00:00	AAPL	Stock	140.44	140.59	139.59	139.85	225542.0
2023-01-24 09:00:00	AAPL	Stock	139.85	142.13	139.72	141.445	7298925.0
2023-01-24 10:00:00	AAPL	Stock	141.46	142.31	141.09	142.255	8239080.0
2023-01-24 11:00:00	AAPL	Stock	142.26	142.498	141.76	142.1	5539824.0
2023-01-24 12:00:00	AAPL	Stock	142.095	142.87	141.81	142.47	5167266.0
2023-01-24 13:00:00	AAPL	Stock	142.47	143.16	142.048	142.655	5477920.0
2023-01-24 14:00:00	AAPL	Stock	142.65	142.8	142.2	142.445	4978619.0
2023-01-24 15:00:00	AAPL	Stock	142.45	142.72	141.905	142.5	7710561.0
2023-01-24 16:00:00	AAPL	Stock	142.53	143.41	142.52	142.84	5098243.0
2023-01-24 17:00:00	AAPL	Stock	142.89	143.02	142.65	142.73	158996.0
2023-01-24 18:00:00	AAPL	Stock	142.76	142.86	141.69	142.0	246913.0
2023-01-24 19:00:00	AAPL	Stock	142.0	142.33	141.81	141.82	133033.0
2023-01-24 04:00:00	MSFT	Stock	243.23	243.23	242.7	242.85	5687.0
2023-01-24 05:00:00	MSFT	Stock	242.66	242.73	242.5	242.65	3780.0
2023-01-24 06:00:00	MSFT	Stock	242.61	242.61	242.1	242.1	12027.0
2023-01-24 07:00:00	MSFT	Stock	242.21	242.76	242.1	242.71	9035.0
2023-01-24 08:00:00	MSFT	Stock	242.3334	243.28	241.5	241.94	56370.0
2023-01-24 09:00:00	MSFT	Stock	241.97	243.21	240.89	241.92	3175594.0
2023-01-24 10:00:00	MSFT	Stock	241.93	243.95	241.62	242.93	3089673.0
2023-01-24 11:00:00	MSFT	Stock	242.93	242.96	241.705	242.0632	1727929.0
2023-01-24 12:00:00	MSFT	Stock	242.0674	242.48	241.48	241.8	1601141.0
2023-01-24 13:00:00	MSFT	Stock	241.79	242.86	241.21	242.383	2291774.0
2023-01-24 14:00:00	MSFT	Stock	242.38	242.6552	241.6107	242.49	2412540.0
2023-01-24 15:00:00	MSFT	Stock	242.49	242.5361	240.44	242.07	5488815.0
2023-01-24 16:00:00	MSFT	Stock	242.04	254.79	238.5	251.97	5999820.0
2023-01-24 17:00:00	MSFT	Stock	251.97	253.38	247.0	251.5	1557231.0
2023-01-24 18:00:00	MSFT	Stock	251.54	251.95	238.7	240.37	2164016.0
2023-01-24 19:00:00	MSFT	Stock	240.38	240.45	238.6001	239.6	387448.0
2023-01-24 04:00:00	NVDA	Stock	19.145	19.145	18.959	18.965	197880.0
2023-01-24 05:00:00	NVDA	Stock	18.987	18.996	18.948	18.971	138560.0
2023-01-24 06:00:00	NVDA	Stock	18.973	18.979	18.909	18.93	65620.0
2023-01-24 07:00:00	NVDA	Stock	18.949	18.99	18.931	18.96	422790.0
2023-01-24 08:00:00	NVDA	Stock	18.9598	18.9971	18.804	18.82	2329980.0
2023-01-24 09:00:00	NVDA	Stock	18.82	19.495	18.764	19.139	88645080.0
2023-01-24 10:00:00	NVDA	Stock	19.14	19.297	18.936	19.229	95926120.0
2023-01-24 11:00:00	NVDA	Stock	19.232	19.297	19.131	19.256	43192380.0
2023-01-24 12:00:00	NVDA	Stock	19.254	19.272	19.041	19.0475	36794350.0
2023-01-24 13:00:00	NVDA	Stock	19.0485	19.155	18.961	19.122	42516880.0
2023-01-24 14:00:00	NVDA	Stock	19.1196	19.232	19.058	19.217	31379380.0
2023-01-24 15:00:00	NVDA	Stock	19.218	19.28	19.061	19.264	56869940.0
2023-01-24 16:00:00	NVDA	Stock	19.265	19.5	19.245	19.437	22086100.0
2023-01-24 17:00:00	NVDA	Stock	19.435	19.535	19.42	19.435	1392470.0
2023-01-24 18:00:00	NVDA	Stock	19.438	19.462	19.124	19.134	4205160.0
2023-01-24 19:00:00	NVDA	Stock	19.135	19.169	19.02	19.06	806190.0
2023-01-24 04:00:00	AMZN	Stock	97.3	97.51	97.28	97.4	10644.0
2023-01-24 05:00:00	AMZN	Stock	97.27	97.31	97.01	97.13	6898.0

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

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