PREVIEW / stock_1hour / 2004-05-07

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-05-07.parquet
  size:    540 KB
  rows:    24,794
  symbols: 1,772

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-05-07 08:00:00	AAPL	Stock	0.4759	0.4759	0.4746	0.4746	347200.0
2004-05-07 09:00:00	AAPL	Stock	0.4746	0.4829	0.4739	0.48	73257352.0
2004-05-07 10:00:00	AAPL	Stock	0.48	0.4891	0.4777	0.4884	100613072.0
2004-05-07 11:00:00	AAPL	Stock	0.4882	0.4923	0.4877	0.4907	60508504.0
2004-05-07 12:00:00	AAPL	Stock	0.4907	0.4909	0.4873	0.4888	20464584.0
2004-05-07 13:00:00	AAPL	Stock	0.4888	0.4902	0.4825	0.483	32239144.0
2004-05-07 14:00:00	AAPL	Stock	0.483	0.4848	0.4804	0.4834	43087688.0
2004-05-07 15:00:00	AAPL	Stock	0.4834	0.4839	0.4763	0.4763	52198832.0
2004-05-07 16:00:00	AAPL	Stock	0.4768	0.4775	0.475	0.4768	1634080.0
2004-05-07 17:00:00	AAPL	Stock	0.4768	0.482	0.4763	0.482	95200.0
2004-05-07 08:00:00	MSFT	Stock	26.1	26.28	26.0	26.0	173613.0
2004-05-07 09:00:00	MSFT	Stock	26.01	26.38	26.0	26.19	8969904.0
2004-05-07 10:00:00	MSFT	Stock	26.199	26.25	26.0	26.17	12397826.0
2004-05-07 11:00:00	MSFT	Stock	26.17	26.29	26.1	26.23	6511039.0
2004-05-07 12:00:00	MSFT	Stock	26.23	26.331	26.16	26.27	5448150.0
2004-05-07 13:00:00	MSFT	Stock	26.28	26.38	26.1	26.13	7904759.0
2004-05-07 14:00:00	MSFT	Stock	26.13	26.21	26.03	26.11	8619818.0
2004-05-07 15:00:00	MSFT	Stock	26.111	26.16	25.78	25.78	14264499.0
2004-05-07 16:00:00	MSFT	Stock	25.79	26.1364	25.72	25.85	888548.0
2004-05-07 17:00:00	MSFT	Stock	25.85	26.1348	25.691	25.84	204608.0
2004-05-07 18:00:00	MSFT	Stock	25.86	25.86	25.84	25.86	5898.0
2004-05-07 08:00:00	NVDA	Stock	0.1882	0.19	0.185	0.1862	6049320.0
2004-05-07 09:00:00	NVDA	Stock	0.1874	0.1914	0.1836	0.1838	277235760.0
2004-05-07 10:00:00	NVDA	Stock	0.1838	0.1878	0.1837	0.1867	226286040.0
2004-05-07 11:00:00	NVDA	Stock	0.1867	0.1897	0.1852	0.1894	98058000.0
2004-05-07 12:00:00	NVDA	Stock	0.1896	0.1898	0.1887	0.1887	86262480.0
2004-05-07 13:00:00	NVDA	Stock	0.1887	0.1893	0.1854	0.1857	42579240.0
2004-05-07 14:00:00	NVDA	Stock	0.1857	0.1868	0.1847	0.1858	56634960.0
2004-05-07 15:00:00	NVDA	Stock	0.1858	0.1862	0.183	0.184	98121360.0
2004-05-07 16:00:00	NVDA	Stock	0.184	0.1842	0.1836	0.1837	927480.0
2004-05-07 17:00:00	NVDA	Stock	0.1834	0.1837	0.1827	0.1832	726000.0
2004-05-07 18:00:00	NVDA	Stock	0.1808	0.1832	0.1808	0.183	288000.0
2004-05-07 08:00:00	AMZN	Stock	2.1625	2.1725	2.14	2.1505	718580.0
2004-05-07 09:00:00	AMZN	Stock	2.1555	2.209	2.1475	2.1615	31843760.0
2004-05-07 10:00:00	AMZN	Stock	2.1615	2.1705	2.134	2.165	30329880.0
2004-05-07 11:00:00	AMZN	Stock	2.1645	2.1715	2.1465	2.1475	15940760.0
2004-05-07 12:00:00	AMZN	Stock	2.148	2.148	2.1275	2.1415	13997620.0
2004-05-07 13:00:00	AMZN	Stock	2.1415	2.144	2.1115	2.121	16465320.0
2004-05-07 14:00:00	AMZN	Stock	2.121	2.13	2.0965	2.108	26312660.0
2004-05-07 15:00:00	AMZN	Stock	2.1075	2.1145	2.084	2.0965	37993020.0
2004-05-07 16:00:00	AMZN	Stock	2.095	2.1296	2.094	2.095	3138980.0
2004-05-07 17:00:00	AMZN	Stock	2.0925	2.1572	2.0925	2.11	1049520.0
2004-05-07 18:00:00	AMZN	Stock	2.11	2.11	2.11	2.11	2000.0
2004-05-07 09:00:00	CL	Stock	29.17	29.3	29.04	29.1	357800.0
2004-05-07 10:00:00	CL	Stock	29.1	29.3	29.075	29.235	563400.0
2004-05-07 11:00:00	CL	Stock	29.24	29.25	29.1	29.165	339000.0
2004-05-07 12:00:00	CL	Stock	29.165	29.2	29.12	29.135	195600.0
2004-05-07 13:00:00	CL	Stock	29.135	29.2	29.01	29.03	257000.0
2004-05-07 14:00:00	CL	Stock	29.03	29.035	28.83	28.865	448600.0
2004-05-07 15:00:00	CL	Stock	28.87	28.88	28.695	28.81	1013400.0

> showing 50 of 24,794 rows — these rows as CSV

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