PREVIEW / stock_1hour / 2004-06-24

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-06-24.parquet
  size:    515 KB
  rows:    24,195
  symbols: 1,792

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-06-24 08:00:00	AAPL	Stock	0.5988	0.602	0.5988	0.5996	198576.0
2004-06-24 09:00:00	AAPL	Stock	0.5996	0.6018	0.5957	0.5998	34759704.0
2004-06-24 10:00:00	AAPL	Stock	0.5998	0.6014	0.5948	0.5957	39697672.0
2004-06-24 11:00:00	AAPL	Stock	0.5959	0.5973	0.5952	0.5968	33848248.0
2004-06-24 12:00:00	AAPL	Stock	0.5968	0.5995	0.5959	0.5988	13186376.0
2004-06-24 13:00:00	AAPL	Stock	0.5984	0.5988	0.5945	0.5955	16339512.0
2004-06-24 14:00:00	AAPL	Stock	0.5955	0.5955	0.5909	0.5913	37295832.0
2004-06-24 15:00:00	AAPL	Stock	0.5914	0.5923	0.5889	0.5902	53006576.0
2004-06-24 16:00:00	AAPL	Stock	0.5904	0.5962	0.5886	0.5886	10077704.0
2004-06-24 08:00:00	MSFT	Stock	28.5	28.75	28.31	28.53	217823.0
2004-06-24 09:00:00	MSFT	Stock	28.52	28.65	28.42	28.56	9677360.0
2004-06-24 10:00:00	MSFT	Stock	28.56	28.57	28.38	28.501	10220956.0
2004-06-24 11:00:00	MSFT	Stock	28.51	28.63	28.47	28.5	8261003.0
2004-06-24 12:00:00	MSFT	Stock	28.5	28.62	28.46	28.5	6267435.0
2004-06-24 13:00:00	MSFT	Stock	28.5	28.55	28.41	28.441	6190645.0
2004-06-24 14:00:00	MSFT	Stock	28.45	28.53	28.39	28.42	7250909.0
2004-06-24 15:00:00	MSFT	Stock	28.43	28.49	28.37	28.4	11291588.0
2004-06-24 16:00:00	MSFT	Stock	28.42	28.51	28.39	28.39	995105.0
2004-06-24 17:00:00	MSFT	Stock	28.4	28.49	28.4	28.49	19200.0
2004-06-24 18:00:00	MSFT	Stock	28.48	28.5	28.48	28.5	5100.0
2004-06-24 08:00:00	NVDA	Stock	0.1694	0.1727	0.1693	0.1712	9832200.0
2004-06-24 09:00:00	NVDA	Stock	0.1725	0.1742	0.1696	0.1727	135445800.0
2004-06-24 10:00:00	NVDA	Stock	0.1726	0.1735	0.1683	0.17	120078360.0
2004-06-24 11:00:00	NVDA	Stock	0.17	0.1708	0.1692	0.1702	44472840.0
2004-06-24 12:00:00	NVDA	Stock	0.1702	0.1724	0.1702	0.1707	47193240.0
2004-06-24 13:00:00	NVDA	Stock	0.1707	0.1707	0.1686	0.1688	39643560.0
2004-06-24 14:00:00	NVDA	Stock	0.1688	0.1695	0.1664	0.1675	88331280.0
2004-06-24 15:00:00	NVDA	Stock	0.1675	0.1688	0.1672	0.1676	73282200.0
2004-06-24 16:00:00	NVDA	Stock	0.1676	0.1679	0.1676	0.1677	3100560.0
2004-06-24 17:00:00	NVDA	Stock	0.1679	0.1679	0.1679	0.1679	12000.0
2004-06-24 18:00:00	NVDA	Stock	0.1679	0.1679	0.1679	0.1679	120000.0
2004-06-24 08:00:00	AMZN	Stock	2.5425	2.544	2.54	2.54	70000.0
2004-06-24 09:00:00	AMZN	Stock	2.54	2.59	2.537	2.58	24978460.0
2004-06-24 10:00:00	AMZN	Stock	2.5786	2.597	2.556	2.557	27576900.0
2004-06-24 11:00:00	AMZN	Stock	2.5565	2.579	2.551	2.56	19371600.0
2004-06-24 12:00:00	AMZN	Stock	2.5605	2.5625	2.552	2.558	6210640.0
2004-06-24 13:00:00	AMZN	Stock	2.557	2.578	2.556	2.564	14298300.0
2004-06-24 14:00:00	AMZN	Stock	2.5645	2.567	2.544	2.545	13733740.0
2004-06-24 15:00:00	AMZN	Stock	2.5445	2.56	2.5345	2.55	26079600.0
2004-06-24 16:00:00	AMZN	Stock	2.5495	2.5548	2.548	2.55	765040.0
2004-06-24 17:00:00	AMZN	Stock	2.551	2.551	2.5425	2.5425	84740.0
2004-06-24 09:00:00	CL	Stock	29.075	29.11	29.06	29.08	248000.0
2004-06-24 10:00:00	CL	Stock	29.075	29.12	29.065	29.075	235400.0
2004-06-24 11:00:00	CL	Stock	29.075	29.105	29.005	29.015	202000.0
2004-06-24 12:00:00	CL	Stock	29.02	29.025	28.96	28.98	261400.0
2004-06-24 13:00:00	CL	Stock	28.985	29.07	28.985	29.045	215600.0
2004-06-24 14:00:00	CL	Stock	29.04	29.11	29.04	29.065	179000.0
2004-06-24 15:00:00	CL	Stock	29.06	29.14	29.025	29.09	620800.0
2004-06-24 16:00:00	CL	Stock	29.08	29.08	29.066	29.066	1600.0

> showing 49 of 24,195 rows — these rows as CSV

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