PREVIEW / stock_1hour / 2025-01-22

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-01-22.parquet
  size:    1.5 MB
  rows:    64,700
  symbols: 580

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-01-22 04:00:00	AAPL	Stock	222.7	222.72	221.91	222.2	61469.0
2025-01-22 05:00:00	AAPL	Stock	222.09	222.78	222.09	222.78	24315.0
2025-01-22 06:00:00	AAPL	Stock	222.66	223.0	222.45	222.46	37569.0
2025-01-22 07:00:00	AAPL	Stock	222.47	222.59	221.83	222.0	57250.0
2025-01-22 08:00:00	AAPL	Stock	222.43	222.82	220.85	221.15	315345.0
2025-01-22 09:00:00	AAPL	Stock	221.21	223.28	219.05	222.95	9248749.0
2025-01-22 10:00:00	AAPL	Stock	222.96	223.3528	221.52	222.935	6111482.0
2025-01-22 11:00:00	AAPL	Stock	222.94	223.08	221.7	221.935	4557791.0
2025-01-22 12:00:00	AAPL	Stock	221.945	222.8299	221.8	222.7299	3420287.0
2025-01-22 13:00:00	AAPL	Stock	222.73	222.85	221.91	222.43	2907814.0
2025-01-22 14:00:00	AAPL	Stock	222.4299	223.4	222.35	223.3889	3041079.0
2025-01-22 15:00:00	AAPL	Stock	223.38	224.12	222.82	223.77	6127576.0
2025-01-22 16:00:00	AAPL	Stock	223.76	223.99	223.3495	223.5002	9178239.0
2025-01-22 17:00:00	AAPL	Stock	223.51	223.59	223.2	223.35	55529.0
2025-01-22 18:00:00	AAPL	Stock	223.3999	223.5	223.3	223.3607	45911.0
2025-01-22 19:00:00	AAPL	Stock	223.4	223.45	223.1245	223.18	37883.0
2025-01-22 04:00:00	MSFT	Stock	435.65	435.7	434.77	435.6	20284.0
2025-01-22 05:00:00	MSFT	Stock	435.55	435.65	434.7	434.73	9903.0
2025-01-22 06:00:00	MSFT	Stock	434.89	434.98	433.12	433.34	14141.0
2025-01-22 07:00:00	MSFT	Stock	433.23	434.75	432.78	434.7	27094.0
2025-01-22 08:00:00	MSFT	Stock	433.96	438.0	428.5	437.23	122002.0
2025-01-22 09:00:00	MSFT	Stock	437.3	441.9	436.0	441.285	3314775.0
2025-01-22 10:00:00	MSFT	Stock	441.285	443.3	439.17	441.2	2302590.0
2025-01-22 11:00:00	MSFT	Stock	441.29	444.44	440.51	444.33	1512603.0
2025-01-22 12:00:00	MSFT	Stock	444.34	445.96	444.27	445.3229	1210655.0
2025-01-22 13:00:00	MSFT	Stock	445.25	445.37	443.64	444.77	1080128.0
2025-01-22 14:00:00	MSFT	Stock	444.765	445.85	444.43	445.36	917519.0
2025-01-22 15:00:00	MSFT	Stock	445.34	447.27	444.86	446.16	2604218.0
2025-01-22 16:00:00	MSFT	Stock	446.2	446.49	444.78	445.2	4409570.0
2025-01-22 17:00:00	MSFT	Stock	445.19	445.19	444.6083	444.95	9241.0
2025-01-22 18:00:00	MSFT	Stock	444.97	445.0	444.7	444.7737	5837.0
2025-01-22 19:00:00	MSFT	Stock	444.8	445.0	444.4501	445.0	14253.0
2025-01-22 04:00:00	NVDA	Stock	143.45	144.75	143.3	144.75	892027.0
2025-01-22 05:00:00	NVDA	Stock	144.76	145.0	144.26	144.49	629501.0
2025-01-22 06:00:00	NVDA	Stock	144.5	144.9	144.46	144.58	467498.0
2025-01-22 07:00:00	NVDA	Stock	144.57	145.46	144.52	145.3	1460565.0
2025-01-22 08:00:00	NVDA	Stock	145.3	146.0	143.15	145.4388	3940536.0
2025-01-22 09:00:00	NVDA	Stock	145.4201	147.43	140.83	146.2	47413260.0
2025-01-22 10:00:00	NVDA	Stock	146.205	147.18	145.72	145.79	31210134.0
2025-01-22 11:00:00	NVDA	Stock	145.795	146.68	145.46	146.5854	19602597.0
2025-01-22 12:00:00	NVDA	Stock	146.59	146.99	146.43	146.9792	12942436.0
2025-01-22 13:00:00	NVDA	Stock	146.97	147.71	146.38	147.4	18754515.0
2025-01-22 14:00:00	NVDA	Stock	147.4	147.7763	147.13	147.76	12828107.0
2025-01-22 15:00:00	NVDA	Stock	147.755	147.79	146.7	147.03	23354834.0
2025-01-22 16:00:00	NVDA	Stock	147.035	147.11	146.55	146.6995	20170834.0
2025-01-22 17:00:00	NVDA	Stock	146.7	147.07	146.16	146.399	538281.0
2025-01-22 18:00:00	NVDA	Stock	146.35	146.398	146.0102	146.03	437373.0
2025-01-22 19:00:00	NVDA	Stock	146.04	146.05	144.93	145.21	1073210.0
2025-01-22 04:00:00	AMZN	Stock	231.45	232.33	231.3	232.17	89699.0
2025-01-22 05:00:00	AMZN	Stock	232.14	232.37	231.54	232.24	30997.0

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

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