PREVIEW / stock_daily / 2006-10-27

all stock daily files

  file:    by_date/stock_daily/2006/2006-10-27.parquet
  size:    152 KB
  rows:    4,547
  symbols: 2,866

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-10-27	AAPL	Stock	2.9196	2.9446	2.8575	2.8718	594966400.0
2006-10-27	MSFT	Stock	28.49	28.79	28.25	28.34	89060100.0
2006-10-27	NVDA	Stock	0.564	0.5765	0.5333	0.5397	566988000.0
2006-10-27	AMZN	Stock	1.9075	1.919	1.883	1.912	199068000.0
2006-10-27	CL	Stock	31.39	31.785	31.365	31.655	5045200.0
2006-10-27	A	Stock	25.3362	25.3577	24.8927	24.9499	3304872.0
2006-10-27	AABA-DELISTED	Stock	25.2299995422363	25.6000003814697	24.8999996185303	25.3400001525879	29647200.0
2006-10-27	AACC-DELISTED	Stock	17.47	17.66	17.2	17.51	53614.0
2006-10-27	AACQ-DELISTED	Stock	5.34	5.38	5.33	5.38	2500.0
2006-10-27	AACQU-DELISTED	Stock	6.1	6.35	6.1	6.35	18600.0
2006-10-27	AACQW-DELISTED	Stock	0.42	0.47	0.42	0.47	189500.0
2006-10-27	AAI-DELISTED	Stock	10.58	10.65	10.15	10.21	2781700.0
2006-10-27	AAIC-DELISTED	Stock	156.2	158.0	151.6	152.6	769000.0
2006-10-27	AAME	Stock	2.85	2.87	2.6	2.72	10900.0
2006-10-27	AAON	Stock	3.1447	3.1447	3.0486	3.0617	110869.0
2006-10-27	AAP	Stock	36.27	36.44	35.84	35.85	650600.0
2006-10-27	AATI-DELISTED	Stock	5.7	6.5	5.42	6.1299	1416519.0
2006-10-27	AAU-DELISTED	Stock	2.42	2.47	2.42	2.42	9200.0
2006-10-27	AAUAF-DELISTED	Stock	2.42	2.47	2.42	2.42	9200.0
2006-10-27	AAV-DELISTED	Stock	14.45	14.49	14.25	14.25	427900.0
2006-10-27	AAWW-DELISTED	Stock	46.38	46.42	45.76	45.87	103159.0
2006-10-27	AAXN-DELISTED	Stock	9.60999965667725	9.8100004196167	9.56999969482422	9.61999988555908	1188100.0
2006-10-27	AB	Stock	77.05	77.05	75.01	76.25	279200.0
2006-10-27	ABAX-DELISTED	Stock	20.71	20.71	19.98	20.14	223570.0
2006-10-27	ABB-DELISTED	Stock	15.08	15.15	14.98	14.98	2280400.0
2006-10-27	ABBC-DELISTED	Stock	16.12	16.2	15.98	15.98	6121.0
2006-10-27	ABC-DELISTED	Stock	23.2	23.37	22.94	23.36	1848600.0
2006-10-27	ABCB	Stock	27.0394	27.2826	27.0394	27.0589	35984.0
2006-10-27	ABCO-DELISTED	Stock	27.88	27.99	26.99	27.1	168459.0
2006-10-27	ABCW-DELISTED	Stock	29.55	29.62	29.05	29.05	16860.0
2006-10-27	ABD-DELISTED	Stock	24.55	24.6	24.14	24.2	316500.0
2006-10-27	ABE-DELISTED	Stock	15.82	15.99	15.78	15.93	32400.0
2006-10-27	ABFS-DELISTED	Stock	40.75	42.13	40.56	41.16	677034.0
2006-10-27	ABG	Stock	24.35	24.46	23.53	23.8	812600.0
2006-10-27	ABK-DELISTED	Stock	84.91	85.18	83.94	84.01	529500.0
2006-10-27	ABM	Stock	19.9	19.95	19.72	19.73	101100.0
2006-10-27	ABMD-DELISTED	Stock	14.32	14.5	14.26	14.37	58499.0
2006-10-27	ABP-DELISTED	Stock	3.8	3.88	3.66	3.69	87600.0
2006-10-27	ABR	Stock	27.88	28.0	27.64	27.71	35300.0
2006-10-27	ABT	Stock	22.7665	22.9009	22.6706	22.8721	10186119.0
2006-10-27	ABTL-DELISTED	Stock	16.649	17.051	16.549	17.001	5038.0
2006-10-27	ABV-DELISTED	Stock	43.36	43.36	42.65	42.77	751500.0
2006-10-27	ABVA-DELISTED	Stock	17.1	17.1	16.58	17.08	1173.0
2006-10-27	ABVT-DELISTED	Stock	60.0	63.0	60.0	63.0	243517.0
2006-10-27	ABX-DELISTED	Stock	30.63	30.75	29.83	29.96	4541240.0
2006-10-27	ACAD	Stock	9.68	9.93	9.54	9.57	414700.0
2006-10-27	ACAP-DELISTED	Stock	53.99	54.48	53.53	53.55	26916.0
2006-10-27	ACAS-DELISTED	Stock	42.77	43.25	42.65	42.8	843900.0
2006-10-27	ACAT-DELISTED	Stock	17.89	18.13	17.35	17.47	86378.0
2006-10-27	ACC-DELISTED	Stock	26.52	26.65	26.41	26.42	103600.0

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

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