PREVIEW / stock_daily / 2007-02-28

all stock daily files

  file:    by_date/stock_daily/2007/2007-02-28.parquet
  size:    163 KB
  rows:    4,884
  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-02-28	AAPL	Stock	2.9643	3.0571	2.9643	3.0218	919475200.0
2007-02-28	MSFT	Stock	27.95	28.25	27.92	28.17	86333300.0
2007-02-28	NVDA	Stock	0.5182	0.5278	0.5118	0.5167	780048000.0
2007-02-28	AMZN	Stock	1.9455	1.979	1.904	1.957	153748000.0
2007-02-28	TLT	Stock	90.16	90.47	89.89	90.15	1701900.0
2007-02-28	CL	Stock	33.645	34.115	33.525	33.705	5933200.0
2007-02-28	A	Stock	22.9685	23.0687	22.6109	22.711	4254114.0
2007-02-28	AABA-DELISTED	Stock	30.8600006103516	31.4699993133545	30.0900001525879	30.8600006103516	30487800.0
2007-02-28	AACC-DELISTED	Stock	14.98	14.98	14.57	14.71	62847.0
2007-02-28	AACQ-DELISTED	Stock	5.3	5.32	4.84	5.0	52650.0
2007-02-28	AACQU-DELISTED	Stock	6.55	6.55	6.55	6.55	2300.0
2007-02-28	AACQW-DELISTED	Stock	0.75	0.75	0.62	0.68	112500.0
2007-02-28	AAI-DELISTED	Stock	10.5	10.6	10.3	10.41	1128800.0
2007-02-28	AAIC-DELISTED	Stock	135.6	139.0	133.6	135.6	2208600.0
2007-02-28	AAME	Stock	3.38	3.41	3.36	3.36	2300.0
2007-02-28	AAON	Stock	3.6464	3.657	3.5687	3.657	387281.0
2007-02-28	AAP	Stock	37.6	38.08	37.14	37.65	902600.0
2007-02-28	AATI-DELISTED	Stock	6.31	6.66	6.3	6.47	296873.0
2007-02-28	AAU-DELISTED	Stock	2.21	2.32	2.21	2.29	39200.0
2007-02-28	AAUAF-DELISTED	Stock	2.21	2.32	2.21	2.29	39200.0
2007-02-28	AAV-DELISTED	Stock	10.56	10.63	10.46	10.6	381400.0
2007-02-28	AAWW-DELISTED	Stock	48.37	49.13	48.1	48.85	60728.0
2007-02-28	AAXN-DELISTED	Stock	8.09000015258789	8.14000034332275	7.90000009536743	7.94000005722046	1555200.0
2007-02-28	AB	Stock	84.68	85.97	83.84	85.8	428100.0
2007-02-28	ABAX-DELISTED	Stock	23.35	23.43	22.6	22.8	197710.0
2007-02-28	ABB-DELISTED	Stock	16.77	16.87	16.56	16.71	1642200.0
2007-02-28	ABBC-DELISTED	Stock	19.3	19.43	19.25	19.41	10314.0
2007-02-28	ABC-DELISTED	Stock	26.15	26.54	25.98	26.32	1678600.0
2007-02-28	ABCB	Stock	23.9173	24.4425	23.5088	23.82	68679.0
2007-02-28	ABCO-DELISTED	Stock	25.83	26.26	25.28	26.0	306666.0
2007-02-28	ABCW-DELISTED	Stock	28.33	28.53	28.25	28.26	48540.0
2007-02-28	ABD-DELISTED	Stock	22.13	22.27	21.48	21.78	339130.0
2007-02-28	ABE-DELISTED	Stock	18.24	18.5	17.6	18.3	72200.0
2007-02-28	ABFS-DELISTED	Stock	39.79	40.24	39.4	39.46	307412.0
2007-02-28	ABG	Stock	26.5	26.9	26.45	26.71	253600.0
2007-02-28	ABK-DELISTED	Stock	87.6	88.4	87.0	87.5	962800.0
2007-02-28	ABM	Stock	26.18	26.61	25.78	26.3	286600.0
2007-02-28	ABMD-DELISTED	Stock	13.88	14.14	13.5	13.96	131086.0
2007-02-28	ABP-DELISTED	Stock	3.07	3.1	3.0	3.06	141900.0
2007-02-28	ABR	Stock	30.86	30.9	29.8	30.79	219700.0
2007-02-28	ABT	Stock	25.7029	26.4178	25.5446	26.2067	24763235.0
2007-02-28	ABTL-DELISTED	Stock	19.7	21.0	18.9	19.5	31243.0
2007-02-28	ABV-DELISTED	Stock	48.48	48.94	47.97	48.37	440900.0
2007-02-28	ABVA-DELISTED	Stock	15.85	16.0	15.85	15.85	2750.0
2007-02-28	ABVT-DELISTED	Stock	41.0	58.0	41.0	57.5	739.0
2007-02-28	ABX-DELISTED	Stock	30.09	30.17	29.56	29.9	5000900.0
2007-02-28	ACAD	Stock	7.15	7.25	6.94	6.96	268300.0
2007-02-28	ACAP-DELISTED	Stock	36.55	37.34	36.25	37.0	41422.0
2007-02-28	ACAS-DELISTED	Stock	44.9	44.9	43.6	44.46	1220667.0
2007-02-28	ACAT-DELISTED	Stock	18.87	19.0	18.5	18.57	63333.0

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

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