PREVIEW / stock_1hour / 2002-04-25

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-04-25.parquet
  size:    409 KB
  rows:    19,117
  symbols: 1,408

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
2002-04-25 08:00:00	AAPL	Stock	0.4243	0.4243	0.4243	0.4243	5600.0
2002-04-25 09:00:00	AAPL	Stock	0.4243	0.4275	0.4205	0.4256	17292800.0
2002-04-25 10:00:00	AAPL	Stock	0.4263	0.4321	0.4241	0.4293	26684000.0
2002-04-25 11:00:00	AAPL	Stock	0.4293	0.4313	0.4237	0.4311	24539200.0
2002-04-25 12:00:00	AAPL	Stock	0.4311	0.4313	0.4207	0.4221	23486400.0
2002-04-25 13:00:00	AAPL	Stock	0.4218	0.4298	0.4218	0.4284	32776800.0
2002-04-25 14:00:00	AAPL	Stock	0.4284	0.4293	0.425	0.4271	23811200.0
2002-04-25 15:00:00	AAPL	Stock	0.4273	0.4346	0.4264	0.4307	30368800.0
2002-04-25 16:00:00	AAPL	Stock	0.4307	0.433	0.4288	0.4307	5644800.0
2002-04-25 17:00:00	AAPL	Stock	0.4307	0.4307	0.4307	0.4307	39200.0
2002-04-25 08:00:00	MSFT	Stock	26.45	26.55	26.25	26.505	82400.0
2002-04-25 09:00:00	MSFT	Stock	26.37	26.95	26.37	26.865	8041400.0
2002-04-25 10:00:00	MSFT	Stock	26.865	27.225	26.765	26.88	12628000.0
2002-04-25 11:00:00	MSFT	Stock	26.881	26.9255	26.61	26.875	7954600.0
2002-04-25 12:00:00	MSFT	Stock	26.875	26.88	26.64	26.75	3655600.0
2002-04-25 13:00:00	MSFT	Stock	26.75	27.03	26.745	26.9	4766400.0
2002-04-25 14:00:00	MSFT	Stock	26.9	27.05	26.7505	26.81	5103000.0
2002-04-25 15:00:00	MSFT	Stock	26.81	27.19	26.56	26.855	10807400.0
2002-04-25 16:00:00	MSFT	Stock	26.855	27.0	26.575	26.855	2155600.0
2002-04-25 17:00:00	MSFT	Stock	26.855	26.94	26.85	26.865	43000.0
2002-04-25 18:00:00	MSFT	Stock	26.865	26.935	26.865	26.935	2800.0
2002-04-25 08:00:00	NVDA	Stock	0.2683	0.2715	0.2627	0.2654	14784000.0
2002-04-25 09:00:00	NVDA	Stock	0.2654	0.2812	0.2647	0.2792	198060000.0
2002-04-25 10:00:00	NVDA	Stock	0.2792	0.2866	0.2767	0.2822	250764000.0
2002-04-25 11:00:00	NVDA	Stock	0.2822	0.2861	0.2801	0.284	130548000.0
2002-04-25 12:00:00	NVDA	Stock	0.284	0.2845	0.2741	0.2774	105816000.0
2002-04-25 13:00:00	NVDA	Stock	0.2773	0.2845	0.2773	0.2806	88116000.0
2002-04-25 14:00:00	NVDA	Stock	0.2808	0.2845	0.2764	0.2776	98976000.0
2002-04-25 15:00:00	NVDA	Stock	0.2777	0.2854	0.2742	0.2797	188472000.0
2002-04-25 16:00:00	NVDA	Stock	0.2808	0.2827	0.2721	0.2823	18036000.0
2002-04-25 17:00:00	NVDA	Stock	0.2817	0.2817	0.2812	0.2812	408000.0
2002-04-25 18:00:00	NVDA	Stock	0.2817	0.2824	0.2797	0.2797	600000.0
2002-04-25 08:00:00	AMZN	Stock	0.8245	0.85	0.8025	0.8205	2178000.0
2002-04-25 09:00:00	AMZN	Stock	0.8225	0.84	0.818	0.831	48902000.0
2002-04-25 10:00:00	AMZN	Stock	0.831	0.8515	0.826	0.8376	63766000.0
2002-04-25 11:00:00	AMZN	Stock	0.8375	0.846	0.831	0.839	20796000.0
2002-04-25 12:00:00	AMZN	Stock	0.8395	0.8405	0.828	0.8286	15474000.0
2002-04-25 13:00:00	AMZN	Stock	0.829	0.85	0.8285	0.8385	19268000.0
2002-04-25 14:00:00	AMZN	Stock	0.8385	0.839	0.8275	0.828	15528000.0
2002-04-25 15:00:00	AMZN	Stock	0.8275	0.8425	0.8255	0.841	27036000.0
2002-04-25 16:00:00	AMZN	Stock	0.8425	0.85	0.8258	0.841	5862000.0
2002-04-25 17:00:00	AMZN	Stock	0.8465	0.8465	0.8402	0.841	338000.0
2002-04-25 18:00:00	AMZN	Stock	0.842	0.8435	0.842	0.8435	70000.0
2002-04-25 09:00:00	CL	Stock	27.65	27.65	27.38	27.455	493600.0
2002-04-25 10:00:00	CL	Stock	27.475	27.625	27.45	27.625	695000.0
2002-04-25 11:00:00	CL	Stock	27.625	27.78	27.525	27.585	456000.0
2002-04-25 12:00:00	CL	Stock	27.565	27.64	27.55	27.625	449600.0
2002-04-25 13:00:00	CL	Stock	27.625	27.7	27.625	27.695	396200.0
2002-04-25 14:00:00	CL	Stock	27.695	27.87	27.655	27.865	795400.0
2002-04-25 15:00:00	CL	Stock	27.87	27.87	27.78	27.82	1187600.0

> showing 50 of 19,117 rows — these rows as CSV

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