PREVIEW / stock_1hour / 2004-04-06

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-04-06.parquet
  size:    504 KB
  rows:    24,031
  symbols: 1,757

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-06 08:00:00	AAPL	Stock	0.5027	0.5027	0.5009	0.5009	50400.0
2004-04-06 09:00:00	AAPL	Stock	0.5	0.5045	0.492	0.5004	53766608.0
2004-04-06 10:00:00	AAPL	Stock	0.5005	0.5027	0.4954	0.4955	49302512.0
2004-04-06 11:00:00	AAPL	Stock	0.4957	0.4988	0.4898	0.4938	50716568.0
2004-04-06 12:00:00	AAPL	Stock	0.4939	0.4955	0.4914	0.4936	18548096.0
2004-04-06 13:00:00	AAPL	Stock	0.4936	0.4957	0.4932	0.4938	16139368.0
2004-04-06 14:00:00	AAPL	Stock	0.4936	0.4961	0.4914	0.4957	17342136.0
2004-04-06 15:00:00	AAPL	Stock	0.4957	0.4975	0.4918	0.4964	35037184.0
2004-04-06 16:00:00	AAPL	Stock	0.4964	0.4971	0.4921	0.4944	2536016.0
2004-04-06 17:00:00	AAPL	Stock	0.4929	0.4958	0.4923	0.4958	252000.0
2004-04-06 08:00:00	MSFT	Stock	25.9	25.93	25.7	25.83	42647.0
2004-04-06 09:00:00	MSFT	Stock	25.81	25.87	25.67	25.79	5569593.0
2004-04-06 10:00:00	MSFT	Stock	25.79	25.88	25.77	25.86	6808814.0
2004-04-06 11:00:00	MSFT	Stock	25.86	25.86	25.73	25.78	7603884.0
2004-04-06 12:00:00	MSFT	Stock	25.78	25.9	25.77	25.8303	6637442.0
2004-04-06 13:00:00	MSFT	Stock	25.84	25.89	25.75	25.79	5237744.0
2004-04-06 14:00:00	MSFT	Stock	25.79	25.86	25.77	25.8	5252745.0
2004-04-06 15:00:00	MSFT	Stock	25.8	25.81	25.67	25.8	8093643.0
2004-04-06 16:00:00	MSFT	Stock	25.81	25.84	25.63	25.68	967892.0
2004-04-06 17:00:00	MSFT	Stock	25.67	25.7999	25.67	25.7821	43960.0
2004-04-06 18:00:00	MSFT	Stock	25.69	25.7955	25.69	25.69	21280.0
2004-04-06 08:00:00	NVDA	Stock	0.225	0.225	0.2227	0.2241	236400.0
2004-04-06 09:00:00	NVDA	Stock	0.224	0.2241	0.2195	0.2195	104135520.0
2004-04-06 10:00:00	NVDA	Stock	0.2195	0.2212	0.2179	0.2187	112233480.0
2004-04-06 11:00:00	NVDA	Stock	0.2187	0.2187	0.2167	0.2182	98161440.0
2004-04-06 12:00:00	NVDA	Stock	0.2182	0.2184	0.2172	0.2177	47403240.0
2004-04-06 13:00:00	NVDA	Stock	0.2177	0.2196	0.2175	0.2186	64995360.0
2004-04-06 14:00:00	NVDA	Stock	0.2184	0.2208	0.2184	0.2201	58710840.0
2004-04-06 15:00:00	NVDA	Stock	0.2201	0.2207	0.2187	0.2196	75339240.0
2004-04-06 16:00:00	NVDA	Stock	0.2196	0.2196	0.2178	0.2178	5459760.0
2004-04-06 17:00:00	NVDA	Stock	0.2177	0.2194	0.2168	0.2194	5028000.0
2004-04-06 18:00:00	NVDA	Stock	0.2169	0.2169	0.2169	0.2169	24000.0
2004-04-06 08:00:00	AMZN	Stock	2.335	2.335	2.32	2.32	186400.0
2004-04-06 09:00:00	AMZN	Stock	2.3205	2.3375	2.315	2.3285	20484280.0
2004-04-06 10:00:00	AMZN	Stock	2.3285	2.3485	2.3275	2.328	17264300.0
2004-04-06 11:00:00	AMZN	Stock	2.328	2.3285	2.2985	2.3015	24119780.0
2004-04-06 12:00:00	AMZN	Stock	2.3005	2.3015	2.2875	2.297	10664920.0
2004-04-06 13:00:00	AMZN	Stock	2.297	2.311	2.2945	2.301	10796580.0
2004-04-06 14:00:00	AMZN	Stock	2.301	2.323	2.2975	2.3195	10358880.0
2004-04-06 15:00:00	AMZN	Stock	2.3195	2.3255	2.313	2.322	17663060.0
2004-04-06 16:00:00	AMZN	Stock	2.322	2.3235	2.28	2.311	702800.0
2004-04-06 17:00:00	AMZN	Stock	2.322	2.322	2.3085	2.3191	114480.0
2004-04-06 18:00:00	AMZN	Stock	2.307	2.3312	2.307	2.3312	95500.0
2004-04-06 09:00:00	CL	Stock	27.225	27.3	27.2	27.205	574600.0
2004-04-06 10:00:00	CL	Stock	27.21	27.35	27.185	27.35	678400.0
2004-04-06 11:00:00	CL	Stock	27.36	27.495	27.36	27.475	505200.0
2004-04-06 12:00:00	CL	Stock	27.475	27.54	27.42	27.475	469000.0
2004-04-06 13:00:00	CL	Stock	27.47	27.4705	27.335	27.35	277200.0
2004-04-06 14:00:00	CL	Stock	27.335	27.445	27.33	27.37	425800.0
2004-04-06 15:00:00	CL	Stock	27.37	27.47	27.345	27.46	806000.0

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

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