PREVIEW / stock_daily / 2007-03-22

all stock daily files

  file:    by_date/stock_daily/2007/2007-03-22.parquet
  size:    161 KB
  rows:    4,864
  symbols: 3,056

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-22	AAPL	Stock	3.3475	3.37	3.3214	3.3557	561492400.0
2007-03-22	MSFT	Stock	28.52	28.55	28.01	28.27	47934900.0
2007-03-22	NVDA	Stock	0.5	0.5135	0.4977	0.5105	810954000.0
2007-03-22	AMZN	Stock	1.974	1.986	1.9455	1.9745	106630000.0
2007-03-22	TLT	Stock	89.48	89.48	88.83	89.04	1484257.0
2007-03-22	CL	Stock	33.84	33.84	32.98	33.525	3364000.0
2007-03-22	A	Stock	23.1044	23.4549	22.8898	23.3119	4801990.0
2007-03-22	AABA-DELISTED	Stock	31.3600006103516	31.4400005340576	30.8500003814697	31.2600002288818	12989800.0
2007-03-22	AACC-DELISTED	Stock	15.5	15.74	15.4	15.73	107626.0
2007-03-22	AAI-DELISTED	Stock	11.04	11.09	10.76	10.83	1789700.0
2007-03-22	AAIC-DELISTED	Stock	118.2	119.0	113.0	117.6	4625843.0
2007-03-22	AAME	Stock	3.97	3.98	3.79	3.93	10300.0
2007-03-22	AAON	Stock	3.5674	3.6438	3.5674	3.6346	173137.0
2007-03-22	AAP	Stock	39.3	39.48	38.95	39.1	749900.0
2007-03-22	AATI-DELISTED	Stock	6.86	7.0	6.61	6.9	352637.0
2007-03-22	AAU-DELISTED	Stock	2.04	2.06	2.0	2.01	84800.0
2007-03-22	AAUAF-DELISTED	Stock	2.04	2.06	2.0	2.01	84800.0
2007-03-22	AAV-DELISTED	Stock	10.52	10.65	10.5	10.5899	793200.0
2007-03-22	AAWW-DELISTED	Stock	53.98	54.69	53.64	54.0	60030.0
2007-03-22	AAXN-DELISTED	Stock	8.35000038146973	8.36999988555908	8.21000003814697	8.34000015258789	762000.0
2007-03-22	AB	Stock	86.0	86.46	84.76	85.5	243500.0
2007-03-22	ABAX-DELISTED	Stock	24.6	25.16	24.41	24.83	258087.0
2007-03-22	ABB-DELISTED	Stock	17.8	17.8	17.41	17.53	2035500.0
2007-03-22	ABBC-DELISTED	Stock	19.95	20.03	19.75	20.03	4989.0
2007-03-22	ABC-DELISTED	Stock	26.4	26.69	26.31	26.66	1915600.0
2007-03-22	ABCB	Stock	24.5495	24.9093	24.5495	24.8413	12338.0
2007-03-22	ABCO-DELISTED	Stock	26.06	26.06	25.63	25.8	203706.0
2007-03-22	ABCW-DELISTED	Stock	28.99	28.99	28.57	28.69	28020.0
2007-03-22	ABD-DELISTED	Stock	22.94	22.94	22.49	22.8	390450.0
2007-03-22	ABE-DELISTED	Stock	18.45	18.8	18.31	18.52	48700.0
2007-03-22	ABFS-DELISTED	Stock	37.64	37.71	36.88	37.05	861342.0
2007-03-22	ABG	Stock	28.19	28.19	27.98	28.08	286300.0
2007-03-22	ABK-DELISTED	Stock	88.07	88.32	87.29	87.43	699500.0
2007-03-22	ABM	Stock	26.35	26.4	25.86	26.0	635000.0
2007-03-22	ABMD-DELISTED	Stock	14.05	14.2	13.5	13.76	1108237.0
2007-03-22	ABP-DELISTED	Stock	3.09	3.22	3.06	3.21	366200.0
2007-03-22	ABR	Stock	30.53	30.71	30.45	30.65	97200.0
2007-03-22	ABT	Stock	25.9476	26.3506	25.914	26.1491	13735723.0
2007-03-22	ABTL-DELISTED	Stock	18.101	19.268	17.189	18.0	26927.0
2007-03-22	ABV-DELISTED	Stock	53.95	54.11	53.28	53.45	381000.0
2007-03-22	ABVA-DELISTED	Stock	15.15	15.4	15.15	15.4	5125.0
2007-03-22	ABX-DELISTED	Stock	29.26	29.41	29.03	29.09	4790800.0
2007-03-22	ACAD	Stock	13.75	14.32	13.25	13.58	2307100.0
2007-03-22	ACAP-DELISTED	Stock	38.94	39.28	38.59	39.0	44836.0
2007-03-22	ACAS-DELISTED	Stock	44.68	44.77	44.59	44.68	2134127.0
2007-03-22	ACAT-DELISTED	Stock	19.99	19.99	19.38	19.4	32392.0
2007-03-22	ACC-DELISTED	Stock	31.14	31.52	30.83	31.21	210786.0
2007-03-22	ACCL-DELISTED	Stock	6.41	6.5	6.32	6.36	65637.0
2007-03-22	ACCO	Stock	22.94	22.94	22.49	22.8	392300.0
2007-03-22	ACCP-DELISTED	Stock	6.5	6.5	6.01	6.35	12720.0

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

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