PREVIEW / stock_daily / 2007-09-26

all stock daily files

  file:    by_date/stock_daily/2007/2007-09-26.parquet
  size:    177 KB
  rows:    5,510
  symbols: 3,329

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-09-26	AAPL	Stock	5.5168	5.5357	5.4018	5.4561	975268000.0
2007-09-26	MSFT	Stock	29.68	29.85	29.48	29.5	60337000.0
2007-09-26	NVDA	Stock	0.9	0.9188	0.8978	0.9168	518032000.0
2007-09-26	AMZN	Stock	4.702	4.713	4.6145	4.6715	115406000.0
2007-09-26	TLT	Stock	87.62	88.13	87.43	87.91	2646389.0
2007-09-26	CL	Stock	35.5	35.94	35.325	35.81	5011800.0
2007-09-26	A	Stock	26.5737	26.5737	26.2876	26.4163	2745392.0
2007-09-26	AABA-DELISTED	Stock	26.73	27.07	26.5	26.69	18692684.0
2007-09-26	AACC-DELISTED	Stock	11.33	11.43	11.12	11.2	442191.0
2007-09-26	AAI-DELISTED	Stock	9.95	10.03	9.83	9.9	1165900.0
2007-09-26	AAIC-DELISTED	Stock	95.8	98.4	95.0	96.0	1860400.0
2007-09-26	AAME	Stock	2.41	2.72	2.41	2.64	4300.0
2007-09-26	AAON	Stock	3.9012	4.0691	3.8716	4.002	360956.0
2007-09-26	AAP	Stock	33.73	33.84	32.8	33.06	1012800.0
2007-09-26	AATI-DELISTED	Stock	10.4	10.99	10.4	10.8	1011131.0
2007-09-26	AAU-DELISTED	Stock	2.27	2.32	2.27	2.3	17400.0
2007-09-26	AAUAF-DELISTED	Stock	2.27	2.32	2.27	2.3	17400.0
2007-09-26	AAV-DELISTED	Stock	12.24	12.25	11.92	12.0	973000.0
2007-09-26	AAWW-DELISTED	Stock	53.7	53.7	52.73	53.2	42208.0
2007-09-26	AAXN-DELISTED	Stock	15.34	15.83	15.34	15.63	1343034.0
2007-09-26	AB	Stock	85.64	86.24	84.43	85.52	208900.0
2007-09-26	ABAX-DELISTED	Stock	21.52	22.12	21.46	21.97	239458.0
2007-09-26	ABB-DELISTED	Stock	25.85	25.97	25.75	25.92	1559200.0
2007-09-26	ABBC-DELISTED	Stock	9.76	9.8	9.7	9.75	20075.0
2007-09-26	ABBNY-DELISTED	Stock	25.85	25.97	25.75	25.94	1559200.0
2007-09-26	ABC-DELISTED	Stock	22.36	22.76	22.14	22.64	2380268.0
2007-09-26	ABCB	Stock	18.4802	18.5289	18.0717	18.2371	27040.0
2007-09-26	ABCO-DELISTED	Stock	29.38	29.96	29.37	29.51	130866.0
2007-09-26	ABCW-DELISTED	Stock	28.02	28.12	27.77	27.9	28200.0
2007-09-26	ABD-DELISTED	Stock	21.98	22.28	21.76	22.06	131900.0
2007-09-26	ABE-DELISTED	Stock	22.9	23.2799	22.9	23.18	17090.0
2007-09-26	ABEO	Stock	5612.5	5700.0	5375.0	5500.0	19.0
2007-09-26	ABFS-DELISTED	Stock	32.5	32.87	32.08	32.33	280955.0
2007-09-26	ABG	Stock	19.28	19.45	19.17	19.39	647000.0
2007-09-26	ABK-DELISTED	Stock	64.16	64.16	61.67	62.54	3579500.0
2007-09-26	ABM	Stock	20.14	20.58	20.06	20.44	236600.0
2007-09-26	ABMD-DELISTED	Stock	11.82	12.16	11.74	11.87	139116.0
2007-09-26	ABP-DELISTED	Stock	3.65	3.7	3.5	3.61	152200.0
2007-09-26	ABR	Stock	19.49	19.56	18.92	19.29	157500.0
2007-09-26	ABT	Stock	26.0292	26.2307	25.6885	25.9092	15665486.0
2007-09-26	ABTL-DELISTED	Stock	16.05	17.35	15.75	16.5	40790.0
2007-09-26	ABV-DELISTED	Stock	71.09	71.41	70.04	70.65	769588.0
2007-09-26	ABVA-DELISTED	Stock	10.069	10.17	10.05	10.16	8908.0
2007-09-26	ABX-DELISTED	Stock	39.24	39.48	37.44	38.65	10816914.0
2007-09-26	ACAD	Stock	15.58	15.75	15.25	15.27	173500.0
2007-09-26	ACAP-DELISTED	Stock	38.15	38.15	37.36	37.75	112502.0
2007-09-26	ACAS-DELISTED	Stock	41.25	41.71	40.9	41.46	1518124.0
2007-09-26	ACAT-DELISTED	Stock	16.17	16.67	16.05	16.57	178113.0
2007-09-26	ACC-DELISTED	Stock	29.42	29.53	28.94	29.28	139671.0
2007-09-26	ACCL-DELISTED	Stock	6.69	6.76	6.43	6.46	58831.0

> showing 50 of 5,510 rows — these rows as CSV

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