PREVIEW / stock_1hour / 2004-03-24

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-03-24.parquet
  size:    498 KB
  rows:    23,289
  symbols: 1,743

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
2004-03-24 08:00:00	AAPL	Stock	0.45	0.4518	0.45	0.4518	78400.0
2004-03-24 09:00:00	AAPL	Stock	0.4521	0.4559	0.4513	0.4534	18684904.0
2004-03-24 10:00:00	AAPL	Stock	0.4533	0.4563	0.4525	0.4534	45234392.0
2004-03-24 11:00:00	AAPL	Stock	0.4534	0.4584	0.4525	0.4554	68158552.0
2004-03-24 12:00:00	AAPL	Stock	0.4554	0.4598	0.455	0.4555	42407568.0
2004-03-24 13:00:00	AAPL	Stock	0.4557	0.4564	0.4543	0.455	38679760.0
2004-03-24 14:00:00	AAPL	Stock	0.4552	0.4573	0.4545	0.455	46989880.0
2004-03-24 15:00:00	AAPL	Stock	0.455	0.458	0.4534	0.4554	41580896.0
2004-03-24 16:00:00	AAPL	Stock	0.4552	0.458	0.4546	0.4548	2232608.0
2004-03-24 17:00:00	AAPL	Stock	0.4547	0.458	0.4529	0.4543	47406072.0
2004-03-24 08:00:00	MSFT	Stock	24.33	24.37	24.11	24.3	530672.0
2004-03-24 09:00:00	MSFT	Stock	24.3	24.4	24.25	24.27	10860937.0
2004-03-24 10:00:00	MSFT	Stock	24.27	24.4691	24.24	24.31	17460833.0
2004-03-24 11:00:00	MSFT	Stock	24.31	24.41	24.18	24.34	14122976.0
2004-03-24 12:00:00	MSFT	Stock	24.34	24.58	24.32	24.51	9917700.0
2004-03-24 13:00:00	MSFT	Stock	24.5	24.5449	24.4	24.52	5604580.0
2004-03-24 14:00:00	MSFT	Stock	24.52	24.58	24.35	24.39	10055710.0
2004-03-24 15:00:00	MSFT	Stock	24.38	24.53	24.28	24.42	15782038.0
2004-03-24 16:00:00	MSFT	Stock	24.4	24.53	24.36	24.46	1344363.0
2004-03-24 17:00:00	MSFT	Stock	24.46	24.53	24.44	24.47	122826.0
2004-03-24 18:00:00	MSFT	Stock	24.45	24.46	24.45	24.45	2680.0
2004-03-24 08:00:00	NVDA	Stock	0.1837	0.1839	0.1837	0.1839	180000.0
2004-03-24 09:00:00	NVDA	Stock	0.184	0.1854	0.1833	0.1847	22255920.0
2004-03-24 10:00:00	NVDA	Stock	0.1847	0.186	0.1833	0.1849	67127280.0
2004-03-24 11:00:00	NVDA	Stock	0.1849	0.1879	0.1837	0.1879	108737760.0
2004-03-24 12:00:00	NVDA	Stock	0.1878	0.1922	0.1876	0.1912	145301280.0
2004-03-24 13:00:00	NVDA	Stock	0.1912	0.1954	0.1907	0.1942	144348840.0
2004-03-24 14:00:00	NVDA	Stock	0.1942	0.1948	0.192	0.1923	89031240.0
2004-03-24 15:00:00	NVDA	Stock	0.1923	0.1933	0.1912	0.1922	117652320.0
2004-03-24 16:00:00	NVDA	Stock	0.1922	0.1933	0.1917	0.1923	2484240.0
2004-03-24 17:00:00	NVDA	Stock	0.1923	0.1923	0.1917	0.1919	132000.0
2004-03-24 08:00:00	AMZN	Stock	2.015	2.02	2.012	2.02	108000.0
2004-03-24 09:00:00	AMZN	Stock	2.02	2.024	1.9785	1.9835	21896400.0
2004-03-24 10:00:00	AMZN	Stock	1.9835	1.9925	1.966	1.983	30910580.0
2004-03-24 11:00:00	AMZN	Stock	1.9825	1.9825	1.9575	1.982	25371260.0
2004-03-24 12:00:00	AMZN	Stock	1.9815	1.994	1.9785	1.9845	14022580.0
2004-03-24 13:00:00	AMZN	Stock	1.9845	2.005	1.9765	1.9945	16223560.0
2004-03-24 14:00:00	AMZN	Stock	1.995	2.003	1.985	1.988	15840900.0
2004-03-24 15:00:00	AMZN	Stock	1.9875	1.991	1.972	1.9825	18515560.0
2004-03-24 16:00:00	AMZN	Stock	1.9815	1.986	1.979	1.9795	678180.0
2004-03-24 17:00:00	AMZN	Stock	1.9875	1.9875	1.9875	1.9875	2000.0
2004-03-24 18:00:00	AMZN	Stock	1.9875	1.9875	1.9875	1.9875	4000.0
2004-03-24 09:00:00	CL	Stock	26.425	26.565	26.405	26.54	241000.0
2004-03-24 10:00:00	CL	Stock	26.545	26.605	26.425	26.455	1069400.0
2004-03-24 11:00:00	CL	Stock	26.455	26.525	26.395	26.5	590400.0
2004-03-24 12:00:00	CL	Stock	26.5	26.55	26.495	26.495	592600.0
2004-03-24 13:00:00	CL	Stock	26.495	26.57	26.475	26.555	317800.0
2004-03-24 14:00:00	CL	Stock	26.555	26.63	26.46	26.475	528200.0
2004-03-24 15:00:00	CL	Stock	26.47	26.55	26.325	26.425	699800.0
2004-03-24 16:00:00	CL	Stock	26.4	26.4995	26.4	26.4	65800.0

> showing 50 of 23,289 rows — these rows as CSV

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