PREVIEW / stock_1hour / 2026-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2026/2026-07-20.parquet
  size:    1.4 MB
  rows:    59,247

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
2026-07-20 04:00:00	AAPL	Stock	333.26	334.33	332.9112	333.51	45170.0
2026-07-20 05:00:00	AAPL	Stock	333.55	333.61	333.1648	333.29	12365.0
2026-07-20 06:00:00	AAPL	Stock	333.21	335.0	332.6	333.1455	51729.0
2026-07-20 07:00:00	AAPL	Stock	332.99	333.0	331.27	331.57	109136.0
2026-07-20 08:00:00	AAPL	Stock	331.6	332.65	331.27	332.55	92773.0
2026-07-20 09:00:00	AAPL	Stock	332.54	333.71	328.4	328.9	4603440.0
2026-07-20 10:00:00	AAPL	Stock	328.88	329.01	326.02	326.43	6160204.0
2026-07-20 11:00:00	AAPL	Stock	326.45	327.015	324.42	325.975	4819987.0
2026-07-20 12:00:00	AAPL	Stock	325.98	326.04	323.68	324.245	3878763.0
2026-07-20 13:00:00	AAPL	Stock	324.26	325.3832	323.91	324.78	2670372.0
2026-07-20 14:00:00	AAPL	Stock	324.77	327.37	324.655	326.75	4491683.0
2026-07-20 15:00:00	AAPL	Stock	326.77	329.76	326.0	326.7	7339990.0
2026-07-20 16:00:00	AAPL	Stock	326.59	327.17	326.41	326.95	8444814.0
2026-07-20 17:00:00	AAPL	Stock	326.8501	327.2	326.6	326.7972	9159.0
2026-07-20 18:00:00	AAPL	Stock	326.65	326.66	325.27	325.3155	36614.0
2026-07-20 19:00:00	AAPL	Stock	325.32	326.59	325.3	326.0	41632.0
2026-07-20 04:00:00	MSFT	Stock	394.24	395.0224	392.1	393.14	54315.0
2026-07-20 05:00:00	MSFT	Stock	393.1	393.2	392.3	392.43	14158.0
2026-07-20 06:00:00	MSFT	Stock	392.6	393.14	391.16	392.1	20594.0
2026-07-20 07:00:00	MSFT	Stock	392.19	392.19	390.53	391.1	67739.0
2026-07-20 08:00:00	MSFT	Stock	391.0	391.31	388.7641	389.25	116435.0
2026-07-20 09:00:00	MSFT	Stock	389.32	392.99	388.58	390.97	2937931.0
2026-07-20 10:00:00	MSFT	Stock	390.98	396.26	390.15	395.86	2797345.0
2026-07-20 11:00:00	MSFT	Stock	395.9	399.2	395.53	398.95	2394543.0
2026-07-20 12:00:00	MSFT	Stock	398.96	403.18	398.7525	401.41	2753461.0
2026-07-20 13:00:00	MSFT	Stock	401.4	402.39	400.2201	401.72	1927707.0
2026-07-20 14:00:00	MSFT	Stock	401.72	402.37	399.8401	400.57	1922444.0
2026-07-20 15:00:00	MSFT	Stock	400.54	402.68	400.45	402.51	3892184.0
2026-07-20 16:00:00	MSFT	Stock	402.52	402.95	400.22	400.42	4146979.0
2026-07-20 17:00:00	MSFT	Stock	400.49	401.5	400.23	401.31	22729.0
2026-07-20 18:00:00	MSFT	Stock	401.15	401.19	399.51	399.9801	26119.0
2026-07-20 19:00:00	MSFT	Stock	399.98	401.34	399.72	401.0232	21438.0
2026-07-20 04:00:00	NVDA	Stock	203.52	204.04	202.5353	203.326	213310.0
2026-07-20 05:00:00	NVDA	Stock	203.66	204.28	203.4	203.96	40363.0
2026-07-20 06:00:00	NVDA	Stock	204.0	205.0	203.71	204.5431	75382.0
2026-07-20 07:00:00	NVDA	Stock	204.51	206.35	204.31	205.7155	464183.0
2026-07-20 08:00:00	NVDA	Stock	205.732	206.64	205.21	205.99	395239.0
2026-07-20 09:00:00	NVDA	Stock	205.94	207.74	205.0	205.85	9815336.0
2026-07-20 10:00:00	NVDA	Stock	205.865	206.5799	204.58	204.875	8598667.0
2026-07-20 11:00:00	NVDA	Stock	204.875	206.535	204.71	205.9201	7876683.0
2026-07-20 12:00:00	NVDA	Stock	205.93	206.34	203.66	204.03	6024644.0
2026-07-20 13:00:00	NVDA	Stock	204.03	204.73	203.0426	204.435	5574546.0
2026-07-20 14:00:00	NVDA	Stock	204.425	205.015	203.14	203.35	5142500.0
2026-07-20 15:00:00	NVDA	Stock	203.36	203.47	202.28	203.38	10344480.0
2026-07-20 16:00:00	NVDA	Stock	203.38	203.4	202.41	202.72	12612711.0
2026-07-20 17:00:00	NVDA	Stock	202.72	202.95	202.52	202.95	88044.0
2026-07-20 18:00:00	NVDA	Stock	202.89	202.89	202.3	202.3301	113936.0
2026-07-20 19:00:00	NVDA	Stock	202.35	203.19	202.35	203.0892	85633.0
2026-07-20 04:00:00	AMZN	Stock	247.77	248.53	246.9845	247.65	29429.0
2026-07-20 05:00:00	AMZN	Stock	247.705	247.78	247.4024	247.4024	4273.0

> showing 50 of 59,247 rows — these rows as CSV

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