PREVIEW / stock_daily / 2007-09-20

all stock daily files

  file:    by_date/stock_daily/2007/2007-09-20.parquet
  size:    178 KB
  rows:    5,496
  symbols: 3,317

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-20	AAPL	Stock	5.0054	5.0639	4.9757	5.0111	691840800.0
2007-09-20	MSFT	Stock	28.48	28.58	28.34	28.42	67168900.0
2007-09-20	NVDA	Stock	0.8595	0.8688	0.8445	0.854	324172000.0
2007-09-20	AMZN	Stock	4.445	4.521	4.441	4.4825	115616000.0
2007-09-20	TLT	Stock	88.18	88.29	87.1	87.15	5903200.0
2007-09-20	CL	Stock	34.905	35.235	34.865	34.95	3586600.0
2007-09-20	A	Stock	26.5451	26.6524	26.3662	26.4807	2166900.0
2007-09-20	AABA-DELISTED	Stock	25.28	25.61	25.16	25.27	14863776.0
2007-09-20	AACC-DELISTED	Stock	10.55	10.78	9.84	10.68	319393.0
2007-09-20	AAI-DELISTED	Stock	10.49	10.56	10.21	10.3	632700.0
2007-09-20	AAIC-DELISTED	Stock	104.2	104.2	98.2	100.2	1088200.0
2007-09-20	AAON	Stock	4.0553	4.1185	3.9941	4.0928	341212.0
2007-09-20	AAP	Stock	34.45	34.64	33.97	34.27	1139400.0
2007-09-20	AATI-DELISTED	Stock	10.8	11.23	10.76	11.16	1339714.0
2007-09-20	AAU-DELISTED	Stock	2.29	2.38	2.29	2.37	177200.0
2007-09-20	AAUAF-DELISTED	Stock	2.29	2.38	2.29	2.37	177200.0
2007-09-20	AAV-DELISTED	Stock	11.46	11.5	11.29	11.33	557700.0
2007-09-20	AAWW-DELISTED	Stock	54.58	55.89	53.51	53.99	95276.0
2007-09-20	AAXN-DELISTED	Stock	15.8	15.87	15.52	15.64	1424376.0
2007-09-20	AB	Stock	88.0	88.05	84.67	85.1	220100.0
2007-09-20	ABAX-DELISTED	Stock	21.65	22.27	20.94	21.25	276153.0
2007-09-20	ABB-DELISTED	Stock	24.98	25.28	24.94	25.07	1786300.0
2007-09-20	ABBC-DELISTED	Stock	9.72	9.95	9.69	9.78	43069.0
2007-09-20	ABBNY-DELISTED	Stock	24.98	25.28	24.94	25.08	1869800.0
2007-09-20	ABC-DELISTED	Stock	22.8	23.08	22.78	22.8	2211000.0
2007-09-20	ABCB	Stock	19.4334	19.4334	18.5969	18.9957	44724.0
2007-09-20	ABCO-DELISTED	Stock	29.47	29.58	29.04	29.34	134676.0
2007-09-20	ABCW-DELISTED	Stock	28.99	29.02	28.34	28.56	59860.0
2007-09-20	ABD-DELISTED	Stock	22.38	22.84	22.22	22.49	452500.0
2007-09-20	ABE-DELISTED	Stock	22.12	22.52	22.1	22.31	10100.0
2007-09-20	ABEO	Stock	5875.0	5937.5	5687.5	5937.5	25.0
2007-09-20	ABFS-DELISTED	Stock	34.25	34.25	32.89	33.68	458180.0
2007-09-20	ABG	Stock	22.58	22.94	21.46	21.74	495600.0
2007-09-20	ABK-DELISTED	Stock	68.51	68.68	65.38	65.52	1730900.0
2007-09-20	ABM	Stock	20.76	20.76	19.97	20.54	426900.0
2007-09-20	ABMD-DELISTED	Stock	12.44	12.44	11.82	11.85	130394.0
2007-09-20	ABP-DELISTED	Stock	3.58	3.65	3.48	3.62	371300.0
2007-09-20	ABR	Stock	21.43	21.6	20.34	20.6	156000.0
2007-09-20	ABT	Stock	25.8036	26.1155	25.7221	25.7605	12359108.0
2007-09-20	ABTL-DELISTED	Stock	15.599	16.251	15.449	16.151	11000.0
2007-09-20	ABV-DELISTED	Stock	71.25	73.1	70.21	71.16	475002.0
2007-09-20	ABVA-DELISTED	Stock	9.9308	9.95	9.9	9.95	1898.0
2007-09-20	ABVT-DELISTED	Stock	75.0	75.0	75.0	75.0	113.0
2007-09-20	ABX-DELISTED	Stock	39.92	40.98	39.28	40.91	12890619.0
2007-09-20	ACAD	Stock	15.68	16.2	15.62	15.82	236200.0
2007-09-20	ACAP-DELISTED	Stock	39.0	39.99	39.0	39.78	51894.0
2007-09-20	ACAS-DELISTED	Stock	41.22	41.49	40.55	40.69	1518745.0
2007-09-20	ACAT-DELISTED	Stock	16.59	16.59	16.32	16.39	80826.0
2007-09-20	ACC-DELISTED	Stock	28.42	28.71	28.36	28.65	155500.0
2007-09-20	ACCL-DELISTED	Stock	6.27	6.46	6.27	6.46	21607.0

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

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