PREVIEW / stock_1hour / 2000-07-31

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-31.parquet
  size:    302 KB
  rows:    15,746
  symbols: 1,200

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-31 08:00:00	AAPL	Stock	0.8705	0.8705	0.8705	0.8705	5600.0
2000-07-31 09:00:00	AAPL	Stock	0.875	0.8917	0.8705	0.8884	22624000.0
2000-07-31 10:00:00	AAPL	Stock	0.8895	0.9107	0.8717	0.9096	34109600.0
2000-07-31 11:00:00	AAPL	Stock	0.9085	0.9163	0.8906	0.9018	16766400.0
2000-07-31 12:00:00	AAPL	Stock	0.8996	0.9096	0.8962	0.9063	12152000.0
2000-07-31 13:00:00	AAPL	Stock	0.9063	0.9152	0.894	0.8984	9968000.0
2000-07-31 14:00:00	AAPL	Stock	0.9007	0.9163	0.8951	0.9074	17841600.0
2000-07-31 15:00:00	AAPL	Stock	0.9085	0.9219	0.8973	0.9063	26790400.0
2000-07-31 16:00:00	AAPL	Stock	0.9057	0.9191	0.8817	0.9074	9301600.0
2000-07-31 17:00:00	AAPL	Stock	0.9063	0.9074	0.8973	0.8973	1388800.0
2000-07-31 08:00:00	MSFT	Stock	34.8438	35.25	34.8438	35.1875	27800.0
2000-07-31 09:00:00	MSFT	Stock	35.2188	35.3125	34.875	34.9688	6613400.0
2000-07-31 10:00:00	MSFT	Stock	35.0	35.5625	34.625	35.5312	11687800.0
2000-07-31 11:00:00	MSFT	Stock	35.5312	35.5625	35.1875	35.4062	6238200.0
2000-07-31 12:00:00	MSFT	Stock	35.4375	35.4375	35.25	35.2812	4329800.0
2000-07-31 13:00:00	MSFT	Stock	35.2812	35.4375	34.9375	35.0938	7485600.0
2000-07-31 14:00:00	MSFT	Stock	35.0938	35.125	35.0	35.0312	10823000.0
2000-07-31 15:00:00	MSFT	Stock	35.0625	35.1562	34.875	34.9062	17290000.0
2000-07-31 16:00:00	MSFT	Stock	34.9062	35.3438	34.8906	34.9062	4043200.0
2000-07-31 17:00:00	MSFT	Stock	34.9062	35.0625	34.875	35.0625	314400.0
2000-07-31 18:00:00	MSFT	Stock	34.9062	34.9844	34.9062	34.9844	600.0
2000-07-31 08:00:00	NVDA	Stock	0.2292	0.2292	0.2286	0.2286	96000.0
2000-07-31 09:00:00	NVDA	Stock	0.2292	0.2411	0.2276	0.2315	75144000.0
2000-07-31 10:00:00	NVDA	Stock	0.232	0.237	0.225	0.2354	73296000.0
2000-07-31 11:00:00	NVDA	Stock	0.2357	0.2458	0.234	0.2401	37344000.0
2000-07-31 12:00:00	NVDA	Stock	0.2404	0.2422	0.2391	0.2417	46104000.0
2000-07-31 13:00:00	NVDA	Stock	0.2417	0.2443	0.2411	0.2419	26232000.0
2000-07-31 14:00:00	NVDA	Stock	0.2419	0.2479	0.2419	0.2453	21192000.0
2000-07-31 15:00:00	NVDA	Stock	0.2464	0.2505	0.2453	0.25	73632000.0
2000-07-31 16:00:00	NVDA	Stock	0.25	0.2505	0.249	0.2505	4560000.0
2000-07-31 17:00:00	NVDA	Stock	0.2542	0.2542	0.2542	0.2542	24000.0
2000-07-31 08:00:00	AMZN	Stock	1.5125	1.5375	1.5125	1.5188	104000.0
2000-07-31 09:00:00	AMZN	Stock	1.5188	1.5188	1.4344	1.4344	27178000.0
2000-07-31 10:00:00	AMZN	Stock	1.4344	1.4719	1.3938	1.4688	36056000.0
2000-07-31 11:00:00	AMZN	Stock	1.4672	1.5031	1.4594	1.4875	18522000.0
2000-07-31 12:00:00	AMZN	Stock	1.4875	1.4906	1.4688	1.4766	19964000.0
2000-07-31 13:00:00	AMZN	Stock	1.475	1.5062	1.475	1.4813	21788000.0
2000-07-31 14:00:00	AMZN	Stock	1.4813	1.4875	1.4688	1.475	20530000.0
2000-07-31 15:00:00	AMZN	Stock	1.4781	1.5125	1.4594	1.5094	34566000.0
2000-07-31 16:00:00	AMZN	Stock	1.5062	1.5188	1.5	1.5094	4574000.0
2000-07-31 17:00:00	AMZN	Stock	1.5188	1.5188	1.5125	1.5188	40000.0
2000-07-31 18:00:00	AMZN	Stock	1.5188	1.5188	1.5062	1.5062	6000.0
2000-07-31 09:00:00	CL	Stock	28.0	28.3125	28.0	28.0938	206400.0
2000-07-31 10:00:00	CL	Stock	28.0625	28.8125	28.0625	28.5312	529000.0
2000-07-31 11:00:00	CL	Stock	28.5312	28.5312	28.4062	28.4375	172200.0
2000-07-31 12:00:00	CL	Stock	28.375	28.4375	28.2812	28.2812	138400.0
2000-07-31 13:00:00	CL	Stock	28.2812	28.3125	28.1875	28.25	242400.0
2000-07-31 14:00:00	CL	Stock	28.2812	28.3438	28.125	28.1562	227400.0
2000-07-31 15:00:00	CL	Stock	28.1562	28.1562	27.8438	27.8438	467400.0
2000-07-31 16:00:00	CL	Stock	27.875	27.875	27.8438	27.8438	178000.0

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

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