PREVIEW / stock_1hour / 2002-09-17

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-09-17.parquet
  size:    394 KB
  rows:    18,702
  symbols: 1,468

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-09-17 08:00:00	AAPL	Stock	0.2616	0.2646	0.2616	0.2643	224000.0
2002-09-17 09:00:00	AAPL	Stock	0.2634	0.2652	0.2602	0.2652	45842888.0
2002-09-17 10:00:00	AAPL	Stock	0.2645	0.2666	0.2621	0.2654	78854552.0
2002-09-17 11:00:00	AAPL	Stock	0.2654	0.2682	0.2646	0.267	64142512.0
2002-09-17 12:00:00	AAPL	Stock	0.267	0.2671	0.2648	0.2661	46041128.0
2002-09-17 13:00:00	AAPL	Stock	0.2661	0.2682	0.2657	0.2679	29281560.0
2002-09-17 14:00:00	AAPL	Stock	0.2679	0.2684	0.2661	0.2666	56586992.0
2002-09-17 15:00:00	AAPL	Stock	0.2664	0.2675	0.2618	0.2632	85580488.0
2002-09-17 16:00:00	AAPL	Stock	0.2636	0.2643	0.2616	0.2643	17276000.0
2002-09-17 17:00:00	AAPL	Stock	0.2643	0.2643	0.2643	0.2643	1276800.0
2002-09-17 18:00:00	AAPL	Stock	0.262	0.262	0.262	0.262	11200.0
2002-09-17 08:00:00	MSFT	Stock	24.28	24.45	24.1	24.345	304734.0
2002-09-17 09:00:00	MSFT	Stock	24.35	24.4535	24.155	24.165	12963366.0
2002-09-17 10:00:00	MSFT	Stock	24.16	24.35	23.835	23.905	16167678.0
2002-09-17 11:00:00	MSFT	Stock	23.905	24.125	23.76	24.06	8925406.0
2002-09-17 12:00:00	MSFT	Stock	24.07	24.08	23.825	23.935	5508330.0
2002-09-17 13:00:00	MSFT	Stock	23.93	23.985	23.775	23.88	5199240.0
2002-09-17 14:00:00	MSFT	Stock	23.88	23.975	23.765	23.9095	6972872.0
2002-09-17 15:00:00	MSFT	Stock	23.9	23.94	23.605	23.645	12353424.0
2002-09-17 16:00:00	MSFT	Stock	23.645	23.835	23.25	23.315	3016672.0
2002-09-17 17:00:00	MSFT	Stock	23.373	23.645	23.3	23.375	358700.0
2002-09-17 18:00:00	MSFT	Stock	23.375	23.955	23.325	23.886	16050.0
2002-09-17 08:00:00	NVDA	Stock	0.0846	0.0879	0.0828	0.0872	10322400.0
2002-09-17 09:00:00	NVDA	Stock	0.0871	0.0882	0.085	0.0854	175680960.0
2002-09-17 10:00:00	NVDA	Stock	0.0854	0.0855	0.0828	0.0837	169309800.0
2002-09-17 11:00:00	NVDA	Stock	0.0837	0.0838	0.0828	0.0834	117174240.0
2002-09-17 12:00:00	NVDA	Stock	0.0836	0.0838	0.0828	0.0833	85019760.0
2002-09-17 13:00:00	NVDA	Stock	0.0833	0.0837	0.0825	0.0829	68696280.0
2002-09-17 14:00:00	NVDA	Stock	0.0829	0.0831	0.0818	0.0825	64207800.0
2002-09-17 15:00:00	NVDA	Stock	0.0825	0.0826	0.0807	0.0812	147882120.0
2002-09-17 16:00:00	NVDA	Stock	0.0817	0.0821	0.0796	0.0804	7794840.0
2002-09-17 17:00:00	NVDA	Stock	0.0804	0.0812	0.0796	0.0812	1427760.0
2002-09-17 18:00:00	NVDA	Stock	0.0798	0.0801	0.0797	0.0801	144000.0
2002-09-17 08:00:00	AMZN	Stock	0.845	0.8505	0.845	0.85	372000.0
2002-09-17 09:00:00	AMZN	Stock	0.85	0.86	0.844	0.848	15175520.0
2002-09-17 10:00:00	AMZN	Stock	0.8485	0.851	0.8385	0.845	19184820.0
2002-09-17 11:00:00	AMZN	Stock	0.8455	0.8695	0.8425	0.8635	27211220.0
2002-09-17 12:00:00	AMZN	Stock	0.864	0.872	0.855	0.871	17750060.0
2002-09-17 13:00:00	AMZN	Stock	0.871	0.886	0.8705	0.885	29093680.0
2002-09-17 14:00:00	AMZN	Stock	0.8855	0.8875	0.8705	0.8735	26230060.0
2002-09-17 15:00:00	AMZN	Stock	0.873	0.874	0.8635	0.8675	28903820.0
2002-09-17 16:00:00	AMZN	Stock	0.8675	0.8691	0.861	0.861	2547100.0
2002-09-17 17:00:00	AMZN	Stock	0.864	0.8675	0.861	0.8675	282000.0
2002-09-17 18:00:00	AMZN	Stock	0.86	0.86	0.86	0.86	8000.0
2002-09-17 09:00:00	CL	Stock	28.125	28.3	28.1	28.3	410400.0
2002-09-17 10:00:00	CL	Stock	28.3	28.32	27.9	27.93	851000.0
2002-09-17 11:00:00	CL	Stock	27.935	28.0	27.855	28.0	565000.0
2002-09-17 12:00:00	CL	Stock	28.0	28.04	27.67	27.73	680600.0
2002-09-17 13:00:00	CL	Stock	27.71	27.785	27.53	27.66	529400.0
2002-09-17 14:00:00	CL	Stock	27.66	27.66	27.49	27.585	633000.0

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

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