PREVIEW / stock_daily / 2006-06-14

all stock daily files

  file:    by_date/stock_daily/2006/2006-06-14.parquet
  size:    147 KB
  rows:    4,431
  symbols: 2,789

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-06-14	AAPL	Stock	2.0814	2.0993	2.0246	2.0575	878136000.0
2006-06-14	MSFT	Stock	21.59	21.94	21.55	21.88	86081500.0
2006-06-14	NVDA	Stock	0.333	0.3417	0.3295	0.3407	480492000.0
2006-06-14	AMZN	Stock	1.675	1.6995	1.654	1.684	97382000.0
2006-06-14	CL	Stock	30.65	30.72	29.875	30.175	7676800.0
2006-06-14	A	Stock	22.4964	22.8541	22.4249	22.8326	6152318.0
2006-06-14	AABA-DELISTED	Stock	29.8099994659424	30.0	29.25	29.6200008392334	19257500.0
2006-06-14	AACC-DELISTED	Stock	18.55	18.66	18.28	18.3	174954.0
2006-06-14	AACQW-DELISTED	Stock	0.48	0.48	0.48	0.48	1000.0
2006-06-14	AAI-DELISTED	Stock	12.0	12.58	11.99	12.56	2451800.0
2006-06-14	AAIC-DELISTED	Stock	199.8	200.0	194.8	195.6	1052400.0
2006-06-14	AAME	Stock	3.01	3.02	3.01	3.02	500.0
2006-06-14	AAON	Stock	2.6877	2.8155	2.6614	2.8155	386522.0
2006-06-14	AAP	Stock	36.49	37.04	36.17	36.48	561200.0
2006-06-14	AATI-DELISTED	Stock	10.86	10.9	10.63	10.77	65981.0
2006-06-14	AAU-DELISTED	Stock	2.17	2.32	2.17	2.2	43700.0
2006-06-14	AAUAF-DELISTED	Stock	2.17	2.32	2.17	2.2	43700.0
2006-06-14	AAV-DELISTED	Stock	16.93	17.9	16.93	17.84	399100.0
2006-06-14	AAWW-DELISTED	Stock	48.01	49.37	48.0	49.37	16682.0
2006-06-14	AAXN-DELISTED	Stock	7.55000019073486	8.30000019073486	7.51000022888184	8.02000045776367	2964100.0
2006-06-14	AB	Stock	58.6	58.64	57.15	57.67	336400.0
2006-06-14	ABAX-DELISTED	Stock	17.7	18.05	17.05	17.98	276796.0
2006-06-14	ABB-DELISTED	Stock	10.8	11.02	10.78	11.02	3746300.0
2006-06-14	ABBC-DELISTED	Stock	14.58	15.17	14.58	14.91	16215.0
2006-06-14	ABC-DELISTED	Stock	20.32	20.62	20.31	20.48	2200800.0
2006-06-14	ABCB	Stock	19.9391	20.1337	19.9391	20.124	13880.0
2006-06-14	ABCO-DELISTED	Stock	23.72	24.05	23.59	23.85	101732.0
2006-06-14	ABCW-DELISTED	Stock	29.2	29.47	28.9	29.33	44850.0
2006-06-14	ABD-DELISTED	Stock	21.81	22.01	21.51	21.61	221000.0
2006-06-14	ABE-DELISTED	Stock	10.67	11.4	10.64	11.18	36700.0
2006-06-14	ABFS-DELISTED	Stock	41.0	41.3	40.16	40.94	230351.0
2006-06-14	ABG	Stock	20.83	21.1	20.67	20.84	51200.0
2006-06-14	ABK-DELISTED	Stock	77.87	77.96	76.79	77.24	828300.0
2006-06-14	ABM	Stock	17.3	17.47	17.04	17.43	135600.0
2006-06-14	ABMD-DELISTED	Stock	12.78	12.82	12.43	12.66	185020.0
2006-06-14	ABP-DELISTED	Stock	4.04	4.36	4.02	4.31	287700.0
2006-06-14	ABR	Stock	23.55	24.0	23.26	23.75	164000.0
2006-06-14	ABT	Stock	20.2476	20.6074	20.2428	20.4875	10675281.0
2006-06-14	ABTL-DELISTED	Stock	14.951	15.599	14.702	15.599	94776.0
2006-06-14	ABV-DELISTED	Stock	35.0	36.15	34.74	35.12	1252000.0
2006-06-14	ABVA-DELISTED	Stock	16.49	16.49	16.35	16.38	77842.0
2006-06-14	ABX-DELISTED	Stock	27.27	27.7	26.7	27.2	5829300.0
2006-06-14	ACAD	Stock	8.57	8.88	8.48	8.73	162800.0
2006-06-14	ACAP-DELISTED	Stock	44.99	45.43	44.61	45.17	54071.0
2006-06-14	ACAS-DELISTED	Stock	32.58	32.7	32.33	32.56	739738.0
2006-06-14	ACAT-DELISTED	Stock	17.21	17.3	17.0	17.27	53800.0
2006-06-14	ACC-DELISTED	Stock	23.97	24.0	23.7	23.82	161000.0
2006-06-14	ACCL-DELISTED	Stock	7.32	7.44	7.24	7.24	192663.0
2006-06-14	ACCO	Stock	21.81	22.01	21.51	21.61	225500.0
2006-06-14	ACCP-DELISTED	Stock	0.95	0.95	0.75	0.85	1690.0

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

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