PREVIEW / stock_daily / 2007-03-14

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-14.parquet
  size:    161 KB
  rows:    4,864
  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-14	AAPL	Stock	3.1643	3.2143	3.14	3.2143	796586000.0
2007-03-14	MSFT	Stock	26.82	27.4	26.73	27.4	75730300.0
2007-03-14	NVDA	Stock	0.4855	0.4883	0.4673	0.4818	971610000.0
2007-03-14	AMZN	Stock	1.888	1.911	1.863	1.904	171822000.0
2007-03-14	TLT	Stock	90.15	90.54	89.84	89.88	1698100.0
2007-03-14	CL	Stock	33.0	33.075	32.435	32.665	6446400.0
2007-03-14	A	Stock	22.6538	22.9399	22.5393	22.8898	4232165.0
2007-03-14	AABA-DELISTED	Stock	29.6299991607666	30.0400009155273	29.2600002288818	29.8600006103516	23604900.0
2007-03-14	AACC-DELISTED	Stock	14.89	15.19	14.88	15.09	100175.0
2007-03-14	AACQ-DELISTED	Stock	4.55	4.57	4.47	4.47	13140.0
2007-03-14	AACQU-DELISTED	Stock	5.75	5.75	5.75	5.75	2000.0
2007-03-14	AACQW-DELISTED	Stock	0.635	0.64	0.635	0.635	36000.0
2007-03-14	AAI-DELISTED	Stock	10.18	10.24	9.69	9.87	3408300.0
2007-03-14	AAIC-DELISTED	Stock	99.2	101.4	95.2	99.4	7092200.0
2007-03-14	AAME	Stock	3.46	3.69	3.46	3.69	4000.0
2007-03-14	AAON	Stock	3.3422	3.6741	3.2922	3.6741	317419.0
2007-03-14	AAP	Stock	37.67	38.1	37.08	38.03	838600.0
2007-03-14	AATI-DELISTED	Stock	6.44	6.78	6.44	6.69	225763.0
2007-03-14	AAU-DELISTED	Stock	2.13	2.14	2.07	2.11	56900.0
2007-03-14	AAUAF-DELISTED	Stock	2.13	2.14	2.07	2.11	56900.0
2007-03-14	AAV-DELISTED	Stock	9.92	9.9668	9.75	9.89	712100.0
2007-03-14	AAWW-DELISTED	Stock	49.83	51.47	49.83	51.27	273756.0
2007-03-14	AAXN-DELISTED	Stock	7.84000015258789	7.92999982833862	7.71999979019165	7.8899998664856	785800.0
2007-03-14	AB	Stock	82.82	83.52	80.79	82.85	457600.0
2007-03-14	ABAX-DELISTED	Stock	22.45	22.7	22.18	22.67	152902.0
2007-03-14	ABB-DELISTED	Stock	16.37	16.61	16.19	16.61	3507200.0
2007-03-14	ABBC-DELISTED	Stock	18.82	19.36	18.82	19.0701	11728.0
2007-03-14	ABC-DELISTED	Stock	25.11	26.36	25.11	25.921	3727800.0
2007-03-14	ABCB	Stock	22.8084	23.2948	22.6042	23.1781	25600.0
2007-03-14	ABCO-DELISTED	Stock	25.32	25.67	25.24	25.45	301098.0
2007-03-14	ABCW-DELISTED	Stock	26.84	27.63	26.84	27.53	123820.0
2007-03-14	ABD-DELISTED	Stock	20.92	21.27	20.87	21.25	494600.0
2007-03-14	ABE-DELISTED	Stock	17.18	17.18	16.25	16.7499	66200.0
2007-03-14	ABFS-DELISTED	Stock	36.26	36.94	35.68	36.93	668169.0
2007-03-14	ABG	Stock	27.59	27.69	27.22	27.47	523700.0
2007-03-14	ABK-DELISTED	Stock	87.05	87.27	83.48	86.54	2635285.0
2007-03-14	ABM	Stock	25.65	26.08	25.35	25.79	747700.0
2007-03-14	ABMD-DELISTED	Stock	12.98	13.02	12.46	12.6	284317.0
2007-03-14	ABP-DELISTED	Stock	3.04	3.05	2.93	3.0	243100.0
2007-03-14	ABR	Stock	28.88	29.06	28.09	28.84	134700.0
2007-03-14	ABT	Stock	26.0052	26.0387	25.6549	25.7988	16017924.0
2007-03-14	ABTL-DELISTED	Stock	18.156	19.019	17.244	17.7	41579.0
2007-03-14	ABV-DELISTED	Stock	51.8	52.54	51.58	52.54	473200.0
2007-03-14	ABVA-DELISTED	Stock	14.97	14.97	14.41	14.8	5152.0
2007-03-14	ABVT-DELISTED	Stock	56.0	56.0	56.0	56.0	100.0
2007-03-14	ABX-DELISTED	Stock	27.3	27.73	26.94	27.61	7490510.0
2007-03-14	ACAD	Stock	6.97	7.07	6.65	7.04	343200.0
2007-03-14	ACAP-DELISTED	Stock	35.8	37.38	35.72	37.25	76315.0
2007-03-14	ACAS-DELISTED	Stock	42.23	43.24	42.0	43.04	1585309.0
2007-03-14	ACAT-DELISTED	Stock	18.84	18.93	18.74	18.84	50479.0

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

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