PREVIEW / stock_1hour / 2004-03-31

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-03-31.parquet
  size:    520 KB
  rows:    24,518
  symbols: 1,750

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-03-31 08:00:00	AAPL	Stock	0.4986	0.5	0.4982	0.4982	78400.0
2004-03-31 09:00:00	AAPL	Stock	0.4982	0.4996	0.4939	0.4975	26572952.0
2004-03-31 10:00:00	AAPL	Stock	0.4977	0.4977	0.4934	0.4938	31602648.0
2004-03-31 11:00:00	AAPL	Stock	0.4938	0.4968	0.4938	0.4963	18699352.0
2004-03-31 12:00:00	AAPL	Stock	0.4964	0.4964	0.4914	0.4916	24011288.0
2004-03-31 13:00:00	AAPL	Stock	0.4914	0.4938	0.488	0.4884	38919776.0
2004-03-31 14:00:00	AAPL	Stock	0.4884	0.493	0.4882	0.4907	44324728.0
2004-03-31 15:00:00	AAPL	Stock	0.4907	0.4907	0.4813	0.4825	139080648.0
2004-03-31 16:00:00	AAPL	Stock	0.483	0.485	0.4814	0.4829	32294864.0
2004-03-31 17:00:00	AAPL	Stock	0.4825	0.483	0.4825	0.483	582400.0
2004-03-31 08:00:00	MSFT	Stock	25.2	25.26	25.1	25.18	366575.0
2004-03-31 09:00:00	MSFT	Stock	25.2	25.2	25.0	25.04	8770522.0
2004-03-31 10:00:00	MSFT	Stock	25.05	25.06	24.96	25.01	12459556.0
2004-03-31 11:00:00	MSFT	Stock	25.01	25.04	24.9399	24.97	7220353.0
2004-03-31 12:00:00	MSFT	Stock	24.97	25.04	24.96	25.0	5490210.0
2004-03-31 13:00:00	MSFT	Stock	24.99	25.0	24.8699	24.9	7337411.0
2004-03-31 14:00:00	MSFT	Stock	24.89	25.08	24.89	25.05	9301524.0
2004-03-31 15:00:00	MSFT	Stock	25.05	25.051	24.89	24.93	12516340.0
2004-03-31 16:00:00	MSFT	Stock	24.93	25.0	24.92	24.97	2670546.0
2004-03-31 17:00:00	MSFT	Stock	24.95	24.97	24.93	24.95	85773.0
2004-03-31 18:00:00	MSFT	Stock	24.95	25.0018	24.95	24.96	9649.0
2004-03-31 08:00:00	NVDA	Stock	0.2189	0.22	0.2182	0.2182	422400.0
2004-03-31 09:00:00	NVDA	Stock	0.2182	0.2223	0.2179	0.2215	116429640.0
2004-03-31 10:00:00	NVDA	Stock	0.2215	0.2215	0.2189	0.2195	113718360.0
2004-03-31 11:00:00	NVDA	Stock	0.2196	0.2202	0.2187	0.2194	53762760.0
2004-03-31 12:00:00	NVDA	Stock	0.2194	0.2203	0.2192	0.2201	27257640.0
2004-03-31 13:00:00	NVDA	Stock	0.2201	0.2212	0.2193	0.2197	51032160.0
2004-03-31 14:00:00	NVDA	Stock	0.2197	0.222	0.2196	0.2212	67982640.0
2004-03-31 15:00:00	NVDA	Stock	0.2213	0.2213	0.219	0.2202	104353320.0
2004-03-31 16:00:00	NVDA	Stock	0.2202	0.2208	0.2192	0.22	37610160.0
2004-03-31 17:00:00	NVDA	Stock	0.2202	0.2207	0.22	0.22	670560.0
2004-03-31 08:00:00	AMZN	Stock	2.1898	2.2	2.1755	2.1895	514600.0
2004-03-31 09:00:00	AMZN	Stock	2.1875	2.195	2.155	2.165	14005440.0
2004-03-31 10:00:00	AMZN	Stock	2.164	2.1806	2.1475	2.1665	22144120.0
2004-03-31 11:00:00	AMZN	Stock	2.166	2.1765	2.164	2.1755	7383680.0
2004-03-31 12:00:00	AMZN	Stock	2.175	2.1775	2.172	2.1725	4787220.0
2004-03-31 13:00:00	AMZN	Stock	2.173	2.185	2.1715	2.1805	7446740.0
2004-03-31 14:00:00	AMZN	Stock	2.18	2.2	2.1785	2.197	9431880.0
2004-03-31 15:00:00	AMZN	Stock	2.1965	2.1965	2.1625	2.1625	21745820.0
2004-03-31 16:00:00	AMZN	Stock	2.1625	2.1795	2.1625	2.168	1284120.0
2004-03-31 17:00:00	AMZN	Stock	2.164	2.1695	2.164	2.166	421820.0
2004-03-31 18:00:00	AMZN	Stock	2.166	2.166	2.1655	2.1655	14000.0
2004-03-31 09:00:00	CL	Stock	27.925	27.925	27.705	27.73	197800.0
2004-03-31 10:00:00	CL	Stock	27.73	27.73	27.525	27.65	537200.0
2004-03-31 11:00:00	CL	Stock	27.65	27.72	27.61	27.61	475400.0
2004-03-31 12:00:00	CL	Stock	27.605	27.65	27.52	27.565	411600.0
2004-03-31 13:00:00	CL	Stock	27.56	27.6	27.425	27.455	466800.0
2004-03-31 14:00:00	CL	Stock	27.455	27.59	27.45	27.555	1679200.0
2004-03-31 15:00:00	CL	Stock	27.555	27.58	27.465	27.555	837400.0
2004-03-31 16:00:00	CL	Stock	27.55	27.55	27.55	27.55	47200.0

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

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