PREVIEW / stock_1hour / 2001-03-23

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-03-23.parquet
  size:    353 KB
  rows:    16,460
  symbols: 1,283

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-03-23 08:00:00	AAPL	Stock	0.3951	0.4018	0.3862	0.3962	3813600.0
2001-03-23 09:00:00	AAPL	Stock	0.4007	0.4063	0.3929	0.3996	150007200.0
2001-03-23 10:00:00	AAPL	Stock	0.3984	0.4107	0.3973	0.4085	150763200.0
2001-03-23 11:00:00	AAPL	Stock	0.4085	0.4118	0.4029	0.404	107654400.0
2001-03-23 12:00:00	AAPL	Stock	0.404	0.4051	0.394	0.3996	87192000.0
2001-03-23 13:00:00	AAPL	Stock	0.3984	0.4063	0.3973	0.3996	45102400.0
2001-03-23 14:00:00	AAPL	Stock	0.4007	0.4196	0.3996	0.4141	120892800.0
2001-03-23 15:00:00	AAPL	Stock	0.4152	0.4208	0.4074	0.4096	213740800.0
2001-03-23 16:00:00	AAPL	Stock	0.4096	0.4107	0.4063	0.4085	18228000.0
2001-03-23 17:00:00	AAPL	Stock	0.4096	0.4096	0.4096	0.4096	78400.0
2001-03-23 18:00:00	AAPL	Stock	0.4074	0.4074	0.4074	0.4074	56000.0
2001-03-23 08:00:00	MSFT	Stock	27.2812	27.4375	26.9531	27.375	338000.0
2001-03-23 09:00:00	MSFT	Stock	27.4375	27.75	26.9688	27.3125	16880800.0
2001-03-23 10:00:00	MSFT	Stock	27.2969	27.9375	27.2812	27.9062	16847000.0
2001-03-23 11:00:00	MSFT	Stock	27.9062	28.1562	27.6562	27.8125	12431400.0
2001-03-23 12:00:00	MSFT	Stock	27.7812	27.8125	27.25	27.5312	10757600.0
2001-03-23 13:00:00	MSFT	Stock	27.5	27.9375	27.5	27.6562	6623600.0
2001-03-23 14:00:00	MSFT	Stock	27.6562	28.375	27.6562	28.25	11907200.0
2001-03-23 15:00:00	MSFT	Stock	28.25	28.5	28.0625	28.2812	18369000.0
2001-03-23 16:00:00	MSFT	Stock	28.2812	28.5	27.8438	28.2812	2444400.0
2001-03-23 17:00:00	MSFT	Stock	28.2969	28.3125	28.25	28.25	9000.0
2001-03-23 18:00:00	MSFT	Stock	28.25	28.2812	28.25	28.25	1000.0
2001-03-23 08:00:00	NVDA	Stock	0.2848	0.2911	0.2836	0.2875	1536000.0
2001-03-23 09:00:00	NVDA	Stock	0.2875	0.2922	0.2813	0.2828	270192000.0
2001-03-23 10:00:00	NVDA	Stock	0.2826	0.2867	0.2792	0.2826	203544000.0
2001-03-23 11:00:00	NVDA	Stock	0.2826	0.2862	0.2714	0.2725	180264000.0
2001-03-23 12:00:00	NVDA	Stock	0.2725	0.2734	0.2651	0.2724	171360000.0
2001-03-23 13:00:00	NVDA	Stock	0.2721	0.2766	0.2711	0.2755	86472000.0
2001-03-23 14:00:00	NVDA	Stock	0.275	0.2875	0.274	0.2857	190968000.0
2001-03-23 15:00:00	NVDA	Stock	0.2854	0.2859	0.2771	0.2786	334848000.0
2001-03-23 16:00:00	NVDA	Stock	0.2789	0.2802	0.2773	0.2792	10080000.0
2001-03-23 17:00:00	NVDA	Stock	0.2792	0.2792	0.2792	0.2792	72000.0
2001-03-23 08:00:00	AMZN	Stock	0.525	0.525	0.5156	0.525	136000.0
2001-03-23 09:00:00	AMZN	Stock	0.5188	0.5375	0.4969	0.5062	14710000.0
2001-03-23 10:00:00	AMZN	Stock	0.5062	0.5406	0.5062	0.5281	18122000.0
2001-03-23 11:00:00	AMZN	Stock	0.5281	0.5375	0.5125	0.5156	8446000.0
2001-03-23 12:00:00	AMZN	Stock	0.5188	0.5188	0.5031	0.5062	9688000.0
2001-03-23 13:00:00	AMZN	Stock	0.5062	0.5156	0.5062	0.5062	2890000.0
2001-03-23 14:00:00	AMZN	Stock	0.5062	0.5156	0.5062	0.5125	6078000.0
2001-03-23 15:00:00	AMZN	Stock	0.5125	0.5156	0.5094	0.5094	7220000.0
2001-03-23 16:00:00	AMZN	Stock	0.5094	0.5156	0.5062	0.5094	5004000.0
2001-03-23 18:00:00	AMZN	Stock	0.5125	0.5125	0.5125	0.5125	4000.0
2001-03-23 09:00:00	CL	Stock	25.375	25.375	25.15	25.155	587400.0
2001-03-23 10:00:00	CL	Stock	25.15	25.85	25.15	25.755	1710000.0
2001-03-23 11:00:00	CL	Stock	25.755	25.79	25.7	25.74	794800.0
2001-03-23 12:00:00	CL	Stock	25.725	25.82	25.655	25.74	560600.0
2001-03-23 13:00:00	CL	Stock	25.745	25.9	25.74	25.745	493600.0
2001-03-23 14:00:00	CL	Stock	25.725	25.8	25.62	25.765	612200.0
2001-03-23 15:00:00	CL	Stock	25.755	25.87	25.75	25.775	819400.0
2001-03-23 16:00:00	CL	Stock	25.775	25.775	25.75	25.75	135000.0

> showing 50 of 16,460 rows — these rows as CSV

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