PREVIEW / stock_daily / 2009-07-09

all stock daily files

  file:    by_date/stock_daily/2009/2009-07-09.parquet
  size:    179 KB
  rows:    5,723
  symbols: 3,412

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
2009-07-09	AAPL	Stock	4.92	4.9282	4.8546	4.87	343025200.0
2009-07-09	MSFT	Stock	22.65	22.81	22.37	22.44	46981200.0
2009-07-09	NVDA	Stock	0.257	0.2625	0.2563	0.2583	714564000.0
2009-07-09	AMZN	Stock	3.9125	3.927	3.841	3.905	127190000.0
2009-07-09	TLT	Stock	95.35	95.73	94.45	95.35	5250766.0
2009-07-09	ES	Stock	21.85	22.0	21.35	21.51	2709800.0
2009-07-09	CL	Stock	36.86	36.935	36.425	36.53	4157600.0
2009-07-09	A	Stock	13.4907	13.6052	13.3619	13.505	4342607.0
2009-07-09	AABA-DELISTED	Stock	14.48	14.68	14.25	14.55	15521683.0
2009-07-09	AACC-DELISTED	Stock	7.45	7.67	7.22	7.24	36582.0
2009-07-09	AACG	Stock	7.52	7.6	7.52	7.52	1900.0
2009-07-09	AAI-DELISTED	Stock	5.88	5.9	5.66	5.69	2550015.0
2009-07-09	AAIC-DELISTED	Stock	7.4	7.6	6.8	7.002	1947929.0
2009-07-09	AAON	Stock	3.9032	3.9032	3.7531	3.7906	215156.0
2009-07-09	AAP	Stock	44.48	44.66	43.67	44.12	1254400.0
2009-07-09	AATI-DELISTED	Stock	4.21	4.33	4.18	4.25	140940.0
2009-07-09	AAU-DELISTED	Stock	0.57	0.61	0.57	0.59	37858.0
2009-07-09	AAUAF-DELISTED	Stock	0.57	0.61	0.57	0.59	37958.0
2009-07-09	AAV-DELISTED	Stock	3.6	4.22	3.48	4.15	1282700.0
2009-07-09	AAWW-DELISTED	Stock	21.12	21.22	20.5	20.6	174274.0
2009-07-09	AAXJ	Stock	43.32	43.83	43.21	43.6	158792.0
2009-07-09	AAXN-DELISTED	Stock	4.33	4.35	4.19	4.21	280722.0
2009-07-09	AB	Stock	18.44	18.5	17.83	18.0	382000.0
2009-07-09	ABAX-DELISTED	Stock	19.5	19.5	18.87	19.0	105205.0
2009-07-09	ABB-DELISTED	Stock	15.32	15.41	15.05	15.19	4966245.0
2009-07-09	ABBC-DELISTED	Stock	8.05	8.05	7.88	7.93	33009.0
2009-07-09	ABBNY-DELISTED	Stock	15.3	15.41	15.05	15.2	5096845.0
2009-07-09	ABC-DELISTED	Stock	18.03	18.03	17.64	17.81	2819799.0
2009-07-09	ABCB	Stock	5.9914	5.9914	5.6996	5.797	14188.0
2009-07-09	ABCO-DELISTED	Stock	12.025	12.04	11.66	11.66	114237.0
2009-07-09	ABCW-DELISTED	Stock	1.12	1.21	1.11	1.17	132450.0
2009-07-09	ABD-DELISTED	Stock	2.58	2.64	2.46	2.49	156940.0
2009-07-09	ABE-DELISTED	Stock	14.64	14.8575	14.64	14.7001	3200.0
2009-07-09	ABEO	Stock	2500.0	2500.0	1900.0	2312.5	32.0
2009-07-09	ABFS-DELISTED	Stock	28.24	28.76	27.12	27.2	711228.0
2009-07-09	ABG	Stock	9.49	9.76	9.11	9.17	300500.0
2009-07-09	ABII-DELISTED	Stock	34.46	34.46	33.42	33.42	25478.0
2009-07-09	ABK-DELISTED	Stock	0.8	0.81	0.76	0.8	3217269.0
2009-07-09	ABM	Stock	17.26	17.29	16.79	16.83	120300.0
2009-07-09	ABMD-DELISTED	Stock	8.19	8.32	7.96	7.96	185613.0
2009-07-09	ABR	Stock	1.52	1.58	1.51	1.53	72000.0
2009-07-09	ABT	Stock	22.2675	22.3539	21.8021	22.0372	15427261.0
2009-07-09	ABTL-DELISTED	Stock	2.1202	2.1449	2.095	2.1	7853.0
2009-07-09	ABV-DELISTED	Stock	65.08	65.44	63.22	63.85	370192.0
2009-07-09	ABVT-DELISTED	Stock	71.07	71.46	70.01	70.01	15310.0
2009-07-09	ABX-DELISTED	Stock	31.88	32.64	31.64	31.75	6002252.0
2009-07-09	ACAD	Stock	1.92	2.04	1.92	1.98	92200.0
2009-07-09	ACAP-DELISTED	Stock	38.66	39.8	37.84	37.86	26133.0
2009-07-09	ACAS-DELISTED	Stock	3.02	3.04	2.7996	2.8297	1855338.0
2009-07-09	ACAT-DELISTED	Stock	3.95	3.95	3.77	3.89	80116.0

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

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