PREVIEW / stock_daily / 2007-08-16

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-16.parquet
  size:    178 KB
  rows:    5,540
  symbols: 3,350

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
2007-08-16	AAPL	Stock	4.1789	4.2321	3.9864	4.1804	1866690000.0
2007-08-16	MSFT	Stock	27.88	28.35	27.51	27.81	81447400.0
2007-08-16	NVDA	Stock	0.7143	0.7195	0.675	0.7095	780030000.0
2007-08-16	AMZN	Stock	3.6	3.662	3.5025	3.6395	215746000.0
2007-08-16	TLT	Stock	86.87	87.6	86.76	87.14	2410200.0
2007-08-16	CL	Stock	32.275	32.815	31.875	32.72	10346400.0
2007-08-16	A	Stock	23.1044	23.5908	22.7325	23.4478	9505841.0
2007-08-16	AABA-DELISTED	Stock	23.0	23.1	22.5	22.82	27180390.0
2007-08-16	AACC-DELISTED	Stock	8.69	9.2	8.69	9.06	331271.0
2007-08-16	AAI-DELISTED	Stock	9.81	10.33	9.5	9.99	2489500.0
2007-08-16	AAIC-DELISTED	Stock	85.0	89.2	76.2	88.0	3575500.0
2007-08-16	AAME	Stock	3.19	3.19	3.19	3.19	800.0
2007-08-16	AAON	Stock	3.9862	4.1086	3.8835	4.0428	857334.0
2007-08-16	AAP	Stock	31.1	31.2	30.2	30.58	4408900.0
2007-08-16	AATI-DELISTED	Stock	8.46	8.56	8.15	8.3	346761.0
2007-08-16	AAU-DELISTED	Stock	2.41	2.41	1.86	2.15	374100.0
2007-08-16	AAUAF-DELISTED	Stock	2.41	2.41	1.86	2.15	367800.0
2007-08-16	AAV-DELISTED	Stock	11.4	11.55	10.74	11.24	1695000.0
2007-08-16	AAWW-DELISTED	Stock	50.71	52.38	48.34	50.3	212256.0
2007-08-16	AAXN-DELISTED	Stock	13.5	13.72	11.75	13.63	6338048.0
2007-08-16	AB	Stock	74.05	80.0	72.33	79.27	838800.0
2007-08-16	ABAX-DELISTED	Stock	19.17	20.32	18.99	20.27	317787.0
2007-08-16	ABB-DELISTED	Stock	21.27	21.42	20.42	21.23	6101700.0
2007-08-16	ABBC-DELISTED	Stock	9.19	9.2	8.84	9.05	102479.0
2007-08-16	ABBNY-DELISTED	Stock	21.27	21.4222	20.42	21.28	6309600.0
2007-08-16	ABC-DELISTED	Stock	22.18	22.45	21.86	22.26	3410400.0
2007-08-16	ABCB	Stock	18.6844	21.6802	18.6844	21.3884	108570.0
2007-08-16	ABCO-DELISTED	Stock	27.97	29.26	27.97	28.57	445786.0
2007-08-16	ABCW-DELISTED	Stock	23.88	25.8	23.77	25.8	361140.0
2007-08-16	ABD-DELISTED	Stock	23.17	23.51	22.43	23.51	699400.0
2007-08-16	ABE-DELISTED	Stock	17.96	17.96	12.0	17.74	119300.0
2007-08-16	ABEO	Stock	3812.5	4000.0	2625.0	3875.0	45.0
2007-08-16	ABFS-DELISTED	Stock	33.86	35.43	33.51	35.04	604202.0
2007-08-16	ABG	Stock	20.38	20.95	20.16	20.95	797600.0
2007-08-16	ABK-DELISTED	Stock	54.51	58.93	53.1	58.5	6488700.0
2007-08-16	ABM	Stock	21.7	22.46	21.24	21.96	534000.0
2007-08-16	ABMD-DELISTED	Stock	10.96	12.26	10.84	12.25	468872.0
2007-08-16	ABP-DELISTED	Stock	3.68	3.84	3.53	3.8	218700.0
2007-08-16	ABR	Stock	16.35	18.43	16.05	18.38	1193600.0
2007-08-16	ABT	Stock	25.0696	25.1511	24.3642	24.8824	17383285.0
2007-08-16	ABTL-DELISTED	Stock	13.926	14.824	13.476	14.724	45125.0
2007-08-16	ABV-DELISTED	Stock	57.99	57.99	52.45	55.73	1834800.0
2007-08-16	ABVA-DELISTED	Stock	9.6	9.67	9.27	9.6	28507.0
2007-08-16	ABVT-DELISTED	Stock	79.0	79.0	79.0	79.0	500.0
2007-08-16	ABX-DELISTED	Stock	31.27	31.27	28.89	30.14	14461200.0
2007-08-16	ACAD	Stock	15.0	15.21	14.5	15.21	879200.0
2007-08-16	ACAP-DELISTED	Stock	37.34	41.74	37.05	41.34	159008.0
2007-08-16	ACAS-DELISTED	Stock	36.5	38.0	35.0	37.89	4897491.0
2007-08-16	ACAT-DELISTED	Stock	17.2	17.68	16.95	17.45	212007.0
2007-08-16	ACC-DELISTED	Stock	25.46	26.58	25.05	25.7	500900.0

> showing 50 of 5,540 rows — these rows as CSV

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