PREVIEW / stock_1hour / 2025-07-23

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-07-23.parquet
  size:    1.5 MB
  rows:    64,011
  symbols: 369

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-07-23 04:00:00	AAPL	Stock	215.29	215.5	215.07	215.45	20784.0
2025-07-23 05:00:00	AAPL	Stock	215.5	215.51	215.27	215.27	5928.0
2025-07-23 06:00:00	AAPL	Stock	215.27	215.27	214.95	215.05	10484.0
2025-07-23 07:00:00	AAPL	Stock	215.05	215.05	214.69	215.0	16466.0
2025-07-23 08:00:00	AAPL	Stock	214.88	215.78	214.7	215.56	214940.0
2025-07-23 09:00:00	AAPL	Stock	215.48	215.63	212.42	212.56	6284326.0
2025-07-23 10:00:00	AAPL	Stock	212.56	213.16	212.41	212.66	5004268.0
2025-07-23 11:00:00	AAPL	Stock	212.675	213.82	212.65	213.355	3946837.0
2025-07-23 12:00:00	AAPL	Stock	213.35	213.72	213.21	213.5999	2470838.0
2025-07-23 13:00:00	AAPL	Stock	213.59	214.635	213.51	214.4601	3139980.0
2025-07-23 14:00:00	AAPL	Stock	214.465	214.695	214.25	214.56	2571124.0
2025-07-23 15:00:00	AAPL	Stock	214.57	214.63	213.61	214.31	4721599.0
2025-07-23 16:00:00	AAPL	Stock	214.15	214.6	213.71	214.2	6769775.0
2025-07-23 17:00:00	AAPL	Stock	214.1	214.1575	213.5522	213.63	93922.0
2025-07-23 18:00:00	AAPL	Stock	213.65	213.9462	213.6	213.7	41291.0
2025-07-23 19:00:00	AAPL	Stock	213.64	213.8	213.6	213.64	29997.0
2025-07-23 04:00:00	MSFT	Stock	507.0	507.22	506.75	506.87	4229.0
2025-07-23 05:00:00	MSFT	Stock	507.2	507.34	507.05	507.27	1188.0
2025-07-23 06:00:00	MSFT	Stock	507.19	507.5	507.19	507.5	659.0
2025-07-23 07:00:00	MSFT	Stock	507.06	507.06	506.34	506.57	2703.0
2025-07-23 08:00:00	MSFT	Stock	507.16	507.34	505.5573	505.95	28307.0
2025-07-23 09:00:00	MSFT	Stock	505.99	507.99	502.2	503.16	1418305.0
2025-07-23 10:00:00	MSFT	Stock	503.13	503.13	500.7	502.485	1825110.0
2025-07-23 11:00:00	MSFT	Stock	502.49	505.5	501.4029	504.51	1333937.0
2025-07-23 12:00:00	MSFT	Stock	504.5	504.6899	502.8	503.745	678890.0
2025-07-23 13:00:00	MSFT	Stock	503.76	505.299	503.69	505.18	493374.0
2025-07-23 14:00:00	MSFT	Stock	505.18	505.75	504.6201	505.245	575164.0
2025-07-23 15:00:00	MSFT	Stock	505.27	506.11	504.4	505.97	1382262.0
2025-07-23 16:00:00	MSFT	Stock	505.87	507.36	504.25	507.0	2597732.0
2025-07-23 17:00:00	MSFT	Stock	507.0	507.0	506.0	506.0	10176.0
2025-07-23 18:00:00	MSFT	Stock	506.0041	506.5	505.85	506.5	5471.0
2025-07-23 19:00:00	MSFT	Stock	506.5	506.5	506.48	506.5	972.0
2025-07-23 04:00:00	NVDA	Stock	168.25	168.6	167.9	168.51	258624.0
2025-07-23 05:00:00	NVDA	Stock	168.52	168.6	168.27	168.44	121308.0
2025-07-23 06:00:00	NVDA	Stock	168.44	168.88	168.4	168.46	206954.0
2025-07-23 07:00:00	NVDA	Stock	168.45	168.99	168.1	168.92	463180.0
2025-07-23 08:00:00	NVDA	Stock	168.5	169.29	167.57	168.88	2206325.0
2025-07-23 09:00:00	NVDA	Stock	168.88	170.4	168.23	168.345	23650556.0
2025-07-23 10:00:00	NVDA	Stock	168.34	169.42	167.97	169.3671	19274467.0
2025-07-23 11:00:00	NVDA	Stock	169.3525	169.88	168.96	169.5548	13242721.0
2025-07-23 12:00:00	NVDA	Stock	169.55	169.56	168.53	169.12	10197755.0
2025-07-23 13:00:00	NVDA	Stock	169.1252	169.81	168.83	169.75	8328699.0
2025-07-23 14:00:00	NVDA	Stock	169.75	171.26	169.7414	170.815	17883065.0
2025-07-23 15:00:00	NVDA	Stock	170.82	171.06	170.1707	170.83	14658650.0
2025-07-23 16:00:00	NVDA	Stock	170.78	172.99	170.46	172.52	13294916.0
2025-07-23 17:00:00	NVDA	Stock	172.42	172.75	172.1	172.5899	832648.0
2025-07-23 18:00:00	NVDA	Stock	172.59	172.7	172.4	172.54	390591.0
2025-07-23 19:00:00	NVDA	Stock	172.54	172.95	172.5	172.89	566230.0
2025-07-23 04:00:00	AMZN	Stock	228.31	228.31	228.02	228.24	6510.0
2025-07-23 05:00:00	AMZN	Stock	228.29	228.29	227.94	228.08	2664.0

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

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