PREVIEW / stock_1hour / 2004-05-04

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-05-04.parquet
  size:    499 KB
  rows:    23,413
  symbols: 1,764

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-04 09:00:00	AAPL	Stock	0.4661	0.47	0.457	0.4604	33398792.0
2004-05-04 10:00:00	AAPL	Stock	0.46	0.4643	0.4554	0.4616	30150512.0
2004-05-04 11:00:00	AAPL	Stock	0.4614	0.4625	0.4582	0.4596	36941856.0
2004-05-04 12:00:00	AAPL	Stock	0.4595	0.462	0.4582	0.4609	16714152.0
2004-05-04 13:00:00	AAPL	Stock	0.4609	0.4654	0.4609	0.4625	24552248.0
2004-05-04 14:00:00	AAPL	Stock	0.4625	0.4741	0.4598	0.4714	53051544.0
2004-05-04 15:00:00	AAPL	Stock	0.4713	0.4714	0.4616	0.4663	68420240.0
2004-05-04 16:00:00	AAPL	Stock	0.4664	0.4671	0.4661	0.4663	1332352.0
2004-05-04 17:00:00	AAPL	Stock	0.4663	0.4663	0.4663	0.4663	71680.0
2004-05-04 08:00:00	MSFT	Stock	26.4	26.41	26.38	26.38	10650.0
2004-05-04 09:00:00	MSFT	Stock	26.38	26.42	26.26	26.38	5799158.0
2004-05-04 10:00:00	MSFT	Stock	26.38	26.44	26.3	26.34	5861957.0
2004-05-04 11:00:00	MSFT	Stock	26.35	26.35	26.21	26.22	5660828.0
2004-05-04 12:00:00	MSFT	Stock	26.22	26.22	26.02	26.09	6050713.0
2004-05-04 13:00:00	MSFT	Stock	26.09	26.28	26.09	26.27	5420199.0
2004-05-04 14:00:00	MSFT	Stock	26.26	26.54	26.16	26.51	14016797.0
2004-05-04 15:00:00	MSFT	Stock	26.519	26.52	26.19	26.33	10747751.0
2004-05-04 16:00:00	MSFT	Stock	26.33	26.35	26.24	26.3	793169.0
2004-05-04 17:00:00	MSFT	Stock	26.27	26.29	26.26	26.28	17985.0
2004-05-04 08:00:00	NVDA	Stock	0.1689	0.1694	0.1689	0.1694	420000.0
2004-05-04 09:00:00	NVDA	Stock	0.1698	0.1772	0.1698	0.176	107001000.0
2004-05-04 10:00:00	NVDA	Stock	0.176	0.1792	0.1737	0.178	127881600.0
2004-05-04 11:00:00	NVDA	Stock	0.178	0.1782	0.1745	0.1757	59336520.0
2004-05-04 12:00:00	NVDA	Stock	0.1756	0.1764	0.1755	0.1761	28299720.0
2004-05-04 13:00:00	NVDA	Stock	0.1762	0.1792	0.176	0.1792	63687960.0
2004-05-04 14:00:00	NVDA	Stock	0.1792	0.1817	0.1777	0.1804	139824720.0
2004-05-04 15:00:00	NVDA	Stock	0.1805	0.1812	0.178	0.1795	202242000.0
2004-05-04 16:00:00	NVDA	Stock	0.1795	0.1797	0.1792	0.1792	6457440.0
2004-05-04 17:00:00	NVDA	Stock	0.1792	0.1799	0.1792	0.1792	1836000.0
2004-05-04 08:00:00	AMZN	Stock	2.22	2.2235	2.22	2.22	30000.0
2004-05-04 09:00:00	AMZN	Stock	2.2205	2.2285	2.204	2.213	12992920.0
2004-05-04 10:00:00	AMZN	Stock	2.212	2.2185	2.2075	2.2125	15845680.0
2004-05-04 11:00:00	AMZN	Stock	2.212	2.2145	2.204	2.2075	10753400.0
2004-05-04 12:00:00	AMZN	Stock	2.2075	2.2105	2.1875	2.188	16473560.0
2004-05-04 13:00:00	AMZN	Stock	2.1875	2.1945	2.187	2.191	8593120.0
2004-05-04 14:00:00	AMZN	Stock	2.191	2.2165	2.187	2.212	42887260.0
2004-05-04 15:00:00	AMZN	Stock	2.212	2.2175	2.185	2.1995	34332060.0
2004-05-04 16:00:00	AMZN	Stock	2.1975	2.201	2.192	2.1975	1475580.0
2004-05-04 17:00:00	AMZN	Stock	2.1985	2.1985	2.195	2.195	4000.0
2004-05-04 09:00:00	CL	Stock	29.335	29.34	29.115	29.16	787800.0
2004-05-04 10:00:00	CL	Stock	29.16	29.325	29.14	29.265	823400.0
2004-05-04 11:00:00	CL	Stock	29.27	29.39	29.26	29.26	553200.0
2004-05-04 12:00:00	CL	Stock	29.26	29.265	29.2	29.24	579600.0
2004-05-04 13:00:00	CL	Stock	29.24	29.325	29.225	29.27	447800.0
2004-05-04 14:00:00	CL	Stock	29.27	29.5	29.255	29.485	1077000.0
2004-05-04 15:00:00	CL	Stock	29.475	29.5	29.285	29.375	1389600.0
2004-05-04 16:00:00	CL	Stock	29.3	29.365	29.3	29.365	23200.0
2004-05-04 17:00:00	CL	Stock	29.365	29.365	29.365	29.365	800.0

> showing 48 of 23,413 rows — these rows as CSV

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