PREVIEW / stock_1hour / 2026-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2026/2026-04-20.parquet
  size:    1.4 MB
  rows:    62,443
  symbols: 64

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-04-20 04:00:00	AAPL	Stock	268.65	270.328	268.65	270.24	56413.0
2026-04-20 05:00:00	AAPL	Stock	270.33	270.8	270.11	270.53	16096.0
2026-04-20 06:00:00	AAPL	Stock	270.58	271.17	270.33	270.45	20699.0
2026-04-20 07:00:00	AAPL	Stock	270.38	270.7372	270.0	270.32	56663.0
2026-04-20 08:00:00	AAPL	Stock	270.22	270.4218	269.7059	270.01	49700.0
2026-04-20 09:00:00	AAPL	Stock	270.08	274.0999	269.08	273.922	4854550.0
2026-04-20 10:00:00	AAPL	Stock	273.93	274.275	272.095	272.4	3672400.0
2026-04-20 11:00:00	AAPL	Stock	272.38	272.96	271.72	272.7791	2323864.0
2026-04-20 12:00:00	AAPL	Stock	272.77	273.16	272.165	272.35	1611929.0
2026-04-20 13:00:00	AAPL	Stock	272.375	272.97	271.84	272.96	1739300.0
2026-04-20 14:00:00	AAPL	Stock	272.96	273.65	272.8	272.99	1734659.0
2026-04-20 15:00:00	AAPL	Stock	272.99	273.26	272.27	272.93	3471625.0
2026-04-20 16:00:00	AAPL	Stock	272.93	273.45	267.67	270.75	7343924.0
2026-04-20 17:00:00	AAPL	Stock	270.85	272.0	270.3	271.89	256756.0
2026-04-20 18:00:00	AAPL	Stock	271.7	272.0	271.5	271.7485	62700.0
2026-04-20 19:00:00	AAPL	Stock	271.71	271.75	271.25	271.55	58022.0
2026-04-20 04:00:00	MSFT	Stock	418.53	419.85	417.2	418.04	135747.0
2026-04-20 05:00:00	MSFT	Stock	418.17	418.88	418.17	418.5	25326.0
2026-04-20 06:00:00	MSFT	Stock	418.43	419.43	418.4	419.1	16419.0
2026-04-20 07:00:00	MSFT	Stock	419.06	419.89	418.4	419.76	85307.0
2026-04-20 08:00:00	MSFT	Stock	419.7002	423.846	419.51	420.63	100643.0
2026-04-20 09:00:00	MSFT	Stock	420.614	423.33	417.11	420.53	3093110.0
2026-04-20 10:00:00	MSFT	Stock	420.53	422.765	417.78	418.1	3273615.0
2026-04-20 11:00:00	MSFT	Stock	418.12	418.64	416.3	417.475	2398546.0
2026-04-20 12:00:00	MSFT	Stock	417.48	419.54	417.415	418.8	1428160.0
2026-04-20 13:00:00	MSFT	Stock	418.8	420.17	418.22	418.37	1609213.0
2026-04-20 14:00:00	MSFT	Stock	418.38	419.06	416.73	416.99	1894168.0
2026-04-20 15:00:00	MSFT	Stock	416.98	418.17	416.8	418.08	2601315.0
2026-04-20 16:00:00	MSFT	Stock	418.1	418.25	416.9693	417.46	3108931.0
2026-04-20 17:00:00	MSFT	Stock	417.51	417.75	417.45	417.59	27593.0
2026-04-20 18:00:00	MSFT	Stock	417.5	418.29	417.5	418.19	25457.0
2026-04-20 19:00:00	MSFT	Stock	418.21	418.38	417.87	417.9	23945.0
2026-04-20 04:00:00	NVDA	Stock	199.1	199.55	198.35	199.01	553984.0
2026-04-20 05:00:00	NVDA	Stock	199.045	199.4	198.95	199.0	121317.0
2026-04-20 06:00:00	NVDA	Stock	199.0	199.61	198.99	199.43	134804.0
2026-04-20 07:00:00	NVDA	Stock	199.46	199.99	199.39	199.63	444475.0
2026-04-20 08:00:00	NVDA	Stock	199.6502	201.176	199.5217	200.3199	596082.0
2026-04-20 09:00:00	NVDA	Stock	200.28	200.53	198.42	200.25	15645569.0
2026-04-20 10:00:00	NVDA	Stock	200.25	200.34	198.37	198.55	15230458.0
2026-04-20 11:00:00	NVDA	Stock	198.55	199.34	197.8397	198.645	12422570.0
2026-04-20 12:00:00	NVDA	Stock	198.65	199.58	198.5701	199.29	6469113.0
2026-04-20 13:00:00	NVDA	Stock	199.28	200.14	199.14	199.945	7182218.0
2026-04-20 14:00:00	NVDA	Stock	199.96	200.95	199.9502	200.785	9483944.0
2026-04-20 15:00:00	NVDA	Stock	200.79	202.17	200.74	202.12	14847644.0
2026-04-20 16:00:00	NVDA	Stock	202.12	202.38	200.0422	201.93	10040530.0
2026-04-20 17:00:00	NVDA	Stock	201.92	201.99	201.5	201.65	353871.0
2026-04-20 18:00:00	NVDA	Stock	201.66	201.99	201.63	201.95	168875.0
2026-04-20 19:00:00	NVDA	Stock	201.93	201.94	201.6152	201.7	144075.0
2026-04-20 04:00:00	AMZN	Stock	249.93	249.93	248.0	248.72	54083.0
2026-04-20 05:00:00	AMZN	Stock	248.92	249.2	248.13	248.2338	26513.0

> showing 50 of 62,443 rows — these rows as CSV

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