PREVIEW / stock_daily / 2007-01-23

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-23.parquet
  size:    161 KB
  rows:    4,828
  symbols: 3,033

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-01-23	AAPL	Stock	3.0618	3.1254	3.0539	3.0607	1207424400.0
2007-01-23	MSFT	Stock	30.63	30.96	30.52	30.74	49171200.0
2007-01-23	NVDA	Stock	0.5288	0.54	0.519	0.5315	630354000.0
2007-01-23	AMZN	Stock	1.845	1.8535	1.815	1.8215	106272000.0
2007-01-23	TLT	Stock	88.02	88.05	87.57	87.62	1096800.0
2007-01-23	CL	Stock	33.135	33.27	32.96	33.16	2760400.0
2007-01-23	A	Stock	23.1688	23.5479	23.1116	23.3977	3739650.0
2007-01-23	AABA-DELISTED	Stock	27.4200000762939	27.5400009155273	26.8799991607666	26.9599990844727	43728100.0
2007-01-23	AACC-DELISTED	Stock	15.37	15.55	15.31	15.54	87557.0
2007-01-23	AACQ-DELISTED	Stock	5.55	5.58	5.55	5.58	6000.0
2007-01-23	AACQU-DELISTED	Stock	6.76	6.76	6.76	6.76	2500.0
2007-01-23	AACQW-DELISTED	Stock	0.64	0.65	0.64	0.65	69854.0
2007-01-23	AAI-DELISTED	Stock	11.52	11.62	11.0	11.12	3847500.0
2007-01-23	AAIC-DELISTED	Stock	159.6	159.6	154.6	155.6	1233600.0
2007-01-23	AAME	Stock	3.32	3.33	3.32	3.33	1100.0
2007-01-23	AAON	Stock	3.4989	3.5661	3.4989	3.5477	69103.0
2007-01-23	AAP	Stock	37.12	37.65	36.85	37.43	595700.0
2007-01-23	AATI-DELISTED	Stock	5.63	5.72	5.56	5.7	165667.0
2007-01-23	AAU-DELISTED	Stock	2.23	2.27	2.17	2.19	223300.0
2007-01-23	AAUAF-DELISTED	Stock	2.23	2.27	2.17	2.19	223300.0
2007-01-23	AAV-DELISTED	Stock	11.05	11.4	11.0	11.3	1149800.0
2007-01-23	AAWW-DELISTED	Stock	46.68	46.89	46.32	46.77	921165.0
2007-01-23	AAXN-DELISTED	Stock	7.82000017166138	8.07999992370605	7.80000019073486	7.82000017166138	1128100.0
2007-01-23	AB	Stock	88.25	89.12	87.5	88.19	256500.0
2007-01-23	ABAX-DELISTED	Stock	17.63	17.99	17.45	17.84	124164.0
2007-01-23	ABB-DELISTED	Stock	17.64	17.81	17.5899	17.77	1704400.0
2007-01-23	ABBC-DELISTED	Stock	18.9	18.97	18.72	18.78	5519.0
2007-01-23	ABC-DELISTED	Stock	23.74	24.12	23.7	24.1	1961200.0
2007-01-23	ABCB	Stock	26.0182	26.4364	25.8139	26.3003	15216.0
2007-01-23	ABCO-DELISTED	Stock	26.9	27.4	26.85	27.25	153442.0
2007-01-23	ABCW-DELISTED	Stock	28.4	28.65	28.3	28.53	53680.0
2007-01-23	ABD-DELISTED	Stock	24.36	24.88	24.08	24.87	309150.0
2007-01-23	ABE-DELISTED	Stock	18.02	18.7	18.01	18.49	25300.0
2007-01-23	ABFS-DELISTED	Stock	38.21	38.64	37.8	38.55	397210.0
2007-01-23	ABG	Stock	23.56	24.17	23.5	23.8	226700.0
2007-01-23	ABK-DELISTED	Stock	87.05	87.75	86.84	87.61	468800.0
2007-01-23	ABM	Stock	24.35	24.5	24.24	24.3	367200.0
2007-01-23	ABMD-DELISTED	Stock	14.08	14.46	14.07	14.38	50914.0
2007-01-23	ABP-DELISTED	Stock	3.11	3.25	3.11	3.22	221400.0
2007-01-23	ABR	Stock	31.04	31.54	31.0	31.33	78800.0
2007-01-23	ABT	Stock	25.4774	25.6933	25.4294	25.6117	16214673.0
2007-01-23	ABTL-DELISTED	Stock	17.974	17.974	16.376	16.676	28764.0
2007-01-23	ABV-DELISTED	Stock	50.9	51.51	50.51	51.35	344000.0
2007-01-23	ABVA-DELISTED	Stock	16.79	16.79	16.62	16.62	5550.0
2007-01-23	ABVT-DELISTED	Stock	58.95	59.0	58.95	59.0	768.0
2007-01-23	ABX-DELISTED	Stock	28.72	29.38	28.72	29.34	9152800.0
2007-01-23	ACAD	Stock	7.21	7.21	7.0	7.08	191300.0
2007-01-23	ACAP-DELISTED	Stock	35.62	37.02	35.27	36.69	56561.0
2007-01-23	ACAS-DELISTED	Stock	47.17	47.39	46.96	47.33	496809.0
2007-01-23	ACAT-DELISTED	Stock	16.5	17.07	16.45	16.6	67516.0

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

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