PREVIEW / stock_1hour / 2006-10-25

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-25.parquet
  size:    617 KB
  rows:    29,380
  symbols: 2,398

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
2006-10-25 08:00:00	AAPL	Stock	2.9068	2.9121	2.9054	2.9107	894292.0
2006-10-25 09:00:00	AAPL	Stock	2.9082	2.9193	2.8964	2.9107	60616668.0
2006-10-25 10:00:00	AAPL	Stock	2.9104	2.9286	2.9018	2.9114	88355540.0
2006-10-25 11:00:00	AAPL	Stock	2.9114	2.9236	2.9096	2.9171	43135792.0
2006-10-25 12:00:00	AAPL	Stock	2.9171	2.9189	2.9007	2.9057	46143468.0
2006-10-25 13:00:00	AAPL	Stock	2.9054	2.9125	2.9025	2.9046	35387856.0
2006-10-25 14:00:00	AAPL	Stock	2.9048	2.9211	2.8932	2.9039	119419888.0
2006-10-25 15:00:00	AAPL	Stock	2.9038	2.9214	2.9018	2.9161	76927536.0
2006-10-25 16:00:00	AAPL	Stock	2.9161	2.9179	2.9104	2.9161	1454964.0
2006-10-25 17:00:00	AAPL	Stock	2.9168	2.9171	2.9154	2.9168	3747520.0
2006-10-25 18:00:00	AAPL	Stock	2.9154	2.9161	2.915	2.915	95368.0
2006-10-25 19:00:00	AAPL	Stock	2.9168	2.9168	2.9168	2.9168	14000.0
2006-10-25 07:00:00	MSFT	Stock	28.27	28.27	28.27	28.27	500.0
2006-10-25 08:00:00	MSFT	Stock	28.23	28.25	28.19	28.21	16250.0
2006-10-25 09:00:00	MSFT	Stock	28.21	28.4	28.2	28.37	6001815.0
2006-10-25 10:00:00	MSFT	Stock	28.36	28.42	28.34	28.352	6182025.0
2006-10-25 11:00:00	MSFT	Stock	28.35	28.4	28.29	28.32	3963303.0
2006-10-25 12:00:00	MSFT	Stock	28.33	28.37	28.28	28.31	3585415.0
2006-10-25 13:00:00	MSFT	Stock	28.31	28.35	28.3	28.33	2200034.0
2006-10-25 14:00:00	MSFT	Stock	28.32	28.46	28.14	28.232	9451322.0
2006-10-25 15:00:00	MSFT	Stock	28.24	28.36	28.21	28.32	7852379.0
2006-10-25 16:00:00	MSFT	Stock	28.31	28.39	28.27	28.36	137417.0
2006-10-25 17:00:00	MSFT	Stock	28.34	28.37	28.31	28.33	222562.0
2006-10-25 18:00:00	MSFT	Stock	28.32	28.32	28.32	28.32	600.0
2006-10-25 19:00:00	MSFT	Stock	28.38	28.38	28.31	28.38	4427.0
2006-10-25 08:00:00	NVDA	Stock	0.5425	0.5425	0.5425	0.5425	18000.0
2006-10-25 09:00:00	NVDA	Stock	0.5428	0.5523	0.5377	0.5517	49738080.0
2006-10-25 10:00:00	NVDA	Stock	0.5515	0.555	0.5488	0.5498	76129500.0
2006-10-25 11:00:00	NVDA	Stock	0.5498	0.5547	0.5487	0.5499	46407780.0
2006-10-25 12:00:00	NVDA	Stock	0.5498	0.5507	0.543	0.5475	46349160.0
2006-10-25 13:00:00	NVDA	Stock	0.5475	0.5508	0.5467	0.5497	31060500.0
2006-10-25 14:00:00	NVDA	Stock	0.5498	0.5525	0.5433	0.5492	60697740.0
2006-10-25 15:00:00	NVDA	Stock	0.5492	0.55	0.5455	0.5473	65368980.0
2006-10-25 16:00:00	NVDA	Stock	0.5475	0.5482	0.5465	0.5475	5746800.0
2006-10-25 17:00:00	NVDA	Stock	0.5465	0.5475	0.5465	0.5475	534240.0
2006-10-25 19:00:00	NVDA	Stock	0.548	0.548	0.548	0.548	18000.0
2006-10-25 06:00:00	AMZN	Stock	1.9125	1.9125	1.9125	1.9125	102760.0
2006-10-25 07:00:00	AMZN	Stock	1.8885	1.91	1.8775	1.905	1315180.0
2006-10-25 08:00:00	AMZN	Stock	1.905	1.92	1.853	1.855	26504520.0
2006-10-25 09:00:00	AMZN	Stock	1.8565	1.872	1.802	1.8385	247920320.0
2006-10-25 10:00:00	AMZN	Stock	1.839	1.8845	1.83	1.868	208567600.0
2006-10-25 11:00:00	AMZN	Stock	1.868	1.883	1.8545	1.874	83395220.0
2006-10-25 12:00:00	AMZN	Stock	1.874	1.878	1.8648	1.8765	43700180.0
2006-10-25 13:00:00	AMZN	Stock	1.877	1.8825	1.8695	1.878	48049160.0
2006-10-25 14:00:00	AMZN	Stock	1.878	1.899	1.8775	1.8885	138178820.0
2006-10-25 15:00:00	AMZN	Stock	1.8885	1.8935	1.8785	1.8865	115795460.0
2006-10-25 16:00:00	AMZN	Stock	1.884	1.888	1.87	1.888	2452460.0
2006-10-25 17:00:00	AMZN	Stock	1.888	1.888	1.861	1.884	530700.0
2006-10-25 18:00:00	AMZN	Stock	1.8835	1.8875	1.865	1.8705	3147000.0
2006-10-25 19:00:00	AMZN	Stock	1.871	1.875	1.871	1.875	142580.0

> showing 50 of 29,380 rows — these rows as CSV

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