PREVIEW / stock_1hour / 2002-08-22

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-22.parquet
  size:    390 KB
  rows:    18,503
  symbols: 1,473

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-22 08:00:00	AAPL	Stock	0.2929	0.2929	0.2929	0.2929	5600.0
2002-08-22 09:00:00	AAPL	Stock	0.2889	0.2902	0.2827	0.2832	25964680.0
2002-08-22 10:00:00	AAPL	Stock	0.2839	0.2891	0.283	0.2838	50716848.0
2002-08-22 11:00:00	AAPL	Stock	0.2838	0.2852	0.2807	0.2807	43991808.0
2002-08-22 12:00:00	AAPL	Stock	0.2807	0.2855	0.2796	0.2848	18490080.0
2002-08-22 13:00:00	AAPL	Stock	0.2852	0.2855	0.2814	0.2832	14346192.0
2002-08-22 14:00:00	AAPL	Stock	0.2831	0.2855	0.2813	0.2848	22320424.0
2002-08-22 15:00:00	AAPL	Stock	0.2848	0.287	0.2839	0.2857	65563736.0
2002-08-22 16:00:00	AAPL	Stock	0.2857	0.2857	0.2839	0.2852	2682400.0
2002-08-22 17:00:00	AAPL	Stock	0.2852	0.2852	0.2852	0.2852	39200.0
2002-08-22 08:00:00	MSFT	Stock	26.5	26.9	26.125	26.5	932648.0
2002-08-22 09:00:00	MSFT	Stock	26.505	26.525	26.225	26.395	14817290.0
2002-08-22 10:00:00	MSFT	Stock	26.39	26.725	26.3685	26.645	17476606.0
2002-08-22 11:00:00	MSFT	Stock	26.64	26.67	26.385	26.385	9476882.0
2002-08-22 12:00:00	MSFT	Stock	26.39	26.575	26.345	26.49	5493410.0
2002-08-22 13:00:00	MSFT	Stock	26.49	26.63	26.33	26.445	6125832.0
2002-08-22 14:00:00	MSFT	Stock	26.445	26.65	26.385	26.62	6581266.0
2002-08-22 15:00:00	MSFT	Stock	26.62	26.645	26.465	26.605	10239662.0
2002-08-22 16:00:00	MSFT	Stock	26.605	26.63	26.45	26.6	582642.0
2002-08-22 17:00:00	MSFT	Stock	26.59	26.62	26.59	26.615	46700.0
2002-08-22 18:00:00	MSFT	Stock	26.6	26.615	26.585	26.6	11190.0
2002-08-22 08:00:00	NVDA	Stock	0.1063	0.107	0.1037	0.1046	6243000.0
2002-08-22 09:00:00	NVDA	Stock	0.1046	0.1064	0.1018	0.103	222734040.0
2002-08-22 10:00:00	NVDA	Stock	0.1032	0.1071	0.1028	0.1055	279678360.0
2002-08-22 11:00:00	NVDA	Stock	0.1055	0.1056	0.1033	0.1036	161597160.0
2002-08-22 12:00:00	NVDA	Stock	0.1037	0.1058	0.1035	0.1052	98609040.0
2002-08-22 13:00:00	NVDA	Stock	0.1053	0.1054	0.1021	0.1034	186030600.0
2002-08-22 14:00:00	NVDA	Stock	0.1035	0.1049	0.1028	0.1044	103343640.0
2002-08-22 15:00:00	NVDA	Stock	0.1042	0.1046	0.1025	0.1028	227005920.0
2002-08-22 16:00:00	NVDA	Stock	0.1025	0.1037	0.1024	0.1026	65363400.0
2002-08-22 17:00:00	NVDA	Stock	0.1026	0.1026	0.1019	0.1025	918000.0
2002-08-22 18:00:00	NVDA	Stock	0.1025	0.1025	0.1025	0.1025	102000.0
2002-08-22 08:00:00	AMZN	Stock	0.77	0.77	0.7575	0.7625	144200.0
2002-08-22 09:00:00	AMZN	Stock	0.764	0.768	0.746	0.7565	18980060.0
2002-08-22 10:00:00	AMZN	Stock	0.757	0.797	0.756	0.794	32980440.0
2002-08-22 11:00:00	AMZN	Stock	0.7945	0.7975	0.787	0.7874	18205920.0
2002-08-22 12:00:00	AMZN	Stock	0.7865	0.7915	0.7695	0.783	28150160.0
2002-08-22 13:00:00	AMZN	Stock	0.7835	0.7875	0.775	0.783	12630500.0
2002-08-22 14:00:00	AMZN	Stock	0.7825	0.785	0.7765	0.7815	6518700.0
2002-08-22 15:00:00	AMZN	Stock	0.7815	0.7925	0.7785	0.7865	12127120.0
2002-08-22 16:00:00	AMZN	Stock	0.786	0.792	0.784	0.784	2837740.0
2002-08-22 17:00:00	AMZN	Stock	0.78	0.7865	0.78	0.7865	64000.0
2002-08-22 18:00:00	AMZN	Stock	0.7815	0.7815	0.7815	0.7815	8000.0
2002-08-22 09:00:00	CL	Stock	27.4	27.44	27.25	27.27	168800.0
2002-08-22 10:00:00	CL	Stock	27.27	27.495	27.27	27.41	344000.0
2002-08-22 11:00:00	CL	Stock	27.395	27.5	27.305	27.4	294800.0
2002-08-22 12:00:00	CL	Stock	27.375	27.425	27.265	27.305	258800.0
2002-08-22 13:00:00	CL	Stock	27.305	27.35	27.2	27.25	209600.0
2002-08-22 14:00:00	CL	Stock	27.245	27.25	27.145	27.235	430800.0
2002-08-22 15:00:00	CL	Stock	27.2	27.35	27.2	27.325	751000.0

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

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