PREVIEW / stock_1hour / 2023-04-19

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-04-19.parquet
  size:    1.4 MB
  rows:    60,359
  symbols: 1,706

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-04-19 04:00:00	AAPL	Stock	165.98	165.98	165.09	165.38	36463.0
2023-04-19 05:00:00	AAPL	Stock	165.4	165.49	165.01	165.17	20542.0
2023-04-19 06:00:00	AAPL	Stock	165.24	165.64	165.24	165.49	7705.0
2023-04-19 07:00:00	AAPL	Stock	165.55	165.7	165.4	165.56	28277.0
2023-04-19 08:00:00	AAPL	Stock	165.5592	166.054	165.0	165.34	159881.0
2023-04-19 09:00:00	AAPL	Stock	165.35	166.54	165.15	166.16	5224203.0
2023-04-19 10:00:00	AAPL	Stock	166.15	167.205	166.11	166.93	6285501.0
2023-04-19 11:00:00	AAPL	Stock	166.9301	167.79	166.9099	167.59	5451479.0
2023-04-19 12:00:00	AAPL	Stock	167.61	168.16	167.41	167.8401	4594744.0
2023-04-19 13:00:00	AAPL	Stock	167.845	168.09	167.63	167.81	3181756.0
2023-04-19 14:00:00	AAPL	Stock	167.81	168.08	167.59	167.925	3405205.0
2023-04-19 15:00:00	AAPL	Stock	167.925	167.94	167.17	167.62	6070123.0
2023-04-19 16:00:00	AAPL	Stock	167.61	167.65	167.19	167.48	5704115.0
2023-04-19 17:00:00	AAPL	Stock	167.46	167.52	167.37	167.4	31351.0
2023-04-19 18:00:00	AAPL	Stock	167.4	167.48	167.32	167.3944	17251.0
2023-04-19 19:00:00	AAPL	Stock	167.35	167.39	167.08	167.25	42316.0
2023-04-19 04:00:00	MSFT	Stock	287.51	287.51	286.69	286.85	4748.0
2023-04-19 05:00:00	MSFT	Stock	286.7	286.7	285.85	285.85	3997.0
2023-04-19 06:00:00	MSFT	Stock	286.0	286.53	286.0	286.48	3958.0
2023-04-19 07:00:00	MSFT	Stock	286.35	286.86	286.31	286.5	8962.0
2023-04-19 08:00:00	MSFT	Stock	287.65	288.28	285.86	286.0006	31193.0
2023-04-19 09:00:00	MSFT	Stock	286.12	286.98	284.54	285.25	2199508.0
2023-04-19 10:00:00	MSFT	Stock	285.24	286.9799	285.15	286.88	1797586.0
2023-04-19 11:00:00	MSFT	Stock	286.9	288.01	286.9	287.915	1571092.0
2023-04-19 12:00:00	MSFT	Stock	287.94	289.05	287.87	288.47	1567524.0
2023-04-19 13:00:00	MSFT	Stock	288.465	288.81	287.92	288.515	1008805.0
2023-04-19 14:00:00	MSFT	Stock	288.52	288.93	287.76	288.68	1194383.0
2023-04-19 15:00:00	MSFT	Stock	288.68	288.72	288.05	288.43	1569133.0
2023-04-19 16:00:00	MSFT	Stock	288.45	288.46	287.7701	288.45	1994295.0
2023-04-19 17:00:00	MSFT	Stock	288.28	288.28	287.82	287.82	6413.0
2023-04-19 18:00:00	MSFT	Stock	288.12	288.13	287.75	287.75	9424.0
2023-04-19 19:00:00	MSFT	Stock	287.75	287.99	287.21	287.27	14507.0
2023-04-19 04:00:00	NVDA	Stock	27.662	27.662	27.381	27.416	150670.0
2023-04-19 05:00:00	NVDA	Stock	27.4	27.4	27.3	27.3	117290.0
2023-04-19 06:00:00	NVDA	Stock	27.33	27.43	27.313	27.43	68030.0
2023-04-19 07:00:00	NVDA	Stock	27.452	27.474	27.381	27.39	400630.0
2023-04-19 08:00:00	NVDA	Stock	27.439	27.755	27.309	27.34	1437790.0
2023-04-19 09:00:00	NVDA	Stock	27.348	27.7325	27.232	27.5674	50636380.0
2023-04-19 10:00:00	NVDA	Stock	27.5655	27.785	27.536	27.6835	53605730.0
2023-04-19 11:00:00	NVDA	Stock	27.686	27.787	27.644	27.715	35972480.0
2023-04-19 12:00:00	NVDA	Stock	27.717	27.852	27.663	27.808	27556800.0
2023-04-19 13:00:00	NVDA	Stock	27.806	27.884	27.788	27.835	25863310.0
2023-04-19 14:00:00	NVDA	Stock	27.835	27.888	27.725	27.8312	28956240.0
2023-04-19 15:00:00	NVDA	Stock	27.835	28.0	27.763	27.932	50194690.0
2023-04-19 16:00:00	NVDA	Stock	27.933	27.935	27.859	27.91	12239710.0
2023-04-19 17:00:00	NVDA	Stock	27.904	27.976	27.889	27.905	499070.0
2023-04-19 18:00:00	NVDA	Stock	27.904	27.925	27.859	27.859	376530.0
2023-04-19 19:00:00	NVDA	Stock	27.86	27.865	27.766	27.809	503390.0
2023-04-19 04:00:00	AMZN	Stock	101.95	101.99	101.65	101.81	8211.0
2023-04-19 05:00:00	AMZN	Stock	101.79	101.79	100.73	101.01	34631.0

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

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