PREVIEW / stock_daily / 2007-02-26

all stock daily files

  file:    by_date/stock_daily/2007/2007-02-26.parquet
  size:    163 KB
  rows:    4,847
  symbols: 3,044

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-26	AAPL	Stock	3.2086	3.2143	3.1289	3.1611	615848800.0
2007-02-26	MSFT	Stock	28.96	29.09	28.82	29.07	63481900.0
2007-02-26	NVDA	Stock	0.5457	0.5498	0.535	0.5358	494070000.0
2007-02-26	AMZN	Stock	2.043	2.06	2.02	2.044	80704000.0
2007-02-26	TLT	Stock	89.15	89.44	89.11	89.43	763333.0
2007-02-26	CL	Stock	34.265	34.38	34.02	34.235	2831800.0
2007-02-26	A	Stock	23.7911	23.8627	23.6123	23.8054	4141295.0
2007-02-26	AABA-DELISTED	Stock	32.7999992370605	32.8400001525879	30.8500003814697	32.1100006103516	28295200.0
2007-02-26	AACC-DELISTED	Stock	15.52	15.52	15.13	15.2	63268.0
2007-02-26	AACQ-DELISTED	Stock	5.34	5.4	5.34	5.35	20950.0
2007-02-26	AACQW-DELISTED	Stock	0.77	0.82	0.77	0.77	20025.0
2007-02-26	AAI-DELISTED	Stock	11.15	11.15	10.74	10.76	1456771.0
2007-02-26	AAIC-DELISTED	Stock	145.0	146.0	141.0	143.0	1775189.0
2007-02-26	AAME	Stock	3.93	3.93	3.6	3.6	17500.0
2007-02-26	AAON	Stock	3.761	3.761	3.7123	3.736	137447.0
2007-02-26	AAP	Stock	38.71	38.8	38.49	38.73	795500.0
2007-02-26	AATI-DELISTED	Stock	6.58	6.92	6.58	6.75	503029.0
2007-02-26	AAU-DELISTED	Stock	2.3	2.45	2.3	2.44	76871.0
2007-02-26	AAUAF-DELISTED	Stock	2.3	2.45	2.3	2.44	76871.0
2007-02-26	AAV-DELISTED	Stock	10.8	10.82	10.71	10.77	500217.0
2007-02-26	AAWW-DELISTED	Stock	50.15	50.26	49.44	50.01	93351.0
2007-02-26	AAXN-DELISTED	Stock	8.57999992370605	8.68000030517578	8.39000034332275	8.42000007629395	1030200.0
2007-02-26	AB	Stock	89.01	90.25	87.62	88.41	273700.0
2007-02-26	ABAX-DELISTED	Stock	24.0	24.23	23.89	24.06	196045.0
2007-02-26	ABB-DELISTED	Stock	17.99	18.01	17.79	17.89	1323633.0
2007-02-26	ABBC-DELISTED	Stock	19.37	19.57	19.31	19.57	6342.0
2007-02-26	ABC-DELISTED	Stock	27.46	27.48	26.79	27.02	1907215.0
2007-02-26	ABCB	Stock	23.8784	23.8784	23.4406	23.7713	51509.0
2007-02-26	ABCO-DELISTED	Stock	27.07	27.26	26.89	27.04	116130.0
2007-02-26	ABCW-DELISTED	Stock	29.05	29.24	28.6	28.83	29760.0
2007-02-26	ABD-DELISTED	Stock	22.72	22.72	22.44	22.6	366000.0
2007-02-26	ABE-DELISTED	Stock	20.14	20.75	19.44	19.44	76795.0
2007-02-26	ABFS-DELISTED	Stock	42.73	42.73	41.28	41.81	757017.0
2007-02-26	ABG	Stock	27.05	27.13	26.66	26.85	316800.0
2007-02-26	ABK-DELISTED	Stock	88.76	89.73	88.76	89.39	364119.0
2007-02-26	ABM	Stock	27.52	27.52	27.06	27.36	144500.0
2007-02-26	ABMD-DELISTED	Stock	14.78	14.78	14.45	14.51	52605.0
2007-02-26	ABP-DELISTED	Stock	3.22	3.22	3.1	3.17	179265.0
2007-02-26	ABR	Stock	33.0	33.0	31.33	32.19	322700.0
2007-02-26	ABT	Stock	25.7413	26.2259	25.6645	26.1347	16012922.0
2007-02-26	ABTL-DELISTED	Stock	19.7	19.95	19.451	19.95	4551.0
2007-02-26	ABV-DELISTED	Stock	52.73	52.85	51.93	52.3	220405.0
2007-02-26	ABVA-DELISTED	Stock	15.92	16.0	15.9	16.0	2100.0
2007-02-26	ABX-DELISTED	Stock	31.3	31.55	31.0	31.37	4322099.0
2007-02-26	ACAD	Stock	7.98	7.98	7.55	7.58	205800.0
2007-02-26	ACAP-DELISTED	Stock	37.98	38.03	37.62	37.73	19088.0
2007-02-26	ACAS-DELISTED	Stock	47.215	47.215	46.21	46.21	865707.0
2007-02-26	ACAT-DELISTED	Stock	18.57	19.27	18.56	18.98	66818.0
2007-02-26	ACC-DELISTED	Stock	31.63	31.63	30.52	31.24	136760.0
2007-02-26	ACCL-DELISTED	Stock	6.25	6.62	6.2	6.39	81470.0

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

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