PREVIEW / stock_daily / 2007-01-31

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-31.parquet
  size:    161 KB
  rows:    4,830
  symbols: 3,032

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-01-31	AAPL	Stock	3.0307	3.0714	3.0125	3.0618	856069200.0
2007-01-31	MSFT	Stock	30.41	31.1	30.35	30.86	73968400.0
2007-01-31	NVDA	Stock	0.5102	0.5157	0.5038	0.5108	467976000.0
2007-01-31	AMZN	Stock	1.8475	1.9095	1.838	1.8835	145550000.0
2007-01-31	TLT	Stock	86.73	87.61	86.7	87.55	2078000.0
2007-01-31	CL	Stock	33.855	34.28	33.705	34.15	6510400.0
2007-01-31	A	Stock	22.8898	22.9614	22.8183	22.8898	3173460.0
2007-01-31	AABA-DELISTED	Stock	28.0400009155273	28.4799995422363	27.8199996948242	28.3099994659424	14100300.0
2007-01-31	AACC-DELISTED	Stock	15.45	15.6	15.29	15.4	54084.0
2007-01-31	AACQ-DELISTED	Stock	5.55	5.58	5.55	5.58	25185.0
2007-01-31	AACQW-DELISTED	Stock	0.77	0.78	0.77	0.77	39200.0
2007-01-31	AAI-DELISTED	Stock	11.14	11.28	10.99	11.04	1869900.0
2007-01-31	AAIC-DELISTED	Stock	153.8	158.8	153.2	157.2	1080700.0
2007-01-31	AAME	Stock	3.35	3.4	3.32	3.32	1700.0
2007-01-31	AAON	Stock	3.5858	3.6728	3.5582	3.6188	172378.0
2007-01-31	AAP	Stock	37.04	37.97	37.04	37.95	759700.0
2007-01-31	AATI-DELISTED	Stock	5.72	5.76	5.6	5.66	248442.0
2007-01-31	AAU-DELISTED	Stock	2.35	2.48	2.35	2.45	39100.0
2007-01-31	AAUAF-DELISTED	Stock	2.35	2.48	2.35	2.45	39100.0
2007-01-31	AAV-DELISTED	Stock	10.8	10.87	10.72	10.85	348400.0
2007-01-31	AAWW-DELISTED	Stock	47.15	48.16	47.15	47.9	80891.0
2007-01-31	AAXN-DELISTED	Stock	7.78000020980835	7.82999992370605	7.65000009536743	7.75	744300.0
2007-01-31	AB	Stock	89.4	90.28	88.03	90.09	320000.0
2007-01-31	ABAX-DELISTED	Stock	21.67	21.9	21.3	21.59	185097.0
2007-01-31	ABB-DELISTED	Stock	17.57	17.85	17.47	17.81	766600.0
2007-01-31	ABBC-DELISTED	Stock	19.05	19.16	18.9	19.0	11171.0
2007-01-31	ABC-DELISTED	Stock	25.98	26.22	25.9	26.21	1819400.0
2007-01-31	ABCB	Stock	25.4346	25.454	25.0456	25.0845	49247.0
2007-01-31	ABCO-DELISTED	Stock	27.46	28.2	27.08	28.15	278473.0
2007-01-31	ABCW-DELISTED	Stock	29.4	29.94	29.25	29.86	45410.0
2007-01-31	ABD-DELISTED	Stock	24.31	24.35	23.75	24.13	1089330.0
2007-01-31	ABE-DELISTED	Stock	18.17	18.35	18.1	18.21	45800.0
2007-01-31	ABFS-DELISTED	Stock	38.34	38.62	37.98	38.2	499287.0
2007-01-31	ABG	Stock	24.2	24.54	24.1	24.46	185500.0
2007-01-31	ABK-DELISTED	Stock	89.08	89.08	87.58	88.1	741500.0
2007-01-31	ABM	Stock	25.52	26.0	25.41	25.84	471100.0
2007-01-31	ABMD-DELISTED	Stock	14.46	14.77	14.31	14.71	75838.0
2007-01-31	ABP-DELISTED	Stock	3.38	3.44	3.17	3.34	253300.0
2007-01-31	ABR	Stock	31.85	32.14	31.78	31.91	82800.0
2007-01-31	ABT	Stock	25.3095	25.5446	25.2231	25.4294	12249896.0
2007-01-31	ABTL-DELISTED	Stock	18.799	18.851	18.049	18.55	20093.0
2007-01-31	ABV-DELISTED	Stock	50.84	51.87	50.81	51.73	248700.0
2007-01-31	ABVA-DELISTED	Stock	16.75	16.78	16.74	16.77	2980.0
2007-01-31	ABX-DELISTED	Stock	29.26	29.93	29.26	29.6	3177600.0
2007-01-31	ACAD	Stock	7.02	7.17	7.02	7.15	159600.0
2007-01-31	ACAP-DELISTED	Stock	38.73	38.79	38.17	38.73	22948.0
2007-01-31	ACAS-DELISTED	Stock	47.86	48.67	47.76	48.63	793357.0
2007-01-31	ACAT-DELISTED	Stock	18.6	18.69	18.239	18.46	69239.0
2007-01-31	ACC-DELISTED	Stock	31.29	31.98	31.06	31.89	64000.0
2007-01-31	ACCL-DELISTED	Stock	6.13	6.36	6.13	6.31	32806.0

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

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