PREVIEW / stock_daily / 2009-07-20

all stock daily files

  file:    by_date/stock_daily/2009/2009-07-20.parquet
  size:    182 KB
  rows:    5,788
  symbols: 3,453

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-20	AAPL	Stock	5.4739	5.5371	5.3889	5.4611	735526400.0
2009-07-20	MSFT	Stock	24.44	24.53	24.15	24.53	47798000.0
2009-07-20	NVDA	Stock	0.3042	0.3088	0.3002	0.3055	782756000.0
2009-07-20	AMZN	Stock	4.3135	4.444	4.313	4.4115	121132000.0
2009-07-20	TLT	Stock	90.85	92.49	90.8	91.72	4436505.0
2009-07-20	ES	Stock	22.13	22.16	21.8	22.07	1102100.0
2009-07-20	CL	Stock	36.87	36.925	36.335	36.715	4901000.0
2009-07-20	A	Stock	15.1144	15.5222	15.0572	15.422	3101603.0
2009-07-20	AABA-DELISTED	Stock	17.21	17.43	16.65	17.01	27364560.0
2009-07-20	AACC-DELISTED	Stock	7.88	8.21	7.66	8.05	41833.0
2009-07-20	AACG	Stock	8.6	8.6	7.9	7.9	13800.0
2009-07-20	AAI-DELISTED	Stock	6.21	6.44	6.1	6.36	2050879.0
2009-07-20	AAIC-DELISTED	Stock	7.272	8.8	7.272	8.2	402564.0
2009-07-20	AAME	Stock	0.7	0.7	0.7	0.7	5600.0
2009-07-20	AAON	Stock	4.0099	4.0375	3.9723	4.0217	260212.0
2009-07-20	AAP	Stock	45.28	45.68	44.95	45.61	1510400.0
2009-07-20	AATI-DELISTED	Stock	4.53	4.53	4.28	4.37	136269.0
2009-07-20	AAU-DELISTED	Stock	0.6947	0.72	0.67	0.72	159725.0
2009-07-20	AAUAF-DELISTED	Stock	0.6947	0.72	0.67	0.72	160725.0
2009-07-20	AAV-DELISTED	Stock	4.99	5.11	4.98	5.08	770109.0
2009-07-20	AAWW-DELISTED	Stock	23.26	23.96	23.26	23.45	312504.0
2009-07-20	AAXJ	Stock	47.58	51.15	47.56	51.15	183750.0
2009-07-20	AAXN-DELISTED	Stock	5.1	5.17	5.0	5.12	292178.0
2009-07-20	AB	Stock	21.35	22.16	21.22	22.06	651700.0
2009-07-20	ABAX-DELISTED	Stock	20.06	20.24	19.55	19.77	183347.0
2009-07-20	ABB-DELISTED	Stock	16.65	16.79	16.45	16.78	3656785.0
2009-07-20	ABBC-DELISTED	Stock	8.87	8.88	8.75	8.86	35390.0
2009-07-20	ABBNY-DELISTED	Stock	16.65	16.79	16.45	16.75	3666085.0
2009-07-20	ABC-DELISTED	Stock	19.09	19.1	18.6	18.71	2812004.0
2009-07-20	ABCB	Stock	6.3221	6.3221	5.9331	6.0888	18609.0
2009-07-20	ABCO-DELISTED	Stock	12.445	12.525	12.3	12.39	153898.0
2009-07-20	ABCW-DELISTED	Stock	1.15	1.2	1.142	1.17	119650.0
2009-07-20	ABD-DELISTED	Stock	2.86	3.1408	2.83	3.13	300200.0
2009-07-20	ABE-DELISTED	Stock	15.48	16.17	15.48	16.15	23829.0
2009-07-20	ABEO	Stock	2625.0	2625.0	2562.5	2562.5	3.0
2009-07-20	ABFS-DELISTED	Stock	25.9	26.51	25.75	26.39	519601.0
2009-07-20	ABG	Stock	11.68	12.19	11.55	12.16	529300.0
2009-07-20	ABII-DELISTED	Stock	32.47	32.47	30.91	31.64	20977.0
2009-07-20	ABK-DELISTED	Stock	0.88	0.97	0.87	0.97	3888111.0
2009-07-20	ABM	Stock	18.95	19.07	18.8	19.04	120200.0
2009-07-20	ABMD-DELISTED	Stock	8.14	8.21	7.83	7.91	236605.0
2009-07-20	ABR	Stock	1.72	1.75	1.59	1.59	75200.0
2009-07-20	ABT	Stock	21.4039	21.6054	21.2551	21.5958	17642351.0
2009-07-20	ABTL-DELISTED	Stock	2.4498	2.5003	2.4002	2.4002	29344.0
2009-07-20	ABV-DELISTED	Stock	69.98	70.96	69.9	70.81	618675.0
2009-07-20	ABVA-DELISTED	Stock	2.2	2.23	2.2	2.23	875.0
2009-07-20	ABVT-DELISTED	Stock	76.06	77.25	76.02	77.16	44326.0
2009-07-20	ABX-DELISTED	Stock	35.58	35.73	34.85	35.59	6065245.0
2009-07-20	ACAD	Stock	2.34	2.45	2.29	2.34	355100.0
2009-07-20	ACAP-DELISTED	Stock	39.13	39.13	38.11	38.55	33568.0

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

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