PREVIEW / stock_1hour / 2001-09-25

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-09-25.parquet
  size:    371 KB
  rows:    17,996
  symbols: 1,342

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
2001-09-25 08:00:00	AAPL	Stock	0.2938	0.2938	0.2857	0.2859	246400.0
2001-09-25 09:00:00	AAPL	Stock	0.2884	0.2902	0.2845	0.2888	31276000.0
2001-09-25 10:00:00	AAPL	Stock	0.2887	0.2895	0.2843	0.2848	64226400.0
2001-09-25 11:00:00	AAPL	Stock	0.2852	0.2873	0.2832	0.2852	45808000.0
2001-09-25 12:00:00	AAPL	Stock	0.285	0.2863	0.2782	0.2795	35660800.0
2001-09-25 13:00:00	AAPL	Stock	0.2793	0.2795	0.2755	0.2761	48613600.0
2001-09-25 14:00:00	AAPL	Stock	0.2761	0.2786	0.2741	0.2773	44665600.0
2001-09-25 15:00:00	AAPL	Stock	0.2775	0.2793	0.2759	0.2777	53474400.0
2001-09-25 16:00:00	AAPL	Stock	0.2777	0.2813	0.2761	0.2775	13568800.0
2001-09-25 17:00:00	AAPL	Stock	0.2768	0.2775	0.2768	0.2775	1176000.0
2001-09-25 18:00:00	AAPL	Stock	0.2768	0.2768	0.2754	0.2754	16800.0
2001-09-25 08:00:00	MSFT	Stock	25.795	26.2505	25.795	26.14	219200.0
2001-09-25 09:00:00	MSFT	Stock	26.115	26.45	25.97	26.315	11041400.0
2001-09-25 10:00:00	MSFT	Stock	26.315	26.5	25.705	25.75	18248200.0
2001-09-25 11:00:00	MSFT	Stock	25.755	26.055	25.58	25.61	8360200.0
2001-09-25 12:00:00	MSFT	Stock	25.605	25.735	25.285	25.55	8806600.0
2001-09-25 13:00:00	MSFT	Stock	25.565	25.615	25.25	25.305	7534800.0
2001-09-25 14:00:00	MSFT	Stock	25.305	25.5	25.08	25.485	8843600.0
2001-09-25 15:00:00	MSFT	Stock	25.485	25.855	25.4545	25.65	13144400.0
2001-09-25 16:00:00	MSFT	Stock	25.655	26.38	25.425	25.7671	3520400.0
2001-09-25 17:00:00	MSFT	Stock	25.7	26.14	25.6	25.65	245800.0
2001-09-25 18:00:00	MSFT	Stock	25.665	25.72	25.65	25.65	3000.0
2001-09-25 08:00:00	NVDA	Stock	0.2583	0.2583	0.2512	0.2512	408000.0
2001-09-25 09:00:00	NVDA	Stock	0.2501	0.252	0.2434	0.2492	100392000.0
2001-09-25 10:00:00	NVDA	Stock	0.2492	0.2616	0.2458	0.2566	217116000.0
2001-09-25 11:00:00	NVDA	Stock	0.2567	0.2583	0.2519	0.2531	75240000.0
2001-09-25 12:00:00	NVDA	Stock	0.2531	0.2538	0.2417	0.2477	133608000.0
2001-09-25 13:00:00	NVDA	Stock	0.2486	0.2488	0.24	0.2412	105180000.0
2001-09-25 14:00:00	NVDA	Stock	0.242	0.2458	0.2395	0.2427	102492000.0
2001-09-25 15:00:00	NVDA	Stock	0.2427	0.245	0.2397	0.2403	138396000.0
2001-09-25 16:00:00	NVDA	Stock	0.2402	0.2411	0.2397	0.2404	9732000.0
2001-09-25 17:00:00	NVDA	Stock	0.2402	0.2402	0.2402	0.2402	3384000.0
2001-09-25 08:00:00	AMZN	Stock	0.3725	0.387	0.3725	0.387	30000.0
2001-09-25 09:00:00	AMZN	Stock	0.3725	0.3755	0.3645	0.371	14462000.0
2001-09-25 10:00:00	AMZN	Stock	0.3715	0.3775	0.3685	0.371	15154000.0
2001-09-25 11:00:00	AMZN	Stock	0.371	0.3775	0.3695	0.3745	9818000.0
2001-09-25 12:00:00	AMZN	Stock	0.376	0.376	0.366	0.369	8194000.0
2001-09-25 13:00:00	AMZN	Stock	0.369	0.37	0.3525	0.358	7014000.0
2001-09-25 14:00:00	AMZN	Stock	0.3595	0.3625	0.3535	0.3575	9456000.0
2001-09-25 15:00:00	AMZN	Stock	0.3585	0.3605	0.351	0.3545	14676000.0
2001-09-25 16:00:00	AMZN	Stock	0.3545	0.3545	0.35	0.3545	5236000.0
2001-09-25 17:00:00	AMZN	Stock	0.3545	0.3545	0.3545	0.3545	102000.0
2001-09-25 09:00:00	CL	Stock	27.75	27.75	27.515	27.625	696800.0
2001-09-25 10:00:00	CL	Stock	27.62	27.84	27.52	27.56	630600.0
2001-09-25 11:00:00	CL	Stock	27.57	27.795	27.52	27.76	510000.0
2001-09-25 12:00:00	CL	Stock	27.76	27.76	27.575	27.665	348200.0
2001-09-25 13:00:00	CL	Stock	27.665	27.705	27.5	27.59	542800.0
2001-09-25 14:00:00	CL	Stock	27.59	27.795	27.55	27.765	537400.0
2001-09-25 15:00:00	CL	Stock	27.755	27.875	27.715	27.83	667400.0
2001-09-25 16:00:00	CL	Stock	27.83	27.83	27.675	27.675	658200.0

> showing 50 of 17,996 rows — these rows as CSV

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