PREVIEW / stock_daily / 2007-09-25

all stock daily files

  file:    by_date/stock_daily/2007/2007-09-25.parquet
  size:    178 KB
  rows:    5,506
  symbols: 3,322

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-25	AAPL	Stock	5.2443	5.4721	5.2436	5.4707	1192550800.0
2007-09-25	MSFT	Stock	29.14	29.56	29.11	29.56	75621000.0
2007-09-25	NVDA	Stock	0.879	0.8992	0.8765	0.8955	360748000.0
2007-09-25	AMZN	Stock	4.5995	4.675	4.5475	4.674	116006000.0
2007-09-25	TLT	Stock	88.5	88.62	87.83	87.83	2513420.0
2007-09-25	CL	Stock	34.74	35.455	34.625	35.35	6286800.0
2007-09-25	A	Stock	26.0372	26.4378	26.0086	26.3019	2174729.0
2007-09-25	AABA-DELISTED	Stock	25.69	26.65	25.51	26.53	33737023.0
2007-09-25	AACC-DELISTED	Stock	11.15	11.25	11.0	11.2	262717.0
2007-09-25	AAI-DELISTED	Stock	9.89	9.95	9.82	9.86	1537300.0
2007-09-25	AAIC-DELISTED	Stock	97.8	97.8	95.0	95.4	1210400.0
2007-09-25	AAME	Stock	2.63	2.74	2.55	2.63	10800.0
2007-09-25	AAON	Stock	4.0277	4.0652	3.8519	3.8677	221231.0
2007-09-25	AAP	Stock	32.99	33.72	32.5	33.61	1945100.0
2007-09-25	AATI-DELISTED	Stock	10.44	10.66	10.09	10.15	877304.0
2007-09-25	AAU-DELISTED	Stock	2.27	2.33	2.27	2.3	23000.0
2007-09-25	AAUAF-DELISTED	Stock	2.27	2.33	2.27	2.3	23000.0
2007-09-25	AAV-DELISTED	Stock	12.38	12.42	12.15	12.29	1756347.0
2007-09-25	AAWW-DELISTED	Stock	52.69	53.85	52.58	53.66	45492.0
2007-09-25	AAXN-DELISTED	Stock	15.1	15.5	15.0	15.33	1131281.0
2007-09-25	AB	Stock	85.26	86.26	84.01	84.33	326200.0
2007-09-25	ABAX-DELISTED	Stock	20.87	21.45	20.64	21.42	147018.0
2007-09-25	ABB-DELISTED	Stock	25.54	25.83	25.46	25.83	1649900.0
2007-09-25	ABBC-DELISTED	Stock	9.7	9.84	9.7	9.77	30693.0
2007-09-25	ABBNY-DELISTED	Stock	25.54	25.84	25.46	25.84	1649900.0
2007-09-25	ABC-DELISTED	Stock	22.34	22.43	22.14	22.4	1522200.0
2007-09-25	ABCB	Stock	18.6164	18.8401	18.3635	18.4218	13880.0
2007-09-25	ABCO-DELISTED	Stock	28.87	29.59	28.76	29.3	123295.0
2007-09-25	ABCW-DELISTED	Stock	27.88	28.23	27.65	27.91	77070.0
2007-09-25	ABD-DELISTED	Stock	21.96	22.16	21.29	21.85	548720.0
2007-09-25	ABE-DELISTED	Stock	22.11	23.0899	22.11	22.96	20300.0
2007-09-25	ABEO	Stock	5600.0	5612.5	5437.5	5612.5	9.0
2007-09-25	ABFS-DELISTED	Stock	32.18	32.7799	31.84	32.42	378641.0
2007-09-25	ABG	Stock	19.9	19.97	19.04	19.23	1028100.0
2007-09-25	ABK-DELISTED	Stock	63.1	64.46	62.57	63.91	2462204.0
2007-09-25	ABM	Stock	20.26	20.36	19.94	20.1	461800.0
2007-09-25	ABMD-DELISTED	Stock	11.54	11.82	11.31	11.76	109565.0
2007-09-25	ABP-DELISTED	Stock	3.51	3.55	3.45	3.55	290000.0
2007-09-25	ABR	Stock	19.5	19.53	19.12	19.26	110000.0
2007-09-25	ABT	Stock	25.7892	26.2355	25.7365	26.0771	8464569.0
2007-09-25	ABTL-DELISTED	Stock	16.05	16.25	15.6	16.15	13770.0
2007-09-25	ABV-DELISTED	Stock	70.49	71.22	70.22	70.75	819663.0
2007-09-25	ABVA-DELISTED	Stock	9.95	10.15	9.95	10.11	3750.0
2007-09-25	ABVT-DELISTED	Stock	73.5	74.0	73.5	74.0	394.0
2007-09-25	ABX-DELISTED	Stock	39.2	39.63	38.96	39.07	5972000.0
2007-09-25	ACAD	Stock	15.61	15.61	15.31	15.54	124600.0
2007-09-25	ACAP-DELISTED	Stock	38.75	39.11	37.44	37.97	60276.0
2007-09-25	ACAS-DELISTED	Stock	40.87	41.24	40.72	40.97	1223523.0
2007-09-25	ACAT-DELISTED	Stock	16.13	16.19	15.85	15.99	56876.0
2007-09-25	ACC-DELISTED	Stock	29.25	29.32	29.1	29.27	306448.0

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

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