PREVIEW / stock_daily / 2007-09-11

all stock daily files

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

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-11	AAPL	Stock	4.925	4.9393	4.7768	4.8389	971885600.0
2007-09-11	MSFT	Stock	28.63	28.95	28.58	28.93	34380800.0
2007-09-11	NVDA	Stock	0.8568	0.871	0.8478	0.8645	405424000.0
2007-09-11	AMZN	Stock	4.2085	4.3305	4.1765	4.314	137196000.0
2007-09-11	TLT	Stock	90.88	91.27	90.7	90.93	3925339.0
2007-09-11	CL	Stock	33.445	33.83	33.21	33.655	4656200.0
2007-09-11	A	Stock	25.8941	26.1087	25.7654	25.9728	3054910.0
2007-09-11	AABA-DELISTED	Stock	23.31	23.84	23.31	23.73	9577376.0
2007-09-11	AACC-DELISTED	Stock	10.08	10.13	9.9575	10.1	102708.0
2007-09-11	AAI-DELISTED	Stock	10.11	10.47	10.11	10.45	942100.0
2007-09-11	AAIC-DELISTED	Stock	91.8	94.8	91.0	93.8	947800.0
2007-09-11	AAME	Stock	3.21	3.21	2.86	2.87	12500.0
2007-09-11	AAON	Stock	3.8558	3.8815	3.8281	3.8756	236925.0
2007-09-11	AAP	Stock	33.11	33.83	33.11	33.73	572200.0
2007-09-11	AATI-DELISTED	Stock	9.41	9.85	9.32	9.7	324324.0
2007-09-11	AAU-DELISTED	Stock	2.37	2.37	2.29	2.29	57300.0
2007-09-11	AAUAF-DELISTED	Stock	2.37	2.371	2.29	2.29	57300.0
2007-09-11	AAV-DELISTED	Stock	11.16	11.42	11.16	11.37	350400.0
2007-09-11	AAWW-DELISTED	Stock	49.66	50.67	49.66	49.96	165297.0
2007-09-11	AAXN-DELISTED	Stock	14.52	14.65	14.31	14.59	995279.0
2007-09-11	AB	Stock	78.73	81.75	78.73	80.87	337900.0
2007-09-11	ABAX-DELISTED	Stock	19.93	20.5	19.74	20.4	105567.0
2007-09-11	ABB-DELISTED	Stock	23.13	23.46	23.09	23.39	2275100.0
2007-09-11	ABBC-DELISTED	Stock	9.42	9.5	9.42	9.49	193235.0
2007-09-11	ABBNY-DELISTED	Stock	23.13	23.46	23.09	23.36	2403600.0
2007-09-11	ABC-DELISTED	Stock	23.28	23.5	23.04	23.47	1974000.0
2007-09-11	ABCB	Stock	18.5872	18.665	18.3343	18.4413	33106.0
2007-09-11	ABCO-DELISTED	Stock	27.75	28.53	27.75	28.48	100297.0
2007-09-11	ABCW-DELISTED	Stock	26.34	27.23	26.34	27.23	168820.0
2007-09-11	ABD-DELISTED	Stock	21.2	21.39	20.85	21.19	326140.0
2007-09-11	ABE-DELISTED	Stock	21.3	21.7199	21.3	21.46	23100.0
2007-09-11	ABEO	Stock	5937.5	5937.5	5450.0	5537.5	29.0
2007-09-11	ABFS-DELISTED	Stock	33.41	34.0	33.21	33.68	237251.0
2007-09-11	ABG	Stock	20.85	20.85	20.06	20.32	513600.0
2007-09-11	ABK-DELISTED	Stock	60.37	61.47	59.99	60.91	1791300.0
2007-09-11	ABM	Stock	20.33	20.59	20.06	20.43	323200.0
2007-09-11	ABMD-DELISTED	Stock	11.85	12.04	11.7	12.04	77793.0
2007-09-11	ABP-DELISTED	Stock	3.32	3.36	3.27	3.3	120100.0
2007-09-11	ABR	Stock	18.21	18.79	18.02	18.75	234500.0
2007-09-11	ABT	Stock	24.9016	25.0024	24.5993	24.9304	13340559.0
2007-09-11	ABTL-DELISTED	Stock	15.151	15.151	14.599	14.949	4004.0
2007-09-11	ABV-DELISTED	Stock	67.12	67.55	65.56	66.66	501900.0
2007-09-11	ABVA-DELISTED	Stock	10.1	10.1	10.0	10.0	4100.0
2007-09-11	ABVT-DELISTED	Stock	73.95	75.0	73.95	73.95	8848.0
2007-09-11	ABX-DELISTED	Stock	37.04	37.89	36.63	37.65	8400300.0
2007-09-11	ACAD	Stock	15.15	15.45	15.09	15.42	205700.0
2007-09-11	ACAP-DELISTED	Stock	37.61	38.07	36.88	38.0	30551.0
2007-09-11	ACAS-DELISTED	Stock	38.98	39.22	38.62	38.94	1403981.0
2007-09-11	ACAT-DELISTED	Stock	16.05	16.28	15.88	16.17	169958.0
2007-09-11	ACC-DELISTED	Stock	27.57	28.12	27.48	27.85	85900.0

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

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