PREVIEW / stock_daily / 2007-02-22

all stock daily files

  file:    by_date/stock_daily/2007/2007-02-22.parquet
  size:    162 KB
  rows:    4,853
  symbols: 3,055

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-02-22	AAPL	Stock	3.2429	3.2432	3.1618	3.1968	838224800.0
2007-02-22	MSFT	Stock	29.31	29.54	29.16	29.39	57754400.0
2007-02-22	NVDA	Stock	0.5505	0.5593	0.5442	0.5455	655452000.0
2007-02-22	AMZN	Stock	2.07	2.1	2.0445	2.05	98522000.0
2007-02-22	TLT	Stock	88.41	88.45	88.0899	88.21	485200.0
2007-02-22	CL	Stock	34.1	34.205	33.97	34.18	2997600.0
2007-02-22	A	Stock	23.4692	23.7124	23.4692	23.6052	4689451.0
2007-02-22	AABA-DELISTED	Stock	31.6000003814697	32.0800018310547	31.3199996948242	31.6000003814697	15485100.0
2007-02-22	AACC-DELISTED	Stock	15.55	15.7	15.42	15.52	56136.0
2007-02-22	AACQ-DELISTED	Stock	5.51	5.55	5.34	5.34	200750.0
2007-02-22	AACQU-DELISTED	Stock	7.24	7.3	7.24	7.25	2000.0
2007-02-22	AACQW-DELISTED	Stock	0.8	0.9	0.78	0.78	557100.0
2007-02-22	AAI-DELISTED	Stock	11.52	11.52	11.24	11.3	1258500.0
2007-02-22	AAIC-DELISTED	Stock	150.0	158.0	148.0	151.8	5282500.0
2007-02-22	AAME	Stock	3.95	3.96	3.72	3.81	6100.0
2007-02-22	AAON	Stock	3.8295	3.8558	3.7347	3.7807	324253.0
2007-02-22	AAP	Stock	38.3	38.39	38.25	38.38	514500.0
2007-02-22	AATI-DELISTED	Stock	6.49	6.49	6.32	6.36	252594.0
2007-02-22	AAU-DELISTED	Stock	2.41	2.41	2.27	2.3	67000.0
2007-02-22	AAUAF-DELISTED	Stock	2.41	2.41	2.27	2.3	67000.0
2007-02-22	AAV-DELISTED	Stock	10.62	10.75	10.59	10.69	577200.0
2007-02-22	AAWW-DELISTED	Stock	49.87	50.58	49.77	50.34	71342.0
2007-02-22	AAXN-DELISTED	Stock	8.72999954223633	8.72999954223633	8.42000007629395	8.43000030517578	2156400.0
2007-02-22	AB	Stock	92.31	92.44	91.58	91.99	88900.0
2007-02-22	ABAX-DELISTED	Stock	23.65	23.65	22.98	23.39	146767.0
2007-02-22	ABB-DELISTED	Stock	17.87	17.96	17.82	17.92	1975500.0
2007-02-22	ABBC-DELISTED	Stock	19.57	19.71	19.27	19.71	3390.0
2007-02-22	ABC-DELISTED	Stock	27.42	27.5	27.34	27.42	1247200.0
2007-02-22	ABCB	Stock	23.2364	24.0534	23.217	23.9951	192363.0
2007-02-22	ABCO-DELISTED	Stock	26.92	27.06	26.83	27.05	121020.0
2007-02-22	ABCW-DELISTED	Stock	29.22	29.28	29.05	29.26	89510.0
2007-02-22	ABD-DELISTED	Stock	22.64	22.92	22.46	22.64	708410.0
2007-02-22	ABE-DELISTED	Stock	19.19	19.5	19.17	19.31	31400.0
2007-02-22	ABFS-DELISTED	Stock	41.58	41.75	41.15	41.51	262922.0
2007-02-22	ABG	Stock	26.98	27.03	26.83	26.98	201000.0
2007-02-22	ABK-DELISTED	Stock	90.6	90.75	90.13	90.6	625800.0
2007-02-22	ABM	Stock	27.15	27.6	27.01	27.6	204200.0
2007-02-22	ABMD-DELISTED	Stock	14.69	15.0	14.51	14.99	71994.0
2007-02-22	ABP-DELISTED	Stock	3.08	3.08	3.01	3.07	113800.0
2007-02-22	ABR	Stock	33.43	33.94	33.43	33.75	100900.0
2007-02-22	ABT	Stock	25.2903	25.7605	25.2615	25.7269	14388704.0
2007-02-22	ABTL-DELISTED	Stock	19.95	20.05	19.699	19.9	13729.0
2007-02-22	ABV-DELISTED	Stock	52.5	53.93	52.5	53.41	797500.0
2007-02-22	ABVA-DELISTED	Stock	16.15	16.15	16.0	16.02	8726.0
2007-02-22	ABX-DELISTED	Stock	32.0	32.56	31.4	31.45	6368700.0
2007-02-22	ACAD	Stock	7.36	7.72	7.36	7.49	210600.0
2007-02-22	ACAP-DELISTED	Stock	38.66	38.66	38.12	38.5	25662.0
2007-02-22	ACAS-DELISTED	Stock	46.81	47.34	46.78	47.13	834967.0
2007-02-22	ACAT-DELISTED	Stock	18.83	18.86	18.47	18.55	51089.0
2007-02-22	ACC-DELISTED	Stock	31.5	31.76	31.0	31.76	88600.0

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

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