PREVIEW / stock_daily / 2007-01-09

all stock daily files

  file:    by_date/stock_daily/2007/2007-01-09.parquet
  size:    160 KB
  rows:    4,801
  symbols: 3,014

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-09	AAPL	Stock	3.0875	3.3207	3.0411	3.3061	3349298400.0
2007-01-09	MSFT	Stock	30.0	30.18	29.73	29.96	44636600.0
2007-01-09	NVDA	Stock	0.566	0.5698	0.5535	0.5542	764166000.0
2007-01-09	AMZN	Stock	1.88	1.903	1.867	1.889	114060000.0
2007-01-09	TLT	Stock	89.48	89.48	89.22	89.37	481700.0
2007-01-09	CL	Stock	33.025	33.155	32.715	32.84	4146800.0
2007-01-09	A	Stock	24.3777	24.5494	24.0558	24.3276	1937908.0
2007-01-09	AABA-DELISTED	Stock	28.0	28.0499992370605	27.4099998474121	27.5799999237061	25621500.0
2007-01-09	AACC-DELISTED	Stock	16.01	16.34	15.87	16.23	77559.0
2007-01-09	AACQ-DELISTED	Stock	5.47	5.48	5.45	5.45	18100.0
2007-01-09	AACQW-DELISTED	Stock	0.56	0.56	0.52	0.56	145500.0
2007-01-09	AAI-DELISTED	Stock	11.53	11.59	11.15	11.36	998600.0
2007-01-09	AAIC-DELISTED	Stock	160.0	161.6	159.4	161.6	1124200.0
2007-01-09	AAME	Stock	3.75	3.75	3.59	3.63	16800.0
2007-01-09	AAON	Stock	3.5068	3.5121	3.4542	3.5002	132131.0
2007-01-09	AAP	Stock	35.26	35.61	35.13	35.44	506800.0
2007-01-09	AATI-DELISTED	Stock	5.24	5.25	5.15	5.22	175396.0
2007-01-09	AAU-DELISTED	Stock	2.31	2.31	2.21	2.23	48900.0
2007-01-09	AAUAF-DELISTED	Stock	2.31	2.31	2.21	2.23	48900.0
2007-01-09	AAV-DELISTED	Stock	10.38	10.41	10.07	10.32	555700.0
2007-01-09	AAWW-DELISTED	Stock	45.53	46.46	45.53	46.11	339685.0
2007-01-09	AAXN-DELISTED	Stock	8.51000022888184	8.63000011444092	8.35000038146973	8.47999954223633	3130300.0
2007-01-09	AB	Stock	82.87	84.4	82.01	83.91	375700.0
2007-01-09	ABAX-DELISTED	Stock	19.49	19.62	18.96	19.19	153720.0
2007-01-09	ABB-DELISTED	Stock	17.15	17.19	16.92	17.13	1768600.0
2007-01-09	ABBC-DELISTED	Stock	19.07	19.08	18.82	19.08	6121.0
2007-01-09	ABC-DELISTED	Stock	23.34	23.4	23.11	23.16	3169200.0
2007-01-09	ABCB	Stock	27.1659	27.4285	26.7671	27.4285	28788.0
2007-01-09	ABCO-DELISTED	Stock	26.8	27.06	26.8	27.04	239615.0
2007-01-09	ABCW-DELISTED	Stock	28.59	28.59	28.3	28.57	46590.0
2007-01-09	ABD-DELISTED	Stock	26.06	26.26	25.71	26.25	172500.0
2007-01-09	ABE-DELISTED	Stock	18.0	18.07	17.52	17.64	40400.0
2007-01-09	ABFS-DELISTED	Stock	39.72	39.83	38.92	39.55	469253.0
2007-01-09	ABG	Stock	23.54	23.54	22.86	23.05	365200.0
2007-01-09	ABK-DELISTED	Stock	89.05	89.29	87.89	88.02	454600.0
2007-01-09	ABM	Stock	23.2	23.32	23.05	23.2	379600.0
2007-01-09	ABMD-DELISTED	Stock	14.14	14.29	13.6	13.95	206174.0
2007-01-09	ABP-DELISTED	Stock	3.13	3.2	3.11	3.16	185300.0
2007-01-09	ABR	Stock	30.02	30.17	29.44	29.94	57600.0
2007-01-09	ABT	Stock	24.062	24.3067	23.99	24.2395	16969154.0
2007-01-09	ABTL-DELISTED	Stock	17.75	18.55	17.15	17.3	31547.0
2007-01-09	ABV-DELISTED	Stock	48.58	48.58	47.47	48.0	383400.0
2007-01-09	ABVA-DELISTED	Stock	16.17	16.2	16.15	16.186	20600.0
2007-01-09	ABX-DELISTED	Stock	29.22	29.54	28.69	29.4	5577000.0
2007-01-09	ACAD	Stock	8.09	8.1	7.8	7.9	139500.0
2007-01-09	ACAP-DELISTED	Stock	38.97	39.12	37.89	38.82	59906.0
2007-01-09	ACAS-DELISTED	Stock	45.8	46.77	45.75	46.6	3728749.0
2007-01-09	ACAT-DELISTED	Stock	17.02	17.26	16.75	17.19	57074.0
2007-01-09	ACC-DELISTED	Stock	29.37	29.45	29.03	29.44	238159.0
2007-01-09	ACCL-DELISTED	Stock	6.16	6.24	6.1	6.23	44223.0

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

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