PREVIEW / stock_1hour / 2000-07-26

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-26.parquet
  size:    307 KB
  rows:    15,837
  symbols: 1,197

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
2000-07-26 08:00:00	AAPL	Stock	0.8934	0.894	0.8839	0.8839	806400.0
2000-07-26 09:00:00	AAPL	Stock	0.8917	0.8996	0.8839	0.8929	13865600.0
2000-07-26 10:00:00	AAPL	Stock	0.8929	0.9107	0.8884	0.8895	36103200.0
2000-07-26 11:00:00	AAPL	Stock	0.8895	0.9029	0.8817	0.9007	24920000.0
2000-07-26 12:00:00	AAPL	Stock	0.9007	0.9063	0.8984	0.9029	19992000.0
2000-07-26 13:00:00	AAPL	Stock	0.9018	0.9074	0.8962	0.8962	29775200.0
2000-07-26 14:00:00	AAPL	Stock	0.8973	0.9152	0.8973	0.9074	31354400.0
2000-07-26 15:00:00	AAPL	Stock	0.9063	0.9118	0.8929	0.8929	29808800.0
2000-07-26 16:00:00	AAPL	Stock	0.8929	0.9085	0.8929	0.9085	13496000.0
2000-07-26 17:00:00	AAPL	Stock	0.9085	0.9107	0.894	0.894	4636800.0
2000-07-26 18:00:00	AAPL	Stock	0.8929	0.894	0.8929	0.894	1204000.0
2000-07-26 08:00:00	MSFT	Stock	34.75	34.75	34.4844	34.5	58200.0
2000-07-26 09:00:00	MSFT	Stock	34.5312	34.75	34.25	34.4062	9137600.0
2000-07-26 10:00:00	MSFT	Stock	34.3906	34.4062	33.9375	34.0625	17416400.0
2000-07-26 11:00:00	MSFT	Stock	34.0312	34.1875	33.8438	34.0312	9246400.0
2000-07-26 12:00:00	MSFT	Stock	34.0312	34.0625	33.6562	33.75	8813600.0
2000-07-26 13:00:00	MSFT	Stock	33.75	33.8438	33.625	33.8438	7741200.0
2000-07-26 14:00:00	MSFT	Stock	33.8438	34.0625	33.6406	33.875	8254800.0
2000-07-26 15:00:00	MSFT	Stock	33.8438	34.125	33.8125	33.9062	14547600.0
2000-07-26 16:00:00	MSFT	Stock	33.875	34.125	33.7969	34.0625	5796800.0
2000-07-26 17:00:00	MSFT	Stock	33.9219	34.125	33.9062	34.0625	2921400.0
2000-07-26 18:00:00	MSFT	Stock	34.0938	34.125	33.9062	34.0938	682200.0
2000-07-26 08:00:00	NVDA	Stock	0.25	0.25	0.25	0.25	48000.0
2000-07-26 09:00:00	NVDA	Stock	0.256	0.256	0.2461	0.2474	25152000.0
2000-07-26 10:00:00	NVDA	Stock	0.2471	0.2474	0.2375	0.2393	56688000.0
2000-07-26 11:00:00	NVDA	Stock	0.2393	0.2393	0.2297	0.2333	85368000.0
2000-07-26 12:00:00	NVDA	Stock	0.2336	0.2344	0.2307	0.2323	46248000.0
2000-07-26 13:00:00	NVDA	Stock	0.2328	0.238	0.2315	0.2352	45408000.0
2000-07-26 14:00:00	NVDA	Stock	0.2375	0.2448	0.2357	0.2417	52776000.0
2000-07-26 15:00:00	NVDA	Stock	0.2417	0.2417	0.2354	0.2365	59976000.0
2000-07-26 16:00:00	NVDA	Stock	0.2365	0.2367	0.2359	0.2365	2496000.0
2000-07-26 17:00:00	NVDA	Stock	0.2375	0.2375	0.2375	0.2375	96000.0
2000-07-26 18:00:00	NVDA	Stock	0.2374	0.2375	0.2374	0.2375	72000.0
2000-07-26 08:00:00	AMZN	Stock	1.75	1.7938	1.7	1.75	2962000.0
2000-07-26 09:00:00	AMZN	Stock	1.7625	1.8844	1.7	1.775	48336000.0
2000-07-26 10:00:00	AMZN	Stock	1.7781	1.7969	1.7406	1.75	37914000.0
2000-07-26 11:00:00	AMZN	Stock	1.75	1.7531	1.7344	1.7438	33266000.0
2000-07-26 12:00:00	AMZN	Stock	1.7469	1.75	1.725	1.7312	20506000.0
2000-07-26 13:00:00	AMZN	Stock	1.7281	1.7312	1.7031	1.7219	37102000.0
2000-07-26 14:00:00	AMZN	Stock	1.7219	1.7391	1.7156	1.7344	31166000.0
2000-07-26 15:00:00	AMZN	Stock	1.7375	1.8359	1.7344	1.8	61508000.0
2000-07-26 16:00:00	AMZN	Stock	1.8016	1.8188	1.5906	1.6312	26302000.0
2000-07-26 17:00:00	AMZN	Stock	1.6297	1.8047	1.6297	1.6812	6520000.0
2000-07-26 18:00:00	AMZN	Stock	1.6812	1.6969	1.6766	1.6938	598000.0
2000-07-26 09:00:00	CL	Stock	28.2812	28.3125	28.125	28.25	190600.0
2000-07-26 10:00:00	CL	Stock	28.25	28.3125	28.125	28.1875	524800.0
2000-07-26 11:00:00	CL	Stock	28.1875	28.25	27.9688	28.0312	254000.0
2000-07-26 12:00:00	CL	Stock	28.0625	28.0938	27.9375	27.9375	157600.0
2000-07-26 13:00:00	CL	Stock	27.875	27.9062	27.5625	27.875	358800.0
2000-07-26 14:00:00	CL	Stock	27.875	28.1875	27.8125	28.1562	371600.0

> showing 50 of 15,837 rows — these rows as CSV

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