PREVIEW / stock_daily / 2006-01-27

all stock daily files

  file:    by_date/stock_daily/2006/2006-01-27.parquet
  size:    146 KB
  rows:    4,346
  symbols: 2,751

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-01-27	AAPL	Stock	2.6054	2.6286	2.5393	2.5725	953864800.0
2006-01-27	MSFT	Stock	27.23	27.95	27.19	27.79	134520700.0
2006-01-27	NVDA	Stock	0.3832	0.3897	0.38	0.3854	385044000.0
2006-01-27	AMZN	Stock	2.2275	2.261	2.2265	2.261	83480000.0
2006-01-27	CL	Stock	28.0	28.05	27.55	27.995	6117400.0
2006-01-27	A	Stock	24.392	24.6781	24.3777	24.4206	2827315.0
2006-01-27	AABA-DELISTED	Stock	35.2599983215332	35.2700004577637	34.6599998474121	35.0900001525879	24317400.0
2006-01-27	AACC-DELISTED	Stock	23.78	24.75	23.76	24.75	84938.0
2006-01-27	AACQ-DELISTED	Stock	5.34	5.36	5.34	5.36	2000.0
2006-01-27	AACQU-DELISTED	Stock	6.65	6.65	6.65	6.65	4000.0
2006-01-27	AACQW-DELISTED	Stock	0.68	0.69	0.67	0.68	211500.0
2006-01-27	AAI-DELISTED	Stock	15.73	15.79	15.19	15.75	1967400.0
2006-01-27	AAIC-DELISTED	Stock	233.4	237.0	230.0	234.0	821600.0
2006-01-27	AAME	Stock	2.65	2.65	2.65	2.65	600.0
2006-01-27	AAON	Stock	2.5363	2.6324	2.5363	2.6324	143522.0
2006-01-27	AAP	Stock	43.57	43.97	42.94	43.01	501200.0
2006-01-27	AATI-DELISTED	Stock	13.99	14.1	13.88	13.88	107932.0
2006-01-27	AAU-DELISTED	Stock	2.99	3.05	2.96	2.98	189200.0
2006-01-27	AAUAF-DELISTED	Stock	2.99	3.05	2.96	2.98	189200.0
2006-01-27	AAV-DELISTED	Stock	20.68	20.71	20.5	20.58	531900.0
2006-01-27	AAWW-DELISTED	Stock	44.75	47.0	44.75	45.75	2700.0
2006-01-27	AAXN-DELISTED	Stock	9.97000026702881	9.97000026702881	9.52999973297119	9.65999984741211	2692700.0
2006-01-27	ABAX-DELISTED	Stock	17.37	19.25	17.28	19.11	504446.0
2006-01-27	ABB-DELISTED	Stock	11.01	11.04	10.9	10.94	1593000.0
2006-01-27	ABBC-DELISTED	Stock	13.11	13.18	13.1	13.15	5838.0
2006-01-27	ABC-DELISTED	Stock	21.72	22.2	21.66	22.04	4845200.0
2006-01-27	ABCB	Stock	19.9003	20.4158	19.7447	20.4061	14497.0
2006-01-27	ABCO-DELISTED	Stock	23.86	24.05	23.86	24.0	101248.0
2006-01-27	ABCW-DELISTED	Stock	32.41	32.51	30.76	31.9	135720.0
2006-01-27	ABD-DELISTED	Stock	24.47	24.74	24.37	24.48	162830.0
2006-01-27	ABE-DELISTED	Stock	12.97	13.08	12.82	12.93	34200.0
2006-01-27	ABFS-DELISTED	Stock	43.91	44.25	42.55	42.7	624728.0
2006-01-27	ABG	Stock	17.65	17.86	17.3	17.77	56900.0
2006-01-27	ABK-DELISTED	Stock	76.45	77.2	76.08	76.5	423000.0
2006-01-27	ABM	Stock	19.3	19.39	18.96	19.07	164800.0
2006-01-27	ABMD-DELISTED	Stock	10.94	11.13	10.72	10.87	54734.0
2006-01-27	ABP-DELISTED	Stock	6.5	6.54	6.31	6.42	349400.0
2006-01-27	ABR	Stock	26.3	26.4	26.11	26.23	43200.0
2006-01-27	ABT	Stock	21.0152	21.0392	20.5498	20.6314	12138599.0
2006-01-27	ABTL-DELISTED	Stock	24.68	24.93	23.82	24.27	37129.0
2006-01-27	ABV-DELISTED	Stock	42.4	42.6	41.03	41.2	656900.0
2006-01-27	ABVA-DELISTED	Stock	16.65	16.77	16.59	16.72	6140.0
2006-01-27	ABX-DELISTED	Stock	30.04	30.59	29.91	29.92	7415854.0
2006-01-27	ACAD	Stock	10.52	10.52	10.0	10.24	82600.0
2006-01-27	ACAP-DELISTED	Stock	47.7	48.97	47.7	48.43	18044.0
2006-01-27	ACAS-DELISTED	Stock	34.77	34.8	34.46	34.64	858116.0
2006-01-27	ACAT-DELISTED	Stock	22.84	23.88	22.84	23.05	113946.0
2006-01-27	ACC-DELISTED	Stock	25.01	25.15	24.81	24.87	31000.0
2006-01-27	ACCL-DELISTED	Stock	6.91	7.02	6.61	6.68	63227.0
2006-01-27	ACCO	Stock	24.45	24.72	24.35	24.5	162900.0

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

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