PREVIEW / stock_daily / 2007-03-26

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-26.parquet
  size:    162 KB
  rows:    4,882
  symbols: 3,072

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-26	AAPL	Stock	3.3568	3.425	3.3321	3.4232	864987200.0
2007-03-26	MSFT	Stock	27.94	28.22	27.7	28.22	47491500.0
2007-03-26	NVDA	Stock	0.5052	0.51	0.4967	0.5058	447336000.0
2007-03-26	AMZN	Stock	1.949	1.9525	1.9215	1.9505	70422000.0
2007-03-26	TLT	Stock	88.62	89.27	88.5	88.9	763594.0
2007-03-26	CL	Stock	33.595	33.595	33.13	33.47	2748200.0
2007-03-26	A	Stock	23.6195	23.8484	23.1903	23.8484	4143672.0
2007-03-26	AABA-DELISTED	Stock	31.25	31.7399997711182	31.2399997711182	31.6599998474121	12907000.0
2007-03-26	AACC-DELISTED	Stock	15.67	15.75	15.42	15.71	158492.0
2007-03-26	AACQ-DELISTED	Stock	4.5	4.5	4.34	4.44	295800.0
2007-03-26	AACQU-DELISTED	Stock	5.7	5.7	5.5	5.5	5400.0
2007-03-26	AACQW-DELISTED	Stock	0.59	0.59	0.56	0.57	93500.0
2007-03-26	AAI-DELISTED	Stock	10.69	10.8	10.38	10.51	1596500.0
2007-03-26	AAIC-DELISTED	Stock	114.0	114.0	106.8	109.8	5096400.0
2007-03-26	AAME	Stock	3.94	3.97	3.8	3.94	2200.0
2007-03-26	AAON	Stock	3.549	3.5885	3.5002	3.5029	89606.0
2007-03-26	AAP	Stock	39.25	39.43	38.67	39.2	450600.0
2007-03-26	AATI-DELISTED	Stock	6.85	6.9	6.64	6.69	292610.0
2007-03-26	AAU-DELISTED	Stock	2.1	2.15	2.08	2.12	70000.0
2007-03-26	AAUAF-DELISTED	Stock	2.1	2.15	2.08	2.12	70000.0
2007-03-26	AAV-DELISTED	Stock	10.77	10.82	10.68	10.75	778415.0
2007-03-26	AAWW-DELISTED	Stock	53.69	53.94	52.87	53.42	96263.0
2007-03-26	AAXN-DELISTED	Stock	8.3100004196167	8.32999992370605	8.17000007629395	8.27999973297119	559700.0
2007-03-26	AB	Stock	86.82	86.83	85.68	85.96	211300.0
2007-03-26	ABAX-DELISTED	Stock	25.05	25.62	25.05	25.54	239856.0
2007-03-26	ABB-DELISTED	Stock	17.45	17.5	17.19	17.47	1946600.0
2007-03-26	ABBC-DELISTED	Stock	19.95	19.95	19.65	19.67	39512.0
2007-03-26	ABC-DELISTED	Stock	26.96	26.96	26.68	26.9	1865000.0
2007-03-26	ABCB	Stock	24.141	24.8413	24.0728	24.8024	27554.0
2007-03-26	ABCO-DELISTED	Stock	25.95	25.97	25.29	25.58	179623.0
2007-03-26	ABCW-DELISTED	Stock	28.58	28.98	28.32	28.76	34020.0
2007-03-26	ABD-DELISTED	Stock	22.81	23.83	22.72	23.45	428790.0
2007-03-26	ABE-DELISTED	Stock	18.56	18.59	18.31	18.56	59200.0
2007-03-26	ABFS-DELISTED	Stock	37.11	37.16	36.34	36.65	437331.0
2007-03-26	ABG	Stock	28.1	28.32	27.9	28.1	359300.0
2007-03-26	ABK-DELISTED	Stock	87.67	88.08	86.79	87.56	670100.0
2007-03-26	ABM	Stock	25.98	26.5	25.93	26.5	494000.0
2007-03-26	ABMD-DELISTED	Stock	13.55	13.7	13.31	13.35	400926.0
2007-03-26	ABP-DELISTED	Stock	3.21	3.22	3.15	3.22	106800.0
2007-03-26	ABR	Stock	30.57	31.0	30.45	30.6	122300.0
2007-03-26	ABT	Stock	26.4274	27.4733	26.413	27.4638	47897249.0
2007-03-26	ABTL-DELISTED	Stock	17.7	17.7	16.75	17.1	14875.0
2007-03-26	ABV-DELISTED	Stock	54.1	54.45	53.63	54.41	253700.0
2007-03-26	ABVA-DELISTED	Stock	14.9301	15.38	14.9301	15.38	3750.0
2007-03-26	ABX-DELISTED	Stock	29.29	29.31	28.85	29.04	4011800.0
2007-03-26	ACAD	Stock	14.45	15.34	14.01	15.25	2422900.0
2007-03-26	ACAP-DELISTED	Stock	39.0	39.18	38.49	38.83	39287.0
2007-03-26	ACAS-DELISTED	Stock	44.98	44.98	44.28	44.79	1368396.0
2007-03-26	ACAT-DELISTED	Stock	19.18	19.6	19.18	19.48	67733.0
2007-03-26	ACC-DELISTED	Stock	31.06	31.1	30.27	30.78	264100.0

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

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