PREVIEW / stock_daily / 2007-03-05

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-05.parquet
  size:    162 KB
  rows:    4,867
  symbols: 3,058

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-05	AAPL	Stock	3.0675	3.1661	3.0629	3.0829	838899600.0
2007-03-05	MSFT	Stock	27.49	27.91	27.41	27.55	56454300.0
2007-03-05	NVDA	Stock	0.4875	0.4972	0.4777	0.4793	663558000.0
2007-03-05	AMZN	Stock	1.8575	1.916	1.852	1.8525	191312000.0
2007-03-05	TLT	Stock	90.48	90.5	90.0615	90.35	1505200.0
2007-03-05	CL	Stock	33.2	33.535	33.125	33.3	4862800.0
2007-03-05	A	Stock	21.7454	22.2747	21.6452	21.9528	2994236.0
2007-03-05	AABA-DELISTED	Stock	30.1800003051758	31.8999996185303	30.1399993896484	30.3099994659424	21469000.0
2007-03-05	AACC-DELISTED	Stock	15.01	15.36	14.96	15.06	162222.0
2007-03-05	AACQ-DELISTED	Stock	4.95	4.95	4.84	4.84	21315.0
2007-03-05	AACQU-DELISTED	Stock	6.1	6.1	6.06	6.06	2500.0
2007-03-05	AACQW-DELISTED	Stock	0.59	0.59	0.57	0.57	37500.0
2007-03-05	AAI-DELISTED	Stock	10.1	10.2	10.0	10.01	2147100.0
2007-03-05	AAIC-DELISTED	Stock	127.4	128.998	117.6	119.6	3316000.0
2007-03-05	AAME	Stock	3.44	3.47	3.2	3.29	31700.0
2007-03-05	AAON	Stock	3.5556	3.5556	3.3896	3.3896	485241.0
2007-03-05	AAP	Stock	36.1	36.85	35.81	36.25	1452200.0
2007-03-05	AATI-DELISTED	Stock	5.89	5.9	5.7	5.7	431577.0
2007-03-05	AAU-DELISTED	Stock	2.19	2.21	2.13	2.13	138600.0
2007-03-05	AAUAF-DELISTED	Stock	2.19	2.21	2.13	2.13	138600.0
2007-03-05	AAV-DELISTED	Stock	10.19	10.22	9.99	10.0	873900.0
2007-03-05	AAWW-DELISTED	Stock	48.0	48.76	47.06	47.29	111472.0
2007-03-05	AAXN-DELISTED	Stock	7.59000015258789	7.69999980926514	7.44000005722046	7.44000005722046	1387100.0
2007-03-05	AB	Stock	81.23	81.23	79.06	79.75	544100.0
2007-03-05	ABAX-DELISTED	Stock	22.13	22.28	21.31	21.52	195513.0
2007-03-05	ABB-DELISTED	Stock	15.95	16.21	15.94	15.97	4480200.0
2007-03-05	ABBC-DELISTED	Stock	19.26	19.49	19.05	19.1199	26139.0
2007-03-05	ABC-DELISTED	Stock	25.52	25.94	25.52	25.52	1882400.0
2007-03-05	ABCB	Stock	23.003	23.82	22.9057	23.0127	37013.0
2007-03-05	ABCO-DELISTED	Stock	25.51	26.23	25.13	25.46	254171.0
2007-03-05	ABCW-DELISTED	Stock	27.68	28.24	27.21	27.38	107230.0
2007-03-05	ABD-DELISTED	Stock	20.99	21.6	20.47	21.24	466120.0
2007-03-05	ABE-DELISTED	Stock	16.4	16.8	16.1	16.5	69200.0
2007-03-05	ABFS-DELISTED	Stock	37.6	38.31	37.1	37.41	482047.0
2007-03-05	ABG	Stock	26.6	26.9	26.15	26.17	356600.0
2007-03-05	ABK-DELISTED	Stock	87.4	87.78	86.4	87.13	1138500.0
2007-03-05	ABM	Stock	25.67	26.46	25.54	25.92	286400.0
2007-03-05	ABMD-DELISTED	Stock	13.32	13.45	13.05	13.14	149352.0
2007-03-05	ABP-DELISTED	Stock	2.8	2.92	2.72	2.81	258602.0
2007-03-05	ABR	Stock	29.0	29.62	28.01	28.02	300200.0
2007-03-05	ABT	Stock	25.3334	25.7125	25.2951	25.3095	15315965.0
2007-03-05	ABTL-DELISTED	Stock	18.545	18.693	17.855	18.2	27447.0
2007-03-05	ABV-DELISTED	Stock	47.65	48.45	47.4	47.77	771900.0
2007-03-05	ABVA-DELISTED	Stock	16.08	16.08	15.75	15.8	2971.0
2007-03-05	ABX-DELISTED	Stock	28.03	28.43	27.78	27.9	8977812.0
2007-03-05	ACAD	Stock	6.83	6.93	6.7	6.76	240300.0
2007-03-05	ACAP-DELISTED	Stock	35.91	36.42	35.59	35.64	45367.0
2007-03-05	ACAS-DELISTED	Stock	41.96	42.24	39.3	40.78	4630214.0
2007-03-05	ACAT-DELISTED	Stock	18.34	18.87	18.34	18.67	68656.0
2007-03-05	ACC-DELISTED	Stock	29.65	29.97	28.59	28.59	201200.0

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

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