PREVIEW / stock_daily / 2006-06-16

all stock daily files

  file:    by_date/stock_daily/2006/2006-06-16.parquet
  size:    148 KB
  rows:    4,415
  symbols: 2,780

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-16	AAPL	Stock	2.1057	2.1139	2.0543	2.0557	838101600.0
2006-06-16	MSFT	Stock	21.97	22.28	21.79	22.1	147506500.0
2006-06-16	NVDA	Stock	0.368	0.369	0.3575	0.361	503448000.0
2006-06-16	AMZN	Stock	1.744	1.763	1.735	1.7545	102702000.0
2006-06-16	CL	Stock	30.2	30.635	30.17	30.345	6999200.0
2006-06-16	A	Stock	23.7625	23.9771	23.6481	23.8555	3529391.0
2006-06-16	AABA-DELISTED	Stock	30.7000007629395	30.8600006103516	30.1499996185303	30.3600006103516	12951700.0
2006-06-16	AACC-DELISTED	Stock	19.37	19.46	19.02	19.12	302749.0
2006-06-16	AAI-DELISTED	Stock	13.82	14.25	13.63	13.71	2152600.0
2006-06-16	AAIC-DELISTED	Stock	204.0	204.0	200.8	202.2	602500.0
2006-06-16	AAON	Stock	2.9406	3.0723	2.6838	2.8892	1149694.0
2006-06-16	AAP	Stock	37.87	38.19	37.4	37.56	561600.0
2006-06-16	AATI-DELISTED	Stock	10.58	10.58	10.21	10.4	102063.0
2006-06-16	AAU-DELISTED	Stock	2.42	2.45	2.3	2.36	68700.0
2006-06-16	AAUAF-DELISTED	Stock	2.42	2.45	2.3	2.36	68700.0
2006-06-16	AAV-DELISTED	Stock	18.74	18.8	18.39	18.63	428600.0
2006-06-16	AAWW-DELISTED	Stock	49.99	50.51	49.87	50.0	222042.0
2006-06-16	AAXN-DELISTED	Stock	8.26000022888184	8.3100004196167	7.92000007629395	8.22000026702881	1452400.0
2006-06-16	AB	Stock	60.3	60.3	59.55	59.85	147400.0
2006-06-16	ABAX-DELISTED	Stock	19.33	19.47	18.95	19.41	353082.0
2006-06-16	ABB-DELISTED	Stock	11.56	11.7	11.51	11.66	1741400.0
2006-06-16	ABBC-DELISTED	Stock	15.64	15.72	15.44	15.51	42846.0
2006-06-16	ABC-DELISTED	Stock	20.82	20.92	20.6	20.64	1957800.0
2006-06-16	ABCB	Stock	21.5537	21.7677	20.5422	21.0577	187016.0
2006-06-16	ABCO-DELISTED	Stock	24.4	24.4	23.57	23.95	321446.0
2006-06-16	ABCW-DELISTED	Stock	29.43	29.65	29.08	29.15	155710.0
2006-06-16	ABD-DELISTED	Stock	22.12	22.13	21.92	21.98	177720.0
2006-06-16	ABE-DELISTED	Stock	12.15	12.33	12.0411	12.3	22800.0
2006-06-16	ABFS-DELISTED	Stock	42.33	43.26	41.79	42.1	368545.0
2006-06-16	ABG	Stock	21.44	21.44	20.91	21.34	202500.0
2006-06-16	ABK-DELISTED	Stock	79.22	79.5	78.56	78.9	683600.0
2006-06-16	ABM	Stock	17.93	17.96	17.44	17.54	566700.0
2006-06-16	ABMD-DELISTED	Stock	12.6	13.11	12.55	12.82	144969.0
2006-06-16	ABP-DELISTED	Stock	4.7	4.75	4.5	4.7	285900.0
2006-06-16	ABR	Stock	24.35	24.42	23.7	23.81	266200.0
2006-06-16	ABT	Stock	20.4971	20.6026	20.4299	20.5258	9296165.0
2006-06-16	ABTL-DELISTED	Stock	15.9	16.2	15.0	15.5	98390.0
2006-06-16	ABV-DELISTED	Stock	37.2	37.78	36.14	37.07	651800.0
2006-06-16	ABVA-DELISTED	Stock	16.57	16.66	16.51	16.66	400.0
2006-06-16	ABX-DELISTED	Stock	27.76	27.95	27.52	27.71	4591800.0
2006-06-16	ACAD	Stock	9.16	9.28	8.75	8.87	604300.0
2006-06-16	ACAP-DELISTED	Stock	47.37	47.37	45.43	45.88	58313.0
2006-06-16	ACAS-DELISTED	Stock	33.1	33.17	32.79	33.0	610080.0
2006-06-16	ACAT-DELISTED	Stock	18.06	18.22	16.99	17.06	118089.0
2006-06-16	ACC-DELISTED	Stock	24.2	24.25	23.76	23.94	144300.0
2006-06-16	ACCL-DELISTED	Stock	7.03	7.07	6.9	6.94	96612.0
2006-06-16	ACCO	Stock	22.12	22.13	21.92	21.98	181200.0
2006-06-16	ACCP-DELISTED	Stock	0.75	0.75	0.75	0.75	329.0
2006-06-16	ACE-DELISTED	Stock	48.8	49.01	48.45	48.58	2847600.0
2006-06-16	ACF-DELISTED	Stock	27.46	27.46	26.89	27.04	2345500.0

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

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