PREVIEW / stock_daily / 2006-08-14

all stock daily files

  file:    by_date/stock_daily/2006/2006-08-14.parquet
  size:    148 KB
  rows:    4,482
  symbols: 2,833

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2006-08-14	AAPL	Stock	2.2875	2.3293	2.2714	2.2836	717620400.0
2006-08-14	MSFT	Stock	24.52	24.6	24.35	24.53	47831900.0
2006-08-14	NVDA	Stock	0.3948	0.3988	0.3858	0.388	809412000.0
2006-08-14	AMZN	Stock	1.311	1.353	1.309	1.3265	102560000.0
2006-08-14	CL	Stock	30.025	30.09	29.79	29.83	2680800.0
2006-08-14	A	Stock	19.628	20.6509	19.6137	20.3648	5375869.0
2006-08-14	AABA-DELISTED	Stock	27.7099990844727	27.7999992370605	27.0	27.2600002288818	10640100.0
2006-08-14	AACC-DELISTED	Stock	15.3	15.57	14.91	15.44	216417.0
2006-08-14	AACQU-DELISTED	Stock	6.08	6.08	6.04	6.04	3500.0
2006-08-14	AACQW-DELISTED	Stock	0.41	0.41	0.39	0.39	15000.0
2006-08-14	AAI-DELISTED	Stock	11.35	11.38	10.86	10.94	1135000.0
2006-08-14	AAIC-DELISTED	Stock	177.0	182.8	175.8	178.0	1104600.0
2006-08-14	AAME	Stock	2.7	2.7	2.7	2.7	1500.0
2006-08-14	AAON	Stock	2.9524	2.9564	2.8971	2.9393	158709.0
2006-08-14	AAP	Stock	29.02	29.6	28.96	28.99	1222600.0
2006-08-14	AATI-DELISTED	Stock	8.81	9.24	8.79	9.04	105834.0
2006-08-14	AAU-DELISTED	Stock	2.68	2.68	2.59	2.6299	17100.0
2006-08-14	AAUAF-DELISTED	Stock	2.68	2.68	2.59	2.6299	17100.0
2006-08-14	AAV-DELISTED	Stock	16.25	16.32	15.99	16.0254	406700.0
2006-08-14	AAWW-DELISTED	Stock	37.95	39.1	36.63	38.15	152337.0
2006-08-14	AAXN-DELISTED	Stock	7.0	7.07000017166138	6.90999984741211	6.96999979019165	553600.0
2006-08-14	AB	Stock	67.55	68.22	66.9	67.52	143600.0
2006-08-14	ABAX-DELISTED	Stock	21.55	22.19	21.5	21.73	133146.0
2006-08-14	ABB-DELISTED	Stock	12.93	13.038	12.85	12.88	1555200.0
2006-08-14	ABBC-DELISTED	Stock	14.76	14.8799	14.57	14.65	15418.0
2006-08-14	ABC-DELISTED	Stock	21.81	21.83	21.67	21.7	1645600.0
2006-08-14	ABCB	Stock	25.2984	26.6893	25.2984	25.6875	39583.0
2006-08-14	ABCO-DELISTED	Stock	23.67	24.89	23.67	24.72	321520.0
2006-08-14	ABCW-DELISTED	Stock	28.57	29.0	28.43	28.48	25000.0
2006-08-14	ABD-DELISTED	Stock	18.26	18.75	18.1	18.29	153700.0
2006-08-14	ABE-DELISTED	Stock	13.02	13.18	12.97	13.17	17200.0
2006-08-14	ABFS-DELISTED	Stock	42.08	43.58	42.08	42.43	367071.0
2006-08-14	ABG	Stock	19.91	20.48	19.91	20.29	57700.0
2006-08-14	ABK-DELISTED	Stock	83.67	83.96	82.93	83.04	643600.0
2006-08-14	ABM	Stock	16.42	16.85	16.31	16.41	87300.0
2006-08-14	ABMD-DELISTED	Stock	13.06	13.24	12.93	13.14	48809.0
2006-08-14	ABP-DELISTED	Stock	4.03	4.03	3.9	3.94	323200.0
2006-08-14	ABR	Stock	24.6	25.0	24.38	24.38	79100.0
2006-08-14	ABT	Stock	22.7473	23.3135	22.7377	23.0112	12076073.0
2006-08-14	ABTL-DELISTED	Stock	15.022	15.325	14.871	14.95	66719.0
2006-08-14	ABV-DELISTED	Stock	40.89	41.28	40.73	40.87	368500.0
2006-08-14	ABVA-DELISTED	Stock	16.55	16.55	16.45	16.45	550.0
2006-08-14	ABX-DELISTED	Stock	31.7	31.7	30.47	30.5	3388700.0
2006-08-14	ACAD	Stock	5.4	5.84	5.39	5.49	216800.0
2006-08-14	ACAP-DELISTED	Stock	47.41	47.54	47.09	47.39	19915.0
2006-08-14	ACAS-DELISTED	Stock	37.39	37.44	37.02	37.14	997126.0
2006-08-14	ACAT-DELISTED	Stock	18.35	18.37	17.25	17.36	72590.0
2006-08-14	ACC-DELISTED	Stock	24.91	25.01	24.75	24.87	82991.0
2006-08-14	ACCL-DELISTED	Stock	6.16	6.35	6.16	6.23	29000.0
2006-08-14	ACCO	Stock	18.26	18.75	18.1	18.29	163800.0

> showing 50 of 4,482 rows — these rows as CSV

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