PREVIEW / stock_1hour / 2001-10-10

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-10-10.parquet
  size:    369 KB
  rows:    17,749
  symbols: 1,347

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-10-10 09:00:00	AAPL	Stock	0.2859	0.2902	0.2848	0.2898	16279200.0
2001-10-10 10:00:00	AAPL	Stock	0.2898	0.2939	0.2891	0.2927	50635200.0
2001-10-10 11:00:00	AAPL	Stock	0.292	0.292	0.2875	0.2884	28828800.0
2001-10-10 12:00:00	AAPL	Stock	0.2886	0.2925	0.2879	0.2911	8030400.0
2001-10-10 13:00:00	AAPL	Stock	0.2911	0.2927	0.2884	0.2898	50887200.0
2001-10-10 14:00:00	AAPL	Stock	0.2898	0.2964	0.2898	0.295	57965600.0
2001-10-10 15:00:00	AAPL	Stock	0.295	0.3009	0.2941	0.3004	75622400.0
2001-10-10 16:00:00	AAPL	Stock	0.3004	0.3005	0.2928	0.2982	8752800.0
2001-10-10 17:00:00	AAPL	Stock	0.3004	0.3004	0.3004	0.3004	61600.0
2001-10-10 08:00:00	MSFT	Stock	27.125	27.2825	26.56	26.75	298400.0
2001-10-10 09:00:00	MSFT	Stock	26.7	27.28	26.5	26.9825	19924000.0
2001-10-10 10:00:00	MSFT	Stock	26.975	27.395	26.83	27.185	16933800.0
2001-10-10 11:00:00	MSFT	Stock	27.185	27.31	26.99	27.21	7742400.0
2001-10-10 12:00:00	MSFT	Stock	27.2105	27.475	27.155	27.43	8471800.0
2001-10-10 13:00:00	MSFT	Stock	27.385	27.81	27.385	27.59	8722800.0
2001-10-10 14:00:00	MSFT	Stock	27.595	27.75	27.3645	27.715	8162200.0
2001-10-10 15:00:00	MSFT	Stock	27.715	27.875	27.65	27.745	10267200.0
2001-10-10 16:00:00	MSFT	Stock	27.76	27.825	27.2378	27.8	1755600.0
2001-10-10 17:00:00	MSFT	Stock	27.755	27.825	27.755	27.825	41600.0
2001-10-10 18:00:00	MSFT	Stock	27.82	27.82	27.82	27.82	200.0
2001-10-10 08:00:00	NVDA	Stock	0.2692	0.2692	0.2667	0.2667	312000.0
2001-10-10 09:00:00	NVDA	Stock	0.2678	0.2716	0.2617	0.2699	117564000.0
2001-10-10 10:00:00	NVDA	Stock	0.2693	0.2846	0.2686	0.2792	234876000.0
2001-10-10 11:00:00	NVDA	Stock	0.2797	0.2809	0.275	0.2803	99000000.0
2001-10-10 12:00:00	NVDA	Stock	0.28	0.282	0.2757	0.2785	60528000.0
2001-10-10 13:00:00	NVDA	Stock	0.2784	0.2842	0.2773	0.2803	81492000.0
2001-10-10 14:00:00	NVDA	Stock	0.2802	0.2858	0.2783	0.2847	71640000.0
2001-10-10 15:00:00	NVDA	Stock	0.2847	0.2875	0.2817	0.2855	178836000.0
2001-10-10 16:00:00	NVDA	Stock	0.2858	0.2868	0.285	0.2868	26952000.0
2001-10-10 17:00:00	NVDA	Stock	0.2868	0.2874	0.2853	0.2854	576000.0
2001-10-10 18:00:00	NVDA	Stock	0.2854	0.2858	0.2854	0.2858	108000.0
2001-10-10 08:00:00	AMZN	Stock	0.346	0.346	0.346	0.346	2000.0
2001-10-10 09:00:00	AMZN	Stock	0.346	0.355	0.34	0.3525	6326000.0
2001-10-10 10:00:00	AMZN	Stock	0.3525	0.3625	0.35	0.353	18880000.0
2001-10-10 11:00:00	AMZN	Stock	0.3535	0.355	0.3486	0.3505	7520000.0
2001-10-10 12:00:00	AMZN	Stock	0.351	0.3575	0.3505	0.3575	5460000.0
2001-10-10 13:00:00	AMZN	Stock	0.3575	0.3655	0.357	0.362	8216000.0
2001-10-10 14:00:00	AMZN	Stock	0.362	0.3625	0.357	0.3625	4644000.0
2001-10-10 15:00:00	AMZN	Stock	0.361	0.365	0.3595	0.363	5996000.0
2001-10-10 16:00:00	AMZN	Stock	0.3635	0.3825	0.3625	0.3775	2536000.0
2001-10-10 17:00:00	AMZN	Stock	0.3785	0.3785	0.363	0.37	180000.0
2001-10-10 09:00:00	CL	Stock	28.5	28.56	28.42	28.54	213000.0
2001-10-10 10:00:00	CL	Stock	28.55	28.93	28.55	28.91	499800.0
2001-10-10 11:00:00	CL	Stock	28.9	29.15	28.875	29.075	286400.0
2001-10-10 12:00:00	CL	Stock	29.095	29.2	29.0	29.04	397200.0
2001-10-10 13:00:00	CL	Stock	29.05	29.125	28.95	28.955	175400.0
2001-10-10 14:00:00	CL	Stock	28.975	29.035	28.825	28.945	243600.0
2001-10-10 15:00:00	CL	Stock	28.95	29.115	28.895	29.015	387000.0
2001-10-10 16:00:00	CL	Stock	29.015	29.015	28.92	28.995	194800.0
2001-10-10 17:00:00	CL	Stock	28.995	28.995	28.995	28.995	20000.0

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

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