PREVIEW / stock_1hour / 2004-04-26

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-04-26.parquet
  size:    495 KB
  rows:    23,063
  symbols: 1,756

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-04-26 08:00:00	AAPL	Stock	0.4952	0.4955	0.4938	0.4938	165200.0
2004-04-26 09:00:00	AAPL	Stock	0.4945	0.4945	0.4896	0.4922	29479576.0
2004-04-26 10:00:00	AAPL	Stock	0.4923	0.4923	0.4829	0.4839	47647936.0
2004-04-26 11:00:00	AAPL	Stock	0.4839	0.4875	0.4839	0.485	17938368.0
2004-04-26 12:00:00	AAPL	Stock	0.485	0.4871	0.4843	0.4859	9384088.0
2004-04-26 13:00:00	AAPL	Stock	0.4859	0.4873	0.4839	0.4839	14004480.0
2004-04-26 14:00:00	AAPL	Stock	0.4839	0.4857	0.4829	0.4854	25867856.0
2004-04-26 15:00:00	AAPL	Stock	0.4852	0.4857	0.4821	0.4838	47258400.0
2004-04-26 16:00:00	AAPL	Stock	0.4838	0.4866	0.4834	0.4866	5933592.0
2004-04-26 08:00:00	MSFT	Stock	27.6	27.6	27.44	27.44	147223.0
2004-04-26 09:00:00	MSFT	Stock	27.46	27.53	27.43	27.47	6933741.0
2004-04-26 10:00:00	MSFT	Stock	27.47	27.49	27.13	27.21	16018860.0
2004-04-26 11:00:00	MSFT	Stock	27.21	27.34	27.19	27.27	10254909.0
2004-04-26 12:00:00	MSFT	Stock	27.27	27.32	27.13	27.17	8018152.0
2004-04-26 13:00:00	MSFT	Stock	27.17	27.27	27.15	27.18	5640768.0
2004-04-26 14:00:00	MSFT	Stock	27.18	27.24	27.13	27.208	13794495.0
2004-04-26 15:00:00	MSFT	Stock	27.2	27.25	27.1	27.24	14657035.0
2004-04-26 16:00:00	MSFT	Stock	27.24	27.28	27.21	27.25	1465005.0
2004-04-26 17:00:00	MSFT	Stock	27.25	27.28	27.25	27.25	123212.0
2004-04-26 18:00:00	MSFT	Stock	27.26	27.26	27.2	27.2	3100.0
2004-04-26 08:00:00	NVDA	Stock	0.195	0.1954	0.195	0.1954	204000.0
2004-04-26 09:00:00	NVDA	Stock	0.1953	0.1958	0.1926	0.1927	31192440.0
2004-04-26 10:00:00	NVDA	Stock	0.1927	0.193	0.1882	0.1887	66063240.0
2004-04-26 11:00:00	NVDA	Stock	0.1886	0.1908	0.1883	0.1896	56213760.0
2004-04-26 12:00:00	NVDA	Stock	0.1896	0.1899	0.1879	0.1883	49373760.0
2004-04-26 13:00:00	NVDA	Stock	0.1882	0.1887	0.1879	0.1882	19879560.0
2004-04-26 14:00:00	NVDA	Stock	0.1882	0.1882	0.1863	0.1874	40837920.0
2004-04-26 15:00:00	NVDA	Stock	0.1875	0.1877	0.1856	0.1858	88877040.0
2004-04-26 16:00:00	NVDA	Stock	0.1858	0.1899	0.1858	0.1886	6879720.0
2004-04-26 17:00:00	NVDA	Stock	0.188	0.1881	0.188	0.1881	60000.0
2004-04-26 18:00:00	NVDA	Stock	0.1884	0.1884	0.188	0.188	36000.0
2004-04-26 08:00:00	AMZN	Stock	2.3145	2.321	2.3125	2.321	169300.0
2004-04-26 09:00:00	AMZN	Stock	2.3085	2.36	2.3075	2.353	21622420.0
2004-04-26 10:00:00	AMZN	Stock	2.3515	2.3625	2.337	2.3545	22467920.0
2004-04-26 11:00:00	AMZN	Stock	2.3545	2.3865	2.3545	2.3795	18556440.0
2004-04-26 12:00:00	AMZN	Stock	2.3805	2.3875	2.373	2.3775	12580200.0
2004-04-26 13:00:00	AMZN	Stock	2.378	2.385	2.3725	2.375	6318560.0
2004-04-26 14:00:00	AMZN	Stock	2.374	2.388	2.365	2.3825	16766100.0
2004-04-26 15:00:00	AMZN	Stock	2.3815	2.382	2.3525	2.3635	22177720.0
2004-04-26 16:00:00	AMZN	Stock	2.3635	2.366	2.355	2.3625	4508720.0
2004-04-26 17:00:00	AMZN	Stock	2.362	2.3635	2.361	2.361	617020.0
2004-04-26 18:00:00	AMZN	Stock	2.36	2.36	2.359	2.359	21800.0
2004-04-26 09:00:00	CL	Stock	28.445	28.445	28.305	28.375	328000.0
2004-04-26 10:00:00	CL	Stock	28.375	28.415	28.265	28.3	654000.0
2004-04-26 11:00:00	CL	Stock	28.3	28.335	28.265	28.33	518400.0
2004-04-26 12:00:00	CL	Stock	28.33	28.485	28.32	28.34	790000.0
2004-04-26 13:00:00	CL	Stock	28.34	28.385	28.33	28.365	816600.0
2004-04-26 14:00:00	CL	Stock	28.36	28.425	28.34	28.4	1066600.0
2004-04-26 15:00:00	CL	Stock	28.395	28.625	28.395	28.52	1759600.0
2004-04-26 16:00:00	CL	Stock	28.53	28.53	28.5285	28.53	35000.0

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

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