PREVIEW / stock_daily / 2007-03-23

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-23.parquet
  size:    162 KB
  rows:    4,865
  symbols: 3,052

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-03-23	AAPL	Stock	3.3339	3.3596	3.3321	3.34	450884000.0
2007-03-23	MSFT	Stock	28.22	28.27	27.8	28.02	50519800.0
2007-03-23	NVDA	Stock	0.5067	0.5157	0.5012	0.5048	524640000.0
2007-03-23	AMZN	Stock	1.978	1.98	1.949	1.949	58830000.0
2007-03-23	TLT	Stock	89.19	89.2	88.78	88.79	1679700.0
2007-03-23	CL	Stock	33.5	33.59	33.375	33.56	2764400.0
2007-03-23	A	Stock	23.226	24.0987	23.226	23.7625	4695183.0
2007-03-23	AABA-DELISTED	Stock	31.3299999237061	31.7000007629395	31.1599998474121	31.3600006103516	12727900.0
2007-03-23	AACC-DELISTED	Stock	15.64	15.78	15.56	15.71	106780.0
2007-03-23	AACQ-DELISTED	Stock	4.5	4.5	4.34	4.44	295800.0
2007-03-23	AACQU-DELISTED	Stock	5.7	5.7	5.5	5.5	5400.0
2007-03-23	AACQW-DELISTED	Stock	0.59	0.59	0.56	0.57	93500.0
2007-03-23	AAI-DELISTED	Stock	10.85	10.9	10.63	10.71	1254200.0
2007-03-23	AAIC-DELISTED	Stock	117.6	118.0	112.2	112.2	4167900.0
2007-03-23	AAME	Stock	3.9	3.99	3.82	3.97	7000.0
2007-03-23	AAON	Stock	3.6214	3.6214	3.524	3.5345	197437.0
2007-03-23	AAP	Stock	39.1	39.5	39.1	39.35	532600.0
2007-03-23	AATI-DELISTED	Stock	6.9	7.0	6.8	6.9	206342.0
2007-03-23	AAU-DELISTED	Stock	2.09	2.09	1.99	2.08	56600.0
2007-03-23	AAUAF-DELISTED	Stock	2.09	2.09	1.99	2.08	56600.0
2007-03-23	AAV-DELISTED	Stock	10.65	10.71	10.55	10.68	906300.0
2007-03-23	AAWW-DELISTED	Stock	53.79	54.13	53.26	53.63	57695.0
2007-03-23	AAXN-DELISTED	Stock	8.38000011444092	8.39999961853027	8.14999961853027	8.26000022888184	912700.0
2007-03-23	AB	Stock	85.5	87.09	85.5	86.57	245600.0
2007-03-23	ABAX-DELISTED	Stock	24.8	25.17	24.75	24.99	185680.0
2007-03-23	ABB-DELISTED	Stock	17.62	17.649	17.52	17.56	1035800.0
2007-03-23	ABBC-DELISTED	Stock	20.02	20.11	19.98	20.0	6066.0
2007-03-23	ABC-DELISTED	Stock	27.08	27.08	26.6	26.96	1574800.0
2007-03-23	ABCB	Stock	24.7538	24.8121	24.0631	24.0826	16964.0
2007-03-23	ABCO-DELISTED	Stock	25.74	26.06	25.74	25.97	124624.0
2007-03-23	ABCW-DELISTED	Stock	28.55	28.84	28.54	28.69	32490.0
2007-03-23	ABD-DELISTED	Stock	22.74	23.07	22.74	22.81	203020.0
2007-03-23	ABE-DELISTED	Stock	18.57	18.6	18.5	18.59	21100.0
2007-03-23	ABFS-DELISTED	Stock	37.04	37.5	36.96	37.12	448214.0
2007-03-23	ABG	Stock	28.14	28.18	27.98	28.1	200300.0
2007-03-23	ABK-DELISTED	Stock	87.45	87.83	87.15	87.49	504800.0
2007-03-23	ABM	Stock	25.94	26.09	25.89	26.0	268200.0
2007-03-23	ABMD-DELISTED	Stock	13.76	13.97	13.5	13.59	407073.0
2007-03-23	ABP-DELISTED	Stock	3.22	3.22	3.11	3.21	197100.0
2007-03-23	ABR	Stock	30.55	30.68	30.32	30.53	78200.0
2007-03-23	ABT	Stock	26.2115	26.2259	25.7892	25.842	13322009.0
2007-03-23	ABTL-DELISTED	Stock	18.0	18.151	17.248	17.65	16342.0
2007-03-23	ABV-DELISTED	Stock	51.96	54.13	51.96	54.03	230100.0
2007-03-23	ABVA-DELISTED	Stock	15.89	15.89	15.16	15.39	6700.0
2007-03-23	ABVT-DELISTED	Stock	58.0	59.0	58.0	59.0	5052.0
2007-03-23	ABX-DELISTED	Stock	29.09	29.18	28.78	29.09	4269730.0
2007-03-23	ACAD	Stock	13.53	15.07	13.41	14.45	2982100.0
2007-03-23	ACAP-DELISTED	Stock	38.81	39.16	38.62	38.98	28809.0
2007-03-23	ACAS-DELISTED	Stock	44.8	44.88	44.61	44.85	1475660.0
2007-03-23	ACAT-DELISTED	Stock	19.34	19.49	19.17	19.21	81749.0

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

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