PREVIEW / stock_1hour / 2001-09-21

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-09-21.parquet
  size:    380 KB
  rows:    18,639
  symbols: 1,356

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-21 08:00:00	AAPL	Stock	0.2768	0.2768	0.2607	0.2732	957600.0
2001-09-21 09:00:00	AAPL	Stock	0.2732	0.3232	0.2621	0.2759	103583200.0
2001-09-21 10:00:00	AAPL	Stock	0.2759	0.2902	0.2723	0.2757	104344800.0
2001-09-21 11:00:00	AAPL	Stock	0.2754	0.2784	0.2705	0.2729	52130400.0
2001-09-21 12:00:00	AAPL	Stock	0.2729	0.2777	0.2691	0.2745	42554400.0
2001-09-21 13:00:00	AAPL	Stock	0.2745	0.2786	0.2723	0.2755	24281600.0
2001-09-21 14:00:00	AAPL	Stock	0.2755	0.2857	0.275	0.2836	51318400.0
2001-09-21 15:00:00	AAPL	Stock	0.2841	0.2854	0.2766	0.2809	67636800.0
2001-09-21 16:00:00	AAPL	Stock	0.2809	0.2821	0.2753	0.2809	16755200.0
2001-09-21 17:00:00	AAPL	Stock	0.2809	0.2809	0.2809	0.2809	50400.0
2001-09-21 08:00:00	MSFT	Stock	24.3	25.355	24.05	24.26	289000.0
2001-09-21 09:00:00	MSFT	Stock	24.325	24.65	23.225	24.07	34260000.0
2001-09-21 10:00:00	MSFT	Stock	24.07	25.3	23.95	24.7005	38155400.0
2001-09-21 11:00:00	MSFT	Stock	24.72	24.81	24.365	24.395	17892000.0
2001-09-21 12:00:00	MSFT	Stock	24.4	24.8245	24.15	24.5	14161200.0
2001-09-21 13:00:00	MSFT	Stock	24.5255	25.0295	24.4	24.4305	13874400.0
2001-09-21 14:00:00	MSFT	Stock	24.435	24.6445	24.28	24.59	13183200.0
2001-09-21 15:00:00	MSFT	Stock	24.5753	25.16	24.4	24.85	22758600.0
2001-09-21 16:00:00	MSFT	Stock	24.85	24.96	24.3	24.825	4707000.0
2001-09-21 17:00:00	MSFT	Stock	24.4335	25.37	24.4335	24.65	92200.0
2001-09-21 18:00:00	MSFT	Stock	24.625	24.745	24.625	24.63	1400.0
2001-09-21 08:00:00	NVDA	Stock	0.2351	0.2406	0.2242	0.2257	6792000.0
2001-09-21 09:00:00	NVDA	Stock	0.2258	0.2308	0.2209	0.2262	165252000.0
2001-09-21 10:00:00	NVDA	Stock	0.2262	0.2357	0.2233	0.23	237936000.0
2001-09-21 11:00:00	NVDA	Stock	0.2302	0.2326	0.2262	0.2289	65256000.0
2001-09-21 12:00:00	NVDA	Stock	0.2289	0.2296	0.2237	0.2292	97404000.0
2001-09-21 13:00:00	NVDA	Stock	0.2284	0.2317	0.2271	0.2287	79356000.0
2001-09-21 14:00:00	NVDA	Stock	0.2288	0.2308	0.2217	0.2233	172548000.0
2001-09-21 15:00:00	NVDA	Stock	0.2233	0.2271	0.2167	0.2248	252132000.0
2001-09-21 16:00:00	NVDA	Stock	0.2248	0.225	0.223	0.2242	36384000.0
2001-09-21 17:00:00	NVDA	Stock	0.2242	0.2247	0.2238	0.2244	636000.0
2001-09-21 18:00:00	NVDA	Stock	0.2244	0.2244	0.2244	0.2244	48000.0
2001-09-21 08:00:00	AMZN	Stock	0.3495	0.3665	0.349	0.35	90000.0
2001-09-21 09:00:00	AMZN	Stock	0.3525	0.3625	0.3345	0.36	36102000.0
2001-09-21 10:00:00	AMZN	Stock	0.36	0.386	0.353	0.372	40758000.0
2001-09-21 11:00:00	AMZN	Stock	0.372	0.3775	0.37	0.372	15890000.0
2001-09-21 12:00:00	AMZN	Stock	0.372	0.3745	0.37	0.371	22420000.0
2001-09-21 13:00:00	AMZN	Stock	0.371	0.38	0.37	0.374	38202000.0
2001-09-21 14:00:00	AMZN	Stock	0.374	0.376	0.3715	0.374	12426000.0
2001-09-21 15:00:00	AMZN	Stock	0.374	0.3825	0.3735	0.375	55018000.0
2001-09-21 16:00:00	AMZN	Stock	0.374	0.3855	0.371	0.374	3390000.0
2001-09-21 17:00:00	AMZN	Stock	0.38	0.38	0.374	0.374	28000.0
2001-09-21 18:00:00	AMZN	Stock	0.385	0.385	0.385	0.385	2000.0
2001-09-21 09:00:00	CL	Stock	26.45	26.625	26.1	26.1	1433400.0
2001-09-21 10:00:00	CL	Stock	26.1	26.75	26.1	26.375	1918600.0
2001-09-21 11:00:00	CL	Stock	26.375	26.5	25.765	25.9	778200.0
2001-09-21 12:00:00	CL	Stock	25.9	26.54	25.855	26.415	964000.0
2001-09-21 13:00:00	CL	Stock	26.425	26.525	26.2	26.23	471800.0
2001-09-21 14:00:00	CL	Stock	26.225	26.475	26.2	26.28	296800.0
2001-09-21 15:00:00	CL	Stock	26.28	26.415	26.1	26.315	829200.0

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

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