PREVIEW / stock_1hour / 2003-05-20

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-05-20.parquet
  size:    427 KB
  rows:    20,913
  symbols: 1,574

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
2003-05-20 08:00:00	AAPL	Stock	0.3238	0.325	0.3236	0.325	761600.0
2003-05-20 09:00:00	AAPL	Stock	0.325	0.325	0.3177	0.3188	54167120.0
2003-05-20 10:00:00	AAPL	Stock	0.3188	0.323	0.3175	0.3216	125953520.0
2003-05-20 11:00:00	AAPL	Stock	0.3218	0.3223	0.3194	0.3204	18572736.0
2003-05-20 12:00:00	AAPL	Stock	0.3204	0.3205	0.317	0.3175	25545240.0
2003-05-20 13:00:00	AAPL	Stock	0.3173	0.318	0.3145	0.3159	34962088.0
2003-05-20 14:00:00	AAPL	Stock	0.3161	0.3168	0.3143	0.3157	46080160.0
2003-05-20 15:00:00	AAPL	Stock	0.3161	0.3195	0.3154	0.3173	33418672.0
2003-05-20 16:00:00	AAPL	Stock	0.3177	0.3213	0.3175	0.3212	2716000.0
2003-05-20 17:00:00	AAPL	Stock	0.3189	0.3189	0.3175	0.3175	1181600.0
2003-05-20 08:00:00	MSFT	Stock	24.86	24.9	24.802	24.89	99800.0
2003-05-20 09:00:00	MSFT	Stock	24.89	24.962	24.78	24.837	5847168.0
2003-05-20 10:00:00	MSFT	Stock	24.84	24.94	24.819	24.88	7467934.0
2003-05-20 11:00:00	MSFT	Stock	24.881	24.93	24.75	24.88	4430065.0
2003-05-20 12:00:00	MSFT	Stock	24.88	24.98	24.8299	24.88	4884980.0
2003-05-20 13:00:00	MSFT	Stock	24.89	24.91	24.76	24.88	3505494.0
2003-05-20 14:00:00	MSFT	Stock	24.88	24.9	24.577	24.62	6408089.0
2003-05-20 15:00:00	MSFT	Stock	24.62	24.77	24.5	24.64	9878268.0
2003-05-20 16:00:00	MSFT	Stock	24.64	24.81	24.58	24.8	1054019.0
2003-05-20 17:00:00	MSFT	Stock	24.81	24.84	24.62	24.8	263680.0
2003-05-20 18:00:00	MSFT	Stock	24.8	24.8	24.8	24.8	1700.0
2003-05-20 08:00:00	NVDA	Stock	0.1667	0.168	0.1662	0.1679	1503840.0
2003-05-20 09:00:00	NVDA	Stock	0.1675	0.1692	0.1667	0.168	143207640.0
2003-05-20 10:00:00	NVDA	Stock	0.1681	0.1694	0.168	0.1687	143553480.0
2003-05-20 11:00:00	NVDA	Stock	0.1687	0.1691	0.1675	0.1689	66819120.0
2003-05-20 12:00:00	NVDA	Stock	0.1689	0.1696	0.1687	0.169	62066400.0
2003-05-20 13:00:00	NVDA	Stock	0.1689	0.1692	0.1683	0.169	67421160.0
2003-05-20 14:00:00	NVDA	Stock	0.169	0.1691	0.1671	0.1676	118028400.0
2003-05-20 15:00:00	NVDA	Stock	0.1676	0.1689	0.1667	0.1684	149062080.0
2003-05-20 16:00:00	NVDA	Stock	0.1683	0.17	0.1679	0.17	7728000.0
2003-05-20 17:00:00	NVDA	Stock	0.17	0.1707	0.1683	0.1703	1980000.0
2003-05-20 18:00:00	NVDA	Stock	0.1703	0.1704	0.17	0.1702	516000.0
2003-05-20 08:00:00	AMZN	Stock	1.5925	1.5925	1.5805	1.5875	52000.0
2003-05-20 09:00:00	AMZN	Stock	1.5831	1.604	1.576	1.5925	27967060.0
2003-05-20 10:00:00	AMZN	Stock	1.593	1.6065	1.587	1.587	28457980.0
2003-05-20 11:00:00	AMZN	Stock	1.5874	1.5925	1.575	1.584	18651820.0
2003-05-20 12:00:00	AMZN	Stock	1.584	1.5907	1.5785	1.5905	12252920.0
2003-05-20 13:00:00	AMZN	Stock	1.59	1.5905	1.584	1.587	6299060.0
2003-05-20 14:00:00	AMZN	Stock	1.5875	1.5875	1.5605	1.566	19966140.0
2003-05-20 15:00:00	AMZN	Stock	1.567	1.579	1.5585	1.575	16492720.0
2003-05-20 16:00:00	AMZN	Stock	1.5741	1.585	1.571	1.5775	1922440.0
2003-05-20 17:00:00	AMZN	Stock	1.5785	1.582	1.574	1.582	288000.0
2003-05-20 18:00:00	AMZN	Stock	1.5785	1.5785	1.5785	1.5785	160000.0
2003-05-20 09:00:00	CL	Stock	29.5	29.545	29.425	29.48	954400.0
2003-05-20 10:00:00	CL	Stock	29.485	29.535	29.4	29.505	796400.0
2003-05-20 11:00:00	CL	Stock	29.51	29.54	29.405	29.54	504600.0
2003-05-20 12:00:00	CL	Stock	29.54	29.55	29.475	29.505	381800.0
2003-05-20 13:00:00	CL	Stock	29.505	29.525	29.45	29.5	528000.0
2003-05-20 14:00:00	CL	Stock	29.5	29.535	29.44	29.455	952200.0
2003-05-20 15:00:00	CL	Stock	29.455	29.655	29.375	29.655	878400.0

> showing 50 of 20,913 rows — these rows as CSV

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