PREVIEW / stock_1hour / 2024-01-23

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-01-23.parquet
  size:    1.3 MB
  rows:    58,484
  symbols: 1,196

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
2024-01-23 04:00:00	AAPL	Stock	193.6	193.6	193.23	193.33	10432.0
2024-01-23 05:00:00	AAPL	Stock	193.33	193.49	193.01	193.3	7221.0
2024-01-23 06:00:00	AAPL	Stock	193.3	193.7	193.05	193.7	87454.0
2024-01-23 07:00:00	AAPL	Stock	193.69	194.5	193.62	194.5	53684.0
2024-01-23 08:00:00	AAPL	Stock	193.67	194.87	193.3	194.37	121670.0
2024-01-23 09:00:00	AAPL	Stock	194.39	195.75	194.01	194.8	5378800.0
2024-01-23 10:00:00	AAPL	Stock	194.8	194.85	193.8299	194.3	5393468.0
2024-01-23 11:00:00	AAPL	Stock	194.295	194.72	194.18	194.64	3649315.0
2024-01-23 12:00:00	AAPL	Stock	194.63	195.21	194.495	195.14	2976705.0
2024-01-23 13:00:00	AAPL	Stock	195.15	195.24	194.75	194.8028	3337773.0
2024-01-23 14:00:00	AAPL	Stock	194.81	195.03	194.57	194.9401	3018920.0
2024-01-23 15:00:00	AAPL	Stock	194.945	195.25	194.6599	195.15	5970858.0
2024-01-23 16:00:00	AAPL	Stock	195.14	195.18	194.88	194.95	3610807.0
2024-01-23 17:00:00	AAPL	Stock	194.92	194.94	194.81	194.86	10163.0
2024-01-23 18:00:00	AAPL	Stock	194.9	195.11	194.9	195.11	15648.0
2024-01-23 19:00:00	AAPL	Stock	195.14	195.15	194.97	195.15	30673.0
2024-01-23 04:00:00	MSFT	Stock	396.88	397.99	396.21	396.51	8977.0
2024-01-23 05:00:00	MSFT	Stock	396.8	396.87	396.25	396.27	2641.0
2024-01-23 06:00:00	MSFT	Stock	396.51	397.08	396.5	397.08	2735.0
2024-01-23 07:00:00	MSFT	Stock	397.13	397.16	396.49	396.95	8105.0
2024-01-23 08:00:00	MSFT	Stock	397.03	397.79	396.51	397.0998	38976.0
2024-01-23 09:00:00	MSFT	Stock	397.03	397.1	393.93	395.7494	1489439.0
2024-01-23 10:00:00	MSFT	Stock	395.73	395.9275	394.93	395.4326	1395624.0
2024-01-23 11:00:00	MSFT	Stock	395.47	395.85	394.7401	395.73	997794.0
2024-01-23 12:00:00	MSFT	Stock	395.72	397.18	395.37	397.126	801214.0
2024-01-23 13:00:00	MSFT	Stock	397.1399	397.78	396.76	397.498	1203467.0
2024-01-23 14:00:00	MSFT	Stock	397.49	398.2636	396.95	397.78	954977.0
2024-01-23 15:00:00	MSFT	Stock	397.79	399.38	397.72	398.9	2242777.0
2024-01-23 16:00:00	MSFT	Stock	398.84	400.2	398.69	400.2	2292905.0
2024-01-23 17:00:00	MSFT	Stock	400.1	400.32	399.8401	400.0238	24113.0
2024-01-23 18:00:00	MSFT	Stock	400.1495	400.58	400.13	400.58	12911.0
2024-01-23 19:00:00	MSFT	Stock	400.43	400.95	400.43	400.9	20442.0
2024-01-23 04:00:00	NVDA	Stock	59.85	59.869	59.714	59.803	88560.0
2024-01-23 05:00:00	NVDA	Stock	59.754	59.754	59.52	59.57	56950.0
2024-01-23 06:00:00	NVDA	Stock	59.585	59.805	59.578	59.785	50250.0
2024-01-23 07:00:00	NVDA	Stock	59.78	59.845	59.574	59.68	305350.0
2024-01-23 08:00:00	NVDA	Stock	59.779	59.881	59.5723	59.7	1281100.0
2024-01-23 09:00:00	NVDA	Stock	59.7	59.739	58.585	59.491	54031890.0
2024-01-23 10:00:00	NVDA	Stock	59.487	59.637	59.217	59.5	40525740.0
2024-01-23 11:00:00	NVDA	Stock	59.492	59.73	59.378	59.62	28795130.0
2024-01-23 12:00:00	NVDA	Stock	59.62	59.661	59.442	59.6395	15819100.0
2024-01-23 13:00:00	NVDA	Stock	59.638	59.671	59.423	59.497	14532510.0
2024-01-23 14:00:00	NVDA	Stock	59.4975	59.6	59.294	59.54	19734360.0
2024-01-23 15:00:00	NVDA	Stock	59.544	59.91	59.54	59.859	33582120.0
2024-01-23 16:00:00	NVDA	Stock	59.859	59.908	59.682	59.908	11269680.0
2024-01-23 17:00:00	NVDA	Stock	59.896	60.0	59.896	59.979	471270.0
2024-01-23 18:00:00	NVDA	Stock	59.98	60.188	59.98	60.185	871510.0
2024-01-23 19:00:00	NVDA	Stock	60.194	60.2	60.106	60.14	585360.0
2024-01-23 04:00:00	AMZN	Stock	154.35	154.58	154.17	154.48	20133.0
2024-01-23 05:00:00	AMZN	Stock	154.48	154.57	154.25	154.51	6455.0

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

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