PREVIEW / stock_1hour / 2000-03-23

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-03-23.parquet
  size:    287 KB
  rows:    14,462
  symbols: 1,148

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-03-23 09:00:00	AAPL	Stock	1.2679	1.308	1.2623	1.2952	70291200.0
2000-03-23 10:00:00	AAPL	Stock	1.2946	1.3047	1.2801	1.2801	90630400.0
2000-03-23 11:00:00	AAPL	Stock	1.2813	1.2969	1.2684	1.2941	60928000.0
2000-03-23 12:00:00	AAPL	Stock	1.2941	1.2941	1.2801	1.2863	56392000.0
2000-03-23 13:00:00	AAPL	Stock	1.2874	1.317	1.2868	1.317	39659200.0
2000-03-23 14:00:00	AAPL	Stock	1.3158	1.3426	1.3125	1.3281	88334400.0
2000-03-23 15:00:00	AAPL	Stock	1.3287	1.3348	1.25	1.2612	116782400.0
2000-03-23 16:00:00	AAPL	Stock	1.2589	1.2617	1.2589	1.2617	470400.0
2000-03-23 09:00:00	MSFT	Stock	53.4062	55.375	53.3125	55.0625	32222600.0
2000-03-23 10:00:00	MSFT	Stock	55.0625	55.3125	54.125	54.8438	22295600.0
2000-03-23 11:00:00	MSFT	Stock	54.8438	55.1875	54.625	55.1875	15945000.0
2000-03-23 12:00:00	MSFT	Stock	55.1719	55.4688	54.9688	55.1875	13260800.0
2000-03-23 13:00:00	MSFT	Stock	55.1875	55.7969	55.1562	55.7188	13339200.0
2000-03-23 14:00:00	MSFT	Stock	55.7188	56.125	55.375	55.75	16816800.0
2000-03-23 15:00:00	MSFT	Stock	55.75	56.4375	55.625	55.9062	23487000.0
2000-03-23 16:00:00	MSFT	Stock	55.9375	56.0312	55.9062	55.9375	126400.0
2000-03-23 09:00:00	NVDA	Stock	0.1973	0.2135	0.1969	0.2104	99600000.0
2000-03-23 10:00:00	NVDA	Stock	0.2125	0.2125	0.2061	0.2102	57936000.0
2000-03-23 11:00:00	NVDA	Stock	0.2102	0.2103	0.2053	0.2055	18000000.0
2000-03-23 12:00:00	NVDA	Stock	0.2055	0.2104	0.2055	0.2094	20400000.0
2000-03-23 13:00:00	NVDA	Stock	0.2102	0.2125	0.2081	0.2115	34320000.0
2000-03-23 14:00:00	NVDA	Stock	0.2112	0.212	0.2052	0.2073	22128000.0
2000-03-23 15:00:00	NVDA	Stock	0.2065	0.2083	0.1984	0.2029	33696000.0
2000-03-23 16:00:00	NVDA	Stock	0.2049	0.2049	0.2026	0.2026	1056000.0
2000-03-23 09:00:00	AMZN	Stock	3.475	3.5312	3.4688	3.5062	7258000.0
2000-03-23 10:00:00	AMZN	Stock	3.5062	3.5281	3.475	3.5	19806000.0
2000-03-23 11:00:00	AMZN	Stock	3.5	3.525	3.4938	3.5	10188000.0
2000-03-23 12:00:00	AMZN	Stock	3.5	3.5312	3.4938	3.5094	5770000.0
2000-03-23 13:00:00	AMZN	Stock	3.5125	3.5438	3.4875	3.5156	9636000.0
2000-03-23 14:00:00	AMZN	Stock	3.5125	3.5156	3.475	3.4938	8772000.0
2000-03-23 15:00:00	AMZN	Stock	3.4875	3.4938	3.375	3.3875	27788000.0
2000-03-23 16:00:00	AMZN	Stock	3.3859	3.3906	3.3844	3.3844	246000.0
2000-03-23 09:00:00	CL	Stock	25.0938	25.3125	25.0	25.3125	651800.0
2000-03-23 10:00:00	CL	Stock	25.25	25.5938	25.0625	25.5938	735000.0
2000-03-23 11:00:00	CL	Stock	25.5938	26.0	25.5938	25.9688	1101800.0
2000-03-23 12:00:00	CL	Stock	26.0	26.5	25.875	26.4375	996800.0
2000-03-23 13:00:00	CL	Stock	26.4375	26.75	26.4062	26.6562	839000.0
2000-03-23 14:00:00	CL	Stock	26.625	27.0	26.5	26.75	563800.0
2000-03-23 15:00:00	CL	Stock	26.75	26.7812	26.375	26.5312	851200.0
2000-03-23 16:00:00	CL	Stock	26.5312	26.5625	26.5312	26.5625	74800.0
2000-03-23 17:00:00	CL	Stock	26.5625	26.5625	26.5625	26.5625	200.0

> showing 41 of 14,462 rows — these rows as CSV

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