PREVIEW / stock_daily / 2007-04-11

all stock daily files

  file:    by_date/stock_daily/2007/2007-04-11.parquet
  size:    163 KB
  rows:    4,893
  symbols: 3,083

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-04-11	AAPL	Stock	3.3536	3.3554	3.2975	3.3068	549018400.0
2007-04-11	MSFT	Stock	28.3	28.57	27.99	28.11	44050200.0
2007-04-11	NVDA	Stock	0.5015	0.5065	0.4898	0.4915	810150000.0
2007-04-11	AMZN	Stock	2.0865	2.0935	2.062	2.084	101568000.0
2007-04-11	TLT	Stock	87.47	87.58	87.28	87.37	476200.0
2007-04-11	CL	Stock	32.9	32.95	32.705	32.945	3860200.0
2007-04-11	A	Stock	24.9428	25.0	24.7282	24.7639	3634800.0
2007-04-11	AABA-DELISTED	Stock	31.6499996185303	31.7299995422363	30.8999996185303	31.1700000762939	16141100.0
2007-04-11	AACC-DELISTED	Stock	15.63	15.65	15.51	15.56	143737.0
2007-04-11	AACQ-DELISTED	Stock	4.38	4.4	4.36	4.4	11550.0
2007-04-11	AACQU-DELISTED	Stock	5.55	5.55	5.55	5.55	1250.0
2007-04-11	AACQW-DELISTED	Stock	0.61	0.62	0.61	0.62	16100.0
2007-04-11	AAI-DELISTED	Stock	11.24	11.62	11.04	11.56	3846891.0
2007-04-11	AAIC-DELISTED	Stock	111.6	113.0	109.58	109.8	3532883.0
2007-04-11	AAME	Stock	4.12	4.23	3.8	4.23	18100.0
2007-04-11	AAON	Stock	3.4186	3.4186	3.2882	3.308	249075.0
2007-04-11	AAP	Stock	39.87	40.27	39.54	40.15	1507500.0
2007-04-11	AATI-DELISTED	Stock	6.82	6.82	6.64	6.72	246230.0
2007-04-11	AAU-DELISTED	Stock	2.5	2.53	2.41	2.41	53800.0
2007-04-11	AAUAF-DELISTED	Stock	2.5	2.53	2.41	2.41	53800.0
2007-04-11	AAV-DELISTED	Stock	10.37	10.39	10.28	10.32	361100.0
2007-04-11	AAWW-DELISTED	Stock	56.27	56.41	55.36	55.92	129068.0
2007-04-11	AAXN-DELISTED	Stock	7.82999992370605	7.98000001907349	7.82999992370605	7.88000011444092	648600.0
2007-04-11	AB	Stock	91.6	93.14	91.2	92.46	273400.0
2007-04-11	ABAX-DELISTED	Stock	25.51	25.76	25.4	25.53	296896.0
2007-04-11	ABB-DELISTED	Stock	17.97	17.98	17.75	17.82	1887168.0
2007-04-11	ABBC-DELISTED	Stock	20.27	20.38	19.91	19.91	6428.0
2007-04-11	ABC-DELISTED	Stock	26.94	27.02	26.81	26.83	1576578.0
2007-04-11	ABCB	Stock	24.6078	24.6078	23.0516	23.713	36499.0
2007-04-11	ABCO-DELISTED	Stock	25.4	25.61	25.27	25.39	135290.0
2007-04-11	ABCW-DELISTED	Stock	27.6	27.74	27.29	27.5	100160.0
2007-04-11	ABD-DELISTED	Stock	25.2	25.23	24.8	24.9	789500.0
2007-04-11	ABE-DELISTED	Stock	19.85	19.97	19.0	19.5601	21800.0
2007-04-11	ABFS-DELISTED	Stock	36.82	36.99	36.28	36.61	652569.0
2007-04-11	ABG	Stock	27.1	27.38	26.95	27.38	366100.0
2007-04-11	ABK-DELISTED	Stock	85.42	85.63	84.87	84.9	1079838.0
2007-04-11	ABM	Stock	26.76	26.79	26.48	26.75	528000.0
2007-04-11	ABMD-DELISTED	Stock	13.46	13.46	13.0	13.28	323352.0
2007-04-11	ABP-DELISTED	Stock	3.09	3.09	3.0	3.03	71500.0
2007-04-11	ABR	Stock	30.79	31.09	30.21	30.42	66500.0
2007-04-11	ABT	Stock	27.2286	27.5933	26.9504	27.3486	13570446.0
2007-04-11	ABTL-DELISTED	Stock	16.55	16.849	16.351	16.55	11000.0
2007-04-11	ABV-DELISTED	Stock	57.6	57.6	56.59	56.69	273100.0
2007-04-11	ABVA-DELISTED	Stock	14.7	14.79	14.6	14.79	4300.0
2007-04-11	ABX-DELISTED	Stock	29.39	29.55	28.77	28.92	6410939.0
2007-04-11	ACAD	Stock	15.7	15.84	15.23	15.65	598200.0
2007-04-11	ACAP-DELISTED	Stock	39.16	39.16	38.04	38.71	35425.0
2007-04-11	ACAS-DELISTED	Stock	45.8	45.91	45.31	45.6	1066200.0
2007-04-11	ACAT-DELISTED	Stock	19.33	19.33	18.16	18.55	143926.0
2007-04-11	ACC-DELISTED	Stock	30.11	30.11	29.51	29.71	527900.0

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

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