PREVIEW / stock_daily / 2007-08-28

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-28.parquet
  size:    176 KB
  rows:    5,472
  symbols: 3,284

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-08-28	AAPL	Stock	4.6782	4.7289	4.5225	4.5293	1179365600.0
2007-08-28	MSFT	Stock	28.3	28.49	27.91	27.93	43924400.0
2007-08-28	NVDA	Stock	0.825	0.8283	0.7703	0.7722	560022000.0
2007-08-28	AMZN	Stock	3.893	3.9325	3.804	3.811	115340000.0
2007-08-28	TLT	Stock	88.43	88.74	88.28	88.46	1298900.0
2007-08-28	CL	Stock	33.045	33.12	32.665	32.67	7645200.0
2007-08-28	A	Stock	25.0	25.1931	24.7496	24.7997	4307657.0
2007-08-28	AABA-DELISTED	Stock	22.95	23.102	22.5	22.53	14742598.0
2007-08-28	AACC-DELISTED	Stock	10.75	10.75	10.53	10.6	173667.0
2007-08-28	AAI-DELISTED	Stock	10.31	10.4	10.06	10.06	897600.0
2007-08-28	AAIC-DELISTED	Stock	89.6	92.2	88.0	88.0	1690200.0
2007-08-28	AAME	Stock	2.9	2.91	2.9	2.9	18300.0
2007-08-28	AAON	Stock	4.1067	4.1146	3.9091	3.9269	298687.0
2007-08-28	AAP	Stock	35.04	35.12	34.09	34.25	937000.0
2007-08-28	AATI-DELISTED	Stock	8.75	9.0	8.74	8.93	373185.0
2007-08-28	AAU-DELISTED	Stock	2.1	2.17	2.06	2.16	57100.0
2007-08-28	AAUAF-DELISTED	Stock	2.1	2.17	2.06	2.16	57100.0
2007-08-28	AAV-DELISTED	Stock	11.41	11.46	11.3	11.33	479700.0
2007-08-28	AAWW-DELISTED	Stock	50.13	50.2	48.84	48.98	169058.0
2007-08-28	AAXN-DELISTED	Stock	13.91	13.9893	13.27	13.32	1856882.0
2007-08-28	AB	Stock	83.2	83.2	80.15	80.4	193600.0
2007-08-28	ABAX-DELISTED	Stock	20.45	20.6	19.43	19.48	178388.0
2007-08-28	ABB-DELISTED	Stock	23.99	24.03	23.22	23.23	2073800.0
2007-08-28	ABBC-DELISTED	Stock	9.57	9.72	9.55	9.59	69734.0
2007-08-28	ABBNY-DELISTED	Stock	23.99	24.03	23.22	23.28	2169100.0
2007-08-28	ABC-DELISTED	Stock	24.04	24.14	23.38	23.62	4870800.0
2007-08-28	ABCB	Stock	19.6668	19.9197	18.9665	19.0054	32078.0
2007-08-28	ABCO-DELISTED	Stock	28.22	28.44	27.8	27.82	265662.0
2007-08-28	ABCW-DELISTED	Stock	27.27	27.35	26.38	26.38	174450.0
2007-08-28	ABD-DELISTED	Stock	23.18	23.47	22.77	22.77	299580.0
2007-08-28	ABE-DELISTED	Stock	21.6	21.6	20.29	20.29	24000.0
2007-08-28	ABFS-DELISTED	Stock	35.75	35.75	34.95	35.06	610879.0
2007-08-28	ABG	Stock	21.36	21.44	20.87	21.08	438700.0
2007-08-28	ABK-DELISTED	Stock	62.48	62.8	61.12	61.94	2091800.0
2007-08-28	ABM	Stock	23.05	23.15	22.14	22.23	209400.0
2007-08-28	ABMD-DELISTED	Stock	11.59	12.13	11.58	12.07	272970.0
2007-08-28	ABP-DELISTED	Stock	3.7	3.74	3.62	3.66	94500.0
2007-08-28	ABR	Stock	19.39	19.48	18.6	18.61	95000.0
2007-08-28	ABT	Stock	24.8488	24.9016	24.3259	24.369	11859525.0
2007-08-28	ABTL-DELISTED	Stock	16.25	16.7	15.6	15.65	40396.0
2007-08-28	ABV-DELISTED	Stock	66.0	66.0	62.95	63.03	640600.0
2007-08-28	ABVA-DELISTED	Stock	9.98	10.0	9.91	9.95	14500.0
2007-08-28	ABX-DELISTED	Stock	31.84	31.99	30.72	30.78	6013402.0
2007-08-28	ACAD	Stock	14.48	14.51	13.99	14.04	237700.0
2007-08-28	ACAP-DELISTED	Stock	39.61	39.89	38.43	38.67	81980.0
2007-08-28	ACAS-DELISTED	Stock	40.61	40.74	39.06	39.17	1681439.0
2007-08-28	ACAT-DELISTED	Stock	17.28	17.28	16.51	16.54	128992.0
2007-08-28	ACC-DELISTED	Stock	27.57	27.69	26.93	26.94	131675.0
2007-08-28	ACCL-DELISTED	Stock	6.2	6.22	6.06	6.06	80237.0
2007-08-28	ACCO	Stock	23.15	23.44	22.74	22.8	299700.0

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

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