PREVIEW / stock_daily / 2007-01-29

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-29.parquet
  size:    161 KB
  rows:    4,841
  symbols: 3,041

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-29	AAPL	Stock	3.0821	3.0946	3.0546	3.0693	901664400.0
2007-01-29	MSFT	Stock	30.65	30.78	30.34	30.53	57605900.0
2007-01-29	NVDA	Stock	0.5222	0.5225	0.4985	0.503	1258284000.0
2007-01-29	AMZN	Stock	1.835	1.8725	1.827	1.8715	147900000.0
2007-01-29	TLT	Stock	87.06	87.1	86.6	86.72	1015300.0
2007-01-29	CL	Stock	33.1	33.53	33.1	33.355	6465800.0
2007-01-29	A	Stock	23.0758	23.2189	22.8326	22.8827	2829272.0
2007-01-29	AABA-DELISTED	Stock	28.0499992370605	28.2099990844727	27.7299995422363	27.8700008392334	16859000.0
2007-01-29	AACC-DELISTED	Stock	15.54	15.73	15.31	15.42	122573.0
2007-01-29	AACQ-DELISTED	Stock	5.58	5.58	5.56	5.56	6400.0
2007-01-29	AACQU-DELISTED	Stock	7.15	7.15	7.15	7.15	2000.0
2007-01-29	AACQW-DELISTED	Stock	0.78	0.78	0.76	0.78	35000.0
2007-01-29	AAI-DELISTED	Stock	11.11	11.44	11.1	11.15	1913400.0
2007-01-29	AAIC-DELISTED	Stock	153.4	156.2	148.0	152.2	1006300.0
2007-01-29	AAME	Stock	3.39	3.4	3.33	3.33	2700.0
2007-01-29	AAON	Stock	3.6346	3.6846	3.599	3.6214	133650.0
2007-01-29	AAP	Stock	37.49	37.8	37.17	37.3	387000.0
2007-01-29	AATI-DELISTED	Stock	5.91	5.95	5.8	5.85	162497.0
2007-01-29	AAU-DELISTED	Stock	2.37	2.56	2.36	2.5038	37956.0
2007-01-29	AAUAF-DELISTED	Stock	2.37	2.56	2.36	2.5078	37900.0
2007-01-29	AAV-DELISTED	Stock	10.92	10.92	10.74	10.8	681700.0
2007-01-29	AAWW-DELISTED	Stock	47.1	47.5	46.73	47.49	65948.0
2007-01-29	AAXN-DELISTED	Stock	7.82000017166138	7.84000015258789	7.67999982833862	7.73000001907349	850700.0
2007-01-29	AB	Stock	90.65	91.12	89.51	89.59	392400.0
2007-01-29	ABAX-DELISTED	Stock	20.55	21.91	20.5	21.75	587582.0
2007-01-29	ABB-DELISTED	Stock	17.34	17.5	17.32	17.41	1126300.0
2007-01-29	ABBC-DELISTED	Stock	19.0	19.1258	18.9	19.1258	14994.0
2007-01-29	ABC-DELISTED	Stock	26.36	26.4	25.77	25.92	3852000.0
2007-01-29	ABCB	Stock	25.4152	26.096	25.4152	26.0863	24264.0
2007-01-29	ABCO-DELISTED	Stock	27.18	27.65	27.15	27.43	165232.0
2007-01-29	ABCW-DELISTED	Stock	28.95	29.36	28.81	29.26	71180.0
2007-01-29	ABD-DELISTED	Stock	24.59	24.87	24.35	24.74	400800.0
2007-01-29	ABE-DELISTED	Stock	18.38	18.51	18.0	18.37	28400.0
2007-01-29	ABFS-DELISTED	Stock	36.29	37.3	36.19	37.19	413756.0
2007-01-29	ABG	Stock	23.81	24.25	23.58	24.19	170700.0
2007-01-29	ABK-DELISTED	Stock	87.05	88.12	87.0	87.31	364100.0
2007-01-29	ABM	Stock	24.69	25.52	24.61	25.42	440800.0
2007-01-29	ABMD-DELISTED	Stock	14.16	14.5	14.16	14.5	91526.0
2007-01-29	ABP-DELISTED	Stock	3.2	3.25	3.08	3.15	139000.0
2007-01-29	ABR	Stock	31.29	31.53	31.18	31.53	103900.0
2007-01-29	ABT	Stock	24.9064	25.3095	24.7145	25.2663	17678408.0
2007-01-29	ABTL-DELISTED	Stock	18.85	18.85	18.197	18.7	22904.0
2007-01-29	ABV-DELISTED	Stock	50.6	50.98	49.99	50.16	294100.0
2007-01-29	ABVA-DELISTED	Stock	16.45	16.59	16.45	16.45	3665.0
2007-01-29	ABX-DELISTED	Stock	28.98	29.49	28.9	29.04	3067600.0
2007-01-29	ACAD	Stock	7.0	7.07	7.0	7.06	160300.0
2007-01-29	ACAP-DELISTED	Stock	36.4	38.62	36.4	38.39	88869.0
2007-01-29	ACAS-DELISTED	Stock	47.75	47.82	47.38	47.55	651222.0
2007-01-29	ACAT-DELISTED	Stock	18.595	18.705	18.326	18.665	88374.0
2007-01-29	ACC-DELISTED	Stock	30.88	31.19	30.82	31.09	152500.0

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

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