PREVIEW / stock_1hour / 2002-06-21

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-06-21.parquet
  size:    415 KB
  rows:    19,688
  symbols: 1,437

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-06-21 08:00:00	AAPL	Stock	0.3056	0.3107	0.3056	0.3107	470400.0
2002-06-21 09:00:00	AAPL	Stock	0.3107	0.3107	0.3021	0.3096	66920000.0
2002-06-21 10:00:00	AAPL	Stock	0.3096	0.3118	0.3057	0.3089	43691200.0
2002-06-21 11:00:00	AAPL	Stock	0.3091	0.3123	0.3027	0.305	38203200.0
2002-06-21 12:00:00	AAPL	Stock	0.305	0.3061	0.3036	0.3057	16906400.0
2002-06-21 13:00:00	AAPL	Stock	0.3055	0.3086	0.3046	0.307	27003200.0
2002-06-21 14:00:00	AAPL	Stock	0.307	0.3073	0.3036	0.3046	43293600.0
2002-06-21 15:00:00	AAPL	Stock	0.3048	0.3063	0.2998	0.3021	82051200.0
2002-06-21 16:00:00	AAPL	Stock	0.3023	0.3055	0.2991	0.3008	110616800.0
2002-06-21 17:00:00	AAPL	Stock	0.3009	0.3009	0.3009	0.3009	1243200.0
2002-06-21 18:00:00	AAPL	Stock	0.3009	0.3009	0.3009	0.3009	16800.0
2002-06-21 08:00:00	MSFT	Stock	27.255	27.255	26.995	27.0	166800.0
2002-06-21 09:00:00	MSFT	Stock	27.005	27.135	26.63	27.085	29347200.0
2002-06-21 10:00:00	MSFT	Stock	27.089	27.275	26.755	26.915	12252000.0
2002-06-21 11:00:00	MSFT	Stock	26.915	27.065	26.5	26.77	12325200.0
2002-06-21 12:00:00	MSFT	Stock	26.775	26.7845	26.42	26.4755	9549000.0
2002-06-21 13:00:00	MSFT	Stock	26.475	26.595	26.38	26.485	8836200.0
2002-06-21 14:00:00	MSFT	Stock	26.485	26.515	26.255	26.45	8966200.0
2002-06-21 15:00:00	MSFT	Stock	26.45	26.58	26.1405	26.145	16751800.0
2002-06-21 16:00:00	MSFT	Stock	26.145	26.9775	26.125	26.16	11342600.0
2002-06-21 17:00:00	MSFT	Stock	26.16	26.2	26.14	26.155	401600.0
2002-06-21 18:00:00	MSFT	Stock	26.155	26.155	26.105	26.14	18600.0
2002-06-21 08:00:00	NVDA	Stock	0.2	0.2001	0.1969	0.1978	1236000.0
2002-06-21 09:00:00	NVDA	Stock	0.1983	0.2025	0.1958	0.2012	235476000.0
2002-06-21 10:00:00	NVDA	Stock	0.2011	0.2035	0.1974	0.1996	222108000.0
2002-06-21 11:00:00	NVDA	Stock	0.1995	0.2003	0.1942	0.1954	160704000.0
2002-06-21 12:00:00	NVDA	Stock	0.1956	0.1974	0.1901	0.193	151440000.0
2002-06-21 13:00:00	NVDA	Stock	0.1929	0.1956	0.1917	0.1931	100140000.0
2002-06-21 14:00:00	NVDA	Stock	0.193	0.1937	0.1877	0.1896	158304000.0
2002-06-21 15:00:00	NVDA	Stock	0.1896	0.1916	0.1848	0.1883	341724000.0
2002-06-21 16:00:00	NVDA	Stock	0.1883	0.19	0.1867	0.1873	62856000.0
2002-06-21 17:00:00	NVDA	Stock	0.1875	0.1888	0.1871	0.1883	3204000.0
2002-06-21 18:00:00	NVDA	Stock	0.1879	0.1888	0.1875	0.1888	408000.0
2002-06-21 08:00:00	AMZN	Stock	0.8785	0.885	0.8785	0.8845	36000.0
2002-06-21 09:00:00	AMZN	Stock	0.878	0.888	0.867	0.878	16198000.0
2002-06-21 10:00:00	AMZN	Stock	0.8785	0.8875	0.875	0.8835	20946000.0
2002-06-21 11:00:00	AMZN	Stock	0.8835	0.8895	0.8795	0.886	9690000.0
2002-06-21 12:00:00	AMZN	Stock	0.8855	0.887	0.877	0.88	8652000.0
2002-06-21 13:00:00	AMZN	Stock	0.8795	0.8835	0.874	0.877	12310000.0
2002-06-21 14:00:00	AMZN	Stock	0.877	0.88	0.871	0.875	8812000.0
2002-06-21 15:00:00	AMZN	Stock	0.875	0.88	0.872	0.877	17092000.0
2002-06-21 16:00:00	AMZN	Stock	0.877	0.8775	0.87	0.876	3240000.0
2002-06-21 17:00:00	AMZN	Stock	0.8765	0.877	0.8765	0.877	66000.0
2002-06-21 18:00:00	AMZN	Stock	0.875	0.8765	0.875	0.8765	22000.0
2002-06-21 09:00:00	CL	Stock	25.625	25.85	25.625	25.74	1295400.0
2002-06-21 10:00:00	CL	Stock	25.74	25.74	25.55	25.625	448600.0
2002-06-21 11:00:00	CL	Stock	25.625	25.63	25.325	25.395	525600.0
2002-06-21 12:00:00	CL	Stock	25.395	25.395	25.17	25.17	467600.0
2002-06-21 13:00:00	CL	Stock	25.16	25.19	24.95	25.14	898600.0
2002-06-21 14:00:00	CL	Stock	25.14	25.225	25.08	25.21	605400.0

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

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