PREVIEW / stock_daily / 2007-07-30

all stock daily files

  file:    by_date/stock_daily/2007/2007-07-30.parquet
  size:    178 KB
  rows:    5,504
  symbols: 3,309

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-07-30	AAPL	Stock	5.1546	5.1946	4.9846	5.0511	1106988400.0
2007-07-30	MSFT	Stock	29.41	29.49	28.95	29.4	67499600.0
2007-07-30	NVDA	Stock	0.7402	0.7593	0.74	0.7582	538158000.0
2007-07-30	AMZN	Stock	4.15	4.2025	4.0755	4.135	257112000.0
2007-07-30	TLT	Stock	87.19	87.36	86.91	87.03	1803900.0
2007-07-30	CL	Stock	34.445	35.08	33.59	33.7	6734000.0
2007-07-30	A	Stock	26.8026	27.2747	26.6524	27.2461	3879730.0
2007-07-30	AABA-DELISTED	Stock	23.55	23.88	23.38	23.64	18512064.0
2007-07-30	AACC-DELISTED	Stock	13.9	14.15	13.71	14.02	139786.0
2007-07-30	AAI-DELISTED	Stock	10.03	10.06	9.65	9.91	1489300.0
2007-07-30	AAIC-DELISTED	Stock	106.6	111.0	102.6	104.6	2325600.0
2007-07-30	AAME	Stock	3.29	3.34	3.23	3.24	11100.0
2007-07-30	AAON	Stock	3.8347	4.0705	3.8281	3.977	464737.0
2007-07-30	AAP	Stock	35.12	35.77	35.0	35.24	3329400.0
2007-07-30	AATI-DELISTED	Stock	9.0	9.63	8.98	9.5	735226.0
2007-07-30	AAU-DELISTED	Stock	2.6	2.61	2.43	2.45	144400.0
2007-07-30	AAUAF-DELISTED	Stock	2.6	2.61	2.43	2.45	144400.0
2007-07-30	AAV-DELISTED	Stock	12.76	12.89	12.2	12.44	868200.0
2007-07-30	AAWW-DELISTED	Stock	53.44	54.6	53.2201	54.31	97802.0
2007-07-30	AAXN-DELISTED	Stock	14.52	15.28	14.44	15.16	5906077.0
2007-07-30	AB	Stock	86.4	87.0	85.44	86.47	591200.0
2007-07-30	ABAX-DELISTED	Stock	18.0	18.56	17.54	18.37	330674.0
2007-07-30	ABB-DELISTED	Stock	23.74	24.18	23.66	24.09	4174300.0
2007-07-30	ABBC-DELISTED	Stock	9.53	9.53	9.19	9.4	80485.0
2007-07-30	ABBNY-DELISTED	Stock	23.74	24.18	23.66	24.1	4174900.0
2007-07-30	ABC-DELISTED	Stock	23.13	23.58	22.95	23.56	3245978.0
2007-07-30	ABCB	Stock	18.13	18.8109	17.8188	18.3829	57677.0
2007-07-30	ABCO-DELISTED	Stock	26.23	26.32	25.72	26.17	166154.0
2007-07-30	ABCW-DELISTED	Stock	22.92	23.07	22.15	22.89	284380.0
2007-07-30	ABD-DELISTED	Stock	20.72	21.08	19.83	20.66	609730.0
2007-07-30	ABE-DELISTED	Stock	20.81	21.7	20.67	21.36	46700.0
2007-07-30	ABEO	Stock	5375.0	5500.0	5312.5	5500.0	13.0
2007-07-30	ABFS-DELISTED	Stock	36.64	37.18	36.36	36.6	472281.0
2007-07-30	ABG	Stock	22.12	22.89	21.83	22.03	665000.0
2007-07-30	ABK-DELISTED	Stock	75.0	75.0	72.04	72.9	3223000.0
2007-07-30	ABM	Stock	23.17	23.59	22.62	23.35	314500.0
2007-07-30	ABMD-DELISTED	Stock	10.31	10.7	10.0	10.48	230645.0
2007-07-30	ABP-DELISTED	Stock	4.0	4.0	3.75	3.91	160700.0
2007-07-30	ABR	Stock	21.82	21.82	20.54	21.0	399200.0
2007-07-30	ABT	Stock	24.6857	24.6857	23.7885	24.3834	15377241.0
2007-07-30	ABTL-DELISTED	Stock	17.95	18.0	16.8	17.5	31566.0
2007-07-30	ABV-DELISTED	Stock	71.37	71.44	68.92	71.0	915000.0
2007-07-30	ABVA-DELISTED	Stock	11.99	11.99	11.8	11.8	800.0
2007-07-30	ABVT-DELISTED	Stock	71.0	71.0	68.0	70.1958	11058.0
2007-07-30	ABX-DELISTED	Stock	31.93	33.3	31.93	33.27	5870702.0
2007-07-30	ACAD	Stock	13.96	14.23	13.87	14.17	252700.0
2007-07-30	ACAP-DELISTED	Stock	37.78	38.88	36.92	37.55	99723.0
2007-07-30	ACAS-DELISTED	Stock	38.01	39.84	37.9	39.05	3793146.0
2007-07-30	ACAT-DELISTED	Stock	18.03	18.46	17.85	18.26	112878.0
2007-07-30	ACC-DELISTED	Stock	24.99	25.14	24.3	24.7	142900.0

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

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