PREVIEW / stock_1hour / 2002-08-23

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-23.parquet
  size:    395 KB
  rows:    18,574
  symbols: 1,463

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-08-23 09:00:00	AAPL	Stock	0.2839	0.2845	0.2809	0.2838	19220880.0
2002-08-23 10:00:00	AAPL	Stock	0.2839	0.2839	0.2793	0.2802	21722792.0
2002-08-23 11:00:00	AAPL	Stock	0.2802	0.2809	0.2777	0.2788	14295120.0
2002-08-23 12:00:00	AAPL	Stock	0.2788	0.2791	0.2759	0.2779	20283928.0
2002-08-23 13:00:00	AAPL	Stock	0.2779	0.2805	0.2773	0.2791	17091144.0
2002-08-23 14:00:00	AAPL	Stock	0.2791	0.283	0.2768	0.28	30370368.0
2002-08-23 15:00:00	AAPL	Stock	0.2796	0.2809	0.277	0.2795	29691704.0
2002-08-23 16:00:00	AAPL	Stock	0.2789	0.2823	0.2777	0.2823	6082832.0
2002-08-23 17:00:00	AAPL	Stock	0.2809	0.2813	0.2794	0.2809	2044000.0
2002-08-23 08:00:00	MSFT	Stock	26.5	26.785	26.31	26.4	117020.0
2002-08-23 09:00:00	MSFT	Stock	26.4	26.595	26.255	26.32	6092254.0
2002-08-23 10:00:00	MSFT	Stock	26.32	26.355	26.0555	26.2955	10905970.0
2002-08-23 11:00:00	MSFT	Stock	26.295	26.325	26.19	26.235	7463386.0
2002-08-23 12:00:00	MSFT	Stock	26.225	26.25	26.105	26.21	5210804.0
2002-08-23 13:00:00	MSFT	Stock	26.21	26.3	26.125	26.145	7181866.0
2002-08-23 14:00:00	MSFT	Stock	26.15	26.235	26.065	26.08	7090464.0
2002-08-23 15:00:00	MSFT	Stock	26.075	26.18	25.92	26.12	11452536.0
2002-08-23 16:00:00	MSFT	Stock	26.125	26.22	26.09	26.2	1513300.0
2002-08-23 17:00:00	MSFT	Stock	26.19	26.19	26.0381	26.11	333080.0
2002-08-23 18:00:00	MSFT	Stock	26.175	26.175	26.17	26.17	2800.0
2002-08-23 08:00:00	NVDA	Stock	0.1001	0.1033	0.0991	0.0993	3934800.0
2002-08-23 09:00:00	NVDA	Stock	0.0996	0.1023	0.0983	0.0988	175282920.0
2002-08-23 10:00:00	NVDA	Stock	0.0988	0.0992	0.0978	0.0979	164671920.0
2002-08-23 11:00:00	NVDA	Stock	0.0979	0.0987	0.0977	0.0983	117085440.0
2002-08-23 12:00:00	NVDA	Stock	0.0983	0.0983	0.0972	0.0975	113689920.0
2002-08-23 13:00:00	NVDA	Stock	0.0975	0.098	0.0966	0.0975	90021240.0
2002-08-23 14:00:00	NVDA	Stock	0.0973	0.0983	0.097	0.0971	50520360.0
2002-08-23 15:00:00	NVDA	Stock	0.097	0.0971	0.0952	0.0957	154880760.0
2002-08-23 16:00:00	NVDA	Stock	0.0958	0.0977	0.0951	0.0951	19405200.0
2002-08-23 17:00:00	NVDA	Stock	0.0951	0.0958	0.095	0.0957	3264000.0
2002-08-23 18:00:00	NVDA	Stock	0.0949	0.0952	0.0947	0.0947	492000.0
2002-08-23 08:00:00	AMZN	Stock	0.7775	0.7824	0.776	0.7824	30000.0
2002-08-23 09:00:00	AMZN	Stock	0.7726	0.786	0.772	0.782	7999720.0
2002-08-23 10:00:00	AMZN	Stock	0.782	0.7855	0.77	0.779	18470260.0
2002-08-23 11:00:00	AMZN	Stock	0.779	0.78	0.772	0.774	12864640.0
2002-08-23 12:00:00	AMZN	Stock	0.7735	0.774	0.761	0.766	14014620.0
2002-08-23 13:00:00	AMZN	Stock	0.7655	0.773	0.762	0.769	9206000.0
2002-08-23 14:00:00	AMZN	Stock	0.768	0.7715	0.7605	0.763	7297000.0
2002-08-23 15:00:00	AMZN	Stock	0.7625	0.7635	0.7475	0.753	25891300.0
2002-08-23 16:00:00	AMZN	Stock	0.7535	0.77	0.7535	0.7595	2114120.0
2002-08-23 17:00:00	AMZN	Stock	0.7595	0.7605	0.7567	0.7585	430000.0
2002-08-23 18:00:00	AMZN	Stock	0.7595	0.7595	0.7595	0.7595	20000.0
2002-08-23 09:00:00	CL	Stock	27.32	27.375	27.27	27.275	351000.0
2002-08-23 10:00:00	CL	Stock	27.27	27.295	27.075	27.075	414600.0
2002-08-23 11:00:00	CL	Stock	27.075	27.09	26.84	26.94	659200.0
2002-08-23 12:00:00	CL	Stock	26.945	27.0	26.905	26.975	221200.0
2002-08-23 13:00:00	CL	Stock	26.99	27.06	26.945	27.045	198400.0
2002-08-23 14:00:00	CL	Stock	27.04	27.075	26.935	26.95	273000.0
2002-08-23 15:00:00	CL	Stock	26.97	27.0	26.8	26.85	668400.0
2002-08-23 16:00:00	CL	Stock	26.855	26.885	26.855	26.885	75600.0

> showing 50 of 18,574 rows — these rows as CSV

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