PREVIEW / stock_1hour / 2000-06-14

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-06-14.parquet
  size:    292 KB
  rows:    14,960
  symbols: 1,172

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-06-14 08:00:00	AAPL	Stock	0.8443	0.8471	0.8393	0.8471	123200.0
2000-06-14 09:00:00	AAPL	Stock	0.8471	0.8594	0.8259	0.8259	45830400.0
2000-06-14 10:00:00	AAPL	Stock	0.827	0.8326	0.8192	0.8309	50120000.0
2000-06-14 11:00:00	AAPL	Stock	0.8309	0.8348	0.8265	0.8292	31516800.0
2000-06-14 12:00:00	AAPL	Stock	0.8292	0.8354	0.8265	0.8348	18088000.0
2000-06-14 13:00:00	AAPL	Stock	0.8354	0.8354	0.8203	0.8231	25659200.0
2000-06-14 14:00:00	AAPL	Stock	0.8237	0.8281	0.808	0.8136	42324800.0
2000-06-14 15:00:00	AAPL	Stock	0.8136	0.8186	0.8047	0.8075	56369600.0
2000-06-14 16:00:00	AAPL	Stock	0.8075	0.8125	0.8058	0.8086	4457600.0
2000-06-14 17:00:00	AAPL	Stock	0.8103	0.8103	0.8103	0.8103	22400.0
2000-06-14 08:00:00	MSFT	Stock	35.125	35.4688	33.875	34.7188	1082600.0
2000-06-14 09:00:00	MSFT	Stock	34.6875	35.2188	34.5	34.875	20265400.0
2000-06-14 10:00:00	MSFT	Stock	34.9062	35.4375	34.8438	35.4062	16156400.0
2000-06-14 11:00:00	MSFT	Stock	35.4062	35.5	35.125	35.1562	9980600.0
2000-06-14 12:00:00	MSFT	Stock	35.1875	35.3125	34.875	35.1875	6456800.0
2000-06-14 13:00:00	MSFT	Stock	35.1875	35.3438	35.0312	35.125	4134400.0
2000-06-14 14:00:00	MSFT	Stock	35.0938	35.4375	35.0938	35.3125	7513600.0
2000-06-14 15:00:00	MSFT	Stock	35.2812	35.5	35.125	35.25	12437800.0
2000-06-14 16:00:00	MSFT	Stock	35.25	35.3125	35.0625	35.25	1235400.0
2000-06-14 17:00:00	MSFT	Stock	35.1875	35.25	35.125	35.125	12200.0
2000-06-14 18:00:00	MSFT	Stock	35.125	35.125	35.0625	35.0625	3200.0
2000-06-14 08:00:00	NVDA	Stock	0.2667	0.2667	0.2645	0.2645	384000.0
2000-06-14 09:00:00	NVDA	Stock	0.2656	0.2708	0.2615	0.2617	65472000.0
2000-06-14 10:00:00	NVDA	Stock	0.2618	0.2698	0.2607	0.2685	39600000.0
2000-06-14 11:00:00	NVDA	Stock	0.2682	0.2698	0.2643	0.2659	23232000.0
2000-06-14 12:00:00	NVDA	Stock	0.266	0.2667	0.2641	0.2667	12000000.0
2000-06-14 13:00:00	NVDA	Stock	0.2661	0.2677	0.2654	0.2664	15648000.0
2000-06-14 14:00:00	NVDA	Stock	0.2664	0.2695	0.2664	0.2677	17136000.0
2000-06-14 15:00:00	NVDA	Stock	0.2672	0.2689	0.2635	0.2648	85488000.0
2000-06-14 16:00:00	NVDA	Stock	0.2643	0.2656	0.263	0.2656	3456000.0
2000-06-14 08:00:00	AMZN	Stock	2.4812	2.5	2.4563	2.4625	78000.0
2000-06-14 09:00:00	AMZN	Stock	2.4625	2.475	2.375	2.3875	11388000.0
2000-06-14 10:00:00	AMZN	Stock	2.3875	2.4375	2.3562	2.4313	12754000.0
2000-06-14 11:00:00	AMZN	Stock	2.4313	2.4938	2.4125	2.425	14272000.0
2000-06-14 12:00:00	AMZN	Stock	2.4281	2.45	2.4094	2.4125	7632000.0
2000-06-14 13:00:00	AMZN	Stock	2.4156	2.4188	2.3688	2.375	7680000.0
2000-06-14 14:00:00	AMZN	Stock	2.3719	2.3906	2.3156	2.3344	19896000.0
2000-06-14 15:00:00	AMZN	Stock	2.3344	2.3531	2.3	2.325	24332000.0
2000-06-14 16:00:00	AMZN	Stock	2.325	2.3812	2.3219	2.3313	1486000.0
2000-06-14 17:00:00	AMZN	Stock	2.3219	2.35	2.3219	2.35	18000.0
2000-06-14 18:00:00	AMZN	Stock	2.3469	2.3469	2.3469	2.3469	2000.0
2000-06-14 09:00:00	CL	Stock	27.7812	27.9062	27.7188	27.8438	245800.0
2000-06-14 10:00:00	CL	Stock	27.8438	28.4062	27.8438	28.375	509600.0
2000-06-14 11:00:00	CL	Stock	28.3125	28.4688	28.1562	28.4062	384200.0
2000-06-14 12:00:00	CL	Stock	28.3438	28.4375	28.2188	28.4062	176200.0
2000-06-14 13:00:00	CL	Stock	28.4062	28.5312	28.4062	28.5312	280400.0
2000-06-14 14:00:00	CL	Stock	28.5312	28.5625	28.4062	28.4375	238800.0
2000-06-14 15:00:00	CL	Stock	28.4062	28.8125	28.375	28.5938	590400.0
2000-06-14 16:00:00	CL	Stock	28.5625	28.6875	28.5625	28.5625	72600.0
2000-06-14 17:00:00	CL	Stock	28.5625	28.5625	28.5625	28.5625	1120400.0

> showing 50 of 14,960 rows — these rows as CSV

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