PREVIEW / stock_1hour / 2005-12-07

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-07.parquet
  size:    591 KB
  rows:    27,934
  symbols: 2,107

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
2005-12-07 07:00:00	AAPL	Stock	2.6404	2.6518	2.6404	2.6518	46200.0
2005-12-07 08:00:00	AAPL	Stock	2.6518	2.66	2.6307	2.6411	6423536.0
2005-12-07 09:00:00	AAPL	Stock	2.6411	2.6593	2.6282	2.6571	111473852.0
2005-12-07 10:00:00	AAPL	Stock	2.6571	2.6586	2.6136	2.6136	171218572.0
2005-12-07 11:00:00	AAPL	Stock	2.6136	2.6429	2.6114	2.6193	95794944.0
2005-12-07 12:00:00	AAPL	Stock	2.6189	2.64	2.6186	2.6396	52656156.0
2005-12-07 13:00:00	AAPL	Stock	2.6396	2.64	2.6211	2.6236	55020420.0
2005-12-07 14:00:00	AAPL	Stock	2.6236	2.635	2.6143	2.6214	70014448.0
2005-12-07 15:00:00	AAPL	Stock	2.6214	2.6429	2.6161	2.6411	106216768.0
2005-12-07 16:00:00	AAPL	Stock	2.6407	2.6418	2.6375	2.6411	1956164.0
2005-12-07 17:00:00	AAPL	Stock	2.6411	2.6446	2.6407	2.6443	854980.0
2005-12-07 18:00:00	AAPL	Stock	2.6421	2.6443	2.6421	2.6421	109312.0
2005-12-07 08:00:00	MSFT	Stock	27.69	27.69	27.32	27.64	40440.0
2005-12-07 09:00:00	MSFT	Stock	27.7	27.75	27.55	27.59	7388713.0
2005-12-07 10:00:00	MSFT	Stock	27.59	27.68	27.55	27.62	8682749.0
2005-12-07 11:00:00	MSFT	Stock	27.63	27.74	27.62	27.7	6581623.0
2005-12-07 12:00:00	MSFT	Stock	27.7	27.72	27.64	27.69	4623682.0
2005-12-07 13:00:00	MSFT	Stock	27.69	27.73	27.596	27.705	7003277.0
2005-12-07 14:00:00	MSFT	Stock	27.7	27.75	27.67	27.71	8993585.0
2005-12-07 15:00:00	MSFT	Stock	27.71	27.75	27.69	27.75	9230637.0
2005-12-07 16:00:00	MSFT	Stock	27.75	27.83	27.74	27.8	377314.0
2005-12-07 17:00:00	MSFT	Stock	27.81	27.82	27.75	27.75	7269.0
2005-12-07 18:00:00	MSFT	Stock	27.79	27.79	27.75	27.75	3625.0
2005-12-07 09:00:00	NVDA	Stock	0.3011	0.3035	0.2958	0.2992	45851520.0
2005-12-07 10:00:00	NVDA	Stock	0.2992	0.3015	0.2985	0.301	24611520.0
2005-12-07 11:00:00	NVDA	Stock	0.301	0.3024	0.3006	0.3016	26025120.0
2005-12-07 12:00:00	NVDA	Stock	0.3016	0.3019	0.3002	0.3015	23316120.0
2005-12-07 13:00:00	NVDA	Stock	0.3014	0.3017	0.2997	0.3	41054520.0
2005-12-07 14:00:00	NVDA	Stock	0.3	0.3027	0.2996	0.3008	70835160.0
2005-12-07 15:00:00	NVDA	Stock	0.3007	0.3016	0.3	0.3012	65138760.0
2005-12-07 16:00:00	NVDA	Stock	0.301	0.3014	0.3008	0.3014	382080.0
2005-12-07 17:00:00	NVDA	Stock	0.301	0.301	0.301	0.301	14760.0
2005-12-07 08:00:00	AMZN	Stock	2.438	2.4615	2.438	2.4575	65800.0
2005-12-07 09:00:00	AMZN	Stock	2.46	2.4735	2.435	2.45	22056080.0
2005-12-07 10:00:00	AMZN	Stock	2.45	2.4525	2.43	2.433	22253440.0
2005-12-07 11:00:00	AMZN	Stock	2.4335	2.445	2.4275	2.437	14721720.0
2005-12-07 12:00:00	AMZN	Stock	2.437	2.4515	2.434	2.445	15935280.0
2005-12-07 13:00:00	AMZN	Stock	2.445	2.4465	2.4255	2.427	11009060.0
2005-12-07 14:00:00	AMZN	Stock	2.4265	2.4275	2.4145	2.4165	17259680.0
2005-12-07 15:00:00	AMZN	Stock	2.4165	2.4455	2.4145	2.441	27030960.0
2005-12-07 16:00:00	AMZN	Stock	2.441	2.4445	2.4395	2.443	1145700.0
2005-12-07 17:00:00	AMZN	Stock	2.447	2.449	2.4415	2.4475	1451660.0
2005-12-07 09:00:00	CL	Stock	27.73	27.745	27.58	27.615	265400.0
2005-12-07 10:00:00	CL	Stock	27.61	27.61	27.515	27.52	541200.0
2005-12-07 11:00:00	CL	Stock	27.525	27.535	27.45	27.475	938200.0
2005-12-07 12:00:00	CL	Stock	27.475	27.485	27.34	27.48	451800.0
2005-12-07 13:00:00	CL	Stock	27.475	27.495	27.358	27.385	454600.0
2005-12-07 14:00:00	CL	Stock	27.385	27.41	27.315	27.335	346200.0
2005-12-07 15:00:00	CL	Stock	27.335	27.45	27.32	27.45	637600.0

> showing 49 of 27,934 rows — these rows as CSV

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