PREVIEW / stock_1hour / 2025-08-20

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-08-20.parquet
  size:    1.4 MB
  rows:    61,323
  symbols: 329

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
2025-08-20 04:00:00	AAPL	Stock	229.0	229.8	228.98	229.34	17430.0
2025-08-20 05:00:00	AAPL	Stock	229.28	229.49	229.25	229.31	4499.0
2025-08-20 06:00:00	AAPL	Stock	229.2	229.55	229.13	229.3	6183.0
2025-08-20 07:00:00	AAPL	Stock	229.35	229.81	229.12	229.55	17420.0
2025-08-20 08:00:00	AAPL	Stock	229.74	229.99	228.51	229.33	148085.0
2025-08-20 09:00:00	AAPL	Stock	229.39	230.47	226.5	227.31	5093137.0
2025-08-20 10:00:00	AAPL	Stock	227.285	227.78	226.22	226.57	4523462.0
2025-08-20 11:00:00	AAPL	Stock	226.54	227.55	226.11	226.5598	2938961.0
2025-08-20 12:00:00	AAPL	Stock	226.55	227.16	225.89	226.27	2451263.0
2025-08-20 13:00:00	AAPL	Stock	226.2601	226.85	226.14	226.38	1992108.0
2025-08-20 14:00:00	AAPL	Stock	226.38	226.54	225.77	226.08	1879828.0
2025-08-20 15:00:00	AAPL	Stock	226.1	227.13	225.92	225.96	4586968.0
2025-08-20 16:00:00	AAPL	Stock	225.97	226.01	225.45	225.9	4973370.0
2025-08-20 17:00:00	AAPL	Stock	225.8994	225.8994	225.64	225.65	20971.0
2025-08-20 18:00:00	AAPL	Stock	225.75	225.78	225.58	225.61	22941.0
2025-08-20 19:00:00	AAPL	Stock	225.58	225.69	225.5	225.5999	39953.0
2025-08-20 04:00:00	MSFT	Stock	509.77	510.48	509.64	510.37	3605.0
2025-08-20 05:00:00	MSFT	Stock	510.42	510.9	510.42	510.9	2004.0
2025-08-20 06:00:00	MSFT	Stock	510.47	510.47	510.0	510.45	1375.0
2025-08-20 07:00:00	MSFT	Stock	510.32	510.56	509.25	509.8	3624.0
2025-08-20 08:00:00	MSFT	Stock	510.62	510.96	508.06	510.6	27623.0
2025-08-20 09:00:00	MSFT	Stock	510.72	511.0	506.24	506.5	2083528.0
2025-08-20 10:00:00	MSFT	Stock	506.5	508.25	506.16	506.78	1552929.0
2025-08-20 11:00:00	MSFT	Stock	506.75	507.0	504.44	504.815	2296453.0
2025-08-20 12:00:00	MSFT	Stock	504.82	506.46	504.74	505.09	1386333.0
2025-08-20 13:00:00	MSFT	Stock	505.129	507.62	505.0445	506.745	1256621.0
2025-08-20 14:00:00	MSFT	Stock	506.69	506.72	504.83	504.885	1551588.0
2025-08-20 15:00:00	MSFT	Stock	504.885	507.4655	504.76	505.46	1960216.0
2025-08-20 16:00:00	MSFT	Stock	505.5767	505.74	505.19	505.52	3019075.0
2025-08-20 17:00:00	MSFT	Stock	505.47	505.65	505.39	505.61	5498.0
2025-08-20 18:00:00	MSFT	Stock	505.7	505.97	505.45	505.45	4187.0
2025-08-20 19:00:00	MSFT	Stock	505.69	505.69	505.26	505.3973	5754.0
2025-08-20 04:00:00	NVDA	Stock	175.0	176.22	174.0	175.61	354487.0
2025-08-20 05:00:00	NVDA	Stock	175.62	176.59	175.6	176.47	253420.0
2025-08-20 06:00:00	NVDA	Stock	176.45	176.46	175.7	175.92	131761.0
2025-08-20 07:00:00	NVDA	Stock	175.89	176.18	175.0	175.24	315232.0
2025-08-20 08:00:00	NVDA	Stock	175.71	176.55	173.61	176.0004	1594933.0
2025-08-20 09:00:00	NVDA	Stock	175.99	176.02	170.12	170.54	31953702.0
2025-08-20 10:00:00	NVDA	Stock	170.52	171.8	168.801	169.55	39046426.0
2025-08-20 11:00:00	NVDA	Stock	169.5487	173.0964	169.41	171.935	26649867.0
2025-08-20 12:00:00	NVDA	Stock	171.93	174.11	171.8	172.905	16821409.0
2025-08-20 13:00:00	NVDA	Stock	172.9097	174.42	172.79	173.56	11550967.0
2025-08-20 14:00:00	NVDA	Stock	173.58	173.83	172.56	173.405	12600631.0
2025-08-20 15:00:00	NVDA	Stock	173.4	176.0	173.4	175.39	19245104.0
2025-08-20 16:00:00	NVDA	Stock	175.4	175.88	175.26	175.79	11118088.0
2025-08-20 17:00:00	NVDA	Stock	175.79	175.92	175.69	175.86	242130.0
2025-08-20 18:00:00	NVDA	Stock	175.85	176.05	175.74	175.96	306719.0
2025-08-20 19:00:00	NVDA	Stock	175.96	175.99	175.6	175.81	282882.0
2025-08-20 04:00:00	AMZN	Stock	226.98	227.02	226.27	226.95	17841.0
2025-08-20 05:00:00	AMZN	Stock	226.82	227.01	226.8	226.81	4876.0

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

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