PREVIEW / stock_daily / 2006-07-27

all stock daily files

  file:    by_date/stock_daily/2006/2006-07-27.parquet
  size:    148 KB
  rows:    4,458
  symbols: 2,805

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-07-27	AAPL	Stock	2.3036	2.3221	2.245	2.2643	735044800.0
2006-07-27	MSFT	Stock	24.58	24.6	23.77	23.87	85386800.0
2006-07-27	NVDA	Stock	0.3418	0.3558	0.3362	0.3423	694338000.0
2006-07-27	AMZN	Stock	1.3225	1.34	1.3105	1.328	527876000.0
2006-07-27	CL	Stock	29.775	29.875	29.32	29.46	5336000.0
2006-07-27	A	Stock	20.0286	20.1574	19.6638	19.6924	4963459.0
2006-07-27	AABA-DELISTED	Stock	27.3500003814697	27.5	26.6399993896484	26.7000007629395	25153000.0
2006-07-27	AACC-DELISTED	Stock	18.37	18.47	17.48	17.61	88592.0
2006-07-27	AACQ-DELISTED	Stock	5.34	5.34	5.34	5.34	175000.0
2006-07-27	AACQW-DELISTED	Stock	0.35	0.39	0.35	0.38	218918.0
2006-07-27	AAI-DELISTED	Stock	13.5	13.84	12.76	12.82	2533700.0
2006-07-27	AAIC-DELISTED	Stock	192.8	195.6	186.0	189.4	1179700.0
2006-07-27	AAME	Stock	2.81	2.82	2.81	2.82	300.0
2006-07-27	AAON	Stock	3.1381	3.1908	3.0025	3.0446	321975.0
2006-07-27	AAP	Stock	31.54	31.81	30.45	30.51	881900.0
2006-07-27	AATI-DELISTED	Stock	9.35	9.65	9.02	9.14	81901.0
2006-07-27	AAU-DELISTED	Stock	2.4	2.44	2.35	2.39	49000.0
2006-07-27	AAUAF-DELISTED	Stock	2.4	2.44	2.35	2.39	49000.0
2006-07-27	AAV-DELISTED	Stock	16.36	16.36	16.01	16.07	409300.0
2006-07-27	AAWW-DELISTED	Stock	42.0	42.15	40.79	40.95	37436.0
2006-07-27	AAXN-DELISTED	Stock	7.65000009536743	7.65999984741211	7.21999979019165	7.23999977111816	2519300.0
2006-07-27	AB	Stock	61.75	64.35	61.66	64.09	498100.0
2006-07-27	ABAX-DELISTED	Stock	20.67	21.08	20.47	20.52	277398.0
2006-07-27	ABB-DELISTED	Stock	12.66	12.71	12.51	12.55	2590800.0
2006-07-27	ABBC-DELISTED	Stock	14.41	14.55	14.25	14.34	13445.0
2006-07-27	ABC-DELISTED	Stock	21.66	21.68	21.38	21.48	1762800.0
2006-07-27	ABCB	Stock	22.8571	23.3434	22.5848	23.3239	65492.0
2006-07-27	ABCO-DELISTED	Stock	23.75	23.92	23.14	23.14	152371.0
2006-07-27	ABCW-DELISTED	Stock	30.06	30.18	29.08	29.22	23410.0
2006-07-27	ABD-DELISTED	Stock	19.53	19.82	19.31	19.5	98100.0
2006-07-27	ABE-DELISTED	Stock	12.48	12.54	12.4	12.5	18700.0
2006-07-27	ABFS-DELISTED	Stock	44.69	45.5	43.38	43.44	823925.0
2006-07-27	ABG	Stock	20.45	20.75	20.25	20.28	198500.0
2006-07-27	ABK-DELISTED	Stock	84.55	84.66	82.79	82.95	1019100.0
2006-07-27	ABM	Stock	16.9	16.96	16.34	16.44	141300.0
2006-07-27	ABMD-DELISTED	Stock	13.78	13.95	13.25	13.4	156425.0
2006-07-27	ABP-DELISTED	Stock	4.4	4.47	4.2	4.29	326100.0
2006-07-27	ABR	Stock	25.06	25.62	25.0	25.25	127100.0
2006-07-27	ABT	Stock	22.5506	22.8817	22.541	22.6562	10701959.0
2006-07-27	ABTL-DELISTED	Stock	16.036	16.235	15.687	16.114	57451.0
2006-07-27	ABV-DELISTED	Stock	40.75	41.18	39.76	39.77	370900.0
2006-07-27	ABVA-DELISTED	Stock	15.83	15.94	15.72	15.94	691.0
2006-07-27	ABX-DELISTED	Stock	30.6	30.9	29.37	29.6	4482100.0
2006-07-27	ACAD	Stock	6.64	6.86	6.36	6.53	127700.0
2006-07-27	ACAP-DELISTED	Stock	47.52	47.52	46.16	46.99	53890.0
2006-07-27	ACAS-DELISTED	Stock	34.99	35.0	34.47	34.66	971438.0
2006-07-27	ACAT-DELISTED	Stock	18.515	19.276	17.925	18.535	119494.0
2006-07-27	ACC-DELISTED	Stock	25.77	25.88	25.33	25.37	37555.0
2006-07-27	ACCL-DELISTED	Stock	6.29	6.36	6.14	6.25	27510.0
2006-07-27	ACCO	Stock	19.53	19.82	19.31	19.5	107300.0

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

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