PREVIEW / stock_1hour / 2025-04-02

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-04-02.parquet
  size:    1.4 MB
  rows:    63,578
  symbols: 454

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-04-02 04:00:00	AAPL	Stock	222.82	222.82	222.08	222.26	10465.0
2025-04-02 05:00:00	AAPL	Stock	222.45	222.51	222.18	222.25	3200.0
2025-04-02 06:00:00	AAPL	Stock	222.2	222.22	221.49	221.91	20499.0
2025-04-02 07:00:00	AAPL	Stock	221.96	222.55	221.86	221.87	19397.0
2025-04-02 08:00:00	AAPL	Stock	222.3	222.85	221.11	221.45	63393.0
2025-04-02 09:00:00	AAPL	Stock	221.61	223.0	220.6	222.84	2548079.0
2025-04-02 10:00:00	AAPL	Stock	222.83	224.46	222.49	224.35	3278738.0
2025-04-02 11:00:00	AAPL	Stock	224.35	224.7154	223.1	223.685	2456078.0
2025-04-02 12:00:00	AAPL	Stock	223.69	224.9578	223.62	224.68	2047454.0
2025-04-02 13:00:00	AAPL	Stock	224.7	225.19	223.97	224.1903	2477438.0
2025-04-02 14:00:00	AAPL	Stock	224.18	224.28	222.86	222.92	2027323.0
2025-04-02 15:00:00	AAPL	Stock	222.9453	224.46	222.945	223.8	3879420.0
2025-04-02 16:00:00	AAPL	Stock	223.89	225.5	211.32	212.73	6433776.0
2025-04-02 17:00:00	AAPL	Stock	212.7	213.25	208.3587	208.6	998251.0
2025-04-02 18:00:00	AAPL	Stock	208.68	209.2	206.15	208.63	557226.0
2025-04-02 19:00:00	AAPL	Stock	208.71	208.71	206.56	207.91	273693.0
2025-04-02 04:00:00	MSFT	Stock	380.5	380.99	379.58	380.26	11914.0
2025-04-02 05:00:00	MSFT	Stock	380.34	380.34	380.14	380.2	474.0
2025-04-02 06:00:00	MSFT	Stock	380.3	380.74	379.26	379.97	5275.0
2025-04-02 07:00:00	MSFT	Stock	379.97	380.5	379.5	379.65	6362.0
2025-04-02 08:00:00	MSFT	Stock	380.07	381.02	377.4	378.5	32334.0
2025-04-02 09:00:00	MSFT	Stock	378.31	383.0	376.12	381.38	1198869.0
2025-04-02 10:00:00	MSFT	Stock	381.1	382.47	379.165	381.76	992430.0
2025-04-02 11:00:00	MSFT	Stock	381.785	382.67	380.24	381.295	925964.0
2025-04-02 12:00:00	MSFT	Stock	381.31	384.38	381.17	384.08	681670.0
2025-04-02 13:00:00	MSFT	Stock	384.09	385.08	381.6488	382.16	920378.0
2025-04-02 14:00:00	MSFT	Stock	382.04	382.17	380.26	380.415	898859.0
2025-04-02 15:00:00	MSFT	Stock	380.49	384.03	380.49	382.11	1460986.0
2025-04-02 16:00:00	MSFT	Stock	382.14	386.7	373.55	375.7689	2744315.0
2025-04-02 17:00:00	MSFT	Stock	374.5125	376.47	373.08	373.08	72089.0
2025-04-02 18:00:00	MSFT	Stock	373.0104	373.0104	369.0207	370.95	49167.0
2025-04-02 19:00:00	MSFT	Stock	370.89	371.1	370.0	370.5	24637.0
2025-04-02 04:00:00	NVDA	Stock	109.01	109.66	108.8	109.26	324362.0
2025-04-02 05:00:00	NVDA	Stock	109.25	109.48	109.17	109.24	102917.0
2025-04-02 06:00:00	NVDA	Stock	109.24	109.3	108.24	108.64	332352.0
2025-04-02 07:00:00	NVDA	Stock	108.64	108.76	107.78	107.78	724326.0
2025-04-02 08:00:00	NVDA	Stock	108.6	109.79	107.5	107.9	2630155.0
2025-04-02 09:00:00	NVDA	Stock	107.9	109.59	106.79	108.84	25537425.0
2025-04-02 10:00:00	NVDA	Stock	108.83	109.72	108.11	109.38	25147098.0
2025-04-02 11:00:00	NVDA	Stock	109.375	110.49	108.85	109.93	21405885.0
2025-04-02 12:00:00	NVDA	Stock	109.94	111.55	109.8	111.245	20261534.0
2025-04-02 13:00:00	NVDA	Stock	111.25	111.98	110.1	110.335	19249177.0
2025-04-02 14:00:00	NVDA	Stock	110.3301	110.58	108.97	108.9887	18795269.0
2025-04-02 15:00:00	NVDA	Stock	108.985	110.76	108.85	110.31	25895268.0
2025-04-02 16:00:00	NVDA	Stock	110.3	113.23	105.8	106.77	18600540.0
2025-04-02 17:00:00	NVDA	Stock	106.73	107.09	104.02	105.67	5216543.0
2025-04-02 18:00:00	NVDA	Stock	105.69	107.0	104.75	105.25	2199893.0
2025-04-02 19:00:00	NVDA	Stock	105.25	105.26	104.03	104.15	1685613.0
2025-04-02 04:00:00	AMZN	Stock	191.3	191.61	190.93	191.33	8717.0
2025-04-02 05:00:00	AMZN	Stock	191.31	191.4	191.07	191.07	4682.0

> showing 50 of 63,578 rows — these rows as CSV

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