PREVIEW / stock_daily / 2007-09-28

all stock daily files

  file:    by_date/stock_daily/2007/2007-09-28.parquet
  size:    177 KB
  rows:    5,512
  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-28	AAPL	Stock	5.48	5.5214	5.4554	5.4811	615101200.0
2007-09-28	MSFT	Stock	29.49	29.69	29.23	29.46	45819100.0
2007-09-28	NVDA	Stock	0.925	0.9283	0.904	0.906	404292000.0
2007-09-28	AMZN	Stock	4.6385	4.68	4.585	4.6575	96274000.0
2007-09-28	TLT	Stock	89.16	89.33	88.22	88.72	1254645.0
2007-09-28	CL	Stock	35.7	35.745	35.455	35.66	3913000.0
2007-09-28	A	Stock	26.3948	26.5808	26.1946	26.3805	3169406.0
2007-09-28	AABA-DELISTED	Stock	26.49	26.89	26.2	26.85	22178890.0
2007-09-28	AACC-DELISTED	Stock	11.75	11.97	11.6	11.6	248980.0
2007-09-28	AAI-DELISTED	Stock	9.87	9.93	9.77	9.86	1572600.0
2007-09-28	AAIC-DELISTED	Stock	95.0	95.4	91.6	92.2	1505800.0
2007-09-28	AAME	Stock	2.67	2.71	2.58	2.7	8000.0
2007-09-28	AAON	Stock	3.9723	4.0296	3.8677	3.8973	232369.0
2007-09-28	AAP	Stock	33.29	33.89	33.29	33.56	938900.0
2007-09-28	AATI-DELISTED	Stock	10.64	10.87	10.49	10.65	318874.0
2007-09-28	AAU-DELISTED	Stock	2.31	2.4	2.3	2.35	68000.0
2007-09-28	AAUAF-DELISTED	Stock	2.31	2.4	2.3	2.35	68000.0
2007-09-28	AAV-DELISTED	Stock	12.34	12.45	12.23	12.35	1041300.0
2007-09-28	AAWW-DELISTED	Stock	52.7476	52.91	51.29	51.63	110837.0
2007-09-28	AAXN-DELISTED	Stock	15.76	15.95	15.58	15.67	983054.0
2007-09-28	AB	Stock	86.87	88.23	86.64	88.07	184800.0
2007-09-28	ABAX-DELISTED	Stock	22.22	22.89	21.97	22.44	290064.0
2007-09-28	ABB-DELISTED	Stock	26.11	26.48	25.98	26.26	6535800.0
2007-09-28	ABBC-DELISTED	Stock	9.75	9.8	9.71	9.74	94026.0
2007-09-28	ABBNY-DELISTED	Stock	26.11	26.475	25.98	26.23	6535800.0
2007-09-28	ABC-DELISTED	Stock	22.36	22.66	22.25	22.64	1434244.0
2007-09-28	ABCB	Stock	18.2371	18.3926	17.4395	17.5854	43798.0
2007-09-28	ABCO-DELISTED	Stock	29.27	29.83	28.84	29.22	190767.0
2007-09-28	ABCW-DELISTED	Stock	27.52	27.67	27.0	27.0	95680.0
2007-09-28	ABD-DELISTED	Stock	22.41	22.63	22.2	22.42	566210.0
2007-09-28	ABE-DELISTED	Stock	23.91	23.96	23.6032	23.6032	17100.0
2007-09-28	ABEO	Stock	5625.0	5625.0	5250.0	5562.5	7.0
2007-09-28	ABFS-DELISTED	Stock	32.57	33.19	32.57	32.67	284574.0
2007-09-28	ABG	Stock	18.94	19.96	18.86	19.81	529800.0
2007-09-28	ABK-DELISTED	Stock	63.12	63.86	62.48	63.01	2160300.0
2007-09-28	ABM	Stock	20.03	20.13	19.9	19.98	222400.0
2007-09-28	ABMD-DELISTED	Stock	12.16	12.5	12.11	12.42	149952.0
2007-09-28	ABP-DELISTED	Stock	3.76	3.91	3.68	3.89	202600.0
2007-09-28	ABR	Stock	19.64	19.69	18.84	18.89	125100.0
2007-09-28	ABT	Stock	25.866	25.9812	25.6261	25.7269	8573781.0
2007-09-28	ABTL-DELISTED	Stock	16.452	16.452	15.945	16.3	12452.0
2007-09-28	ABV-DELISTED	Stock	71.51	73.18	71.51	73.01	536600.0
2007-09-28	ABVA-DELISTED	Stock	9.89	9.9	9.81	9.81	3200.0
2007-09-28	ABVT-DELISTED	Stock	77.5	79.5	75.0	79.5	13923.0
2007-09-28	ABX-DELISTED	Stock	40.0	41.13	39.8	40.23	10762200.0
2007-09-28	ACAD	Stock	15.31	15.4	14.86	15.05	238600.0
2007-09-28	ACAP-DELISTED	Stock	39.0	39.22	38.88	38.9	49580.0
2007-09-28	ACAS-DELISTED	Stock	41.7901	42.76	41.7901	42.74	2210264.0
2007-09-28	ACAT-DELISTED	Stock	16.72	16.82	16.33	16.36	115478.0
2007-09-28	ACC-DELISTED	Stock	29.34	29.55	29.13	29.18	96348.0

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

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